pptx, 730.77 KB
pptx, 730.77 KB
pdf, 38 KB
pdf, 38 KB

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.

Reviews

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.