Unlocking Grades.

Unlocking Grades.

Natalie Jordan གིས-
Number of replies: 20

I have a lot of grades that have become locked, I am not sure how they have become locked because we mark from the assignments pages.

I know that it is possible to go to the Gradebook and click individually on items that are overriden and unoverride them but this will take hours.

Does anyone know how I can make a global change to unoverride these grades that have become locked.

Kind Regards

Natalie Jordan

In reply to Natalie Jordan

Re: Resetting all overridden flags

Helen Foster གིས-
Core developers གི་པར Documentation writers གི་པར Moodle HQ གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར Testers གི་པར Translators གི་པར
Hi Natalie,

Assuming you have phpMyAdmin, you can reset all the overridden flags as follows:

Click the SQL tab, then in the "Run SQL query/queries on database moodle" field type

UPDATE mdl_grade_grades SET overridden = 0

and click the Go button.

Please note that it's always a good idea to make a backup of your database before trying any SQL queries. wink

If you think it would be helpful to have a setting within Moodle for resetting all overridden flags, please create an issue for it in the tracker.

In reply to Helen Foster

Re: Resetting all overridden flags

Natalie Jordan གིས-
Thank you Helen that is really helpful དགའ་འཛུམ་
In reply to Natalie Jordan

Re: Resetting all overridden flags

Helen Foster གིས-
Core developers གི་པར Documentation writers གི་པར Moodle HQ གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར Testers གི་པར Translators གི་པར
PS To make a feature request (or report a bug) in the tracker, you'll first need to create an account, then login and follow the "Create new issue" link. Please see the tracker documentation for more details.
In reply to Helen Foster

Re: Resetting all overridden flags

Deb Burdick-Hinton གིས-
Is there anyway to just turn off the Overridden feature.
I am really disappointed that when you add "Quick Feedback" it now checks the "overriden" box. The way I like to use this feature is when I see a low grade I post some comments directing the students to correct or redo the assignment, etc...but if I put the comment in and the student retakes the assignment the new grade will not automatically show up and that defeats the purpose and time saving benefit of autograded assignments.

Also sometimes I put a 0 in place of a "-" so the grade will be averaged so the students can see the negative affect earning a 0 is having on their grade, thus hopefully motivating them to complete the assignment, but again unless I uncheck the override box for each student I can not do this.

I am teaching an intro to moodle course to 24 instructors and was excited to share the quick feedback feature to them, but I am thinking it is not worth using if it automatically enables the check on "overriden".

Any way to shut it off or other alternatives?

Thanks so much for your input!
In reply to Deb Burdick-Hinton

Re: Turning off the overridden grades feature

Helen Foster གིས-
Core developers གི་པར Documentation writers གི་པར Moodle HQ གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར Testers གི་པར Translators གི་པར
Hi Debra,

You can turn off the overridden grades feature by preventing the capability to edit grades in the gradebook, in other words, only allow teachers to add grades and feedback from within assignments.
In reply to Helen Foster

Re: Turning off the overridden grades feature

Deb Burdick-Hinton གིས-
Good solution except for autograded assignments like "Lesson" , "Quizzes" etc....that do not allow you to add grades from within them. So if a student does not take a quiz, how do you add "0" to the quiz score from within the quiz module?
In reply to Deb Burdick-Hinton

Re: Turning off the overridden grades feature

Elena Ivanova གིས-
I have no solution, but I just had an eye-opener wide eyes since I am just testing 1.9 for now.

So, once an instructor uses quick feedback/grading in the Gradebook for an activity, there is no way for him to use Assignment/Quiz interface anymore for grading, and it is not possible to remove the overridden flag other that in the database?

I think both things can be useful:
- resetting overridden flags in bulk and
- possibility to turn-off the overridden feature in general

I'll be happy to add a ticket (I just hope that I got it right)
In reply to Elena Ivanova

Re: Removing the overridden flag

Helen Foster གིས-
Core developers གི་པར Documentation writers གི་པར Moodle HQ གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར Testers གི་པར Translators གི་པར
Elena, instructors can change a grade within an assignment after changing it in the gradebook by removing the overridden flag in the grader report. Please see the Grades FAQ for details.

Regarding bulk removal of overridden flags, you'll be pleased to hear we're hoping to add the LSU's grade item and student grades quick edit feature to the grader report (MDL-18229) as part of our Stage 2 gradebook improvements (see Development:Gradebook improvements).
In reply to Helen Foster

Re: Removing the overridden flag

David Hogg གིས-
Hi Helen,
I just noticed that when I went to untick he override box for an individual grade, that I had to switch editing (grades) off before moving on to uncheck the next grade (edit grades on again!) or the change would not be saved. Seems a bit long winded!



I am on Moodle 1.9.4 build 20090211
In reply to Deb Burdick-Hinton

Re: Turning off the overridden grades feature

Helen Foster གིས-
Core developers གི་པར Documentation writers གི་པར Moodle HQ གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར Testers གི་པར Translators གི་པར
Debra, if you un-check the grade category setting "Aggregate only non-empty grades" then students who haven't taken a quiz will receive a grade of zero.
In reply to Helen Foster

Re: Turning off the overridden grades feature

Deb Burdick-Hinton གིས-
Yes I have done that but it would be really nice to give extra feedback without locking the grade to motivate the students to complete before the due date. Also, I hate for all students to have to have their empty grades count as 0's but this has been the best option for now. I was really excited about being able to add feedback in the gradebook but there is no way I can spend the time clicking the override check box twice and updating changes for every single student. I see this is fixed in 1.9.5 but would be nice for it to be fixed in 1.9.4 as I have no idea when 1.9.5 will be released and most likely we will not be able to properly test before our next school year as we have activity locking and it takes a long time for us to be able to upgrade. would be nice if some of the 1.9.5 gradebook improvements could be back ported to 1.9.4. Any chance of that. I am sure it is a lot harder than it sounds but I am just dreaming. If I could get some of the 1.9.5 gradebook improvements in 1.9.4 before faculty depart for the summer the dark cloud that hangs over moodle might be gone and hopefully their enthusism for using it will be renewed and I could work hard in the summer to get their courses/gradebooks lookin good.

This has been a really tough year due to this upgrade. My fault for upgrading to v1.9.5 without testing....I just never imagined the gradebook would be this challenging.


Thanks for all you are doing!!!!
In reply to Helen Foster

Re: Turning off the overridden grades feature

Peter Diedrichs གིས-
Particularly helpful Moodlers གི་པར

You can turn off the overridden grades feature by preventing the capability to edit grades in the gradebook, in other words, only allow teachers to add grades and feedback from within assignments.

I've seen this tip in several posts, but how/where do I turn it off?

In reply to Helen Foster

Re: Resetting all overridden flags

Sam Mudle གིས-


UPDATE mdl_grade_grades SET overridden = 0

Is there a way to do this with Moodle 2.4?  It's such a pain if you accidently override a single grade and all 1000 students get overriden as well.

ANSWERED -

I'm using Bob Puffers awesome LAE Grader plugin for dealing with overrides.

https://moodle.org/plugins/view.php?plugin=gradereport_laegrader

In reply to Sam Mudle

Re: Resetting all overridden flags

Emma Richardson གིས-
Documentation writers གི་པར Particularly helpful Moodlers གི་པར Plugin developers གི་པར

This should still work in 2.4 - it has to be run on the database.

In reply to Emma Richardson

Re: Resetting all overridden flags

Susan Mangan གིས-

This is useful however, one thing to note:  in the case of a student who has performed a quiz when grade book fields were already inadvertently over-ridden - the quiz results will not copy over to the gradebook if you manually update the database.

There is a trigger that will re-write a quiz grade to the gradebook via the interface when you click on the over-ride checkbox.

In my case I may run a query to over-ride all but one record in one course and then manually do the last one just to get the trigger.

Or you could probably also just do a re-grade of the quiz and theoretically that should re-write the scores to the gradebook as well.

In reply to Helen Foster

Re: Resetting all overridden flags

Richard Wallace གིས-

Helen great tip, I just did this on a 3.1 and worked great, I just had to kick start the "recalculation" by locking one student again, and all the others then processed, then I just unlocked that one student back.