This excel sheet will automatically report the PAG group to which a pupil belongs based on KS1 data you enter. It will also return results to show you what the average KS2 result was for pupils in the same PAG in 2017, for Reading, Writing and Maths.

Instant visual maps / MAGs for reading, writing and maths Enter KS1 outcomes and current KS2 attainment and your visual maps are automatically created for you Video showcases entire suite, including this tool

This will create PAG datasets for scrutiny, supporting senior leaders produce data for appraisal, strategic planning, inspection and reporting to governors. Analysis by multiple subgroups for all three subjects. Instant - it will take you about 15min to enter your pupil data, and the numbers are crunched for you as you type! Video showcases complete suite, including this tool.

Analysis of the groups of pupils who attained the expected standard in all three subjects combined at the end of KS1. Grid shows which of these children are on track to attain RWM at end of KS2, and which ones have slipped behind. Similarly, will identify pupils who did not attain RWM at KS1 who are now on track to attain RWM at KS2. Detailed analysis by subgroup. Video showcases complete suite, including this tool.

This file contains ALL of the features in my other tools: Visual Map Writer Prior Attainment Group Analysis Detailed Analysis of All Subjects Reading, Writing & Maths Combined Analysis With this tool, you can access all of the features from one set of data. Two files are included: V1.2 - this is not a macro enabled file, and does not include any macros V1.3 - this is a macro enabled file, and if you allow macros, has the added functionality of exporting reports to word documents

Detailed analysis of progress and attainment in reading, writing and maths by pupil subgroup. Rich sets of data from your relatively quick and easy data entry! Video showcases the complete suite, including this tool.

UPDATED February 2021 This excel sheet will automatically report the PAG group to which a pupil belongs based on KS1 data you enter. It will also: calculate their expected KS2 score for 2018/2019 (the most recent reportable data as of Feb 2021) calculate progress (0 being the expected) for each pupil for each subject calculate overall progress for the school for each subject “All those working with schools and colleges, such as Ofsted, Department for Education regional teams and local authorities, should use data from previous years when assessing school and college performance, and not the 2020 data.”* https://www.gov.uk/government/publications/coronavirus-covid-19-school-and-college-performance-measures/coronavirus-covid-19-school-and-college-accountability