We also use the advanced grading methods in Moodle and I have also voted for this new feature
In the meantime I use the configurable reports block and have created 2 SQL queries for saving all the details. It is in a list format which I transform to a Pivot table in Excel. You can add extra conditions in the WHERE section (course name, assignment id, etc if you have a lot of courses with a lot of results in your Moodle site)
However, I would also be very happy if the rubric/guide result export function were available from the course / assignment interface so that teachers could also get these for themselves.
Éva
SQL for rubric results:
SELECT crc.name, crs.shortname, crs.fullname, asg.name AS assignment, gd.name AS rubric_name, CONCAT(stu.lastname, ' ', stu.firstname) AS student, grc.description, grl.definition, grl.score, grf.remark, ROUND(ag.grade,2) AS rawgrade, FROM_UNIXTIME(gin.timemodified) AS modified, CONCAT(rubm.lastname, ' ', rubm.firstname) AS Rater, ROUND(grg.finalgrade,2) AS Finalgrade, grg.feedback,
CASE
WHEN grg.overridden = 0
THEN '-'
ELSE FROM_UNIXTIME(grg.overridden)
END AS 'GradeOverridden',
FROM_UNIXTIME(grg.timemodified) AS FinalGrade_modified, CONCAT(m.lastname, ' ', m.firstname) AS FinalGrade_modifier, stu.username AS stulogin
FROM {course} AS crs
JOIN {course_categories} AS crc ON crs.category = crc.id
JOIN {course_modules} AS cm ON crs.id = cm.course
JOIN {assign} AS asg ON asg.id = cm.instance
JOIN {context} AS c ON cm.id = c.instanceid
JOIN {grading_areas} AS ga ON c.id=ga.contextid
JOIN {grading_definitions} AS gd ON ga.id = gd.areaid
JOIN {gradingform_rubric_criteria} AS grc ON (grc.definitionid = gd.id)
JOIN {gradingform_rubric_levels} AS grl ON (grl.criterionid = grc.id)
JOIN {grading_instances} AS gin ON gin.definitionid = gd.id
JOIN {assign_grades} AS ag ON ag.id = gin.itemid
JOIN {user} AS rubm ON rubm.id = gin.raterid
JOIN {gradingform_rubric_fillings} AS grf ON ((grf.instanceid = gin.id) AND (grf.criterionid = grc.id) AND (grf.levelid = grl.id))
JOIN {grade_items} AS grit ON ((grit.courseid = crs.id) AND (grit.itemmodule = 'assign') AND (grit.iteminstance = asg.id))
JOIN {grade_grades} AS grg ON (grg.itemid = grit.id)
JOIN {user} AS stu ON ((stu.id = ag.userid) AND (stu.id = grg.userid))
JOIN {user} AS m ON m.id = grg.usermodified
WHERE gin.status = 1
Guide results:
SELECT crc.name AS category_name, crs.shortname, asg.name AS assignment, gd.name AS rubric_name, CONCAT(stu.lastname, ' ', stu.firstname) AS student, grc.shortname AS shortdescr, grc.description, grc.maxscore, grf.score, grf.remark, ROUND(ag.grade,2) AS rawgrade, FROM_UNIXTIME(gin.timemodified) AS modified, CONCAT(rubm.lastname, ' ', rubm.firstname) AS Rater, ROUND(grg.finalgrade,2) AS Finalgrade, grg.feedback,
CASE
WHEN grg.overridden = 0
THEN '-'
ELSE FROM_UNIXTIME(grg.overridden)
END AS 'GradeOverridden',
FROM_UNIXTIME(grg.timemodified) AS FinalGrade_modified, CONCAT(m.lastname, ' ', m.firstname) AS FinalGrade_modifier
FROM {course} AS crs
JOIN {course_categories} AS crc ON crs.category = crc.id
JOIN {course_modules} AS cm ON crs.id = cm.course
JOIN {assign} AS asg ON asg.id = cm.instance
JOIN {context} AS c ON cm.id = c.instanceid
JOIN {grading_areas} AS ga ON c.id=ga.contextid
JOIN {grading_definitions} AS gd ON ga.id = gd.areaid
JOIN {gradingform_guide_criteria} AS grc ON (grc.definitionid = gd.id)
JOIN {grading_instances} AS gin ON gin.definitionid = gd.id
JOIN {assign_grades} AS ag ON ag.id = gin.itemid
JOIN {user} AS rubm ON rubm.id = gin.raterid
JOIN {gradingform_guide_fillings} AS grf ON ((grf.instanceid = gin.id) AND (grf.criterionid = grc.id))
JOIN {grade_items} AS grit ON ((grit.courseid = crs.id) AND (grit.itemmodule = 'assign') AND (grit.iteminstance = asg.id))
JOIN {grade_grades} AS grg ON (grg.itemid = grit.id)
JOIN {user} AS stu ON ((stu.id = ag.userid) AND (stu.id = grg.userid))
JOIN {user} AS m ON m.id = grg.usermodified
WHERE gin.status = 1