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: How to Use Numcol function

How to Use Numcol function 1 year 11 months ago #7351

  • Freen
  • Freen's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 4
I am trying to understand the Numcol (count columns) function. I thought I could provide a range of columns and it would count how many columns there were included but it does not seem to work that way. Also, is it possible to count the number of columns in a category so if you add more columns to the category the count changes accordingly automatically?

I'm new to all of this so any help you can provide would be greatly appreciated.

Thank you.
The administrator has disabled public write access.

How to Use Numcol function 1 year 11 months ago #7352

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2982
  • Thank you received: 534
Hello Freen,
NUMCOL counts the number of non empty cells in a list of columns but it usually is not required.

Let me know the kind of calculation you're trying to do. In a category, any calculation except the formula will automatically take into account the new columns you add in it.
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.

How to Use Numcol function 1 year 11 months ago #7353

  • Freen
  • Freen's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 4
Thanks Bert,

Essentially I am trying to add up bonus participation points for a warm-up routine kids do at the beginning of most classes. As it is not every class, I would be adding columns as I go instead of having a set number of columns in advance. Now this is pretty easy except I would prefer to not have to give a code for every student but be able to leave some spaces blank but still have that space count towards the number of total warmups. So I need to count the number of columns (preferably in a category folder) so I can use that number to divide to get a percentage (ratio of times they got the bonus out of the number of opportunities). But I can't figure out how to leave a cell blank but still have it counted towards a total.

Hope that makes sense.

Thanks!
The administrator has disabled public write access.

How to Use Numcol function 1 year 11 months ago #7360

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2982
  • Thank you received: 534
Do you plan on adding a number on those cells or working with icons would do?
If you only need a limited set of values icons will be faster, more visual, and you could add a default icon on a column so that empty cells are taken into account.

Do let me know and I'll explain in more detail with a sample template that you can import in your gradebook
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.

How to Use Numcol function 1 year 11 months ago #7367

  • Freen
  • Freen's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 4
Funny enough that is what I set up on my own.

I was just hoping that there was a way that I could avoid having to fill every cell - instead having an empty cell count as a predetermined value.

So empty = default value in essence.
The administrator has disabled public write access.

How to Use Numcol function 1 year 11 months ago #7368

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2982
  • Thank you received: 534
The (add column) calculation > addition will let you set a value for empty cells but you will have to choose which columns to take into account. We will try to add this very same calculation in categories in the future.
Give it a try and let me know how that works for you
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.

How to Use Numcol function 1 year 11 months ago #7374

  • Freen
  • Freen's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 4
Ya unfortunately I will not know in advance how many columns I will need to count so for now I will just have to make a mark in every column for every student instead of leaving some blank.
The administrator has disabled public write access.
Time to create page: 0.108 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