How do you extract grade from grading_standards.data where scores.course_score = true?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2024
10:33 PM
Wondering if anyone can suggest how to extract the equivalent of the grade book total letter grade?
In the scores table, scores.course_score is a boolean value where true "represents the overall score for the course referred to in the enrollment".
But it doesn't provide the letter grade. Instead it just links to the grading_standards table where the grading scheme is stored in grading_standards.data as json.
The submissions table contains submissions.grade ("Letter grade mapped from the score by the grading scheme"). Why not do this for course _score? And override_score? It's in the rest api.
It just seems unnecessarily complicated.
Anyway, wondering if anyone has any tips on doing this in SQL?