Getting Quiz Statistics

Getting Quiz Statistics

by Mark Fellowes -
Number of replies: 8
Hi Team.
I am able to create a matrix (as shown below). Top header shows Overall score (Grade), followed by each question. The rows below note how many students received that Grade and score per question.

Ie. 483 students had a 0 out of 20 overall score. Question 6 was a score out of 3 which 3050 students received 3 out of 3.

What I am trying to analyse is for each question, what option did the student select. Ie for Question 6, there were 3 possible answers. I need to get statistics on the "actual" answer the student selected. Was it A, B or C.

If someone can advise the table then I can create a query (SQL) to run against the table.

The result is not individual specific, but for all results. We are wanting to identify if the course needs to be changed to give more information so the student is comfortable getting the correct answer.


The below image is showing overall scores, and scores per question
Average of ratings: -
In reply to Mark Fellowes

Re: Getting Quiz Statistics

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
You are looking at the grades report in in that screen grab. If you want to see the responses, try the Responses report. Here is an example on the Moodle demo site.
Average of ratings: -
In reply to Tim Hunt

Re: Getting Quiz Statistics

by Mark Fellowes -
Hi Tim,

I did as per your suggestion and the report works fine if I leave the report as Grades. If I change it to "Responses" I get the following error even before clicking show report.

Exception - Access to undeclared static property: question_state::$

Steps taken

1. Click on the course in question
2. Expand the left hand panel to display the content / index of the course
3. Select the quiz
4. Click on “Results”
5. Change “Grades” drop down to “Responses”
6. Change “Attempts that are” to only “Finished”
7. Select “Show Report”


Any Suggestions.

Moodle 4.1.2+ (Build: 20230324)
Php 7.4.33
MySql 5.7.42

With developer debugging on.



Average of ratings: -
In reply to Mark Fellowes

Re: Getting Quiz Statistics

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
That is a bug.

However, I don't know what would cause it. I have not seen it before. There seems to be some missing data, but I don't see how that could be. How many attempts are there at this quiz? Is it feasible to review them all, and check that the review pages all display without error?
Average of ratings: -
In reply to Tim Hunt

Re: Getting Quiz Statistics

by Mark Fellowes -
Thanks for the info Tim.

The issue has been fixed which I will put into the question I raised for all to see.
Average of ratings: -
In reply to Mark Fellowes

Re: Getting Quiz Statistics

by Mark Fellowes -
All...
We have fixed the issue causing the above error.

As we use the Edwiser Remui Theme. This has a bug we found that causes two issues (Reported back to their tech support and they are working on optimizing the course stats feature) .

1. Using the theme and logging in as an Administrator the site becomes very slow editing anything, and navigating.
2. Response Report getting the "Undeclared variable"

As we have 9000+ students enrolled into most of our courses, this is simply blowing out the query return. So we simply disabled the course stats feature. Site Administration > Appearance > Themes > Edwiser RemUI > Course Page > EnableCourse Stats.

Now the site is incredibly quick, and we can get all reports (Grades, Responses etc).
Average of ratings:Useful (1)
In reply to Mark Fellowes

Re: Getting Quiz Statistics

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Thank for for letting us know what the problem was.
Average of ratings: -