Assign a numeric value to icons

What is it for?

It is a different way of inserting a grade or mark. Typically, icons are used in iDoceo as helpers, with no numeric value, but sometimes the more conventional  grade isn't as effective for a quick look (and icons look better in your reports).

Icons can be stacked and their value will accrue. For example, a plus sign with 1.0 value, if represented by 3 plus signs, will be in effect a 3.0 in that cell.

Can conventional grades (either numeric or text) be mixed with icons in the same cell?

Yes.
Let's imagine a student has obtained a score of 100 in his exam but because of some sort of penalty you need to decrement it by 10 while keeping the original 100 score for reference.
In our example, we would type the original score in the cell, 100 and then assign a -10 value to an icon that would represent that penalty.
The resulting (internal) value for that cell would be in effect 90.

Keep in mind that these icon values are only taken into account in the calculations. The actual content of a cell is never altered by a combination of icons. 

 

Can we use icons without any additional text in the cell?

Yes, you can do that too.

An example, please!

For this example we will use a conventional grade From 0 to 100. We will then add some icon-values  as a bonus (i.e. with positive values), others as penalties (i.e. negative values) and we will look at the results using a simple calculation

This is the original grade (from main screen > three dots menu > grade types), a simple 0 to 100 score.

 We will now add our values. Tap on the Icons tab.

 This will be our sample data. All the students obtained the same score but we have added a different number of icons.
 The score for all students in this sample is 70, but because of the icons in each cell, the real value taken into account will differ.

 

Now we will add a simple calculation column (Formula) that will represent the result of our "Test", with this configuration we will see the real value taken into account as a result of the 'cell content' + its icons


This calculation is not required. It is only shown in our example to display the internal value of our 'Test' column

And the final result:


Related articles

Counting icons