national Whiteboard Network: Mathematics


Your path: Home » Mathematics » Year 3 • Year 4 » Excel activities
Mathematics: Year 3 • Year 4 ~ Excel activities
Mathematical challenges Problem solving materials Excel activities Stand-alone lessons Interactive Teaching Programs - 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 Controlling counting forwards and backwards from a given number Securing knowledge of multiplication and division facts 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 Used with well-directed questions the images and information presented can help children to see the internal structure of a problem. They can then use and apply this to solve other problems. 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. The excel files are flexible resources that can be used in many mathematics lessons. There is some short guidance in accompanying word documents. These documents explain how to use the excel files and give some suggested questions to be asked in lessons. When you open the files, you must ensure you enable the macros. Your security settings on your macros must be set at medium security. If you need to change your security, open an excel file, click on tools, scroll down to macros and follow the arrow, click security, select medium and click OK. The files will work in this mode.	Fractions Multiplication by partitioning Partitioning numbers Problem solving Problem with 12 4 number sentences Abacus for problem solving or place value Random Numbers Target Practice Total 20 Addition and subtraction facts Addition and subtraction families Addition and subtraction trios Array creator Complements Counting stick Dice Dominoes Doubling and halving Estimation Expanded addition FDP converter Find the Multiples Make my number Make my total Midway point Multiplication grid Number Boards Number Grid Generator Place value – charts and partitioning tool Place Value Dots Sequences Subtraction 4 digit 3 digit Sum, Product, Difference and Quotient

Mathematics: Year 3 • Year 4 ~ Excel activities