A ready-to-teach lesson that helps students break down the Westwood School Trips brief and produce detailed, Mark Band 3 design documentation before they build anything.

What’s included

• 21-slide PowerPoint covering the scenario, trip costs, payment schedule and supplied assets.
• Design guidance for HCI and navigation, formulas, data validation, outputs and what-if models.
• Recommended design tools: wireframes, HCI flowcharts and data dictionaries.
• A Mark Band 1–3 progression slide, an “independent user test” checklist and common planning pitfalls.
• A check-understanding question with answer reveal, a peer-review discussion task and a completion checklist.

Learning objectives

• Deconstruct the scenario by identifying all pupil costs, instalment splits and client requirements.
• Select and apply design tools to plan worksheets, navigation, validation rules and outputs.
• Produce detailed, fit-for-purpose design documentation that another person could implement.

Suitable for:
KS4 students taking OCR Cambridge Nationals in IT (J836), unit R060. Ideal as the launch lesson for the coursework.

Key features:
Worked cost and payment breakdowns, clear links to each client requirement, a focus on the “could someone else build it?” standard, and a pitfalls slide that targets common mark losses.