CD2 Ungraded Submissions

[DougWalker]

Howdy,

I use CD2 CLI to download CD2 tables. I then import into a database.

I am trying to set up a query to show all assignment submissions that are not yet graded.

It seems to me that the submissions table that I download using the CD2 CLI is not showing separate entries for multiple submissions of the same assignment by the same user.

For example, in Canvas LMS, in the gradebook for a course, I get something like the attached image. Where the first submission has been graded, and the second submission has not yet been graded. There are two submissions by the user though.

However, in the submissions table there is only one entry for this course/assignment/student combination.

Is this correct, or am I missing something?

If this is correct, what are the fields in this table I can use to determine the unmarked assignments?

Appreciate any advice.

[KeithSmith_au]

There is only the most recent version of each quiz submission persisted in CD2 as per Quiz submissions which states "This tables persists one record per user_id and quiz_id."  This used to be more prominently displayed.  It has bee requested that all versions of a submission are made available, especially where a "keep highest" rather than "keep most recent" grading approach is in play.

[Jeff_F · Accepted solution]

@DougWalker 

Had you looked over the field submissions.grade_matches_current_submission?

(bool | None) – A boolean flag which is false if the student has re-submitted since the submission was last graded. Valid only when a score has been assigned to a submission. This is set to false if a student makes a new submission to an already graded assignment. This is done to indicate that the current grade given by the teacher is not for the most recent submission by the student. It is set to true if a score has been given and there is no new submission. Defaults to NULL.

https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas.su... 

While I can see where there are additional attempts, with examples that are ungraded, I am not able to find any records show 'False' even though there are additional ungraded submissions.  I am seeing 90% True and 10% null in that field.

I am curious if anyone ever gets a 'False' here?

[DougWalker]

Thanks @Jeff_F .

The submissions.grade_matches_current_submission field combined with a check of the grade field being less than satisfactory has worked for me.

I am fairly confident I am getting the correct list of ungraded assessment tasks.

It's not ideal needing to use this field and not having access to each submission as an entry in the table. But for the purposes of this specific query this one is solved.

Much appreciated.