White Rose Autumn end of term Assessment Gap Analysis / QLA Year 5

This resource will save you many hours work when trying to use Assessment for Learning in your class.

There are two QLA grids included in one Excel document for help with Gap Analysis.

• Arithmetic
• Reasoning

Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.

The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.

The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.

Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.

Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.