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.

These are excel spreadsheets Gap Analysis documents for the May 2022 Year Six SATs Papers for Maths (Arithmetic, Reasoning 1 and Reasoning 2). **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 2022 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, 2’s or 3’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 90 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. This password will not be given out, but I am more than happy to make adaptations or changes for you, provided you show proof of purchase. All of my contact details are in the resource. 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.

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.

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.

These are copies of the White Rose Maths end of term assessments. I do not own these papers and they are freely available on the White Rose Maths website to everyone, regardless as to whether they have a premium subscription or not. White Rose Maths own the copyright and trademarks for these papers. I assert not claim over them.

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.

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.