SQL to report on actual marks from rubric using scales

SQL to report on actual marks from rubric using scales

by William Mair -
Number of replies: 0

Hi All,

I'm stuck with going round in circles and can't map my way from users through the grading_rubric tables onto grade_grades, so am asking for someone's (anyone's) help.

I have 2 assignments setup (2.3 assignments)  which are set against a 4 point scale. I also have a rubric setup with a total highest mark of 17. However, against all of the marks in the grade_grades tables, they all show it as marks out of 4 and I can't find any links in the tables (I thought it was around itemid's or contextid's but neither of those match up correctly).

I am hoping that some kind soul may be able to provide me with some SQL that will pull through the actual marks for each rubric critera (not even necessarily the total mark) for each student given an assignment ID.

Anyone?

Average of ratings: -