SHSubjectHub

Presenting Data with Charts (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, multi-part, multiple choice, calculation, fill the gap.

Try it with a class, freeHow it works

Try one from this worksheet

Which chart type is designed to show how a value changes over time, such as temperature recorded every hour?

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

About this resource

Data Detective (Excel track), Lesson 5 — choosing the right chart type (bar, line or pie) for a set of data, and reading a chart accurately, using a class snack-vote survey (58 votes) as the real-world context. Students work in real Microsoft Excel / Google Sheets on a downloadable starter file,…

18 slides.

Lesson outline

  1. Hook — 58 Votes, One Survey
  2. Open the Real File
  3. Do Now — Retrieval
  4. Keywords for This Lesson
  5. The Snack Survey
  6. Bar Chart — and Why a Line Chart Would Be Wrong Here
  7. Hinge Check — Bar or Line?
  8. Choosing the Right Chart
  9. Practice 1 (guided) — Sort the Scenarios
  10. Reading the Chart Together
  11. Hinge Check — Which Chart Shows the Share?
  12. Practice 2 (guided) — Summarise Before You Chart
Unit bundleData Detective (Excel)
Part of: Data Detective (Excel): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Excel)