Quiz submissions API for completed enrollments

[tony_ganly]

Hello,

This is my first question, and as far as I can tell, it has not already been answered.  Is there any way to get the quiz submissions for students with enrollment status of "Completed"? The Quiz Submissions API (Get all quiz submissions) seems to return only submissions for active enrollments, and there is no optional request parameter (such as the state[] parameter in the Enrollments API) to include students with enrollment state of Completed. I am using API call /api/v1/courses/:course_id/quizzes/:quiz_id/submissions from a PHP script. Thanks in advance for any feedback.

[lalevesque]

Tony,

This is a great question, and something I wish was getting a little bit more attention.

I wrote a python script to initiate a quiz report generation, then download the responses and parse them out. Everything seemed well until I realized it does not include submissions from students that have completed the course.

I submitted a ticket to instructure and was told that this is impossible at this time. Feature request it is!

[kona]

Hmm... I'm not the expert on this, but I know we generate a submission report for our students that Financial Aid uses when compiling their needed documentation. And yes, I'm pretty sure this has to be for completed students as well because the students are "dropped" from the course (no longer show up as enrolled in the course), but somehow the report is still able to generate submission history (for all assignments, discussions, quizzes) from their previously enrolled course(s).

 @James ​ is the expert on that and wrote all the technical stuff the following blog on how we do this - Assignment Submissions Report Programming.

Hope this helps!

[James]

 @kona ​,

We don't actually grab quiz submissions. We grab assignment submissions instead. It has the date, which is what we need for financial aid, but it doesn't have the responses to the individual questions.

Has anyone looked at Canvas Data to obtain this information? It should include quiz information for concluded enrollments.

Strangely though, I did just look at that API call over the weekend when I wrote a script to add the question name to the question number, but I was using it within SpeedGrader / Quiz Moderation, so it was only for enrolled students and I didn't look into concluded enrollments.

[lalevesque]

 @James ​

I have looked at Canvas Data regarding this and we are currently pressing them for a solution. We are really after the essay submission details from our end of course surveys so we can quickly aggregate what students are saying about their courses. The API will list the multiple choice/true or false selection, but essay response data is not in in either the API response or Canvas Data.

At this point, to capture essay responses I'm generating the quiz report CSV for multiple courses, reading it with python, then outputting them to another file. This works well, assuming the student's enrollment hasn't been concluded.

[James]

I dug a little deeper, but have class in a couple of minutes, so won't be able to go farther.

Our financial aid script is pulling up the proper dates - even for concluded students. It uses a combination of student activity (analytics) and listing multiple submissions for a student.

Currently, the list multiple submissions (or even list a single submission) is turning up like the completed student never took it, but I'm getting a date from somewhere.  I'm definitely starting to feel your frustration.

Quiz results for concluded students should not completely disappear once they're completed.  @kona ​ can confirm or correct, but I think we've gone into test or beta, re-added them there, and then obtained the results. By going into test or beta, they don't get the messages about being re-added to the course.

[kona]

Yes,  @James ​ is correct that in the past (and even today) we've gone into Test or Beta and re-added the student (even to last semester classes) and they don't get any type of notification about being added to the class or the class being open.