The teachers at our school wanted to have the exported Excel spreadsheet sort students by their usernames rather than last names (this is how they keep track of students elsewhere). They'd also like to have their scores listed as % rather than raw points.
By modifying grade/lib.php I've managed to have the Excel spreadsheet show user names rather than firstname, but it's still sorting the students by their last names.
Thanks for any help you can offer!
in grade/lib.php on line 1285, we are setting our $grade array values with:
$grades[$student->id] = $currentstudentgrade = $modgrades->grades[$student->id];
I've replaced this line with:
$grades[$student->id] = $currentstudentgrade = round(($modgrades->grades[$student->id]*100/$modgrades->maxgrade),2);
Still not sure what variable is dictating the student order though... can't find any reference to 'lastname' that affects student order in the exported Excel spreadsheet.
Vincent, This sounds like you did what I am looking to do. I posted earlier. I want to modify the profile fields in the excel spreadsheet to match my newly added profile fields. I am very new to Moodle, and not very computer saavy. Can you tell me what your following sentence means:
When you go to the gradebook, do you see a Turn editing on button?
If so, then click on it to show the controls for each grade item:
Click on the edit icon for the grade item (in the Controls row). Then you can change how that particular item is displayed.
I'm pretty sure you can set this on a site-wide basis using Admin / Grades / General Settings.
I'm afraid I can't help on adding additional profile fields to the report though. It's something I'd like to see as well...