Download Assessment Results

Overview

The results of Assessments may be downloaded for statistical analysis. Analysis is done through another application, such as Microsoft Excel. Only the results of Multiple Choice and True/False questions are included in a results download because these questions have a limited set of defined answers. Other question types, such as essay or fill-in-blank, are not included.

The results download file is a comma-delimited (.CSV) file.

Download the results of an Assessment

Follow these steps to download results.

Click on a Gradebook Item from the Gradebook spreadsheet view.
Click Download Results from the Item Options page.
Select to download the results By User or By Question and User.
Click OK on the Download Results page.
The file download box will appear. Select a location and a name for the file.

Note: If the Assessment has over 40 questions select the option By Question and User. If the By User option is selected an error message may appear.

Note: The Instructor may notice that one or more attempts are missing in the download. This may occur because of a bad import, data corruption or similar incident. When this occurs, a warning will appear in the Administrator's log file stating "Gradebook grade entry found with no matching attempt. Possible database corruption. "

Analyze the data

Consider the following points when analyzing results:

Each row represents an assessment attempt. If a user attempts an assessment twice, only the most recent attempt will appear.
Questions and answers are reported in the order presented to the Student. If an assessment includes random questions than each line in the results will report questions in a different order (question 1 for one Student may be question 5 for another Student).
Survey results will not show user data for each attempt.
Results from a user with a course role of Instructor, Grader, or Teaching Assistant will not be reported.