Help Sheet Adapting The Sats Analysis Spreadsheets Help sheet: adapting the sats analysis spreadsheets 1. select the ‘question analysis paper 1’ tab at the bottom of the excel screen. 2. via the edit icon delete the contents of the section of the table highlighted. nb do not enter any data in the % column. 3. you can now type in the question numbers, questions, attainment target, level. Twinkl has lots of lovely previous sats paper grid analysis spreadsheets resources for your ks2 maths students.
2018 Sats Data Analysis Sheet Teaching Resources This simple and handy 2025 ks2 sats papers and analysis spreadsheet is the perfect way to track how well your year 6 students did with the maths sats assessment. As a bit of an excel nerd, i have developed these spreadsheets with the help of a colleague at school. hopefully they are fairly straight forward to use – add the names and the raw scores and the spreadsheet will do the rest. This pack comprises a qla (question level analysis) spreadsheet for the 2019, 2022, 2023, 2024 and 2025 ks2 maths sats papers.these are designed to work on office 365 (please note that some formulae may not work if you are not using office 365). This simple and handy assessment spreadsheet is the perfect way to track how well your year 6 students did with the spag sats assessment.
2016 Ks1 Ks2 Sats Analysis Spreadsheets Etsy Australia This pack comprises a qla (question level analysis) spreadsheet for the 2019, 2022, 2023, 2024 and 2025 ks2 maths sats papers.these are designed to work on office 365 (please note that some formulae may not work if you are not using office 365). This simple and handy assessment spreadsheet is the perfect way to track how well your year 6 students did with the spag sats assessment. These grids have been colour coded with content domains that have been tested and formulas already in the excel document based on 30 children. these are extremely useful for gap analysis and identify which areas that would be useful to address in the run up to ks2 sats. All that is required here is for teachers to input their raw data scores for each part of the mock sats e.g. raw score for arithmetic paper 1, reasoning paper 2 and reasoning paper 3, and that’s it!. Accompanying the analysis spreadsheets, documents and progress tracker is a digital guidance video that explains each of the resources and how to use them. This editable spreadsheet provides a clear question level gap analysis of the 2025 ks2 reading sats, helping year 6 teachers quickly identify strengths, weaknesses and priority areas.
Analysis Spreadsheets For Ks2 Sats Reading May 2016 And Ks2 Sample Sats These grids have been colour coded with content domains that have been tested and formulas already in the excel document based on 30 children. these are extremely useful for gap analysis and identify which areas that would be useful to address in the run up to ks2 sats. All that is required here is for teachers to input their raw data scores for each part of the mock sats e.g. raw score for arithmetic paper 1, reasoning paper 2 and reasoning paper 3, and that’s it!. Accompanying the analysis spreadsheets, documents and progress tracker is a digital guidance video that explains each of the resources and how to use them. This editable spreadsheet provides a clear question level gap analysis of the 2025 ks2 reading sats, helping year 6 teachers quickly identify strengths, weaknesses and priority areas.
Comments are closed.