Maths Assessment Grids
Age Range: 5 to 11
James has contributed a handy Excel tool to help primary teachers keep a summary 'overview' of what parts of the curriculum their students have covered. Each area can be colour coded to assist (using traffic-light colours).
Download the Excel sheet here. 
He explains... When you open the Excel document, a dialogue box will ask you if you want to 'Enable Macros' - which you should allow. The macro enables you to double-click on any cell to change the colour from blank, to red, to amber, to green and back to blank.
You will see that all of the worksheets are completely the same - I have just joined them together in Excel to allow teachers to scroll through each year group (from Year R up to Year 6) and choose the most appropriate cells for each student. All you need to do is to use the LEFT and RIGHT arrow keys to go forwards or back. Double clicking in any of the cells will highlight them and make them change colour (and make the text bold).
There is a worksheet for each member of the class. If the file is saved it will store the most recent levelling, placement and highlighting and can be dated or updated accordingly to evidence progress. Teachers can use File --> 'Select Print Area' within Excel if they want to print a hard copy of part of the assessment.
Note: if the colour highlighting doesn't work, you may have to click on Tools/Macro/Security to change security level to Medium or Low. Do this and reopen the Excel file, then choose 'Enable Macros.
Comments powered by Disqus
