BTEC Tech Award Sport - Component 1 Tracking sheet

Tracking sheet created to monitor progress throughout delivery of Component 1. Save time calculating working at grades / progress of students. Formulas used to calculate scores, working at grades, class progress.

Tracking sheet created to monitor progress throughout delivery of Component 1. (Google Sheets)
Includes:
Overview tab

• Student information (group / SEN / PP / EAL / attendance)
• Homework log
• Effort log - complete at the end of each month giving a score 1-4 (cells change colour based on values entered)
• Behaviour log

Component 1 tab

• Space to link student work for each task.
• Separate cell to input students score for each task
• Total score calculated in (column K) to provide score /60
• Grade for C1 (based on Jan 23 boundaries) calculated based on the number of column K
• Group progress outlined by a count formula added to identify how many students are working at each grade.

Interventions tab:

• Space to include any additional information / support that has been provided to students.

*The file downloaded contains a link to a Google Sheets document.