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

[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]

Unfortunately, all I see for that specific assignment_group is

group_weight

0

rules.drop_highest

NULL

rules.drop_lowest

NULL

rules.never_drop
[]

Anything there jump out at you?

[IanGoh]

Could it be taking into account the group_weight 0, then taking the submission.score x group_weight or something?

Update:

Unfortunately, in the same course, I can find other assignments where group_weight 0, but there are some actual scores in the score table.  So I don't think the group_weight is the culprit

[IanGoh]

O, I think I get it

scores - This table stores assignment group and course grades for students enrolled in a course.

IF there was a one-to-one between the Assignment and the Assignment_Group, then we would expect the Score = submission.grade, right?

But typically, there's not a one-to-one between Assignment and Assignment_Group, e.g., you have four HW  assignments and there's an assignment group called Homeworks.  There'd be four Submissions per student, but only one Score for the Homeworks for that student.

Right?

[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.

[IanGoh]

Best we can tell, the CD2 incremental pulls we made last week (Week of December 4th) didn't return all the data we'd expect.

This week  we're monitoring incremementals, and it seems to match up (for Scores table).

We can't expect every table to have new/updated data, e.g., Accounts table won't change much. 

How can we tell we're missing data?

Ian