I know there is the plugin to export component grades as an excel sheet (https://moodle.org/plugins/pluginversions.php?plugin=report_componentgrades) but I have a question...
Could anyone recommend a simple SQL query for me to be able to extract the component grades (and comments) when using the marking guide so I can build a bespoke User Report that captures all that data?
Something that flows like:
FOR STUDENT(id) IN ASSIGNMENT(id) IN COURSE(id)
1. see how many component grades are in that assignment
2. loop to provide all of the grades and their associated comments as an array
Thank you so much for any help.