We utilise Assignments with Marking Guides in our courses and at the end of a course want to produce a "Report Card" for every assignment attempt. I can't find a native or plugin way to do this so I'm resorting to writing SQL to access the database.
I can see all the data I need in the database tables (user, assign, gradingform_guide_fillings, grading_definition, grade_grades_history and course) but I can't work out the relationships between them all.
For a course we want a report per assignment attempt (filling) showing:
- student information
- teacher information
- course information
- assignment level information (overall feedback, maxscore, score) and underneath that
- one row per marking guide criteria showing criteria description, criteria feedback and criteria score and criteria max score
Any help on some SQL statements that would combine the informaton from each of the relevant tables would be much appreciated.