OCR+Nats+U1+-+AO5

AO5 – Spreadsheet  Unit 1 You must design a spreadsheet and then use it to model two different scenarios. ALL of your evidence should be printouts - NO SCREENSHOTS!

The school has arranged a trip to Adventure Island. The data is below
 * 35 students from each year group have been invited
 * 1 teacher is required for every 25 students
 * Each coach costs £225
 * Each coach seats 53 people
 * Adventure island are offering the wristbands for £11 per student
 * Adventure island are not charging for the teachers wristbands

Set up a spreadsheet to work out
 * The total cost of the trip
 * How many teachers are required
 * How many coaches are required

You will need to use the following formulas to calculate your results
 * **/ ** divide
 * **<span style="font-family: 'Arial','sans-serif';">* **<span style="font-family: 'Arial','sans-serif';"> multiply
 * **<span style="font-family: 'Arial','sans-serif';">+ **<span style="font-family: 'Arial','sans-serif';"> add
 * **<span style="font-family: 'Arial','sans-serif';">SUM **<span style="font-family: 'Arial','sans-serif';"> add a range
 * **<span style="font-family: 'Arial','sans-serif';">ROUNDUP **<span style="font-family: 'Arial','sans-serif';"> to round up the number of coaches and the number of teachers required




 * <span style="font-family: 'Arial','sans-serif';">Formatting options **
 * <span style="font-family: 'Arial','sans-serif';">Format appropriate cells as currency
 * <span style="font-family: 'Arial','sans-serif';">Bold & Shade your labels
 * <span style="font-family: 'Arial','sans-serif';">Add lines to your data area
 * <span style="font-family: 'Arial','sans-serif';">Shade your formulas
 * <span style="font-family: 'Arial','sans-serif';">Wrap the text in some cells
 * <span style="font-family: 'Arial','sans-serif';">Merge some cells


 * <span style="font-family: 'Arial','sans-serif';">PRINT **<span style="font-family: 'Arial','sans-serif';"> 2 copies of your spreadsheet – firstly showing the data and secondly showing the formula

**<span style="font-family: 'Arial','sans-serif';">Modelling Task 1 ** <span style="font-family: 'Arial','sans-serif';">There are now only 30 children going from years 7, 8 & 9 and 31 from years 10 & 11.

<span style="font-family: 'Arial','sans-serif';">Change your spreadsheet to show the new numbers and **PRINT** a copy – circle all of the changes due to these new figures.

**<span style="font-family: 'Arial','sans-serif';">Modelling Task 2 ** <span style="font-family: 'Arial','sans-serif';">After running this trip successfully last year the head has decided to run it again.

<span style="font-family: 'Arial','sans-serif';">This time there are 40 places for each year group. Change your spreadsheet accordingly and **PRINT** a copy – circle all of the changes due to these new figures.