Bulk Upload Issues with Gradebook

Description

Hello,

IU (Masters Partner) reported issues uploading their grades via bulk upload in the gradebook tool.

From the course team: "The gradebook doesn't seem to accept changes that we enter. Or if the changes are accepted, they aren't universally applied to all of the grades or applied correctly. For example, Discussion 1 in this course (https://gradebook.edx.org/course-v1:IUx+BL-BUKX-A597+3T2020?track=masters) should show 10/10 for all Master students. For most, I see 10/0. Those scores originated from a Bulk management upload. One student, Rose Martin, shows 10/10 only after I manually reentered her grade in the gradebook. I can't understand why the upload didn't correctly assign grades to all students and why the only one that is correct only appears correct after I've manually edited again.

When I switch to percentage view, Rose is the only one who actually has a score. The assignment/points are the same for all students on this assignment. The assignment is published for students."

Current behavior:
Bulk uploaded grades are not applied to learners correctly.

Expected behavior:
Bulk uploaded grades should be applied for each learner that has a grade update.

Steps to Reproduce

None

Current Behavior

None

Expected Behavior

None

Reason for Variance

None

Release Notes

None

User Impact Summary

None

Activity

Show:
Jennifer A. Akana
February 4, 2021, 8:36 PM

Updating here and in the CR ticket that the specific issue is resolved, IUx was able to update all their grades as intended. TY!

Matthew Hughes
February 4, 2021, 7:01 PM

Is it accurate to say that Bulk Grades / Gradbook should not be used to import off-platform scores into assignments that don’t require learner interactions?

I would relax that condition a little bit: they shouldn’t use Bulk Grades Management first. Gradebook (currently) only works well if we’re overriding grades that’re already there. In the case of staff-graded XBlocks, the way we get that to be the case is by uploading grades in the instructor’s side of the XBlock.

[I’m guessing that since the staff-graded xblock update counted as an attempt, gradebook now had knowledge of points possible and can apply the intended override(?)]

This is exactly correct. At the time of their first upload via Bulk Management, the vast majority of the learners had no grade, so their grade overrides were created with a possible_graded_override of 0. That field on the override record doesn’t change when their earned score is updated by an XBlock csv upload, unfortunately, so the denominator remains 0 in their effective score.

Workflow I would recommend: for Discussion 1, reupload the grade overrides via bulk management. I expect this to re-write the grade overrides and causing them to be written with the correct possible_graded_override value of 10. (Note: this expectation may be false, but if it is they’ll have lost nothing for having tried it.)

For future Discussions: upload grades via the staff graded XBlock before attempting to upload grades via Bulk Management. They could even give everyone a zero when uploading via the XBlock, and then override that zero later via Bulk Management, if they want to do that.

Jennifer A. Akana
February 4, 2021, 6:25 PM

And to resolve the specific issue of Discussion 1, I think we have a way forward.

For reference:

  1. The course team inadvertently applied a 10/0 scores via Gradebook Bulk Update, so learner scores = 0.

  2. The course team then imported points to the staff-Graded xblock, so learners had 10/10 scores that were overridden to the 10/0 score from the previous step. Learner scores = 0.

  3. Now I can use Gradebook to override a learner’s score to 10/10 (verified with learner skybowthorpe). [I’m guessing that since the staff-graded xblock update counted as an attempt, gradebook now had knowledge of points possible and can apply the intended override(?)] Specific learner’s score =10/10.

Jennifer A. Akana
February 4, 2021, 6:10 PM

Thanks . I think this has turned into a workflow issues, and I’d love to get your / your team’s check on my understanding here:

The best workflow:
My understanding of the ‘best’ workflow for IUx, who wants to bring in off-platform scores into their Discussion sections, is:

  • [Background] The course team has created a graded Discussion assignment. The point points possible are from a staff-graded xblock to create “points possible”.

  • The course team should only use the staff-graded xblock to update scores.

  • The course team cannot use Bulk Management to import external scores into the Discussion assignments, since:

    • It’s known that Bulk Management will give a learner a 0 if the assignment contains 0 points.

    • It’s known that Bulk Management will give a learner 0 if the learner hasn’t attempted the assignment

Is it accurate to say that Bulk Grades / Gradbook should not be used to import off-platform scores into assignments that don’t require learner interactions?


For context, IUx plans to update scores in several courses in the near term- we’d like to give them the most fool-proof way of doing so.

Matthew Hughes
February 4, 2021, 4:58 PM
Edited

It seems very notable that the discussion assignments appear to consist of only a Staff-Graded XBlock, which also involves a CSV upload to add the learner’s initial grade.

There’s a known issue with Bulk Management where a learner who hasn’t initially attempted an assignment will show in gradebook as having a 0 for that assignment, even if their grade is overridden. (The override shows in their history if you click into the modal in gradebook, reflecting what the learner’s actual effective grade is.)

It seems likely that the course team doesn’t know that they can upload the grades for discussions via the staff-graded XBlock’s feature, which would cause the learner’s grades to show correctly in gradebook. So the next step discussed offline is to communicate with the course team about that.

Done

Assignee

Unassigned

Reporter

Julia Song

Reach

Group(s)

Impact

None

Platform Area

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Story Points

None

Actual Points

None

Category of Work

None

Platform Map Area (Levels 1 & 2)

Educator Experiences - Program Operations / Console

Platform Map Area (Levels 3 & 4)

Grading Tools

Priority

CAT-3