Midpoint Assessment: The School Trip Spreadsheet

Scenario:
Your form tutor has asked you to help plan the Year 9 geography field trip. You need to create a spreadsheet to track who has paid, how much they've paid, and whether they have brought back their permission slip. Your friend, who only started using Excel last week, tells you: "Just type everything in quickly – it doesn't need to look fancy. You can just add up the money yourself and write 'YES' or 'NO' for the permission slips. Why waste time with formulas and colours?"

Task:
Write a response to your form tutor (aim for at least two paragraphs or 10 minutes of continuous writing) explaining why your friend's "quick and simple" approach is actually risky and inefficient. In your writing, you should:

1. Describe what could go wrong if you type all the money totals by hand instead of using formulas, giving a simple example of a mistake that could happen

2. Suggest one function (SUM, AVERAGE, or IF) that would make the spreadsheet more useful and explain exactly what it would do to help with the trip planning

3. Explain why basic formatting (like making headings bold, using fill colours, or adding borders) isn't just about making things look nice – describe how it would help different people use the spreadsheet correctly