CD2 - How many assessment submissions have been graded

[DougWalker]

Howdy,

I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff.

I use CD2 CLI to download CD2 tables. I then import into a database and then run SQL queries on the data.

In the submissions table, it's my understanding that there are not entries for every submission, even though this data exists somewhere as every submission is available in the gradebook in Canvas LMS.

Is it possible using CD2 to count the number of submissions (original attempt and resubmissons) graded by a marker for each assignment. Ideally in that data knowing the course, assignedment and student for each? Not interested in ungraded submissions.

Appreciate any advice.

[KeithSmith_au]

I don't think it is possible.  Whilst the submission_versions table exists to provide information and a version_id, the versions table is not exposed in Canvas Data 2 (and the contents and structure are not documented).

This means that you are left with just the data from the most recent submission.  I am not sure that even the REST API calls actually let you get at prior versions of submissions even if you were to go that far.  I don't know of anyway to achieve this other than through the user interface (potentially you could script something to automate pulling this data, but it would be horrendously inefficient, as well as being complicated).