We're trying to understand Assignment grades. We have an assignment * set for submissions: none * grades (percentages) uploaded * but not posted For that assignment, in CD2: * Scores table has records, but no scores (posted or unposted), either 0 or NULL columns * Submissions table has grades which were the ones uploaded. Is that functioning as expected? Are there no scores because it's a manual grade column? Just trying to understand when we check Submissions vs Scores Thanks Ian

Submissions.Grade vs Scores table

IanGoh

We're trying to understand Assignment grades.

We have an assignment

set for submissions: none
grades (percentages) uploaded
but not posted

For that assignment, in CD2:

Scores table has records, but no scores (posted or unposted), either 0 or NULL columns
Submissions table has grades which were the ones uploaded.

Is that functioning as expected?

Are there no scores because it's a manual grade column?

Just trying to understand when we check Submissions vs Scores

Thanks

Ian

Find more posts tagged with

cd2

Accepted answers

All comments

stimme

@IanGoh The Scores table contains records for assignment groups but not for specific assignments. Joining the assignments table to scores would to go through the assignment_groups table. Information on the assignment groups table might explain why a student has a score for a submission within the assignment group but not a score for the assignment group (e.g. only one assignment in the group is scored, and the lowest score is dropped automatically).

IanGoh

Just to circle back, so our issue seemed to be missing scores data between 12/5 and 12/6 incremental pulls. We only pull once a day, since the last max meta.ts.

We got the scores empty records created on 12/5 incremental pull

The course folk updated the data late on 12/5.

But the 12/6 incremental pull did not have that updated data. And then life moved on.

On 12/5 our max(scores.meta.ts) = 12/5/2023 19:31
On 12/6 our min(scores.meta.ts) = 12/6/2023 8:17

Thus, we lost scores data between those two timestamps.

I checked recently. Yesterday's max(scores.meta.ts) was close to today's min(scores.meta.ts) as expected.

It could have been a one-off issue then.

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