 |  | Year 5Handling Data |
Introduction to Spreadsheets
| Year Group | some children will not have made so much progress and will | most children will | some children will have progressed further and will |
| Year 5 | Be able to develop a database, or create a yes/no branching database to identify something. Will need help interpreting data presented graphically. | In order to solve a problem use ICT to collect and process data and present their findings. Be able to create a database and compare graphical data. E.g. Children investigate the difference between the life expectancy of children in Victorian and modern times. | Generate, process, interpret and store and present data, understanding the need for accuracy. |
| Show elements of Level 3 - use of ICT to develop ideas and solve problems | |||
| Year Group | some children will not have made so much progress and will | most children will | some children will have progressed further and will |
| Year 5 | Use a pre-prepared spreadsheet model to explore the effects of changes. Use a provided graphical model to test spatial theories. | Use ICT based models to explore variables to solve problems. Some will understand the principles behind spreadsheet formulae and start to create their own. e.g. Use a pre-prepared spreadsheet to calculate costs of ingredients for biscuits, or supplying an event. Pupils answer questions about price or quality changes | Create their own spreadsheet model with formulae, which they can explain and adjust if necessary. Be able to review rules and variables and make predictions about the consequences of decisions. |
| Show elements of Level 3 - use of ICT to develop ideas and solve problems | Show elements of Level 3 use ICT-based models to explore patterns and relationships, and make predictions about the consequences of their decisions. | ||
| Linked Planning | Linked Resources | ||
| Data Handling 5D Introduction to spreadsheets |
| ||
 Formulae | |||
| Party Plan (Number Magic) | |||
Introduction to spreadsheets
Click here to download the plannng seen below
Week | Area of study (From NC PoS) | Learning Objectives | Activities | Key Vocabulary | Resources | Assessment Outcomes |
|
1 | Enter and store information …. think about what might happen if there were any errors … | To enter information into a spreadsheet. | Demonstrate how to enter the results of a science investigation into a spreadsheet. Pupils create their own table. | Spreadsheet | Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet | Level 4: Level 5: I can check it is accurate and organise this information so that it is ready for processing. |
|
2 | Interpret information, to check it is relevant and reasonable. | To create charts and graphs using a spreadsheet. | Pupils use the spreadsheet to create a line graph, pie chart & bar chart. Which type is most helpful? Interpret the chart / graph. | Spreadsheet | Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet | |
|
3 | Interpret information …. think about what might happen if there were any errors … | To create charts and graphs using a spreadsheet. | Pupils enter a list of the ingredients to make bread & their costs into a spreadsheet. Pupils create a chart to show the costs of each item. | Spreadsheet | Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet | |
|
4 | Interpret information …. think about what might happen if there were any errors … | To use formula within a spreadsheet. | Pupils enter formula into a spreadsheet to find out the total cost. Pupils explore changing the costs and using other formula. | Spreadsheet | Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet | |
|
5 | Interpret information …. think about what might happen if there were any errors … | To use a spreadsheet to record the costs of planning an event. | Pupils are given a budget & create a spreadsheet to record the costings for a party. Pupils create charts to show these costs and use formula to calculate total. | Spreadsheet | Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet |
