Hi Theresa,
there is nothing simple that can be done at the moment, I'm afraid.
I see what you mean about the colors being lost when the data is exported into Excel.
When you looking at the "Detailed statistics" report for a HotPot, the number of tries at each question is the last of the three numbers in the green brackets. It would be difficult for you to extract in Excel, but the information is there.
This report also shows you the "the response each student provided to each question". What's more it shows you the wrong answers and the correct answers. However because there are several answers in one cell, it is difficult to extract this information in Excel.
On the whole then, I think this report already has the information you want, but the information is not easily accessible to Excel because one cell contains several pieces of information.
I am just working on the reports for the next version of the HotPot module, so I will try to ensure that the Excel downloads are more granular.
many thanks
Gordon
Hotpot (plugin)
question about HotPot quiz results summarization
This discussion has been locked so you can no longer reply to it.