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.

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
Loading...