Calculate an average with scores and grades

What can be 'averaged' in iDoceo?

Short answer: Anything, any column with any kind of content. Even icons.

Elaborated: Each column in your grade book has a 'Grade type' property. This allows iDoceo to combine different kind of columns in a calculation and represent it in a 'Calculation' column which in turn has a grade type assigned as well.
This basically means that you can mix any kind of columns in the average and the result can be represented as a grade, percent, or any other grade type , even your own.

You can add as many calculations as you need to in the grade book, linking a result with another calculation, or mixing columns from different tabs (details here).



A brief introduction

In this article, we will explain different kinds of calculations and its results with different grade types. In essence all boils down to the same steps: 

- Assign a 'Grade type' to each column, either a score, a grade or your own grade types.
- Add a column > Calculation > Average
- Select the columns that you'd like to take into account (by tapping on its headers)
- Choose the Grade type that will represent the result (i.e. A to F, or 0 to 100 for a percent)
- (optional) Assign the weight on each column. By default it calculates the arithmetic mean.


A simple average  



In this example we are calculating the average of Test 1, Test 2 and Test 3 .
The grade type on all four columns (including the calculation) is left as generic.
As soon as you configure a column with a different grade type, you will need to set a grade type to the rest of columns involved in that calculation. You can mix any kind of grade types: numeric,text or grade conversions

After adding the average calculation, you will have to tap on the headers of the columns you would like to take into account

Here is the final result

Representing the result as a text grade 

In our previous example, the calculation's grade type was set as generic. We will now show the result as a grade from A to F. For this to work, we will have configure the grade type on each of the columns involved.

The grade type can be changed individually: Double tap on header > Grade type
or in bulk: Tap on Tools (top bar) > Select your columns > Edit > Grade type
You can create your own grades or edit the current ones. Main screen > Three dots menu > Grade types


This will be the result

 

Averaging scores into a percent

In this example, we'll average two columns with different grade types, the first column holds a score out of 20, and the next one out 50.

- The first step will be to assign a grade type to these two columns to define the max score of each one
- The next step will be to create the calculation column in the same way we've shown in our previous examples. The final result will be represented as a percentage.

Here a short video.

This will be the result


Assigning weights

Weights can be assigned when configuring the calculation column.
Double tap on any cell of that calculation and modify the default weights assigned to each column.