Gradebook

How do you determine the BEST STUDENT of a programme when the time is right?

 
Frankie's the name, Moodle's my game!
Re: How do you determine the BEST STUDENT of a programme when the time is right?
Particularly helpful MoodlersPlugin developers

I am answering my own question after eight days. Haha. 

I solved this. The trick is to use the Configurable reports block (plugin).


For your convenience, I reproduce the SQL Query code in the text below:

SELECT prefix_course.id AS courseid, prefix_course.shortname AS Course_ShortName, prefix_user.id AS studentid, prefix_user.firstname AS FirstName, prefix_user.lastname AS LastName, prefix_grade_grades.finalgrade AS coursetotalgrade
FROM prefix_grade_grades
JOIN prefix_user ON prefix_grade_grades.userid = prefix_user.id
JOIN prefix_grade_items ON prefix_grade_grades.itemid = prefix_grade_items.id
JOIN prefix_course ON prefix_grade_items.courseid = prefix_course.id
WHERE prefix_grade_items.itemtype = 'course'AND
prefix_user.lastname='GIJB Jan 2016'
ORDER BY prefix_course.idnumber, prefix_user.username, prefix_grade_items.itemname, prefix_grade_grades.timemodified

Note: replace  the line prefix_user.lastname='GIJB Jan 2016' with your own values between the apostrophes.

Clicking the "View report" tab (which is to the immediate left of "Custom SQL") of the block tab yields this output for me:



I then save the output as an Excel export file. The rest is manual work on the Excel to give me enough information as to who is the top scorer.

Hope this helps someone.