SHSubjectHub

Logic in a Spreadsheet (IF)

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

Question types: short answer, multi-part, calculation, multiple choice, matching.

Try it with a class, freeHow it works

Try one from this worksheet

An IF function has three parts. Which list is in the correct order?

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

About this resource

Data Detective (Web track), Lesson 4 — the IF function for testing a condition, then nested IF for sorting into three bands, using a spelling test as the real-world context. I do / we do / you do for IF, then a second I do for nested IF, two hinge polls on the classic mix-ups, and hands-on Spread…

16 slides.

Lesson outline

  1. Hook — Mark 30 Tests in Zero Minutes
  2. Do Now — Retrieval
  3. Keywords for This Lesson
  4. Testing a Condition — IF
  5. I Do — Pass or Fail for Ben
  6. Hinge Check — Spot the Mistake
  7. We Do — Pass or Fail for the Class Together
  8. Spreadsheet Lab — Pass or Fail
  9. Nested IF — Sorting Into Three Bands
  10. I Do — Merit, Pass or Practise for Chloe
  11. Hinge Check — Reading a Nested IF
  12. Spreadsheet Lab — Merit, Pass or Practise
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)