Year 5 · Spring 2 · Week 19 of 30
Analysing responses
Objective I can turn responses into a chart and explain them.
Suggested 30-minute plan
A shape to adapt — not a script. Reorder, extend or trim to suit your class.
-
Connect5 min
Recap last week and share today’s goal: “I can turn responses into a chart and explain them.”. Show a quick example of analysing responses to hook interest and check what pupils already know.
-
Teach & model8 min
Model the key steps on the board using Forms and ExcelGoogle Forms and Google SheetsForms and Numbers. Think aloud, name the buttons and menus, and show one common mistake and how to fix it.
-
Practise13 min
Pupils work on today’s task — analysing responses — using Forms and ExcelGoogle Forms and Google SheetsForms and Numbers. Use the prepared materials: A Form with sample responses already collected. Circulate, prompt against the success criteria, and pair finishers with pupils who need support.
-
Review & reflect4 min
Pupils check their work against the “I can…” objective, save and tidy up, then share one thing that went well and one to improve. Preview next week.
Adapting for your class
Support
Pre-open the app and any files, give a printed step-by-step, and pair with a confident partner. Keep the focus on the core “I can…”.
Challenge
Ask pupils to add an extra feature, explain the steps back to the class, or help a partner who is stuck.