View source for Download Tests and Quizzes submissions for grading offline

You can download assessment responses for grading offline, including bulk downloading submissions to a [[Create a file upload question on a test or quiz|File Upload]] question so you can easily access them from a single folder on your computer.
For more information on entering assessment grades and comments, see the following articles:
*[[Grade tests and quizzes]].
*[[Give zeros to all students with no submission for an assessment]].
*[[Grade assessment submissions by student]].
*[[Grade assessment submissions by question]].

==Go to Tests & Quizzes.==
[[File:Test and quizzes.png|frame|center]]
Select the '''Tests & Quizzes''' tool from the Tool Menu in your site.

==Select the Published-All View.==
[[File:Select the Published-All View.1.png|frame|center]]
Select the '''Published-All''' option in the View drop-down to view the assessments that have been released to students in your site.

==Go to the assessment submissions.==
[[File:Go to the assessment submissions.2.png|frame|center]]
Select the '''Scores''' option from the drop-down menu for the assessment you would like to grade.
Alternatively, you may click on the '''number of student submissions''' in the ''Submitted'' column to view the submissions.

==Export scores and students' responses as an Excel spreadsheet.==
You can export an Excel spreadsheet that contains all the students' responses and scores for an assessment, as well as any comments you entered for students on the Total Scores screen.
===Click Export.===
[[File:Click Export.1.png|frame|center]]

===On the following screen, click Export.===
[[File:On the following screen, click Export..png|frame|center]]
Click the second '''Export''' button on the screen to export the file.
Depending on your browser settings, you may be asked to save or open the file.  Once downloaded, you can open the file in a spreadsheet program, such as Excel.

===View spreadsheet.===
[[File:View spreadsheet..png|frame|center]]
The resulting spreadsheet lists the students' names, user names, number of the assessment submission (if multiple submissions were allowed), final scores, any ''Grader's comments'' you entered for students in the ''Total Scores'' screen, and the students' responses to each question.
''Note: Certain question types, such as File Upload questions and Audio Recording questions, which need to be graded within the Tests & Quizzes screen, will not be able to display answers in the spreadsheet.''

==Download all File Upload submissions.==
[[File:Download all File Upload submissions..png|frame|center]]
If your assessment has a [[Create a file upload question on a test or quiz|File Upload]] question, you can download all submissions to it simultaneously (e.g. to add inline comments, or for ease of reading certain types of files from your computer.)
Click on the '''Questions''' link in the assessment menu to access the list of questions.

===Select the File Upload question.===
[[File:Select the File Upload question..png|frame|center]]
From the list of question numbers, select the File Upload question.  Each question is listed as the letter '''Q''' with the question number (e.g. '''Q1, Q2''').

===Click Download Responses.===
[[File:Click Download Responses..png|frame|center]]

===Save and open the ZIP file.===
[[File:Save and open the ZIP file..png|frame|center]]
#Based on your internet browser settings, you may be prompted to save the file.  Save it to your local disk.
#Unzip the resulting zip file.  You can see all the students' submissions in one folder.  Each submission will be labeled with the student's name, followed by an underscore, then the student's user name, another underscore, and the file name.


{{Template:Tests and Quizzes}}
[[Category:Tests and Quizzes]]
[[Category:Instructor]]
[[Category:Sakai 19]]
{{Template:Sakai Community Documentation}}