I need to pull a report of all questions in all tests and pools in a class along with the answers that were given by students; more precisely, whether they were answered correctly or not. We would like to determine efficacy of the questions in the tests. Too many getting the question right, then it is too easy and too many missing it then it is too hard. What tables do I query in the DB to get that info? I haven't been able to decipher it in the DB schema documentation.
I am trying to query a self-hosted DB but Open Db info would be helpful, too.
Thanks in advance for any assistance.