Hero image




Grid of Sums Maths ICT Investigation Excel Spreadsheet KS2 KS3 KS4

Grid of Sums Maths ICT Investigation Excel Spreadsheet KS2 KS3 KS4

I was inspired by the Maths resource of the week recently on the Grid of Sums puzzle and decided to make an excel file that allows students to quickly work through the investigation. Tutorial on the puzzle here http://www.dr-mikes-math-games-for-kids.com/le-monde-grid-puzzle.html The Grid of Sums puzzle works by choosing a square and then adding up all the squares around it to get the total. If the total is zero then place a 1 in the square. This can be extended with many questions which are included. What you get: Fully coded excel file that is protected so that students can only interact with the game grid and not delete the code 11 questions for students to investigation Individual grids to problem solve on (3x3, 4x4 and hexagonal), also includes a ranking system so students know how good their score is. 3x3 and 4x4 2 player grids with auto scoring. Works with negative numbers as well Please note that I have tried my best to ensure there are no errors in the code, if you do find one then please message me and I will try to fix the problem. It is also difficult to lock in the conditional formatting and students can disrupt this feature by dragging the little dot in the bottom right of a cell. If this happens just reload the file. If you want to edit anything or add to the code then you will need to unlock the spreadsheet by choosing 'format' from the Home tab and choosing 'unprotect sheet'. Please email me at gwilson.physics@gmail.com with any issues