The purpose of this resource is to provide simple and accurate tracking for pupils on the J835 OCR Health & Social Care course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Mark the optional unit with a Y in column R034 (AN) or R035 (AV). Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

Tracker for the 601/7699/4 OCR Cambridge Technical Extended Certificate. Record each unit grade in the entry columns marked with ‘E’. Select your optional units in columns AF and AI. The tracker will calculate Unit and Qualification points as well as UCAS points and compare against target. Calculated columns are marked with an ‘R’ for review. This tracker contains individual 1 page pupil print outs which can be bulk printed by selecting all tabs holding down Ctrl while you select and then print using Ctrl + P. Please let me know any feedback/bugs/suggestions. Thanks Tom

Tracker for the 601/7685/4 OCR Cambridge Technical Extended Certificate. Record each unit grade in the entry columns marked with ‘E’. Select your optional unit in column AI. The tracker will calculate Unit and Qualification points as well as UCAS points and compare against target. Calculated columns are marked with an ‘R’ for review. This tracker contains individual 1 page pupil print outs which can be bulk printed by selecting all tabs holding down Ctrl while you select and then print using Ctrl + P. Please let me know any feedback/bugs/suggestions. Thanks Tom

Tracker for the 601/7458/4 OCR Cambridge Technical Extended Certificate. Record each unit grade in the entry columns marked with ‘E’. The tracker will calculate Unit and Qualification points as well as UCAS points and compare against target. Calculated columns are marked with an ‘R’ for review. This tracker contains individual 1 page pupil print outs which can be bulk printed by selecting all tabs holding down Ctrl while you select and then print using Ctrl + P. Please let me know any feedback/bugs/suggestions. Thanks Tom

The purpose of this resource is to provide simple and accurate tracking for pupils on the 603/7090/7 OCR Cambridge National L1/2 Creative iMedia (J834) course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: Star 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom datatom1875@gmail.com

The purpose of this resource is to provide simple and accurate tracking for pupils on the L1/2 WJEC Hospitality & Catering course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: Star 2 - Distinction Star at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 Star 1 - Distinction Star at Level 1 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide simple and accurate tracking for pupils on the J829 OCR Sport Studies course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Mark the optional unit with a Y in column R186 (AM) or R187 (AT). Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide simple and accurate tracking for pupils on the J828 OCR Sport Science course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Mark the optional unit with a Y in column R182 (AN) or R183 (AU). Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide simple and accurate tracking for pupils on the J837 OCR Enterprise and Marketing course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide accurate tracking for pupils on the J809 OCR Child Development course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide simple and accurate tracking for pupils on the J823 OCR Engineering Manufacture course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom

The purpose of this resource is to provide accurate tracking for pupils on the J822 OCR Engineering course. Columns are marked with a green E for entry columns or a yellow R for review columns. Populate the Entry columns to calculate marks and grades for each unit and overall course. Additional learner details can be completed to allow filtering within the tracker. Enter target grade for progress comparison against target. The grades used in this tracker are: 2 - Distinction at Level 2 D2 - Distinction at Level 2 M2 - Merit at Level 2 P2 - Pass at Level 2 D1 - Distinction at Level 1 M1 - Merit at Level 1 P1 - Pass at Level 1 U The BRAG grades are: AT - Above Target (1+ grade above) OT - On Target BT - Below Target (1 grade below) SBT - Significantly Below Target (Less than 1 grade below) Please contact me for any further information or if you would like anything bespoke for your school. Data Tom