### iDoceo 8 for iPhone,iPad and Mac 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 :

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

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.