Please can anyone help me with a problem I'm having with pointers for a report I'm writing for the results of Moodle quizzes. The report is expected to show the following information:
- Questions answered correctly
- Marks for partially correct answers
- Total score achieved
I've looked through Moodle's database, but I've been unable to find the tables that contain the data required to show that information, i.e. data about a user's attempts, correct and incorrect answers, etc.?
Is anybody able to tell me whether the data I'm looking for even exists or can be derived from the database, and if I need to derive it, how to link the data in the different tables? Any hints or pointers appreciated.
Thanks,
Muyi