Plan and Budget in Google Sheets

Rating
No votes yet
728 Views Updated: Wednesday, February 19, 2020 - 3:41pm
Share with a friend
Facebook
Twitter
Pinterest
LinkedIN
email
sharethis
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:

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.

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

Lesson Plan Resources

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
23 Lessons and Resources, 1 Collection