BTEC level 2 and BTEC 3 sport course tracking documents with look up tables and formulas calculated

These excel spreadsheets are designed to help PE teachers accurately track and monitor both BTEC level 2 Pearson first award in sport (4 units) and BTEC level 3 Pearson BTEC Level 3 National Extended Diploma in Sport. There is a seperate tracker for each course.

There are seperate sheet tabs already done for the different units split into the different learning aim criteria where you need you can track their progress for a specific and learning aim. The first tab is the overall course tracker where all you need to input is the points that each student achieved for a particular whole unit. The column at the end pf this tracker is already formulated with the look up table etc to calculate their overall grade for you. All you need to do is input your student names and the greades they achieve for each unit.

I hope these help you and save you time.