Year 4 · Summer 1 · Week 23 of 30

Collecting simple data

Objective I can enter data into a table or a form.

Productivity & M365 collaborationProductivity & Workspace collaborationProductivity & iWork collaboration Data & presenting ⏱ 30 minutes

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 enter data into a table or a form.”. Show a quick example of collecting simple data 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 — collecting simple data — using Forms and ExcelGoogle Forms and Google SheetsForms and Numbers. Use the prepared materials: A simple survey question; Forms or a shared Excel table set upA simple survey question; Google Forms or a shared Google Sheets table set upA simple survey question; Forms or a shared Numbers table set up. 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.

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…”.

Ask pupils to add an extra feature, explain the steps back to the class, or help a partner who is stuck.