My university is trying to collect data on specific outcomes from exams used in multiple courses. We are trying to utilize the Tagging feature to tag questions with a specific words and phrases. We want a report to be able to look at (or be able to sort from all the courses in a category) what tags are used in quizzes, we want to know how many students attempted, and we want to know the number of students who answered correctly and incorrectly and report that as a percentage if possible. We also want to know if there is a way to declare a set of tags to look at. This would maybe be hard-coded into the report this way the report would only look at this certain set of tags for the given set of courses.
We have used this forum post as a starting point, https://moodle.org/mod/forum/discuss.php?d=324314#p1346542
Any help on how to write this report in SQL using the configurable reports block would be so helpful. Eventually we want to be able to run a report that looks at each individual student in the course also and see how well they performed on the tagged questions. I know there is a plug in that does that, and we have used that also which helps us.