Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
Applicable for the 2021-2022 WRM assessments.
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.
Applicable for the 2021-2022 WRM assessments.
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.
Applicable for the 2021-2022 WRM assessments.
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.
Perfect for a Maths coordinator looking to have detailed discussions with class teachers about the specific strengths and areas for development for a whole cohort or individual children, these QLA/Gap Analysis grids for each of the White Rose Maths Autumn term assessments will help you support teachers to draw accurate and impactful conclusions from their assessment data.
So far these resources have been used:
To plan revision for a whole class.
To plan interventions for children
In pupil progress meetings to indicate areas for development.
As part of an evidence base for Ofsted deep dives into Maths
These are excel spreadsheet Gap Analysis documents for the 2023 Year Two SATs Papers for Maths .
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2023 SATs with that score. If it goes Purple with a White font, it means that child would have achieved a ‘More Able’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s or 2’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 60 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
A complete bundle of Gap Analysis Grids / QLA (Reading, GPS, Spelling, Arithmetic and Reasoning) for the 2022 KS2 SATs assessments. I have also included links to the papers, the mark schemes and the conversion grids within each spreadsheet.
Please read the description of each individual resource for more information.
This activity is differentiated two ways and focuses on the skills of identifying 2D polygons and telling the difference between regular polygons and irregular polygons. Furthermore, a reasoning challenge is included to help you assess whether children understand the difference between the two groups.
An easy to interpret answer sheet has been included.
This resource contains three differentiated codebreaking activities that will help you assess children's understanding of BIDMAS/BODMAS. Each activity has a detailed answer sheet with it. Furthermore, on each sheet there is an optional speed challenge - perfect for building up fluency.
Bronze level – Brackets, Multiplication, Division, Addition and Subtraction.
Silver Level – introduces indices and square roots.
Gold Level – introduces decimals.
This resource contains three, differentiated codebreaking activities that will help you assess children's understanding of Roman Numerals. Each activity has a detailed answer sheet with it. Furthermore, on each sheet there is an optional speed challenge - perfect for building up fluency.
Bronze level – Numerals up to 500 (D).
Silver Level – Numerals up to 1000 (M).
Gold Level – Famous years in Roman Numerals.
This resource contains three differentiated codebreaking activities that will help you assess children's understanding of multiplication. Each activity has a detailed answer sheet with it. Furthermore, on each sheet there is an optional speed challenge - perfect for building up fluency.
Bronze level – Short Multiplication
Silver Level – Long Multiplication
Gold Level –Long multiplication with decimals
Complete suite of Gap Analysis grids for the 2016 , 2017 & 2018 KS1 SATs. Reading, Maths and GPS papers for each year plus links to the matching assessments.
Please read each resources page for a more detailed breakdown of the contents.