Data Investigation: Planning a Class Party
This worksheet marks itself
Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.
- 12 questions
- 34 marks
- about 35 minutes
- marked instantly
Question types: short answer, calculation, multiple choice, true or false, fill the gap.
Try one from this worksheet
Which formula correctly works out the cost of an item, if its cost each is in B2 and its quantity is in C2?
Pick an answer: it's marked straight away, just as your pupils would see it.
About this resource
Data Detective (Web track), Lesson 6 — the unit's capstone build. Pupils plan a spreadsheet model on paper before touching a keyboard, then build it for real in Spreadsheet Lab to find out whether a class party fits inside a £50.00 budget. A peer check tests every success criterion against real e…
14 slides.
Lesson outline
- Hook — £10.60
- Do Now — Retrieval
- Keywords for This Lesson
- Success Criteria — Copy This Table Now
- How to Plan It — Before Any Screen
- Hinge Check — Reading the Budget Verdict
- Task (guided) — Plan It On Paper First
- Build Sprint — Build It For Real (15 Minutes)
- Checkpoint 1 — Compare Your Screen
- Checkpoint 2 — How Many Criteria?
- Task (independent) — Peer Check Against the Criteria
- Plenary — 3-2-1
More from Data Detective (Spreadsheet Lab)
- Lesson packAsking Questions of Data (COUNTIF & SUMIF)Subscription
- Lesson packChoosing and Reading ChartsSubscription
- Lesson packFormulas and Functions (SUM, AVERAGE, MIN, MAX)Subscription
- Lesson packIntroduction to SpreadsheetsSubscription
- Lesson packLogic in a Spreadsheet (IF)Subscription
- Knowledge organiserData Detective (Spreadsheet Lab)Subscription
- Scheme of workData Detective (Spreadsheet Lab)Subscription


