Dynamic "ALPS"-style Markbook for A-level

This is an Excel-based markbook for use at A-level.

1. Simply enter or cut and paste in students' names and GCSE average point score (also gender, pupil premium eligibility, SEND status to fully utilise the functionality of the markbook).

2. Select the A-level subject at the top of the sheet. Subjects included are:
Art
Biology
Business
Chemistry
Design & Technology
Drama
Economics
English Combined
English Literature
Geography
Health (double)
Health (single)
History
Law
Maths
Maths (Further)
Media
Music
Music Technology
Performance
Photography
Physical Education
Physics
Psychology
Sociology
[** the document is not locked for editing so you can add extra subjects/edit to your heart's desire]

3. The sheet generates ALPS-style target grades (NB: it uses the same 'Look-up' table as ALPS, but actually generates 'fine grades', ie. B+, B, B-, rather than 'split grades', ie. B, B/C, C

4. Then, every time you put in a new set of grades, the sheet colour-codes these compared with student targets, and calculates class statistics (ie. current 'ALPS' grade, %A*-B, %A*-E and %achieving target grade; including breaking these down by gender, PP, SEND and prior attainment.)

With an up-to-date ALPS-style grade every time you do an assessment, there should be no nasty surprises. I find it useful anyway!

I have included a second file with a bunch of made-up students in so that you can see how things are meant to work.