ICT at key stage 3 (Year 7)
Unit 4: Models - rules and investigations
Section 1: Activity 1
|
|
Objectives |
| Children should learn: |
- to revise calculation and graphing techniques in a spreadsheet
- the basic structure of spreadsheet formulae
|
Activities |
|
Outcomes |
|
Children: |
- Revise pupils' knowledge of spreadsheet techniques, including entry of data and formulae, graphing and modelling techniques. Use a prepared spreadsheet with column 1 being the items in a recipe for oatcakes, column 2 being the amount required to make enough oatcakes for four people and column 3 the cost of the item. Ask the pupils to investigate what happens when they change the values of any variable. Tasks for pupils could include demonstrating formulae building and replication to produce total costs for enough cakes for 8, 12 or more people. They could use an absolute cell to calculate costs and amounts for any variable,
eg if the price of oats goes up or feedback from customers is that oatcakes are too sweet, too small.
|
|
- carry out calculations and graphing techniques
- create correct formulae
|
|
Points to note |
- Graphing techniques could be revised using a different spreadsheet containing values of,
eg x, x+2, x2
|
|
|
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.
|
|
|
