SHSubjectHub

Data Investigation Capstone: The Party Budget (Excel)

KS3Lesson packSubscription
Also online

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
  • 35 marks
  • about 35 minutes
  • marked instantly

Question types: multiple choice, short answer, multi-part, matching, fill the gap.

Try it with a class, freeHow it works

Try one from this worksheet

In a table, cost each is in column B and quantity is in column C. Which formula works out the total cost for the item in row 2?

Pick an answer: it's marked straight away, just as your pupils would see it.

About this resource

Data Detective (Excel track), Lesson 6 of 6 — the unit's capstone build. Pupils plan a spreadsheet model BEFORE opening it, then build cost, SUM and IF budget-check formulas in the real downloaded Excel workbook, checking their finished model against five success criteria and a partner's evidence…

14 slides.

Lesson outline

  1. Hook — £60.60
  2. Do Now — Retrieval
  3. Keywords for the Build
  4. Success Criteria — What 'Finished' Means
  5. How to Plan the Model in Four Steps
  6. Hinge Check — Reading an IF Formula
  7. Task (guided) — Plan Your Build
  8. BUILD SPRINT (15 minutes) — Build It For Real
  9. Checkpoint 1 — Halfway Through the Sprint
  10. Checkpoint 2 — Show Me Your Number
  11. Task (independent) — Peer Check Against the Criteria
  12. Plenary — 3, 2, 1
Unit bundleData Detective (Excel)
Part of: Data Detective (Excel): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Excel)