Welcome, Guest
Username: Password: Remember me

TOPIC: Grade conversion (Excel If function)

If function 4 years 5 months ago #5564

Hi,
I have set up my excel spreadsheet to show a grade based on the score using the if function.
Is there a way of converting this formula so that it will work in my grade book in iDoceo?
Here is the formula, where AC6 is the total mark column.
IF(AC6>26,"*",IF(AC6>22,"A",IF(AC6>18,"B",IF(AC6>15,"C",IF(AC6>12,"D",IF(AC6>9,"E",IF(AC6>7,"F",IF(AC6>4,"G",IF(AC6<4,"U")))))))))

I can't seem to get the speech marks or text.

Thanks
The administrator has disabled public write access.

If function 4 years 5 months ago #5565

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
Hello James,

Yes, you can do that with what we call a 'grade conversion'.
I'll prepare the article today and I'll post here the link.

In short, the steps are as follows:

If you have not done it already, you must create a text grade type with the steps explained here. Add your texts from A to U
The exact value of the percentages is not important, just make sure that the highest value has a 100%, the lowest 0%

Add now a new grade type but this time choose Grade conversion. Make sure the input max value is what you need (30?) and select as output the Text grade type you have created in the previous step. You will find a table at the bottom left corner that will let you enter the correlation between the score and the grade.
Once finished, assign this new grade type to your score column. Double tap header > Grade type > Your grade conversion.

Here a couple of screenshots of how the grade conversion looks

b1_grade_conversion_graph.jpg


angela_02.png
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.

If function 4 years 5 months ago #5566

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
Here it is.
Let me know if something is not clear enough!

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.
The following user(s) said Thank You: james.me.robinson

If function 4 years 5 months ago #5567

This is brilliant. Thank you. Really helpful and easy to follow instructions.

This brings me onto one more feature I use in Excel. I usually get excel to auto format the grade compared to the target grade. E.g. When a student has met their target it is yellow. When above target green. When below target red. Is it possible to do conditional formatting like this?
The administrator has disabled public write access.

If function 4 years 5 months ago #5568

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
Yes, you will find here the details and it will look like this

column_comparison_03.png

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
Last Edit: 4 years 5 months ago by bert.
The administrator has disabled public write access.
The following user(s) said Thank You: james.me.robinson

If function 4 years 4 months ago #5609

  • Wendy
  • Wendy's Avatar
  • OFFLINE
  • Junior Member
  • Posts: 5
this is a fantastic resource! have been exporting my gradebook to excel in order to use an if function for all our tracking needs, yet now I can do it directly in the gradebook, thanks.
just one question, if I may: having set up my text grade type as standard AS grades with % decrements of 10, as far as 40. then 0 for U
however, when using it, the column gives any value less than 40 as E not U. What have I done wrong?! :huh:
thanks
The administrator has disabled public write access.

If function 4 years 4 months ago #5610

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
Hi Wendy, the issue may be due to:
- the columns leading to that final result not having the proper grade types.
- something wrong in the grade conversion's configuration

If you are working with the grade conversion, you should disable it for a moment. Double tap on the column's header > Grade type and change the grade type to something like 'From 0 to 100' for example.

If this yields the right result it is then only a matter of properly configuring the grade conversion, if you can send me a screenshot of your configuration (with the green graph) I'll see if I can spot the problem.
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.

If function 4 years 1 month ago #5841

You want to put the max mark allowed for each grade in the grade conversion. This confused me at first! See the attached picture for my setup for A Level UMS that works.
Attachments:
The administrator has disabled public write access.
Time to create page: 0.162 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