Export response history

Export response history

Przemek Kaszubski írta időpontban
Válaszok szám: 9
Kép Kép

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

Értékelések átlaga: -
Válasz erre: Przemek Kaszubski

Re: Export response history

Tim Hunt írta időpontban
Kép Kép Kép Kép Kép
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.
Értékelések átlaga: -
Válasz erre: Tim Hunt

Re: Export response history

Przemek Kaszubski írta időpontban
Kép Kép

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

2020-05-14 , 01_11_07 - Identify WA Stylesheet reference types - Mozilla Firefox.png csatolmány
Értékelések átlaga: -
Válasz erre: Przemek Kaszubski

Re: Export response history

Tim Hunt írta időpontban
Kép Kép Kép Kép Kép
Then you probably need to go direct to the DB.
Értékelések átlaga: -
Válasz erre: Tim Hunt

Re: Export response history

Przemek Kaszubski írta időpontban
Kép Kép
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.
Értékelések átlaga: -
Válasz erre: Przemek Kaszubski

Re: Export response history

shpetim aliaj írta időpontban
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
Értékelések átlaga: -
Válasz erre: shpetim aliaj

Re: Export response history

Przemek Kaszubski írta időpontban
Kép Kép
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.
2020-11-11 , 14_08_12 - Identify WA Stylesheet reference types - Mozilla Firefox.png csatolmány
Értékelések átlaga:Useful (1)
Válasz erre: Przemek Kaszubski

Re: Export response history

shpetim aliaj írta időpontban
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
Értékelések átlaga: -
Válasz erre: shpetim aliaj

Re: Export response history

Przemek Kaszubski írta időpontban
Kép Kép
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..
Értékelések átlaga: -