iDoceo 6 is now available!

We are updating the web with all the new features of iDoceo 6.
This is a manual update, please tap on this link if you wish to update on the App Store
Welcome, Guest
Username: Password: Remember me

TOPIC: Ignore icon values in calculations?

Ignore icon values in calculations? 2 years 11 months ago #7056

  • chrisrowe
  • chrisrowe's Avatar
  • Regular member
  • Posts: 14
  • Thank you received: 1
Ive been trying to set up a grade book where I can use icons to track and count behaviour points accrued in lessons.

Its different points for escalating offences, so I've worked out how to assign values to icons and a calculation column to add them up (as every 5 points is a detention)

the snag I've hit is that I'm also adding up the columns for their classwork, my additions are including the behaviour icon values too (as I'm placing the behaviour icons in the columns for the classwork/lesson

so a pupil with a 5 for the classwork and a C1 (1 behaviour point) is getting a total classwork score of 6

can you ignore icon values when calculating columns additions?

cheers :)
The administrator has disabled public write access.

Ignore icon values in calculations? 2 years 11 months ago #7057

  • bert
  • bert's Avatar
  • Admin
  • Posts: 3096
  • Thank you received: 571
Hello Chris,
I'm afraid it is not possible (i.e. easily feasible) if both text and icons are on the same cell. They are meant to be in different columns if you do not want their values added.

The long winded way:
Add a column > calculation > Icon counter > Select your icons and 'Count icons' value to take them all into account
Add a column > Calculation > Formula > If you wrap your columns around the RAW function they won't take the icon values into account. Something like RAW(COLUMN1) + RAW(COLUMN2)
Please take a moment to add or update your rating for iDoceo 6 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
The administrator has disabled public write access.
Time to create page: 0.099 seconds

iDoceo 6 is now available!

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

Read more


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

Read more