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.

Before the lesson

This content is for subscribers only. Join for access today.

Lesson plan

1: Lesson plan

An area for you to put useful resources from the previous lesson

This content is for subscribers only. Join for access today.

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.

Richard Williams

Computing specialist

Image Specialists 6
Richard is a Year 6 Teacher at St. Pancras Primary School. Richard’s passion for teaching was recognised when he received Suffolk’s ‘Raising The Bar’ award for Innovation 2016. With his class he made the world’s first guided VR:360 school tour and also a…
Find out more
Image Specialists 6

Maintained by: Kapow Primary team

_
For copyright reasons, you may not screenshot this page.
Press esc to exit