BTEC Level 2 Engineering: Unit 7 Tracking Spreadsheet

This is the tracking sheet that accompanies the Unit 7 Booklet that I have for sale. This spreadsheet is something that I display each lesson to the group to inform both them and me where each student is in the unit.

Each column references a specific page in the booklet and each column is conditionally formatted to change depending on the data you enter;

Entering 'y' = box turns green meaning work is completed
Entering 'r' = box turns orange meaning work needs to be resubmitted
Entering 'n' = box turns red meaning work was not completed
Entering 'a' = box turns blue meaning student was absent when work was collected

I have found this to be an invaluable resource during my lessons and the students are able to self-track and manage their work.

I am uploading this without any password protection so that the entire workbook is editable if you wish to modify this as you wish.

Feedback appreciated!