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: Conmparing two cells

Conmparing two cells 5 years 7 months ago #4567

Hi

I would like to compare two cells in gradebook, and either give a value or have some sort of conditional formatting. It may be easier if I explain how I achieve this in excel:

My students have a Target grade. Every time they sit a test, I have a vlookup formula that takes their target grade, assigns it a numerical value, then I use a vlookup to get a numerical value for their latest test grade, subtract one from the other. If the result is either -1 or -2 (i.e. they are achieving their target or beating it) the cell turns green, if it is below zero (ie they are not yet hitting their target, it turns orange) if the result is -3 (ie they are way off their target) it turns red.

Is it possibly to achieve this in idoceo?

I would be happy if it just gives me the numerical answer of the calculation, that way I can set those as grade types and colour them accordingly.

I've attached my excel version so you have an idea.

Please help!
Last Edit: 5 years 7 months ago by dunkymunky.
The administrator has disabled public write access.

Conmparing two cells 5 years 7 months ago #4568

It wouldn't let me upload the file, here's a link to it

onedrive.live.com/redir?resid=6265FEB898...Q&ithint=file%2c.xls
Last Edit: 5 years 7 months ago by dunkymunky.
The administrator has disabled public write access.

Conmparing two cells 5 years 7 months ago #4569

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2981
  • Thank you received: 534
Hello dunkymunky,

In the current version of iDoceo, you can configure this but in a somewhat hacky manner.
Find attached below a sample which will give you an idea on how it's set up, 'Open In' iDoceo and type 1111 as its password.

However, we're now working on our next update, iDoceo 3.1 which will make this task a lot easier. It will soon be available, I'd say in about 2 weeks (here the details)

And here a screenshot of the new comparison and ranking features. Instead of those arrows, you'll be able to choose colors instead (red below, amber on target, green above)


h66babfe.png



PS: Don't worry about that Excel, the forum won't let you attach that file!
Attachments:
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.
Time to create page: 0.124 seconds
9 DEC

iDoceo 6 is 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