Skip to main content

Plan and Budget in Google Sheets


In this lesson entitled, "Plan and Budget in Google Sheets", students make financial decisions by collecting, organizing, and evaluating data using Google Sheets. They research information about long-term purchases, then organize the data in Google Sheets. They also write code and create and track a budget in a spreadsheet. 

Getting started is easy. Go to the Applied Digital Skills website and sign up to set up your first class. Check out this guide with step-by-step instructions or go directly to the lesson through this link.

This lesson uses videos to teach critical life and technology skills:


  1. Research information about cell phones and plans, then organize the data in Google Sheets.
  2. Research housing options, and write code to calculate the driving distance between two locations in a spreadsheet.
  3. Create and track a budget.
  4. Examine the costs of car loans.
  5. Plan a vacation within an assigned budget.

Life Skills

  • Build knowledge by actively exploring real-world issues and problems, developing ideas and theories, and pursuing answers and solutions.

Technology Skills

  • Utilize a database, such as a spreadsheet, to collect, organize, graph, and analyze data to facilitate problem-solving and decision-making.
  • Apply basic formulas (add, subtract) and advanced formulas (example: using =sumif to calculate costs).
  • Differentiate between formulas with absolute and relative cell references.

Enjoy "Plan and Budget in Google Sheets"?

Check out more free lesson plans and resources on Share My Lesson in the Digital Literacy and Computer Science Collection


Write A Review!

Be the first to submit a review!

This resource appears in the following places