4Matrix Cloud Provisional KS4 APS for KS5 Progress Measures (Current Y12 2026/27)
This guide applies to Year 12 in the 2026/27 academic year. If you wish to import KS4 APS figures for use with the Value Added performance measure, you can use this guide to generate provisional KS4 APS data until the official data becomes available through GIAP (expected November 2026).
If you need to import KS4 APS for current Year 13 in the 2026/27 academic year or older cohorts, please refer to this article instead: ????
Importing KS4 APS: Understanding What’s Required
In 4Matrix, the KS4 APS figure reported in Year 11 series (and any other GCSE series) is based on and designed for KS4 Performance Indicators. It is not necessarily the same figure that will be used when setting the KS4 APS as the baseline for KS5 progress measures, not least because 2 separate figures are required, but because of the way the APS figures are calculated for this purpose.
Caveats in obtaining the APS figures from 4Matrix
It is possible to use the KS4 APS figures reported in the Course Profiles tool. These figures remain provisional until the information is officially published through GIAP.
Please be aware of the following information which affects early entries:
1. 4Matrix will use the qualification status setting for the active year i.e. for 2025/26 Y11, the 2026 calculation engine is applied and all qualifications for this cohort are handled in accordance with 2026 qualification statuses as issued by the DfE.
2. 4Matrix series will, by default, be based on First Entry and not Best Entry - the former is used for KS4 Performance Indicators, and the latter is used for the two APS figures for KS5 Progress Measures.
4Matrix users can still proceed and generate a GCSE Only APS and ALL APS score with the caveat that these figures are provisional until the information is officially published through GIAP.
Steps to obtain the APS from 4Matrix
Please only use this guide if your cohort have early entries.
Part 1 OBTAINING KS4 GCSE ONLY APS
1. Duplicate your Y11 Actual Results Series:
2. Go to Admin > Series
3. Tick the checkbox against the Year 11 Actual Results series
4. Click on Duplicate Series
5. For the series name enter, Year 11 Actual Results – GCSE only
6. Click on Year 11 Actual Results – GCSE only
7. Tick the checkbox against each non-GCSE course in the list. Click on Bulk Actions, Delete and confirm. This will only remove the course grades from this. Click on Actions and Recalculate.
8. In the Data Selection panel on the left hand side. Select the Year 11 Actual Results series and Course Name to Maths.
9. Open the Course Profile tool. Change from Chart view to Table View.
10. Right click the forename heading and click on Show Column Chooser and select the UPN column.
11. Download the Overview Grid and open the file. Delete row 1 and the columns for Classes, Result and Residual. Change the Average column heading to KS4 APS GCSE. Delete any pupils not in 2026-27 year 12. Save file.
12. Go to File > Export to Excel and save as KS4 APS GCSE.
PART 2 – IMPORT THE KS4APS DATA INTO 4MATRIX CLOUD
1. Go to Admin, Import Data and select the above spreadsheet file.
2. At step 2 ensure the bullet is against ‘Results’ for file type. Select the academic year 2026-27 – and your most recent year 12 2026-2027 series.
3. In Step 2 "Map Data" map the APS field to "KS4 APS" in the Include As column
4. Complete the import.
Part 1 OBTAINING KS4 GCSE ALL
1. In the Data Selection panel on the left hand side. Select the Year 11 Actual Results – GCSE only and Course Name to Maths.
2. Open the Course Profile tool. Change from Chart view to Table View.
3. Right click the forename heading and click on Show Column Chooser and select the UPN column.
4. Download the Overview Grid and open the file. Delete row one and columns for Classes, Result and Residual. Change the Average column heading to KS4 APS GCSE. Delete any pupils not in 2026-27 year 12. Save file.
PART 2 – IMPORT THE KS4APS GSCE DATA INTO 4MATRIX CLOUD
1. Go to Admin, Import Data and select the above spreadsheet file.
2. At step 2 ensure the bullet is against ‘Results’ for file type.
3. Select the academic year 2026-27 – and your most recent year 12 2026-2027 series.
3. In Step 2 "Map Data" map the APS field to "KS4 APS GCSE" in the Include As column .
4. Complete the import.
External students joining Year 12
You will have to calculate the KS4 APS figures manually for any external students joining Year 12. This could be done by referencing exam results certificates or an export from your MIS into Excel, replacing grades with points values where necessary. These can be either imported into 4Matrix Cloud using a spreadsheet into a Year 12 academic year 2026-27 series or manually via Admin, Pupil Basedata.
Working with Value Added for this cohort
The KS5 Value Added tool in 4Matrix is based on data from the DfE’s Ready Reckoner. The latest VA coefficients in 4Matrix are the validated 2025 dataset, published by the DFE in April 2026.
While it is not possible to predict or accurately calculate your Value Added score in advance, our VA tools can be used to explore and fully understand the parameters governing Value Added, and to model the effect of future changes, provided schools remain aware of the caveats.