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.
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.
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.
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.
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
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.
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.
A complete bundle of Gap Analysis Grids / QLA (Reading, GPS, Spelling, Arithmetic and Reasoning) for the 2023 KS1 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.
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.
Suitable for Years 5-7, this worksheet challenges children to use their knowledge of substitution to find the value of an equation.
Instead of the usual 'a', 'b', 'c' etc, this activity asks children to find the value of equations that contain snowmen, angels, presents, santas etc.
This is a 4-way differentiated worksheet/activity sheet that tests children's understanding of how to add a mixed number to a proper fraction, which is tested at the end of Year Six and onwards in SATs assessments (arithmetic/reasoning) and in other end of year assessments.
There are four challenges:
-Add a mixed number to a proper fraction (same denominators).
-Add a mixed number to a proper fraction (different denominators).
-Add two mixed numbers to a proper fraction (same denominators)
-Add two mixed numbers to a proper fraction (different denominators)
At each stage, children will be expected to give their answer in its simplest form, as is standard practice in the assessed tests.
I have also included an answer sheet.
This is a two-challenge activity sheet/worksheet aimed at children in Years 5-7.
Children are asked to put fractions in ascending and descending order when their denominators are not the same. This tests their knowledge of fractions, common multiples and simplification.
This is a 3-way differentiated worksheet/activity sheet that tests children’s knowledge of percentages.
The three challenges are as follows:
-Find 10% of a quantity.
-Find multiples of five or ten percent of a quantity.
-– find any percentage of a quantity and word problems
I have included an answer sheet.