Free template
Student progress tracking template
An editable Excel workbook for tracking skills in a class or level. Each skill has a condition and an observable action, each student has a status per skill, and a separate log records who assessed what and when. Mastery % is calculated as mastered skills divided by every skill on the checklist.
Updated . No signup needed. All example records are invented.
- Download the templateExcel .xlsx (opens in Google Sheets and Numbers)
- Example records as CSVCSV, 24 rows
What's inside
- Instructions, including suggested meanings for Not started, In progress and Mastered
- Example skills matrix: 8 guitar skills and 3 invented students, with mastery formulas
- Example assessment log: date, student, skill, status, assessor and evidence
- Blank skills matrix for 40 skills and 10 students; status cells only accept the three statuses
- Blank assessment log with 300 rows and date validation
What the filled example shows
Level 1 of an invented junior guitar class has 8 skills. Blank cells count as not started, so every student is measured against the same 8 skills.
| Student | Mastered | In progress | Not started | Mastery |
|---|---|---|---|---|
| Maya C. | 3 | 2 | 3 | 3 / 8 = 38% |
| Leo R. | 5 | 1 | 2 | 5 / 8 = 63% |
| Aisha K. | 1 | 1 | 6 | 1 / 8 = 13% |
Percentages are rounded. They describe checklist coverage, not ability, exam readiness or time to finish the level.
How to use it
- Write each skill so it can be observed. Fill in the condition and the observable action. “Changes from E minor to G on the beat 4 times in 8 beats at 60 bpm” can be assessed; “good at chords” cannot.
- Agree the status meanings with every instructor. Use the suggested definitions or write your own on the Instructions sheet. Ask two instructors to assess the same demonstration and compare before you start.
- Update the matrix and add a log row at the same time. The matrix holds the current status. The log keeps the history: when the status changed, who saw it and what they observed.
- Share one student at a time. Copy one student's column and log rows into a separate report before sending anything to a family. Never send the whole class file.
Limits to know
- Every skill has equal weight. Adding or removing a skill changes everyone's percentage, so compare percentages only for the same checklist.
- The workbook does not enforce prerequisites or award levels. Instructors decide when a student moves on.
- Spreadsheet permissions are only as safe as where you store the file. Keep the master copy where only authorized staff can open it.