Cambridge Technicals in Business - CTEC Business 2016 - Excel Tracker

Cambridge Technicals in Business - CTEC Business 2016 - Excel Tracker

A spreadsheet I have used for the past two years to keep track of progress in CTEC Business. The spreadsheet uses a VLOOKUP for marks given for each unit and it will automatically generate a mark for an LO. Really useful to display on the board for pupils to allow them to keep track of their own progress. Grades for each unit should be U, P, M or D.
RobertsResources
Cambridge Technicals in IT - CTEC IT 2016 - Excel Tracker

Cambridge Technicals in IT - CTEC IT 2016 - Excel Tracker

A spreadsheet I have used for the past two years to keep track of progress in CTEC IT. The spreadsheet uses a VLOOKUP for marks given for each unit and it will automatically generate a mark for an LO. Really useful to display on the board for pupils to allow them to keep track of their own progress. Grades for each unit should be U, P, M or D. Add student details and marks for each section (mock exams) and a grade and is calculated. This spreadsheet has proved very successful for predicting outcomes.
RobertsResources