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