This tool allows for analysis of assessment scores across a single grade level.
It was developed to accommodate 5 assessments - initial benchmark, Q1 assessment, mid-term, Q3 assessment, and finals.
You can use it to analyse any 5 assessments though.
Although this can be used by a single teacher in their own classroom, it was developed to give an overview of an entire grade level in every subject.
As such, there is room for 18 subjects, 12 classes in each subject, and 33 students in each class.
The overview allows the user to sort by students alphabetically (from highest to lowest or lowest to highest)..... and more usefully, by every single assessment and average across the 18 subjects (also from highest to lowest and lowest to highest).
It is colour-coded for ease of use - colour-coding is based on the highest score and NOT out of 100.
All score data must be input as a percentage score.
All students must be entered using exactly the same naming convention - if you have a John Smith 9A in history, and the same John Smith 9A is also in English, Maths, and Science, then he must be entered in exactly the same way in each subject.