| Description | Creating and investigating a spreadsheet using diet information collected over a 3 day period. Using formulae and producing graphs and charts. |
| Potential Year Groups | 5 or 6 |
| Approx time | 4 x 1 hour |
| Software |
Microsoft Excel Microsoft Word |
| Difficulty level | 5 |
| Skills | Key Stage 2 Collecting and presenting information compare bar and pie charts, and talk about what they show. design a questionnaire / collect data to enter into a database. use a database to create bar charts and pie charts. use ICT to interpret and analyse information in graphs Introduction to spreadsheets enter a formula to add the contents of two cells. enter data into spreadsheet cells. use SUM to add up numbers in a column or row. Spreadsheet modelling copy formulae to create tables of results. enter formulae, change data and predict the results. make decisions based on spreadsheet model (see below) set up a spreadsheet to model a mathematical investigation. |
Inspiring cross-curricular ICT