Gradebook

 
 
Picture of Brian Peat
Grades out of order
 

I ran into an issue this week where our grades were completely out of order on the site I'm building in Moodle. The reorder tool worked SOME of the time, but not much at all.

I dug into the database and figured out that I could change the grade item ids and it would reorder them, and spent several hours fixing it manually, but I don't like the idea of fiddling in the database, and I actually broke one of our courses-thankfully it was just a copy and hadn't been populated with the correct info yet.

I'm wondering if there's a bug in there somewhere regarding this. I did both course imports and then when that stopped working (imports would run and the course would still be empty) I moved to backing up and restoring to new courses. That works fine it seems.

I also duped lots of forums and then just changed the info on them (I have since started just manually creating all parts of the course). I'm wondering if the mix of duping and restoring/importing messed up the grade order so bad that it couldn't be adjusted?

I noticed too that judging by the database grade item IDs, for the grade reorder to work, it literally has to reorder the entire list of grades to make room to move something. When there was an open ID number where I wanted to move something, I could move it in Moodle. If there was NOT an open ID, it wouldn't move.

Any ideas? Is this just a limitation and glitch I need to live with and keep an eye out for?

Picture of John Hughes
Re: Grades out of order
 

Brian,

is this the same as I reported in:

  https://moodle.org/mod/forum/discuss.php?d=216277

John

 

Picture of Brian Peat
Re: Grades out of order
 

Probably. I posted a link back here from yours, in case someone wanted to read all the details.

Picture of Brian Peat
Re: Grades out of order
 

So I started over with a copy of the site, deleted all the courses and started creating them with each grade item in order one at a time, no duping, no restores, etc.

So far so good BUT, when I check the database after I started adding graded items to the second course-there's no numerical gap between courses. If the re-order function worked correctly, it wouldn't matter, but I noticed earlier that if there were gaps, things seemed to re-order, no gaps, no reorder.

My assumption is that the grade reorder tool SHOULD literally reorder the entire ID column in the database, but it DOES NOT DO THIS.

I've never reported a bug, but this seems like a pretty big one to me. I can literally break it if I do a lot of reordering inside a course page and then do backups or restores or imports, all things I'm allowed to do in Moodle.

Can anyone help?

Picture of Brian Peat
Re: Grades out of order
 

To follow up on this, if I'm careful and I create activities one at a time and don't dupe them and don't drag them around, everything is fine. I'll be duping courses later today so we'll see how that goes, but I suspect since each original course is clean it won't be an issue.

But, I think the system needs to be tweaked and that the grades should ALWAYS follow the order of the course itself unless an admin overrides the order on the back end. And then, if you're going to continue to use the IDs that you currently use in the db, moodle needs to be able to reassign the entire table to actually let you re-order things...OR, that ID needs to be dumped and some sort of smart ID that is tied to the course needs to be used instead so that the order of the table doesn't matter.

Hope that makes sense. I'm not a programmer, I just know it was pretty easy to break the grading order and there was no way to fix it in the admin short of starting over.

Picture of Catherine Berry
Re: Grades out of order
 

You can change the order of grade items within the gradebook. Go to Categories and items: Simple view, and you will find a list of all your grade items. In the Actions column, click on the arrow key to move an item.

I think the default is to list items in the order they were created - I do agree with you that it would be more useful if they were listed in the order in which they appear in the course.

Hope this helps.

Picture of John Hughes
Re: Grades out of order
 

Thanks Catheine - very useful

Am I correct in  thinking that every user will have to do this "re-ordering"?

John

Picture of Teresa Gibbison
Re: Grades out of order
Group Moodle Course Creator Certificate holdersGroup TestersGroup Translators

Hi John

Catherine is correct, the grade items are sorted in the order the activity was created.  Teachers can sort the items using the move up/down icon on the Categories & Items screen of the gradebook.

I hope this helps smile
Cheers
Teresa


My face
Re: Grades out of order
 

I have had the same issue.  The reorder tool doesn't work consistently. 

Picture of Sakshi Goel
Re: Grades out of order
Group Particularly helpful MoodlersGroup Testers

Hi Brian

Here is a issue reported in tracker. You can also vote for it.

My face
Re: Grades out of order
 

Thanks Sakshi.  Can you post that link?  I'd love to have a look.