iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Ignore icon values in calculations?

Ignore icon values in calculations? 3 years 9 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? 3 years 9 months ago #7057

  • bert
  • bert's Avatar
  • Admin
  • Posts: 3327
  • Thank you received: 638
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 7 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.112 seconds
21 AUG

iDoceo 7 for iPad and Mac 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

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.