Comparing columns

The 'Comparison' calculation in iDoceo will let you compare a column in different ways:

  • against another colum
  • against the column's average or median
  • average,median or a constant value.
The 'Comparison' calculation is disabled by default.
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.

Now we'll add a new 'Comparison'calculation as its editor and From 0 to 100 as its Grade type. This will represent the comparison as a percentage.
This will be its configuration


And the result

Showing the comparison result with colours instead of arrows

From the Settings (main screen, gear button) > Options (Gradebook) > Show colors when comparing columns.
The previous example would look like this

Related articles

Calculate an average with scores and grades
    13 APR

    iDoceo 5.1 is now available!

    An amazing update with tons of new features. Audio questions in iDoceo Connect, countdown timer, feedback and more

    Read more

    6 JUN

    Create Multiple-choice tests with iDoceo Connect!

    In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

    Read more