Plan and Budget in Google Sheets

Google's Applied Digital Skills

Rating
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:

Videos

  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.
Activity
Curriculum
Digital Tool
Lesson Plan
Project Based Learning
Video
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