I have several Hot Potatoes quizzes in my Moodle site and nearly 1,000 students have completed them. I have several ways I’d like to analyze the data. For one, I would like to be able to analyze the number of “tries” it took each student to get the correct answer for each question. I can access the type of information I would like by generating the “Detailed Statistics” report – the different colors for correct, incorrect, and ignored answers is perfect. However, this information is lost when I export the data to Excel or Text file format – suddenly, I can’t tell which letters should be which colors, and therefore which categories they should fall into. I have brought the data into Excel and Access and tried to manipulate it but it is a bit of a headache with so many students and so many combinations of right, wrong, and ignored answers!
Ideally, what I’d love to be able to access would be something similar to what the “Detailed Responses” plug-in can generate for standard Moodle quizzes, where I can view the response each student provided to each question. Also ideally, I’d be able to see how many tries it took per question per quiz. Is this possible to access?Thanks very much for any insights you can offer!!