Photo Credit: josef.stuefer via Compfight

Some time ago I published instructions to help schools using Assessment Manager to calculate if their pupils were making acceptable progress between KS2 and KS4 based on the DfE guidance. Recently, @vikpaw emailed me a much more elegant method for using Assessment Manager to indicate the pupils who are (or are not) making expected progress. Here’s the resulting marksheet:

Here’s my summary of the DfE rules for expected progress:

KS2 | GCSE ‘E’ | GCSE ‘D’ | GCSE ‘C’ | GCSE ‘B’ | GCSE ‘A’ | GCSE ‘A*’ |

Level 2 | Yes |
Yes |
Yes |
Yes |
Yes |
Yes |

Level 3 | No |
Yes |
Yes |
Yes |
Yes |
Yes |

Level 4 | No |
No |
Yes |
Yes |
Yes |
Yes |

Level 5 | No |
No |
No |
Yes |
Yes |
Yes |

So a level 5 pupil at KS2 is expected to make at least a grade B at KS4, while a level 2 pupil at KS2 is expected to make at least an E at GCSE.

As you know, both national curriculum levels and GCSE grades have a points value associated with them. For example, 4b has a points value of 27 and a GCSE grade C has a points score of 40. Hence there is a difference of 13 points between a level 4 and the expected progress of a level 4 pupil to grade C at GCSE. **This ‘rule of 13 points’ holds for all the examples in the table above even though there is no official link between national curriculum sublevel points score and GCSE points scores. **So we can create formulas in our marksheets to look for a difference of 13 points or more between the KS2 points score and the GCSE points score.

Assuming we already have a marksheet with a pupil’s KS2 result and GCSE expected grade, we just need to add two formula columns to our marksheet. The first column calculates the points difference between the KS2 result and our expected GCSE grade:

The second column uses a nested-if-then-else formula to decide if the value is greater than or equal to 13 and apply the relevant colour:

Once again, thanks to @vikpaw.

### Similar Posts:

- Highlighting Pupils Who Have Made Three Levels Progress KS2 to KS4
- An Easy Way to Calculate a Pupil’s Levels of Progress from KS2 to KS4 with SIMS
- Calculating Key Performance Indicators for Secondary Schools
- Using SIMS to Convert to New GCSE Grades 1-8
- Another Easy Way to Calculate Levels of Progress in SIMS

Given that a single level of progress is worth 6 points, then for a student to achieve 3 levels of progress they need to progress by 18 points from ks2 to ks4.

So a student acheiving a level 4b at key stage 2 will score 27 points. Add 18 points to this and they will have to score 45 points at ks4. If they achieve a Grade C (as indicated by DfE tables for expected progress) they will score 40 points. This is only an improvement of 13 points. Will they still be deemed to have made 3 levels of progress when league tables are produced?

I had formed the impression that ‘expected’ progress had superceded ‘3 levels’ progress but I may be wrong! Certainly the new style performance tables make no mention of 3 levels of progress…

The FFT people also assume that ‘3 levels of progress’ is ‘expected progress’. See this pdf file on the FFT Live website: https://www.fftlive.org/Live/Help/FFTL32/EXP/FFT_Briefing_Note_English_Bacc_&_Basics.pdf