Download All course data for multiple instances of a course

[jallen14]

Our team has received a request for comprehensive gradebook data, specifically:

• Complete Gradebook scores (not just final course grades, but how each student performed on weekly assignments)
• For all Online MBA students
• Covering the full history of the program going back many semesters

I believe the goal is to align specific student performance to a set of program level course learning objectives.  The reporting group already has an informational spreadsheet that explains which assignments would prove learning across the array of courses. Now they need the raw data on all students to help them to create dashboards and visualizations for accreditation reports, etc.

Is there an API or tool to do this?

[James]

@jallen14 

The gradebook entries are found in the submissions records. There are several APIs for retrieving that information. Some of them can be used to obtain all grades for all students (either through the REST API or the GraphQL API).  You can also limit it to specific user IDs in the case where not everyone in the course is an online MBA student. You can also limit which assignments for each course, just in case they only want specific ones.

If using the API isn't your thing, you can go into each course and export the gradebook to a CSV file and then work on combining them.

You would need to determine what courses were taken by online MBA students and then perform that first step for each course. This step also includes covering the full history of the program going back many semesters. Once you identify those courses, then you can get the grades for them.

As long as someone else is doing the analyzing, getting the data is pretty straightforward. Analyzing the data takes a lot more effort with matching up assignments between courses. You cannot rely on IDs to match assignments, you'll have to go off names and hope people didn't change the assignments. Hopefully the reporting group has already looked at the courses and figured that out.

[James]

I did find out there is a way to get the IDs when the courses are copied, so you don't have to rely on names. Hopefully the reporting group has that taken care of, but I discovered the way to get the data about an hour after I wrote my response to you and wanted to correct my statement.