I am unable to find where the responses of the students to the individual question in a quiz or SCROM is stored.
Will like to extract it to another tool using SQL for analysis.
For quizzes, it depends on your Moodle version. See either
http://docs.moodle.org/dev/Question_database_structure (1.9 and 2.0)
or
http://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine#Database_tables
Thanks again this has been helpful, especially for Moodle 2.1+
However the system we using is moodle 2.0 because our provider cannot update their php version to 5.3.
So I note in the 2.1+ we can get the user who attempts the question in the question engine at question_attempt_steps, however there seems to be no parallel relationship in 1.9 and 2.0. The only relation I see with the user table if for who created and modified the actual question.
Should I then assume that analysis on user-question attempts/responses is not possible for < 2.1
Thanks
Your assumption is wrong.
question_attempt_steps.userid is not (necessarily) the student who attempted the question. It is the user who did this action to the question. (Think about manual grading essays to see the difference.)
In both cases, the student who attempted the quiz is in the quiz_attempts.userid column.
Did you try running this DB query: http://docs.moodle.org/dev/Question_database_structure#Following_what_happens_when_questions_are_attempted
Much thanks for the help,
I was able to get the relationship I was looking for. The help is most appreciated.