SHSubjectHub

Introduction to Spreadsheets (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
  • 30 marks
  • about 30 minutes
  • marked instantly

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

Try it with a class, freeHow it works

Try one from this worksheet

Which of these is a correct cell reference?

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

About this resource

Data Detective (Excel track), Lesson 1 — what a spreadsheet is, rows, columns and cells, cell references, entering text and numbers, and writing your very first formula using = and the + operator, using a break-time snack stall as the real-world context. Two modelled worked examples (I-do), a gui…

18 slides.

Lesson outline

  1. Hook — Adding Up the Snack Stall
  2. Do Now — Retrieval
  3. Keywords for This Lesson
  4. Anatomy of a Cell Reference
  5. Hinge Check — Reading a Cell Reference
  6. Entering Data: Text vs Numbers
  7. I Do — Copying a Price with a Cell Reference
  8. Checkpoint 1 — Show Me
  9. Your First Formula: the + Operator
  10. I Do — Adding Two Prices Together
  11. Hinge Check — Spot the Working Formula
  12. Worked Example — Totalling the Snack Stall
Unit bundleData Detective (Excel)
Part of: Data Detective (Excel): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Excel)