9_3_12

WHAT: Create a spreadsheet for a given purpose

EMBED:

A group of your closest friends have agreed (with parent / carer permission) to go abroad when you finish your college exams. This is 4 years away and gives you time to save up.

You have decided that the maximum budget per person is £800 for everything. This must cover each person's:

  • Travel
  • Food
  • Accomodation
  • Clothing
  • Excursions
  • Night Life Entertainment
  • Travel Insurance
  • Passport renewal / creation

You will be travelling during the last week of June. To get fairly accurate cost projections you will need to look at holidays available next year during the same week.

You must complete research to find a suitable trip within your price range. You must then create a monthly payment plan for each of your friends.

CREATE A SPREADSHEET to track your spending and develop the payment plan.

CLASSROOM IDEAS:

This is nice activity for paired work.