iDoceo 7 for macOS and iPadOS now available!

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

TOPIC: Counticon

Counticon 8 months 2 weeks ago #9602

Hi,

I’ve been trying to set up a calculation using the “if” and “counticon” functions, but am struggling to get a working formula.

I have my class linked to google classroom, and assignment marks are imported.
I have set a quick calculation to get the percentage/colour.
For any student who has not handed in the homework, I have added the cross icon (❌) .

I want to have a formula which counts how many crosses for each student, then returns a 1️⃣/2️⃣/3️⃣ depending on how many homework handed in (or in this case, how many are not handed in )

Thanks
Attachments:
Last Edit: 8 months 2 weeks ago by CBashford.
The administrator has disabled public write access.

Counticon 8 months 2 weeks ago #9603

C3521750-9033-45BB-AC23-CB266B14ABE4.jpeg


I believe I’ve found a work around.
Probably very convoluted and not needed, but does what I’m looking for currently.
It needs editing for each individual term/class, so that will be time consuming, and so I would still love any support/ideas for easier versions.

Thanks
The administrator has disabled public write access.
Time to create page: 0.102 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

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

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.