SHSubjectHub

Asking Questions of Data (COUNTIF & SUMIF)

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.

  • 14 questions
  • 35 marks
  • about 35 minutes
  • marked instantly

Question types: short answer, multiple choice, calculation, multi-part, true or false.

Try it with a class, freeHow it works

Try one from this worksheet

What does COUNTIF do?

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

About this resource

Data Detective (Web track), Lesson 3 — counting and adding up data that meets a condition, using COUNTIF and SUMIF, with a school Sports Day as the real-world context. I do / we do / you do for each function, two hinge polls on the classic mix-ups, and hands-on Spreadsheet Lab tasks.

16 slides.

Lesson outline

  1. Hook — Who Won Sports Day?
  2. Do Now — Retrieval
  3. Keywords for This Lesson
  4. Counting WITH a Condition — COUNTIF
  5. I Do — Count the Red House
  6. Hinge Check — Spot the Working COUNTIF
  7. We Do — Count the Blue House Together
  8. Spreadsheet Lab — How Many Pupils per House?
  9. Adding UP WITH a Condition — SUMIF
  10. I Do — Total the Red House's Points
  11. Hinge Check — COUNTIF or SUMIF?
  12. Spreadsheet Lab — Total Points per House
Unit bundleData Detective (Spreadsheet Lab)
Part of: Data Detective (Spreadsheet Lab): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Spreadsheet Lab)