Assessment Tracker

This comprehensive tracker can be used for any subject to track your end of topic tests.

Includes a video to guide you through using the tracker.

Video trailer of what to expect: https://drive.google.com/file/d/1mz_coyi7UNkUYG6mNeHRsruENZtdyROr/view?usp=sharing

The tracker contains formulas to automatically:
-Find the % score in a test.
-Lookup grade boundaries to provide instant grading when a raw mark is entered.
-Update all areas where names of classes / units will appear so they only need to be entered once.
-Provide a graphical representation of the distribution of scores for each test for each class.
-Highlight the average score / grade earned and highlight which scores students would need to be in the upper / lower quartile.
-Highlight the 3 top / bottom performing students with their score.
-Calculate the residual earned by each class.

The tracker can also produce individual report cards for students - all you have to do is type in their name in the highlighted box and the formulas will do all of the rest for you. This includes a breakdown of each score across each term and a graphical breakdown to go alongside.

The tracker is designed to be used in google sheets, once purchased you will receive a link to a copy of the tracker - in which you can make a copy by:
Clicking file in the top left corner,
Click make a copy - you can put this then into your own google drive.

Alternatively you can download the tracker as an excel document, however, some of the features do not transfer perfectly.