Using estimated grade boundaries (as Edexcel aren't going to produce any) based on the old course, here is a tracking sheet that will guide students through the 2 year course with guided grades for each unit with the correct weighting applied.
It is set up for a mock examination for the listening/written paper and also the 2 compositions and 2 performances as well.
I will edit this every year as the new grade boundaries are released but please be advised these are estimated (although educated) boundaries.
This markbook works well for KS3 as well but I will now use it for the number GCSE number system. Each column works and is RAGged against the target level. It also works so it takes the best performing, composing and listening grade and averages them out to give an overall working at level in the end column. (Really useful for doing reports). Rather than an abc system it works on a 0.2, 0.5, 0.8 system for each grade.