ICT at key stages 1 and 2 (Year 5)
Unit 5D: Introduction to spreadsheets
Section 3: SHORT FOCUSED TASKS
|
|
Objectives |
| Children should learn: |
- technique: to enter formulae into a spreadsheet
|
Activities |
|
Outcomes |
|
Children: |
- Show the children how to enter a formula into a spreadsheet, such as '=c2+c3'. Ask the children to use formulae to add the contents of two cells. Ask the children to explore what happens when data in the two cells is changed. Ask them to explore subtraction, multiplication and division and to predict how the contents of cells will change.
|
|
- enter data and formulae into cells, modify the data, make predictions of changes and check results
|
|
Points to note |
More able children could try more complex formulae such as '=3*c2+c3'. If they are not familiar with using brackets they may be surprised by the results.
|
|
|
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.
|
|
|
