National 4/5 Excel Tracking Spreadsheet

This Excel tracking template for Scottish National 4 & 5 classes helps teachers easily manage student progress, assessment data, and attainment. Includes charts & macros to save you time.

This is a user-friendly Microsoft Excel tracking template (.xlsm file) specifically designed for teachers in Scotland to manage National 4 (N4) and National 5 (N5) level classes. It’s an essential tool for keeping precise records of student progress, assessment results, and overall attainment against SQA benchmarks.

The template comes pre-built with multiple worksheets, allowing you to organise different aspects of your N4/N5 tracking, such as individual unit assessments, coursework progress, final grades, or specific skill development for each student or class group. It also has sections to record concerns and department interventions. You’ll find a variety of charts included, ready to visualize student attainment and identify trends quickly, helping you pinpoint students who might need targeted intervention or additional support to meet course requirements. Furthmore, there is a tab to track individual attendance to help with tracking concerns in relation to attendance.

It is user friendly, full editable and tabs can be easily copied and pasted for multiple classes.