As an instructor, I want to override assignment grades for all enrolled learners in my course at once.
Keep my Canvas grades in sync with edX grades
Support curving off-platform
High level ACs for V1 "alpha"
Allow instructors to override assignment (i.e. graded subsection) grades via CSV file upload, per subsection
Workflow (similar to SGP):
Step 1: instructor exports grades CSV template for a specific subsection from Gradebook
Step 2: instructor fills in assignment override grades and reason off-platform
Step 3: instructor uploads the completed file to edX via Gradebook, to effect grade overrides.
Feedback – Provide feedback after override
e.g. "4 grades updated out of 400 learners enrolled for [subsection name]"
Recovery – Provide a way for edX and course teams to recover from errors
V1 manual reversion OK
ensure edX staff have access to an override history table with grades, date overridden, who overrode, reason.
Validation – Advertise approach chosen for file validation
Instructors should know in advance how they can change CSV columns and rows
Availability - only for Programs by default. V1: for courses with a Master’s track
Try to keep in step with SGP grade upload behavior, so that course teams are not confused
Product requirements for V1: Support Master's and MM course sizes
Eng: Sync or async file processing?
Eng: Store full file for reference?
Eng: max course size for first rollout?
Overall file validation
e.g. is the file a reasonable size and format?
Row validation -
primary keys are user_id, username
secondary read-only columns are skipped
course ID matches course
scores are numerical
TBD: rows are learners enrolled in course?
OK to update a subset of enrolled learners
Rows with blank (empty) input grade values are skipped are skipped
Deen's document with background info/other questions here:
Out of scope/Post V1
Live diff & table readout
Confirmation flow for Instructors ("You're about to change 400 records. Are you sure?")
Possible options for V1 "alpha" format (depending on what's easiest to build):
Export of all subsection grades in one file - e.g. as rows (learner-assignment)
Trevor - history table approach - Scott
Clarify size limits