Include a quiz score in the downloaded report

Brian Dyer

The downloaded report shows the total # of questions and how many were answered correctly but it doesn't show a score percentage like the one shown when you look at the Quiz Results tab of a session. Including the score in a downloaded report may be helpful for some instructors.

Brianna Parker

Hey, Brian!

I love this idea and have filed it with our team for review.

In the meantime, a bit of Excel magic can make this report show the percentage:

1. In the next column at the end of the report, use the "PERCENTOF" function to tally the percent of the "Questions" and "Correct Answers" column.
   1. You'll put in the cell number of "Correct Answers" (by default, K2) in the first text box, and then "Answers" (by default, J2) in the second text box.
   2. You can also do this by typing into the cell: =PERCENTOF(K2,J2)
2. Click save.
3. Next, right-click on the newly created cell, click on "Format cells", and then choose "Percentage" from the Category: Number tab.
4. You can apply this format and formula to all other rows by clicking on the cell again and then dragging it down to the end of your results.

Here's a screenshot with an example of how this should look:

While we're not able to provide support for Excel specifically, I hope this workaround is helpful until any potential changes are implemented in Panopto.

Thanks again for the great suggestion!