Standards Site

 
 
Schemes of Work
QCA

ICT at key stages 1 and 2    (Year 5)

Unit 5D: Introduction to spreadsheets

QCA

Objectives

Section 1: SETTING THE SCENE
Children should learn:
  • key idea: that computers can calculate costs and are useful when prices change

View related activities and outcomes

Section 2: SHORT FOCUSED TASKS
Children should learn:
  • technique: to enter labels and numbers into a spreadsheet

View related activities and outcomes

Section 3: SHORT FOCUSED TASKS
Children should learn:
  • technique: to enter formulae into a spreadsheet

View related activities and outcomes

Section 4: SHORT FOCUSED TASKS
Children should learn:
  • technique: to use 'SUM' to calculate the total of a set of numbers in a range of cells

View related activities and outcomes

Section 5: INTEGRATED TASK
Children should learn:
  • to change data in a spreadsheet to answer 'what if...?' questions and check predictions

View related activities and outcomes


Sections in this unit

This unit is divided into sections. Each section contains a sequence of activities with related objectives and outcomes. You can view this unit by moving through the sections or print/download the whole unit.
1. SETTING THE SCENE
2. SHORT FOCUSED TASKS
3. SHORT FOCUSED TASKS
4. SHORT FOCUSED TASKS
5. INTEGRATED TASK