### iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

# Real calculus examples:Obtain a text based grade from a numeric average

In this example we'll see how to translate a numeric average into a text grade. So that, for example , if we have an average result of 98% in a column we want an A+ as the translation for it in our new column.

We'll begin with the sample data on this image, it is a simple average with three columns. If you need help on how to obtain the average column, take a look at this link here.

The first step is to assign a grade type to each column so that iDoceo knows what kind of information each column holds.

As our example uses a grade from 0 to 100, we'll create this numeric grade with a maximum value of 100 and a minimum value of 0. You'll find instructions on how to create a grade type here

Edit all the columns involved in the average (including its result) and assign our new grade type, in our example called 0 to 100. When editing the calculus properties , it should look like this (note the 0 to 100 grade on each arrow):

Now our final step, we'll create a new calculus column with our TEXT grade type A to F and it will use the 100% of our average column, like in the image:

And the result

Expert's tip: For the sake of simplicty we've left 2 average columns, one numeric and its text translation. iDoceo in fact allows to directly perform a text translation without the numeric average.

If you configure the grade type of the first average column to a text based grade, it will directly represent the average's text without an intermediate column.  It would look like this :

#### Recently updated articles

21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

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