A clever Excel spreadsheet to track or measure your students' progress across the year. This is geared towards A-Level teachers but would work well for FE, HE and secondary teachers too. Using this will assist you in demonstrating 'Progress over Time' for any looming Ofsted inspection.
The sheet caters for up to 25 students per class and tracks their progress in relation to their minimum target grade (MTG). Average grades update as you complete assessments.
Using it is really easy!
All light blue cells are for data/text entry, all dark blue cells are drop down boxes and everything else is protected from accidental clicks. At the bottom of the table is a box where you can amend the raw marks available for each type of assessment - just use 'quiz' (deep blue drop-down for assessment type) if you would prefer to see everything as a percentage of 100.
The formulae are protected but I've included the unlock code (1234) for those of you who feel confident enough to personalise it further.
The sheet caters for up to 25 students per class and tracks their progress in relation to their minimum target grade (MTG). Average grades update as you complete assessments.
Using it is really easy!
All light blue cells are for data/text entry, all dark blue cells are drop down boxes and everything else is protected from accidental clicks. At the bottom of the table is a box where you can amend the raw marks available for each type of assessment - just use 'quiz' (deep blue drop-down for assessment type) if you would prefer to see everything as a percentage of 100.
The formulae are protected but I've included the unlock code (1234) for those of you who feel confident enough to personalise it further.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00