Skip to content
menu
See all lessons

Plan and Budget

Learn to make good financial decisions by analyzing long-term spending, researching and comparing costs, and planning for major purchases.
Start Add to class
Key stages
  • Post-16
Using
  • Apps Script
  • Maps
  • Search
  • Sheets
Lesson plans
Lessons
Lesson 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
    attachment
    Students can submit work
  3. play_circle_filled Review Spreadsheet Terms
  4. play_circle_filled Research and Collect Data
  5. play_circle_filled Research Costs
  6. play_circle_filled Add Rows and Duplicate Formulas
  7. play_circle_filled Use Data to Inform a Decision
  8. play_circle_filled Using Formulas to Inform Decisions
  9. assessment CCE Plan and Budget Activity 1 Reflection
Lesson 2: Choose Where to Live
  1. play_circle_filled Use Code for Decision Making
    attachment
    Students can submit work
  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 CCE Plan and Budget Activity 2 Reflection
Lesson 3: Develop a Budget
  1. play_circle_filled Develop a Budget
    attachment
    Students can submit work
  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
    attachment
    Students can submit work
  8. play_circle_filled Develop a Budget Wrap Up
  9. assessment CCE Plan and Budget Activity 3 Reflection
Lesson 4: Research Car Loans
  1. play_circle_filled Introduction to Car Loans
    attachment
    Students can submit work
  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 CCE Plan and Budget Activity 4 Reflection
Lesson 5: Plan for a Vacation
  1. play_circle_filled Plan a Vacation
    attachment
    Students can submit work
  2. play_circle_filled Set Up Your Spreadsheet and Start Your Research
  3. extension Research Your Vacation
  4. play_circle_filled Vacation Wrap Up
  5. assessment CCE Plan and Budget Activity 5 Reflection
Lesson 6: CCE Plan and Budget Unit Wrap Up
  1. play_circle_filled Budgets
  2. assessment CCE Plan and Budget Unit Reflection