Export response history

Export response history

Przemek Kaszubski གིས-
Number of replies: 9
Particularly helpful Moodlers གི་པར Testers གི་པར

Hello,

Is there a way to save / export (into Excel, csv etc) the response history for a given use and quiz question, or ideally all the questions in the user's quiz attempt - in a single swoop?

I have not been able to find anything suitable, and we need to track the timing of responses for a study we're conducting.

Any help highly appreciated.

At the moment we have Moodle 3.6.5 and the custom_sql plugin installed if this could help with constructing a custom query...

Many thanks for any help.

Przemek Kaszubski

དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Przemek Kaszubski

Re: Export response history

Tim Hunt གིས-
Core developers གི་པར Documentation writers གི་པར Particularly helpful Moodlers གི་པར Peer reviewers གི་པར Plugin developers གི་པར
Quiz settings -> Resulst -> Responses report will let you download all the answers the student input that were acutally submitted for grading (e.g. with Interactive of Adaptive behaviour). Use the All tries option.
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Tim Hunt

Re: Export response history

Przemek Kaszubski གིས-
Particularly helpful Moodlers གི་པར Testers གི་པར

Thank you, Tim. However, the available export function gives me the time and duration of each complete quiz attempt in toto, and not the times of individual answers saved and submitted per attempt.

I attach a screenshot from a Response review for an individual question. (The same show when reviewing a complete attempt, with all the questions listed on one page and response histories attached underneath the scores.)\

I would like to be able to extract those times (which I plan to display more precisely with seconds after tweaking the time string displaying there).

Many thanks.

Przemek

Attachment 2020-05-14 , 01_11_07 - Identify WA Stylesheet reference types - Mozilla Firefox.png
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Przemek Kaszubski

Re: Export response history

Tim Hunt གིས-
Core developers གི་པར Documentation writers གི་པར Particularly helpful Moodlers གི་པར Peer reviewers གི་པར Plugin developers གི་པར
Then you probably need to go direct to the DB.
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Tim Hunt

Re: Export response history

Przemek Kaszubski གིས-
Particularly helpful Moodlers གི་པར Testers གི་པར
Not being a coder, I was wondering if you, or anyone, could suggest a query that might work - as a starting point ... ? Just to be sure that I'm joining the right tables etc.

I could then work it further and implement a custom_sql plugin report.
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to Przemek Kaszubski

Re: Export response history

Tim Hunt གིས-
Core developers གི་པར Documentation writers གི་པར Particularly helpful Moodlers གི་པར Peer reviewers གི་པར Plugin developers གི་པར
Sorry. My previous post was meant to have this link copied and pasted into it!

https://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine#Detailed_data_about_an_attempt
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།:Useful (1)
In reply to Przemek Kaszubski

Re: Export response history

shpetim aliaj གིས-
HI Przemek,

I am trying to get a plugin to display the data regarding the quiz as the pic you attached. Please can you share the name of the plugin you used?

regards,
Shpetim Aliaj
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to shpetim aliaj

Re: Export response history

Przemek Kaszubski གིས-
Particularly helpful Moodlers གི་པར Testers གི་པར
Hmm, that was not really a plugin, but a response review link in quiz results. "Response review for an individual question".
In the quiz clikc on "Responses", then on a given question response link in a student's attempt. Cf. the attachment.
Regards.
Attachment 2020-11-11 , 14_08_12 - Identify WA Stylesheet reference types - Mozilla Firefox.png
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།:Useful (1)
In reply to Przemek Kaszubski

Re: Export response history

shpetim aliaj གིས-
Hi Przemek,

The issue i am having is that some students don't get the results show on the quiz results. The teacher says that he/she has seen- and graded it but it is not on the grades or results. We turned autosave on but still i am having a hard time pinpointing the issue that does not happen for all students so that why i wanted the results to have the timestamp like in you picture.

regards,
Shpetim Aliaj
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -
In reply to shpetim aliaj

Re: Export response history

Przemek Kaszubski གིས-
Particularly helpful Moodlers གི་པར Testers གི་པར
Could these be unfinished attempts?

Perhaps in the quiz settings the option for "When time expires" is / was not set to "Open attempts are submitted automatically" (an option I recommend and a current default in Moodle, ASAIK), or else that the students did not submit their attempts manually if there was no timer set.

If such is the case, the students would need to enter the quiz and submit their attempts. I know of no workaround for this. If you're an admin, perhaps you can "login as" each of these students one by one and submit the quiz attempt. However, I think the students should be warned that this will happen. Plus I am not exactly sure this will work - to be tested..

I am guessing somewhat..
དཔྱ་སྙོམས་ཀྱི་སྐུགས་ཚུ།: -