| Warning |
|---|
This has been moved to https://github.com/edx/edx-platform/blob/master/lms/djangoapps/grades/docs/data-model.rst and should be deprecated in favor of that copy. |
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
...
Use case for reading from the table | Feature/team | Required Indices (to be completed by engineering team) |
|---|---|---|
Progress page displays learner's course grade, along with other grade breakdown info | LMS Progress Page | course_id, user_id |
Course dashboard displays learner's course grade for each enrolled course | LMS Student Dashboard | user_id |
Grade report generates CSV with course grade for each learner in the course | LMS Grade Report | course_id |
Measure course completion statistics. | Analytics/Course Completion | course_id, passed_timestamp |
Subsection Grades
There are two tables that work in conjunction for storing subsection grades: Subsection Grade and Visible Blocks.
...
Use case for reading from the table | Feature/team | Required Indices (to be completed by engineering team) |
|---|---|---|
Progress page displays learner's subsection grade breakdown | LMS Progress Page | course_id, user_id |
Detailed grade report generates CSV with subsection grade for each learner in the course | LMS Grade Report | course_id |
Compare with previous grade to see whether it should be conditionally updated | Rescore to Increase | course_id, user_id, usage_key |
Visible Blocks Table
Table Name: grades_visibleblocks
...
Subsection Grade Overrides
Table Name: grades_persistentsubsectiongradeoverride
Table Description: Stores the most recent override for a given subsection. In grade calculation, supersedes persisted subsection grade totals. The historical version of this table (grades_historicalpersistentsubsectiongradeoverride) captures a rolling list of previous overrides for audit purposes.
...