Fig. 4

This is an example set with the same numbers used in the set above and below. Above: example of formatting before updated conditional formatting. Colours generally changes from shades of red to green over the course. Numbers of 4 or less are generally highlighted more easily with the darker shade of red, therefore are most easily identified by instructors and course leaders. As the course progresses there is less of this colour and therefore few candidates are highlighted. Below: the same dataset with updated example of conditional formatting. The scores given during each session are provided, as well as the difference in scores. Both ratings can be used to highlight struggling candidates, either individually or with each other. This new system continues to highlight candidates that may be struggling throughout the course that may have been missed when solely using the original system