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

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

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