Spreadsheets Task 7

Assessment

Highcliffe School is planning a trip to the adventure park in activities week. You are going to create a spreadsheet to keep track of the expenditure using information given below. You will need to include formulae and functions to find out how much it will cost for each pupil and how much it will cost altogether to run the trip. There are 110 pupils in the year group, however it is possible that not all pupils will be on the trip.

  • The entrance ticket for each pupil is £10.
  • If more than 100 pupils go, there will be a reduction of 10%.
  • The coach hire is £200 per coach, with each able to take 50 pupils.
  • There will need to be 1 teacher per 20 pupils.
  • Entrance is free for teachers accompanying pupils however you need to bear in mind they will take space on the coach.
  • Lunch will cost £5 per pupil.
  • Pupils can pay in instalments, when all money has been paid a confirmation of the payment needs to be displayed on the sheet.

Criteria

You will be assessed on the following:

  1. Your spreadsheet should automatically work out the costs depending on the number of pupils entered.
  2. All formulas need to be correct.
  3. You should use absolute cell referencing to work out the 10% reduction.
  4. You should include suitable formatting for all information on the sheet (i.e set cells that contain money to currency/accounting)
  5. You should use borders, change fonts and you can also include an image.