This excel and word document combination is designed to be used to allow you to track and monitor the progress of students as you navigate through the theory elements of the AQA GCSE Computer Science (9 to 1) specification.
In the word document there is a space for the students to note down their level of confidence with each of the points off the specification, there is also space for them to update this level of confidence as you revise/go over topics with them.
The excel document gives the teacher the opportunity to enter a value of between 1 and 10 for each point on the specification to allow you to track the progress of the students with each part of the theory topics. It will break down each point on the specification and will show you roughly what percentage they have attained for each section of the theory course. It will also provide a working at grade (this is just calculated from all of the percentage understanding values from each section).
UPDATE: 30/09/2018 - This resource now also includes an alternate version of the tracker to be used as a “Personalised Learning Checklist” with spaces for both the student and teacher to make comments. The “Book Chapters” mentioned on the PLC reference the AQA Computer Science for GCSE Students textbook by Hodder (Sean O’Byrne, George Rouse).