Create a Budget in Google Sheets

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:
  • Identify and analyze real world issues and problems, develop ideas and theories, and pursue answers and solutions
  • 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) to spreadsheets

Time to complete

7—9 hours

Audience

  • Key Stage 3
  • Key Stage 4

Digital tools

  • 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-142890410742240601139465847015624009823en-uk