Find all attempts for specif question in DB or Moodle Admin?

Find all attempts for specif question in DB or Moodle Admin?

by Mohammad Awni -
Number of replies: 3

I had a wrong question in my question bank for a specific course, can I find all users who attempted this question and add 1 Mark for all of them, using Moodle admin, or using Database


Moodle version: 3.6.1+ 20181214


Thanks in Advance for your help

Average of ratings: -
In reply to Mohammad Awni

Re: Find all attempts for specif question in DB or Moodle Admin?

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Awarding 1 mark for the question is possible, but not easy.

An alternative that is worth considering is changing the weight for the question to 0. If you so this, Moodle will re-scale the grade earned on the other questions. (Effectively, it replaced the mark for the bad question with the average mark on the other questions.) You make this change on the Quiz settings -> Edit quiz page.

If you want to change the mark for that question to 1 for all students, the safest way to do that is to go to Quiz settings -> Results -> Manual grading page. You will need to use the 'Also show questions that have been graded automatically' option, then you can change all the grades.

Average of ratings: Useful (1)
In reply to Tim Hunt

Re: Find all attempts for specif question in DB or Moodle Admin?

by Mohammad Awni -
Thanks Tim, really appreciate your time, the problem is the quiz is made of Random questions from question bank, so its is not possible to set mark for this specific question, and if we managed to find a way, lets say set the grade to be 0.3339, it will be set for people who answered it correctly, not for those who answered wrong.
In reply to Mohammad Awni

Re: Find all attempts for specif question in DB or Moodle Admin?

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
How many attempts do you have? Is it a manageable number to fix manually?

If it is, go to Quiz settings -> Results -> Responses. Turn on the option to show question text. Then sort by the question text of the problem question, which will group all the people who got the bad question together. Then, one at a time, you can review them, and override the grade.

MDL-49626 would be a nice improvement to help in this situation.