Assessment, Computer Science, using GCSE Grades - adjusted Progression Pathways

CAS Progression Pathways
(original source: https://community.computingatschool.org.uk/resources/1692 )
I use CAS Progression Pathways to asses my pupils and due to changes in area of assessing pupils progress without levels, I had to adjust this to fit our school policy.

We use GCSE Grading system joined with progress within a grade.

Progressing, Grade 1.....Grade 9

B - Beginning
E - Emerging
D - Developing
S - Secure
M - Mastered

Example
Students can achieve 1e (Grade 1 - emerging).

I am using separate grades tabs to record pupils work (tab P, 1, 2, 3,..) but entering the information into the cells in these worksheets will automatically fill the Progress worksheet where you can see the overall progress for each student.
If you are doing your work based on topics (Algorithms, Programming and Development,...), you also can see pupils progressing in separate areas of the curriculum. All this is automated and you have to enter the grade only once into Grades tab.