1. Subjects >
  2. Computing >
  3. Key stage 2 >
  4. Year 4 >
  5. Computing systems and networks: Collaborative learning >
  6. Microsoft Office 365: Computing systems and networks: Collaborative learning >
  7. Lesson 5: Shared spreadsheets

Learning objective

  • To analyse data.

Success criteria

  • I can export data to a spreadsheet.
  • I can
Lock

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

Join Log in

National curriculum

Computing

Pupils should be taught to:

  • Understand
Lock

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

Join Log in

Cross-curricular links

Mathematics

Statistics

Pupils should be

Lock

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

Join Log in

Before the lesson

Lock

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

Join Log in

Lesson plan

Recap and recall

Display the Presentation: 3, 2, 1 and hand each child a whiteboard and pen.

Learning objective

Lock

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

Join Log in
Extended-mode explainer videos

How to extend your display to view the lesson page and presentation mode simultaneously. Choose your operating system below to watch the video

Mac

Windows

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

For pupils needing extra support

Could use the Resource: Conditional formatting for additional support.

Pupils working at greater depth

Should be encouraged to explore creating graphs using their data; should tinker with the data they have collected to see what they can find out.

Lock

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

Join Log in

Assessing progress and understanding

Pupils with secure understanding indicated by: exporting data to a spreadsheet; highlighting

Lock

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

Join Log in

Vocabulary definitions

  • average

    A number that shows the typical value in a set of data.

  • data

    Information, such as facts or numbers, that has been collected.

Lock

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

Join Log in

In this unit

Assessment - Computing Y4: Collaborative learning

Lesson 1: Teamwork

Lesson 2: Sharing a document

Lesson 3: Microsoft Forms 1

Lesson 4: Microsoft Forms 2

Lesson 5: Shared spreadsheets

Originally created by:

Sarah Vaughan

Computing specialist

pic
Sarah has 13 years of experience teaching in a primary school and leading computing.   She now works as a Subject Matter Expert for the NCCE across the East Midlands. In this role, she supports primary schools with bespoke training to develop and…
Find out more
pic

Maintained by: Kapow Primary team

Last update: 18th November, 2024

_
Lesson 4: Microsoft Forms 2 Previous Lesson
Lesson 5: Shared spreadsheets Next Lesson

Related content

Please don’t screenshot or copy images from this page.
Kapow Primary resources are created by teachers and protected by copyright. Copying images or slides into your own presentations (for example using the Snipping Tool) counts as reproducing the resource and isn’t permitted under the Kapow licence.
This resource is being accessed through your school’s Kapow licence.
Thank you for respecting the work of the teachers who create these materials.