Student Submission Reports

[gehringb]

Hello, 

I am looking for a way to pull a report that shows all student submission with a timestamp by course on a particular day. 

[jerry_nguyen · Accepted solution]

@gehringb 

This report is not built-in, so I recommend setting up Canvas Data. Canvas Data allows you to create custom reports using queries or SQL. You can download Canvas Data to your computer or server, but you may need to contact your Canvas CSM to enable access.

Please feel free to send me a PM if you need help setting it up, you can also join the Data and Analytics Group Discussions for help.

FYI, the following SQL query can be used to generate this report

select
canvas.users.name "Student Name",
canvas.courses.name "Course",
canvas.assignments.title "Assessment Name",
canvas.submissions.submitted_at "Submitted At"
from canvas.submissions
JOIN canvas.users ON canvas.users.id = canvas.submissions.user_id
JOIN canvas.assignments on canvas.assignments.id = canvas.submissions.assignment_id
JOIN canvas.enrollments on canvas.enrollments.user_id = canvas.submissions.user_id and canvas.enrollments.course_id = canvas.submissions.course_id
JOIN canvas.pseudonyms on canvas.users.id = canvas.pseudonyms.user_id
JOIN canvas.courses on canvas.courses.id = canvas.submissions.course_id
WHERE
canvas.enrollments.type = 'StudentEnrollment'
and canvas.enrollments.workflow_state != 'deleted'
and (canvas.submissions.workflow_state = 'submitted' or canvas.submissions.workflow_state = 'graded')