iDoceo 8 for iPhone,iPad and Mac now available!

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

TOPIC: Using 'if' conditions in gradebook

Using 'if' conditions in gradebook 8 years 10 months ago #3891

  • Smiffy
  • Smiffy's Avatar
  • OFFLINE
  • Regular member
  • Posts: 15
  • Thank you received: 1
Hi, I am setting up my gradebook and have an imported column of data which represents a student's target grade at the end of the year. I would like ideally to be able to compare a current grade column and this target grade column and calculate \ report whether the student is currently working below, on or above target. All grades are text based (a British levels and sub-levels system of 3a, 3b, 3c, 4a, 4b, 4c etc) but I have managed to work out a percentage value for each of these so that calculations can be done on them (e.g. average grade over an multi-part project). What I haven't worked out is whether I can make such an 'if' comparison. Can it be done?
The administrator has disabled public write access.

Using 'if' conditions in gradebook 8 years 10 months ago #3895

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3490
  • Thank you received: 686
Give this template a try, use the 'Open In' iDoceo
Password is 1111
Attachments:
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
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

Using 'if' conditions in gradebook 8 years 9 months ago #3949

  • Smiffy
  • Smiffy's Avatar
  • OFFLINE
  • Regular member
  • Posts: 15
  • Thank you received: 1
Marvellous! Thank you so much! I have tried this with my British levelling system and I have been able to get it to work successfully. This is a very powerful feature for my school where understanding whether targets are being met is an important focus. Thanks.
The administrator has disabled public write access.

Using 'if' conditions in gradebook 8 years 1 month ago #4618

  • Emilie
  • Emilie's Avatar
  • OFFLINE
  • Master
  • Modern Languages Teacher
  • Posts: 50
  • Thank you received: 4
Hello there!
I'm picking this thread up as I think it's a great feature I didn't know about. I downloaded the file but it doesn't seem to work for me as it is. I am not sure if it is because I removed some of the gradebooks templates or not but it automatically select one that I have created and as a result, my first 2 cells of the calculation are empty, the last one shows a 'b' in a red cell which I assume is correct.
Is there any chance you could explain how to 'make' the formulae for the grade?
Thank you!
The administrator has disabled public write access.

Using 'if' conditions in gradebook 8 years 1 month ago #4619

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3490
  • Thank you received: 686
Hello Emilie,
Our next version, iDoceo 3.1 will have a new calculation called 'Calculation - comparison' which will work right out of the box.
You'll be able to compare two columns (i.e. result/target), a column against the average, median or a specific value.
The template on this thread was offered as a work-around until we developed a better solution. I think it will be more productive for you to wait until the update is ready! It will only take about 10 more days.
You'll find here the full list of new features

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
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: Emilie

Using 'if' conditions in gradebook 8 years 1 month ago #4624

  • Emilie
  • Emilie's Avatar
  • OFFLINE
  • Master
  • Modern Languages Teacher
  • Posts: 50
  • Thank you received: 4
Merci beaucoup! Maintenant, j'ai vraiment hâte! :)
The administrator has disabled public write access.
Time to create page: 0.137 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

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

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.