Viewing the Percentage of Learners Who Chose Each Exam Answer Option

You may want to see how often learners choose each answer option for a question in an exam, for example to find out which options are picked most often. Report Builder does not currently include a built-in report that shows the percentage of learners who chose each answer option for each exam question.

The Exams Count Per Question Report is the closest built-in option, but it shows only how many times a question was answered correctly or incorrectly, not a breakdown by answer option. You can still get this view by exporting learner responses from Report Builder and calculating the percentages in Excel.

Exporting Learner Responses from Report Builder

1. Run an exams report

In the left navigation, make sure you are in the Team Workspace. Then select Reporting and select Report Builder.

In Report Builder, run the Exams Best Attempts Report or the Exams All Attempts Report, filtered to your exam (and to the course, if needed). Both reports are broken down by question and include each learner's response and whether it was correct.

Choose the report based on the attempts you want to count. The Exams Best Attempts Report counts one attempt per learner, so the percentages reflect each learner's strongest result. The Exams All Attempts Report counts every attempt, but only for each learner's current enrollment.

2. Export the report to Excel

Make sure the report includes the exam, the question, and the learner's response. Then export the report to Excel (CSV).

Calculating the Percentages in Excel

3. Prepare the data

Keep one row per learner per question, and filter the data to a single exam.

4. Insert a PivotTable

Insert a PivotTable and set it up as follows:

  • Rows: question, then response.
  • Values: count of response. Then right-click the value, select Show Values As, and choose % of Parent Row Total (set on the Response field).

Each question's answer options then add up to 100%, so you can see the share of learners who chose each option. Optionally, add the question as a slicer or filter to switch between questions, and add a bar chart for each one.

Using a Formula Instead of a PivotTable

If you do not have PivotTables available, use this formula for each answer option: =COUNTIFS(QuestionColumn, "Question text", ResponseColumn, "Answer text") / COUNTIFS(QuestionColumn, "Question text")

Related Articles

Summary

Exporting learner responses from Report Builder and using a PivotTable or formula in Excel gives you the percentage of learners who chose each answer option, until a built-in report is available. If you would like to see this as a built-in report, ask your Customer Success Manager to submit it as an idea.

Was this article helpful?
0 out of 0 found this helpful