ICT at key stages 1 and 2 (Year 6)
Unit 6B: Spreadsheet modelling
Section 3: SHORT FOCUSED TASKS
|
|
Objectives |
| Children should learn: |
|
Activities |
|
Outcomes |
|
Children: |
- Show the class how to copy fomulae from one cell to another. Ask the children to create a set of multiplication tables such as:
| number A |
number B |
number A x number B |
| 4 |
1 |
4 |
| 4 |
2 |
8 |
The spreadsheet should extend number B to 12. Ask the children to investigate changing number A.
|
|
- copy formulae to create tables of results
|
|
Points to note |
Children could be shown how to use and copy a formula such as '=C3+1' to produce a second column of figures.
|
|
|
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.
|
|
|
