Learning objective
- To retrieve data from a spreadsheet.
Success criteria
- I can locate column headers.
- I can identify rows
This content is for subscribers only. Join for access today.
National curriculum
Computing
Pupils should be taught to:
- Use
This content is for subscribers only. Join for access today.
Cross-curricular links
Science
Living things and their habitats
Pupils
This content is for subscribers only. Join for access today.
Before the lesson
This content is for subscribers only. Join for access today.
Lesson plan
Recap and recall
Remind the pupils that computer algorithms include a ‘sense’ and an ‘action’ revisiting the following example: Automatic doors: if a person appears, then open the doors.
This content is for subscribers only. Join for access today.
Extended-mode explainer videos
How to extend your display to view the lesson page and preseantion mode simultaneously. Choose your operating system below to watch the video
If you need further support with extending your display,
please contact [email protected].
Extended-mode explainer video: For Mac
Extended-mode explainer video: For Windows
Adaptive teaching
Pupils needing extra support
Could use the Activity: Unknown planets cards to retrieve data as opposed to the Resource: Planet data spreadsheet; could retrieve data from the Resource: Planet data spreadsheet by verbally answering questions.
Pupils working at greater depth
Could refer to their completed Activity: Retrieving data and ask a partner to retrieve specific information, e.g. ‘What is the name of Proxima’s star?’ by referring to the Resource: Planet data spreadsheet; should explain how the layout of a spreadsheet can help in retrieving specific data.
This content is for subscribers only. Join for access today.
Assessing progress and understanding
Pupils with secure understanding indicated by: using columns and rows
This content is for subscribers only. Join for access today.
Vocabulary definitions
-
column
A line of boxes that go up and down in a spreadsheet.
-
data
Information used for a specific purpose or investigation.
This content is for subscribers only. Join for access today.
In this unit
Maintained by: Kapow Primary team
Last update: 12th June, 2024
