Updated KS4 transition matrices tool with 2018 national figures

April 2019

The powerful subject value-added (VA) grid (see Toolkit files below) combines DfE transition matrices (TMs), published as part of the Guidance in the Performance Tables in January 2019, 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. 

The spreadsheet allows you to compare all pupils/male.female/disadvantaged/non-disadvantaged and new introduction of EAL / nonEAL and SEN / nonSEN  for your school with comparable categories nationally. 

We are grateful to ASCL member David Blow for his continuing work on the transition matrices (TM) tool.

Toolkit files
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.

Related Pages

September pupil level data checking exercise and provisional DfE performance indicators

  • Assessment
  • Accountability
  • Inspection
  • Ofsted
  • Key Stage 2
  • Attainment 8
  • Key Stage 4
  • GCSE
  • BTEC
  • Performance Tables
  • Progress 8

Education Inspection Framework 2019: Inspecting the quality of education

  • Curriculum
  • Assessment
  • Accountability
  • Inspection
  • Ofsted
  • Attainment 8
  • Progress 8

Pupil Premium guidance and templates

  • Funding
  • Primary
  • Business Leadership
  • Financial planning
  • Budget
  • Data
  • Key Stage 1
  • Key Stage 2
  • Regulations
  • Finance
  • Key Stage 3
  • Key Stage 4
  • Resources
  • Pupil Premium