Plan and Budget

Analyze spending, research costs, and plan for purchases using a spreadsheet.

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

  • Adult Learners

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
  • Organizing data
namespaces/google.engedu.apski/contents/Unit-213987178205736857657750558929168294827en