After N number of terms (semesters) I am trying to figure out a way to use Moodle's gradebook to determine the OVERALL BEST STUDENT of a programme. E.g., a particular cohort started their Diploma in April 2016. So in June 2018, they are due to graduate. Admin needs to quickly and accurately determine (not guess!) who is the overall best student based on the marks recorded in Moodle's Gradebook.
Perhaps a high level list like the one below that is sorted on average Course Final Grade score:
Name Average Course Final Grade score for all courses enrolled
Alex Lion 90%
Tony Tiger 80%
Daisy Duck 70%
If nothing like the above is immediately or readily available, I would like to ask how do you determine, at the end of a programme, the overall best student?