Plan and Budget in Google Sheets

Google's Applied Digital Skills

No votes yet
163 Views Updated: Friday, February 1, 2019 - 4:21pm
Share with a friend
Students at a computer

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.
Digital Tool
Lesson Plan
Project Based Learning
Video Guide
Lesson tags: 
Good for Parents
This resource is a part of the following collections: 
Digital Literacy and Computer Science
20 Lessons and Resources, 1 Collection