Quizzes – View Quiz Statistics

Select Activities > Quizzes > Statistics

Select the Quiz from the list > On the View Statistics page, click the User Stats, Question Stats, and Question Details tabs to view statistics broken down by user and by question. Select Export to CSV or Export to Excel if you want to save the quiz’s statistics to your computer.

Note: The system exports the statistics only from the tab you are currently viewing.

User Stats CSV and Excel files contain performance data by user, including the user’s Org Defined ID, username, first name, last name, quiz score, the value the quiz was graded out of, the user’s score as a percentage, and the class average.

Tip: You can create a column to calculate the median score on the quiz to consider the class’s performance from a different perspective. Use the formula <=median(x1:x5)> to calculate the median.

Question Stats CSV and Excel files contain data about the average score on questions by points and percentage.

The question title, text, bonus status, and difficulty level are included in the files so that data can be analyzed without referring back to the learning management system.

Tip: You can sort, query, hide, and delete data to help your analysis and create charts or graphs to visually represent trends.

Question Details CSV and Excel files contain detailed information about each question in the quiz, including a list of all of the answers provided for each quiz attempt, how many users chose each possible answer, the total number of responses, and the average score on the question. Question Details reports can help you evaluate trends in answers and look for questions that were unclear or difficult for a number of users.

The question title, text, bonus status, and difficulty level are included in the CSV file so that data can be analyzed without referring back to the learning management system.

Tip: You can create a column that calculates the average score for all question attempts as a percentage by dividing the Average Score column by the Out Of column and multiplying by 100. Next, create a custom filter for the new Attempt Average column that displays only rows where the attempt average is less than 51%. This way you can quickly review questions that users struggle with and adjust grades or your lesson plans accordingly.