UPDATED 2021 PAG Calculator (Prior Attainment Group Calculator)

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