Top set Y6. Showing how to work out the formula for the triangular numbers from a simple visual stimulus. All of the set could explain in words the formula and most could write it down. They remembered it afterwards too!! Feel free to alter the initial slides for you class.

TU x U, HTU x U and HTU x TU. Enable macros to allow the sheet to generate new calculations. One note is that it could generate duplicates calculations as I haven't found a way to avoid this yet (not tried too hard) but just hit the button again to generate another sheet.

A treasure map using the 4 quadrants. Using the initial co-ordinate clue the children find the first letter (O). This letter then gives them the clue to the next co-ordinate and so on until the arrive at the final letter (P). Used it on my lower ability Y5 set with a lot of success. The ones who could, managed it very quickly and could then go on to design their own, and it was very easy to pick out the ones who couldn't and give them assistance. They all managed it eventually.

Part of year 4 Geometry – position and direction to help practice plotting specified points and drawing sides to complete a given polygon. 6 examples to work through. Starting with a lines to complete the shape and then moving on the completing shapes given co-ordinates. Re-edited thanks to helpful review.

Taken from the DfE document STA/13/6294/e ISBN: 978-1-78315-049-6 English grammar, punctuation and spelling test - Performance descriptors But presented as a list of items that have to be taught level by level. Create your own ticky box list, you know you want too!!

Hit the smiley in the middle and a new character, setting and dilemma are chosen automatically (with pictures). Sorry it is a but rough but my set enjoyed hitting the smiley and the quick 10 minute writing task, particularly the boys. It is possible to change the character, setting and dilemma they are in the hidden rows from 2 to 17, you might not like some of the syntax, but the images are a but more difficult as the are hidden.

Generates a list of 25 random numbers less than 100, then sorts them numerically (leaving original order for comparison) automatically calculates mode, median and mean, with a graph of the three results. Make sure you enable macros then press the top button to set up the needed addins and to undo them when finished press the bottom button. (The buttons just ensure that the iterations are set correctly). No I didn't know what that meant until I made this spread sheet either :)

Two dice are thrown and the scores added up, 11 spiders numbered 2 to 12 then move up a lane if their number corresponds to the total. they race until one spider crosses the winning line. Fun way to show probability in action.

The graph records the cumulative results of two dice being thrown, you also can see how many times the two have been thrown. You do need to enable macros to make it work and the instructions page will help if it doesn't work initially (quite easy to do).

A blank 100 square, press the times table buttons to highlight where that table appears on the square. Also 2 and 3 times table and 3,6 and 9 times tables. Needs Macros enabled.

Pressing the blue button will randomly create a set of green and purple coloured rectangles. The total number of both colours form the denominator of a fraction so the class can then discuss what the numerator is. Useful for working out equivalent fractions too.

The classic game for your white board. Lots of logic needed to solve the code.

Year 5 count forwards or backwards in steps of powers of 10 from any given number. A macro enabled worksheet that will generate a number from 0 to 1 million, say what power of ten upto 10,000 to count in and whether to count up or down. How many steps is up to you.