Skip to content
menu
keyboard_arrow_left See all units

Plan and Budget

Research and collect data about a long-term, contractual purchase, like a cell phone and data plan.
Start
Time to complete

timer 5 - 7 hours

Suitable for

Middle and High School

Skills covered
  • Conditional formulas
  • Data analysis
  • Organizing data
Lesson plans keyboard_arrow_right
Rubric keyboard_arrow_right
Activities
Activity 1: Make a Long-Term Spending Decision
  1. play_circle_filled Budget to Make Good Financial Decisions
  2. play_circle_filled Long-Term Spending Decisions
  3. play_circle_filled Research and Collect Data
  4. play_circle_filled Research Costs
  5. play_circle_filled Add Rows and Duplicate Formulas
  6. play_circle_filled Use Data to Inform a Decision
  7. play_circle_filled Using Formulas to Inform Decisions
  8. assessment Make a Long-Term Spending Decision Activity Reflection
Activity 2: Choose Where to Live
  1. play_circle_filled Use Code For Decision-Making
  2. play_circle_filled Set Up Your Housing Spreadsheet
  3. play_circle_filled Research and Record Rental Options
  4. play_circle_filled Create Variables to Hold Two Locations
  5. play_circle_filled Communicate with the API
  6. play_circle_filled Find the Distance Between Two Points
  7. play_circle_filled Get Locations from Spreadsheet
  8. play_circle_filled Use Coding to Help Solve Problems
  9. assessment Choose Where to Live Activity Reflection
Activity 3: Develop a Budget
  1. play_circle_filled Develop a Budget
  2. play_circle_filled Copy Data and Create a Summary Table
  3. play_circle_filled Calculate Total Expenditures
  4. play_circle_filled Categorize Expenditures
  5. play_circle_filled Label and Calculate Category Totals
  6. play_circle_filled Use Data Validation to Make Your Spreadsheet More Reliable
  7. play_circle_filled Visualize the Data and Make Decisions
  8. play_circle_filled Develop a Budget Wrap Up
  9. assessment Develop a Budget Activity Reflection
Activity 4: Research Car Loans
  1. play_circle_filled Introduction to Car Loans
  2. play_circle_filled Loan Terms and APR
  3. play_circle_filled Create a Loan Amounts Table
  4. play_circle_filled Absolute Values and Currency Formatting
  5. play_circle_filled Calculate Totals for Interest and Amount Paid
  6. play_circle_filled Research Cars in Your Price Range
  7. play_circle_filled Car Loans Wrap Up
  8. assessment Research Car Loans Activity Reflection
Activity 5: Plan a Vacation
  1. play_circle_filled Plan a Vacation
  2. play_circle_filled Set Up Your Spreadsheet and Start Your Research
  3. extension Research Your Trip
  4. assessment Plan a Vacation Activity Reflection
Activity 6: Unit Wrap Up
  1. play_circle_filled Budgets: Life Has Many Financial Decisions
  2. assessment Plan and Budget Reflection