I am working on a method for doing some data tracking of quiz results based on educational standards. My goal is to tie specific test questions to an educational standard. Since Moodle currently doesn't allow you to use outcomes in quiz questions, I am looking into using the quiz question tag to facilitate this. My question is how can I generate a report to tell me the pass/fail percentage of questions based on question tags. I am using Moodle 2.9.2 currently.
There is no way to do that in Moodle.
I suggest you download the results from the 'Grades' report in the quiz, and analyse it offline.
I too was hoping to be able to sort statistics by using the tags. Is there anything in the works?
David, have you considered coding the standards in to the question name? I couldn't quite tell if you were more looking for a solution focused on the questions or the students, but if it is success of the questions you could work in a code in the question name and then use Quiz/Results/Statistics to export to Excel then sort by name and then see the statistics of how well the students as a whole have done on those questions within a quiz. It wouldn't be as efficient as a tool built specifically to track standards. but it may do for now.
Looks like the feature you want is in tracker here: MDL-21977
It might also be the new competency based education in Moodle 3.1, but I am unsure exactly.
Hi Mike,
I've been playing with the new competency based education (CBE) stuff in a Moodle 3.1 Beta site for the past few days. While the new CBE stuff has lots of capability/potential, it is not to the point of being able to link competencies to an individual question...only to the quiz as a whole. You can link multiple course competencies to a quiz.
Tammy's suggestion of 'coding the standards in to the question name' and analyzing in the quiz attempts page or downloading to a spreadsheet is still the only practical way of tracking how well students have done with those questions within a quiz.
It is possible to create a report on questions which are tagged within a course/quiz using configurable reports block. I put together an SQL query that calculates subgrades for tags in the each of the quizzes in the course. There are however a number of different ways that one could aggregate the data beside the way that I have done. Here is the query I am using:
SELECT
quiz.name AS quiz,
t.rawname AS tag,
CONCAT('<a target="_new" href="%%WWWROOT%%/mod/quiz/review.php?attempt=',
MAX(quiza.id),'">',u.firstname,' ',u.lastname,'</a>') AS student,
CAST(SUM(qas.fraction) as decimal(12,1)) AS correct,
CAST(SUM(qa.maxmark) as decimal(12,1)) AS maximum,
CAST(SUM(qas.fraction)/SUM(qa.maxmark)*100 as decimal(4,2)) AS score
FROM prefix_quiz_attempts quiza
JOIN prefix_user u ON quiza.userid = u.id
JOIN prefix_question_usages qu ON qu.id = quiza.uniqueid
JOIN prefix_question_attempts qa ON qa.questionusageid = qu.id
JOIN prefix_quiz quiz ON quiz.id = quiza.quiz
JOIN prefix_tag_instance ti ON qa.questionid = ti.itemid
JOIN prefix_tag t ON t.id = ti.tagid
JOIN (SELECT MAX(fraction) AS fraction, questionattemptid
FROM prefix_question_attempt_steps
GROUP BY questionattemptid) qas ON qas.questionattemptid = qa.id
WHERE quiz.course = %%COURSEID%%
GROUP BY quiza.userid,
quiza.quiz,
quiz.name,
u.firstname,
u.lastname,
ti.tagid,
t.rawname
ORDER BY quiza.quiz, t.rawname, u.lastname, u.firstname, score