CD2: where are the course final grades?

[IanGoh]

Another n00b question, via the REST API, I get the final grades via the Enrollments object;

  // The URL to the Canvas web UI page containing the grades associated with this
  // enrollment.
  "grades": {"html_url":"https:\/\/...","current_score":35,"current_grade":null,"final_score":6.67,"final_grade":null},

but CD2's Enrollments table seems bereft of that information.  Where in CD2 do I get course final grades?

[IanGoh]

Looks like it be the scores: This table stores assignment group and course grades for students enrolled in a course.

along with

scores.course_score - boolean

True if this score does not refer to a particular grading period or assignment group (in other words, if it represents the overall score for the course referred to in the enrollment).

[IanGoh]

hmm, I can get scores, e.g.,

current_score	number <float64> The current score for the assignments represented by this Score object.
final_score	number <float64> The final score for the assignments represented by this Score object, calculated by treating ungraded assignments as though they received zero points.

but where's the final letter grade?!

[KeithSmith_au]

I believe you need to go looking in the grading_standards table.

Actually working out which may apply will involve looking for context_type of 'course' and context_id of the course_id, and if that does not exist, then checking for the context_type of account and the context_id matching the account the course resides in.  I suspect that you will need to also look at using the course_account_associations to check the hierarchy of sub-accounts in case their is an account grading standard applied at an account higher in the hierarchy when there is none in the actual sub-account.

Unfortunately, this sort of logic is easy for a UI and individual reports, but a bit painful to join up in a query.

[KeithSmith_au]

For the grades for individual submissions, then they can be found in submissions - but this isn't going to get you a final grade for the course.

[IanGoh]

thanks grading_standards doesn't seem to be tied to the students, but to the person who created the grading scheme.  so you are prob right there's something else that needs to be checked...

[KeithSmith_au]

All scores at the student level are only held as numbers - to get a letter grade, you need to use the score and apply the appropriate grading standard for the course - the individual submissions already have the grade attached, but for some reason, it doesn't appear against the scores object - either for individual or course scores.

[pgo586]

If what you are saying above is true, this would be very unfortunate @KeithSmith_au . This would add unnecessary processing time to info that can be quickly obtained via regular Canvas API (as @IanGoh explained in his original post).