Foundation Stage | Y1 • Y2 | Y3 • Y4 | Y5 • Y6 | |

## Mathematics: Year 5 • Year 6 ~ Excel activities |
||

Excel is simply a sheet of cells, each cell addressed using letters and numbers, into which different kinds of information can be entered. Excel offers teachers the facility to create templates of cells which can be manipulated and changed to present various problems and explorations for children to solve and explore. The versatility of the spreadsheet means that the activities can be quickly altered in order to set differentiated activities or tasks, for example the size of numbers used or number of options available can be changed. For example - Developing understanding of multiplication and division
- Finding missing numbers which are hidden by shapes or symbols
- Setting up templates which include formulae so that children can explore the effect that changing one number has on sequences and patterns in a variety of tables
- Observing the effect which changing information has on graphical representation and drawing conclusions
- Using random numbers to explore number patterns and puzzles
Used with well-directed questions the images and information presented can help children to see the internal structure of a problem and then use and apply this to solve other problems. Children can explain their ideas and reasoning and record these explanations within the workbook. They can then return to and improve or evaluate their explanations. In this section you will find examples of Excel workbooks and teaching notes to explain the activities and teaching strategies used. The zip files contain a word document and an Excel file. |
Shape puzzle |