Cover lesson · Maths · Year 8 · Beginner
DCF: Data and computational thinking → Data and information literacy
Name: Class: Date:
Print: this sheet, one per pupil. Pupils also need the cost list welsh-trip-costs.csv — either open it in Excel or Google Sheets from the shared area, or print it and have pupils type the eleven rows in. The whole eleven-row list is also reprinted on this sheet, so the lesson still works if the computers are down: pupils then use the paper table and a calculator.
Run: 5 min read the brief · 10 min enter the data · 15 min write the four formulae and fill the line totals · 10 min answer the five budget questions · 10 min write the recommendation to the head of year. You do not need to check the maths live — the answers are on the worked example sheet.
Collect: this sheet. If pupils used a computer, they save the file as trip-budget-INITIALS in the class folder — nothing is shared outside school.
Year 8 has been offered a day trip to Techniquest in Cardiff Bay. The head of year has agreed a budget of £900.00 for 30 pupils and 3 members of staff. You have the costs. Build a spreadsheet that works out the line totals, the grand total, how much is left, and what each pupil should be asked to pay — then write a short recommendation saying whether the trip fits the budget.
Row numbers here match the spreadsheet rows. Fill in column D yourself.
| Row | A — Item | B — Unit cost | C — Qty | D — Line total |
|---|---|---|---|---|
| 2 | Coach hire, 49-seat, school to Cardiff Bay and return | £395.00 | 1 | |
| 3 | Techniquest pupil admission | £8.50 | 30 | |
| 4 | Techniquest adult admission (free at 1 adult to 10 pupils) | £0.00 | 3 | |
| 5 | Science Theatre show supplement, per pupil | £2.00 | 30 | |
| 6 | Packed lunch from the school kitchen | £2.85 | 12 | |
| 7 | Coach parking, Cardiff Bay | £8.00 | 1 | |
| 8 | Hi-vis tabards, pack of 10 | £11.99 | 3 | |
| 9 | Workshop: Forces and Motion (whole class) | £45.00 | 1 | |
| 10 | First aid kit refill | £6.40 | 1 | |
| 11 | Photocopying permission slips and risk assessment | £0.06 | 66 | |
| 12 | Contingency fund | £20.00 | 1 | |
| 13 | GRAND TOTAL |
Write the formula you would type into each cell. Start every one with an equals sign.
| Cell | What it must work out | Your formula |
|---|---|---|
| D2 | The line total for row 2 (unit cost times quantity) | |
| D13 | The grand total of all eleven line totals | |
| G3 | Money left: the £900.00 budget in G2 minus the grand total | |
| G4 | Cost per pupil, to the nearest penny, for 30 pupils |
| Question | Your answer |
|---|---|
| 1. What is the grand total cost of the trip? | |
| 2. Does it fit inside the £900.00 budget? By how much? | |
| 3. Which single item is the biggest share of the cost? | |
| 4. What does the trip cost per pupil, to the nearest penny? | |
| 5. If four pupils drop out and the coach still costs £395.00, what happens to the cost per pupil? Explain in one sentence. |
Three or four sentences. Say whether the trip fits, quote your total, and name one thing you would change.