- against another colum
- against the column's average or median
- average,median or a constant value.
Enable it first from the Settings (main screen, gear icon) > Cell editors, calculations
Comparing two columns (e.g. target vs grade)
We will begin with this example shown below. Our target grade on the first column and the obtained result (Exam 1) next to it. You can use any of the configured grade types for each column, they do not necessarily have to match.
This will be its configuration
And the result
Showing the comparison result with colours instead of arrowsFrom the Settings (main screen, gear button) > Options (Gradebook) > Show colors when comparing columns.
The previous example would look like this