Para tirar a lista de nota final de todos os alunos e em todos os cursos, execute no banco de dados o seguinte comando:
SELECT u.id,u.username,u.firstname,u.lastname, u.email,u.department,u.institution,c.fullname, g.finalgrade,from_unixtime(g.timecreated, '%d/%m/%Y %H:%i:%s') AS timecreated,from_unixtime(g.timemodified, '%d/%m/%Y %H:%i:%s') AS timemodified FROM mdl_grade_items i INNER JOIN mdl_course c ON c.id=i.courseid INNER JOIN mdl_grade_grades g ON i.id=g.itemid INNER JOIN mdl_user u ON u.id=g.userid WHERE i.itemtype = 'course' AND u.deleted=0 AND u.confirmed=1 ORDER by u.firstname,u.lastname