SHSubjectHub

Asking Questions of Data: COUNTIF & SUMIF (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.

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

Question types: short answer, multiple choice, true or false, matching, fill the gap.

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 (Excel track), Lesson 3 — counting and adding up data that meets a condition, using COUNTIF and SUMIF, in real Microsoft Excel / Google Sheets, 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, a spo…

18 slides.

Lesson outline

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

More from Data Detective (Excel)