Inconsistencies in user submission attempts (new quizzes) across tables and interface

Looking for any insight as to why my CD2 submissions table and API submissions are returning an 'attempt' number that is different from CD2 submissions_version and from the New Quizzes moderate page.

Also, extra attempts are always NULL even after attempts are added via New Quizzes moderate (possibly related to New Quizzes not yet being in CD2). It's unclear to me from the docs what submission_versions.version_id refers to!

e.g. the CD2 submissions indicates 11 attempts for a student and so does the API, but the submissions version table shows 12 records, and the moderate quiz page shows only 4 attempts.

Any insights appreciated!

Find more posts tagged with

Canvas Data 2

sql

Accepted answers

All comments

stimme

@Pete5484 I think that the discrepancies you noticed must be explained by the fact that New Quizzes is a separate application, not part of Canvas itself. The assignment submission records that New Quizzes connect with are updated via LTI. That might be why the count of attempts from the submissions table is higher that makes sense.

I haven't worked with the submission_versions table, but it looks like the version_id value is a foreign key to a table in the actual Canvas database that isn't currently part of CD2. So it is inscrutable.

New Quizzes is the next data set that should be coming to CD2. That should provide more informative and meaningful information about New Quizzes than what we can try to surmise from the submissions table.

ESheta

What I understand is submission_versions table, Each row here represents a version of a submission (like autosave, manual save, or final submission). So if a student edits answers multiple times before submitting, you can see more versions than actual attempts.

Moderate Page (New Quizzes): This shows actual graded attempts for the quiz, not intermediate saves.

So if a student started a quiz and saved multiple times, CD2 will show more versions than the Moderate page.
regarding to the attempt 11, I beleive when new quizzes data became available on CD2, we will find an explaination for this number. But uptill now, the number you see in the GUI on the moderate page is the actual number of student attempts.

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian