The powerful subject value-added (VA) grid (see Toolkit files below) combines DfE transition matrices (TMs) with the pupil-level datafile produced for each school by the DfE for the exam result data-checking exercise each October.
At a glance (using the familiar RAISE convention of green = 'good' / blue = 'under'), you can see for each of the main GCSE subjects how your school has performed against national by each KS2 sub-level. This grid format facilitates a detailed discussion, which can look at varying input abilities and output grades, for example.
These two spreadsheets can be used to calculate the subject VA for 2018 and 2019 for the 2020 exam grading process.
We are grateful to ASCL member David Blow for his continuing work on the transition matrices (TM) tool.
GCSE_subject VA GRID for 2019 using 2019 TMs v11d 1Nov19
GCSE subject VA GRID for 2018 using 2018 TMs v11b 26 April 2019
xxx School blank Subject TMs June 2018 with '18 TMs v11
Detailed notes on subject VA GRID for Jun 18 v11 21 Feb 2019
Members may also wish to refer to the Progress 8 toolkit. David has also produced Using Key Stage 2 data as an input measure for secondary schools, 2016-18 which can be downloaded here.