Is there a way to export all the attempt a student makes on a graded assignment, in an export?

[DaveMock]

In a Learning Outcome Assessment we are conducting, we are hoping to see the progression of scores as a student retakes a quiz, until the get a passing score. Like did they pass in 1, 2, 3, 4, etc attempts, and what were those scores. The grade export looks like it only shows the one highest score.

[james_whalley]

@DaveMock If you take a look at the Gradebook History, you should be able to filter to see the multiple attempts on any given quiz for each student. You could possibly copy and paste the whole history to a spreadsheet to manipulate it further for comparison.

[paul_fynn]

Hi @DaveMock Useful thoughts from @james_whalley 

As a different approach you can associate Quiz Outcomes with Account/Sub Account Mastery Outcomes (not Mastery Paths) https://community.canvaslms.com/t5/Canvas-Basics-Guide/What-are-Outcomes/ta-p/75 

These need to be built t sub-account level then associated with one or more assignments or quizzes, and the Mastery Outcomes can be part of the grading or tracked separately without contributing to the grade.

Each time the student achieves an outcome this will be tracked at Quiz, module and sub-account level, including a time stamp. and a parallel central log which can be accessd via the account/sub-account Outcomes Report

Outcome ResultsClose

This report shows the learning outcome results for all students. The resulting csv file will have one row per user-outcome-result pair, and will show the details of the result including the associated assignment.

Example

student name	student id	student sis id	assessment title	assessment id	assessment type	submission date	submission score	learning outcome name	learning outcome id	attempt	outcome score	assessment question	assessment question id	course name	course id	course sis id	section name	section id	section SIS ID	assignment URL	learning outcome friendly name	learning outcome points possible	learning outcome mastery score	learning outcome mastered	learning outcome rating	learning outcome rating points	account ID	account name	enrolment state
smith, heather	423945	u16450	Assignment 1	3217	assignment	01 Apr 2011 18:16:12 UTC	85	Can write basic Ruby	1	1	4			computer science 101	46489	c500190	Section 1	332992	sec001	https://example.com/courses/46489/assignments/3217	Ruby 1A	5	3	1	Needs Improvement	1.0	992	Example Account	active

In this case I might think about setting a set of outcomes corresponding to defined grade scores.