iDoceo 7 for macOS and iPadOS now available!

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

TOPIC: Subtracting one column from another...

Subtracting one column from another... 8 years 10 months ago #2655

Hi there, first off thanks for all the work on this great app, it's developing really nicely!
In a grade book I have a column which lists a student's target grade. I have several other columns giving various performance in single tests. I have an average of these tests and an overall grade but... Is it possible to take their current average mark away from their target grade?

We are always being asked to report on how far off their target grade a student is. I haven't seen a way of subtracting columns, only of averaging them. Any help would be very much appreciated!

Many thanks,
The administrator has disabled public write access.

Subtracting one column from another... 8 years 10 months ago #2656

Ok... I managed to work this out. By weighting one column to -100 and the second to 100 it did the trick but now I have another problem...

Is there a way of copying over the calculated columns to another class? It will copy over the structure and formatting but the little calculator icons are missing and when I enter raw data it doesn't do the calculation. I have several classes that use the same grading system and it would take ages to manually go through and re-do the calculated columns, is there a way around this?

Thanks again!


Edit: Actually, when I try copy and pasting even within the same sheet the little calculator doesn't paste in. Is there a setting I need to set to enable copying of functions/calculations? Cheers.
Last Edit: 8 years 10 months ago by Brett Huckstep.
The administrator has disabled public write access.

Subtracting one column from another... 8 years 10 months ago #2657

  • bert
  • bert's Avatar
  • Admin
  • Posts: 3371
  • Thank you received: 653
Hi Brett,
You can copy a class' structure from the chalkboard, tap&hold on a class, then copy. But it won't allow you to do it on a preexisting class. Once you have that empty class, then you can transfer your students. I've sent you a message with further details

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.
Time to create page: 0.106 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.