iDoceo 7 for macOS and iPadOS now available!

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

TOPIC: Ignoring blank cells

Ignoring blank cells 8 years 8 months ago #2842

  • Dave
  • Dave's Avatar

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?

The administrator has disabled public write access.

Ignoring blank cells 8 years 8 months ago #2843

  • bert
  • bert's Avatar
  • Admin
  • Posts: 3371
  • Thank you received: 653
Hi Dave,

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

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 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
The administrator has disabled public write access.

Ignoring blank cells 8 years 8 months ago #2844

  • Dave
  • Dave's Avatar
Amazing, thank you!
The administrator has disabled public write access.
Time to create page: 0.202 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.