Welcome, Guest
Username: Password: Remember me

TOPIC: Ignoring blank cells

Ignoring blank cells 6 years 2 months ago #2842

  • Dave
  • Dave's Avatar
Hi,

Is there anyway to get the calculator to ignore blank cells? For example whenever I do a test I always have 3 columns - 1 for raw mark (always out of 40, I have a numeric grade out of 40 set up for this), then a column to calculate a percentage from this first column (again, I have a numeric grade out of 100 set up for this) then a third column to give a text grade based on the percentage. For each column I have it set up to show an average line. The problem is that if I have a student who has missed a class then they have a blank cell in the raw data column. This then translates to 0/100 and then gives an F. This isnt the end of the world except for the fact that this then throws out the average on the average line. So is there any way of getting the calculations to leave it as blank rather than 0 when calculating percentage and grade?

Also, is there any way to merge a title across all 3 columns? So I tend to write the title for the test as the column header, and then use the column subheader to indicate what that particular column is showing. This means that I end up writing the column heading 3 times. Is it possible to merge the header across all 3 columns? If not could this be possible in the next release?

Lastly is there any way of inserting a blank template of columns? By which I mean, every time I do a test at GCSE I always use the same 3 types of column, calculation settings and grading options and at A level I always use the same combination of 5 columns with associated settings. Is there any way that it could be possible to to insert a template ready put test data into so you dont have to do it column by column?

Thanks,
Dave
The administrator has disabled public write access.

Ignoring blank cells 6 years 2 months ago #2843

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2881
  • Thank you received: 514
Hi Dave,

To ignore blank cells you must first enable the 'Skip empty cells' option. Here a screenshot
dave_image.jpg

It isn't possible in the current version to merge titles but it is in our to-dos list . I'm not sure if it will make it for our next update though , the list of new features is huge and merging titles hans't the highest priority . We'll get there.

Templates are not possible in this version either, but its will be implemented for sure in our next update, it is set higher on that features list !. You'll be able to create, share and use templates at will.

Hope that helped somehow ...

Kind regards,
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.

Ignoring blank cells 6 years 2 months ago #2844

  • Dave
  • Dave's Avatar
Amazing, thank you!
The administrator has disabled public write access.
Time to create page: 0.112 seconds
13 APR

iDoceo 5.1 is now available!

An amazing update with tons of new features. Audio questions in iDoceo Connect, countdown timer, feedback and more

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