In Key Stage 3, Heads of Year and Subject Heads will want to know data for attainment, (ranking), and progress. You will notice that GCSE grades and especially sub-grades are not used for Key Stage 3, with this great article giving very good reasoning.
The spreadsheet (link below) is for Mathematics, but can easily be adapted for other subjects.
Here is an example spreadsheet.
Here, is a video explaining how it works.