Submissions Questions

[millerjm]

I'm working with submission_dim and submission_fact trying to generate some data based on student submissions.  I see in the schema that submission_dim and submission_fact both have only information about the LATEST submission.  

If there are multiple submisisons for an assignment/student/course:  

Is there any way to generate the FIRST ATTEMPT DATE?  I see the number of attempts but I can't find the first attempt date or timestamp.  

Which score is the actual gradebook score?  is it submission_fact.published_score, submission_fact.score, or submission_dim.published_grade?  If there are multiple attempts on a quiz, and has latest/average/highest does it always include the properly calculated score?  

Is there any way to see past submissions for assignments in canvas data?  

Thanks!

Joni

[fluckigerda]

Joni, I don't know how helpful this will be, but we are using submission_fact not submission_dim because submission_dim lacks a numeric score field - which is what we need. In all of our data submission_dim.published_grade and submission_dim.grade were identical and contained a mixture of numeric values, letters, and strings ("complete", "incomplete"). We are using submission_fact.published_score instead of submission_fact.score because the Canvas Data definitions make it sound like published_score is safer/newer - but in our of our data, both these fields are identical.

I don't know of any way to get the first attempt date.