Gradebook auto feedback.

Gradebook auto feedback.

by Alejandro Cemylto -
Number of replies: 5

I hope someone can help me here please.

Is there a way to set the gradebook feedback to something like if the grade is >60 then it will show Good and if it's <60 it will show Try again'

please note that i am talking about when i ecport the grades to excel. i need to see the original column of students grades and an other column next to it with the feedbacks

Thanks in advance to thhe happy moodlers!

In reply to Alejandro Cemylto

Re: Gradebook auto feedback.

by Marty Soupcoff -

You could set up the same thing I described in another one of your questions. (See here) Since this is only for after you have exported to excel, if your grades start in say C2 and go down the rest of column C, set up a formula like below in column D2:

=IF(C2>=60,"Good",IF(C2>60,"Try again","Error"))

The formula is set up to achieve what you describe i.e. greater than or equal to 60 gets a "Good", less than 60 gets a "Try again". It will say "Error" if they don't fit into either; which shouldn't happen if a number is in that column. After pasting into formula into D2, copy it the rest of the way down column D.

Happy Moodle Logooodling!

In reply to Marty Soupcoff

Re: Gradebook auto feedback.

by Alejandro Cemylto -

I am afraid this is not what i need.

you know how you can add quick grading to the gradebook?

then it gives you a text field to add feedback to each grade ?

i need that text field to auto-populate depending on the grade.

Thanks

 

 

In reply to Alejandro Cemylto

Re: Gradebook auto feedback.

by Marty Soupcoff -

I don't think an auto populate is possible; at least I have never seen or heard of it for the gradebook. One workaround would be export the gradebook, make sure to check the box for Include feedback in export. This will create a column in the excel file called feedback. Then in excel, enter the formula I showed above and then import the grades and feedback into the gradebook. This is by no means automated but it would do the job. Should take less than five minutes to do.

Happy Moodle Logooodling!

In reply to Marty Soupcoff

Re: Gradebook auto feedback.

by Alejandro Cemylto -

Any ideas on how to use the Scales with a grade to pass ?

In reply to Alejandro Cemylto

Re: Gradebook auto feedback.

by Marty Soupcoff -

Most of the time I recommend against using Scales not because they don't work but because most people don't understand how they work. If you create a scale, the text or numbers you enter as values are actually text strings, not values. So if you create a scale of  "1, 2, 3", that is no different than a scale of "cat, dog, bird". In addition, how those values will be calculated towards the course total is dependent on the aggregation type you are using. If you are fine with testing this first in your own Moodle instance, then by all means move forward and follow instructions below.

  1. Create your scale. I won't show you how to do that but rather point you to the documentation. Again, I highly recommend you check out those last two sections to see example scales and how they work with various aggregations.
  2. Create assignment or grade item if not already done so.
  3. Set the created scale as the grading method/type.
  4. Go into your gradebook and select Categories and Items tab.
  5. Select Edit icon next to assignment/grade item. Since you already set the grade method/type to a certain scale, the minimum and maximum grade will be autopopulated with what is the min and max real scores i.e. if you had a 13 different values in your scale, depending on your aggregation type, the min and max would be 1-13 or 0-12.
  6. In the Grade to pass field, enter the real score that corresponds to the value in the scale that you want to be the lowest passing grade. E.g. you scale is "Bad, Below Average, Average, Good, Great". If the min and max shows as 1-5 and you want "Average" to be passing, you would enter a 3 into the Grade to pass field because "Average" is the third value.
  7. Save your changes.
  8. Grades should then appear as red or green in that column depending if they reached the grade to pass.

Happy Moodle Logooodling!