Gathering Data on Assigments that don't have a submission type?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can calculate the number of assignments submitted by student from the submissions table if the assignment has a submission type. Where would I get the data that someone "submitted" an assignment when there isn't a submission? I hope that makes sense!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As students are not posting anything to Canvas perhaps look at the Submissions table Graded At and Grade fields. If these are not null then you could assume that the instructor 'gathered' what was needed to assess some aspect of the student and then entered a grade into the Grades.
So something like COUNTD ID (submissions) if x and/or y are not null.
