Scaled score to fine level conversion & Attainment 8 changes 2016-19.

These are resources for teachers, data managers or members of SLT responsible for attainment and progress.

1. Resources for Converting KS2 scaled score to Equivalent Fine Levels

They take KS2 national SAT data and gives a possible way to convert the KS2 scaled scores into equivalent fine levels so that the attainment 8 estimates for 2019 can be used to monitor the progress of learners in 2020 onwards.
They also analyse the changes in attainment 8 data over the last 5 years, gives some possible explanations for the changes and why these should now stabilise.
Finally there are resources for comparing a school’s KS2 SAT data fine level or scaled scores with national.

2.Resources for KS4 target setting.

These are resources that could be useful for seondary school senior leaders, subject leaders and data managers to set targets for the end of KS4. They are based on the KS2 SAT - KS4 GCSEs subject transition matrices using the 2019 data.

The techniques used are based on statistical and probability methodologies. You may initially have some difficulty with the concepts but with perseverance it should become clear.

In certain parts of the accompanying presentations I have drawn some conclusions e.g. regarding closing attainment gaps between genders and disadvantaged and non disadvantaged. These are my own and you may wish to draw alternative conclusions, all data and sources used are included to enable this.

There are several spreadsheets used included with the resources. These are locked to prevent accidental deletion of formulas used. If you need or wish to change any of these the password used is 1234.

3. Resources comparing relative difficulty of KS4 qualifications.

These resources use a combination of two sets of data from the DfE.

The 2019 KS2-KS4 transition matrices.

Data received under FOI request 2019-0040993: KS2-4 transition data for GCSE English language and mathematics for the cohorts for individual GCSE subjects.

The spreadsheet can be used to look at or determine

The “dependence” of the results in a GCSE subject of pupils’ prior performance as measured by KS2 SAT data in English reading and maths.
The patterns in attainment and progress “gaps” in pupil performance due to gender, disadvantage, SEN and EAL characteristics.

The relative difficulty or leniency of grading in subject GCSEs compared to a subject cohorts’ performance in GCSE English language and maths.

It is for users to investigate and draw their own conclusions.

Over time I intend to add explanatory documents with my conclusions and opinions, which you are free to ignore.

The spreadsheet uses a small amount of visual basic for filtering so macros need to be enabled. These just to add additional functionality to the filtering in Excel.