SHSubjectHub

Logic in a Spreadsheet: IF, Then Nested IF (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
  • 34 marks
  • about 35 minutes
  • marked instantly

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

Try it with a class, freeHow it works

Try one from this worksheet

An IF function has three arguments. 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 (Excel track), Lesson 4 — using real Microsoft Excel / Google Sheets to make decisions with the IF function, then nesting IF functions for three-way outcomes, using a spelling-test scenario. I do / we do / you do for IF, then a second I do for nested IF, two hinge polls on the clas…

17 slides.

Lesson outline

  1. Hook — Mark Six Tests in Zero Minutes
  2. Open the Real File
  3. Do Now — Retrieval
  4. Keywords for This Lesson
  5. Testing a Condition — IF
  6. I Do — Pass or Fail for Ben
  7. Hinge Check — Spot the Mistake
  8. We Do — Pass or Fail for Chloe Together
  9. Excel Task — Pass or Fail
  10. Nested IF — Sorting Into Three Bands
  11. I Do — Merit, Pass or Practise for Ben
  12. Hinge Check — Reading a Nested IF
Unit bundleData Detective (Excel)
Part of: Data Detective (Excel): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Excel)