Discovery: Legacy Dashboard: Grade Downloads about edx-platform HOT 5 CLOSED

Downloading raw/csv grades may need to be ported, but it would be good to understand what the use cases are and whether or not it's really necessary to port the info, or if existing structures can be used (eg Insights).

CSV of answer distributions is terribly unperformant and doesn't use the same analytics structures that we have in place. "Porting" this should be an entirely new implementation that goes through Celery and uses analytics APIs.

from edx-platform.

@pdpinch A couple questions:

1. My assumption right now is that the first button in that screenshot already has some equivalent in the current release, and that the latter 3 buttons probably need to be ported over, but there could possibly be some equivalent in the current release. Is that correct?
2. Do we care about performance for these buttons? I was deliberate about not spending too much time trying to optimize or find better-performing equivalents to the functionality I ported over in the "Export Grades" PR. If we care enough, I can take that time to look around the codebase (including "Insights" and the analytics APIs, which Sarina mentions but I haven't reviewed yet).

from edx-platform.

A few observations after digging through the codebase:

• The RAW grade report, as it existed in Dogwood, seems to be a breakdown of enrolled students' grades for individual problems in a course. There is a rough equivalent in ficus - the CSV generated by "Generate Problem Grade Report" in the "Data Download" tab. Here are the two reports on "DevOps: 0.001 Ops" for comparison: Problem Grade Report - Legacy RAW Grades Report. A couple differences:
  1. The problem grade report represents each problem with 2 columns (one for "Possible" points and one for "Earned") and the column headers are much more verbose.
  2. The legacy report has one extra column: "SGA Unit 1". I'm not sure what that is, but I'd be more inclined to trust the current problem grade report to accurately reflect all of the existing problems and their grades.
     TLDR; We should decide if the problem grade report is a good enough replacement for the legacy RAW grade report (in my opinion, that looks like a 'yes')
• The "Dump All Raw Grades" button just spits out that same CSV report in the browser window, so our implementation of that will depend on our decision about the RAW grade CSV functionality.
• There doesn't seem to be any equivalent to the answer distribution report in ficus. Here's an example report from QA: legacy_answer_distibutions.xlsx. It looks like it's a breakdown of every unique answer to every problem in the course with the number of times that specific answer value was submitted. It looks like a decent chunk of work to reimplement this, so I think it's well worth our time to figure out if anyone still needs this and what their use cases are

I'm moving this back to 'Ready' until we make some decisions about the above

from edx-platform.

I think I'm going to have to consult with the ed tech team on this and get back to you.

from edx-platform.

Thanks Gavin.

I agree that "Dump All Raw Grades for all students in this course" is close enough to "Generate Problem Grade Report"

And I've confirmed that the data available from "Download CSV of answer distributions" is equivalent to what is accessible from analytics.odl.mit.edu.

from edx-platform.