HomedividerWhat is the National Whiteboard Network?dividerSubmitted resourcesdividerlinksdividerProtected areadividerIWB forumdividerHelp
National Whiteboard Network
LiteracydividerMathematicsdividerOther curriculum areasdividerLeadershipdividerSoftware and guidancedividerSearch

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


Mathematics: Year 1 • Year 2 ~ 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 numbers used or number of options available can be changed.

For example

  • Controlling counting forwards and backwards from a given number
  • Securing knowledge of addition and subtraction facts
  • Finding missing numbers which are hidden by shapes or symbols

Used with well-directed questions the images and information presented can help children to see the internal structure of a problem and explain their ideas. 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.

Downloads panel

Excel iconAdding 2 consecutive numbers
Excel iconAdding 19
Excel iconNumber square mystery
Excel icon4 number sentences
Excel iconAbacus for problem solving or place value
Excel iconRandom Numbers

zip iconAddition and subtraction facts
zip iconAddition and subtraction families
zip iconAddition and subtraction trios
zip iconArray creator
zip iconComplements
zip iconCounting stick
zip iconDice
zip iconDominoes
zip iconDoubling and halving
zip iconEstimation
zip iconFind the Multiples
zip iconMake my number
zip iconMake my total
zip iconMidway point
zip iconMultiplication grid
zip iconNumber Boards
zip iconNumber Grid Generator
zip iconPlace value – charts and partitioning tool
zip iconPlace Value Dots
zip iconSequences
zip iconStern Representations
zip iconSum, Product, Difference and Quotient

blue line