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.
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.
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. 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. Weights can be assigned when configuring the calculation column.
or in bulk: Tap on Tools (top bar) > Select your columns > Edit > Grade type
This will be the result
Averaging scores into a percent
- 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.
Assigning weights
Double tap on any cell of that calculation and modify the default weights assigned to each column.
