Convert a score into a grade

In this example we will convert a column called 'Test',a score out of 20, to a column called 'Grade', shown as a grade from A to F
If you'd like to convert the score into a percent instead, here is a video tutorial


Assign a max score to our test

Double tap on the column's header > Grade type > Max score 20



Add a simple calculation



We will now add a new column > Calculation > Average
Tap on the 'Test' column header to add it to our calculation
Tap now on Column (properties) and set the grade type to 'Text grades A to F'. This is where you decide how the result of the calculation will look like. A grade type 'From 0 to 100' would show the result as a percent.





And this will be the result




Related articles


Create your own text grades
Convert a score into a percentage