Applied Digital Skills lessons have moved to a new platform! This site will no longer be available after 30 June 2025 and all accounts and data will be deleted. Learn more

This lesson will no longer be available after 30 Jun 2025.

Plan and Budget

Learn to make good financial decisions by analyzing long-term spending, researching and comparing costs, and planning for major purchases.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Utilize a database, such as a spreadsheet, to collect, organize, graph, and analyze data to facilitate problem-solving and decision-making
  • Curate information from digital sources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions
  • Apply basic formulas (add, subtract) and advanced formulas (example: using =SUMIF to calculate costs)
  • Differentiate between formulas with absolute and relative cell references

Time to complete

7—9 hours

Audience

  • Post-16

Digital tools

  • Icon representing the Apps Script toolApps Script
  • Icon representing the Maps toolMaps
  • Icon representing the Search toolSearch
  • Icon representing the Sheets toolSheets

Skills

  • Conditional formulas
  • Data analysis
  • Organising data
namespaces/google.engedu.apski/contents/Unit-213987178205736857657750558929168294827en-uk