Record if quiz was passed and email address of user

Chris Jarvis
Chris Jarvis
  • Chris Jarvis
  • 10 months ago

Hello

I had 2 requests please.

Would it be possible to show the quiz cutoff score & overall score of each quiz in the quiz_responses table please and also on the responses page in the admin area of the website?

The reasons for this is so you can easily tell by looking if a user has passed a quiz or not. At the moment it shows me their score but if we have a few quizzes, I can't remember the cutoff score for each quiz and can't tell if they have passed it or not.

I also import the  table quiz_responses into our office database to automatically update their progress with us. Some way of marking or knowing if that quiz was passed would be really good please.

If I can see the cutoff score for the quiz against the user's score I could work that out but it would be even better if we had something like a passed column in their (similar to completed) that is say 0 for failed and -1 for passed or the other way around.

I have found the state column but can't work out what that flags or tells me.

It would be amazing if in the website admin area I could easily see if people had passed the quiz or not from all the responses AND also if the responses table could show a pass/fail result flag somehow too.

Secondly, I wondered if it was possible to stamp the email address against the responses in a similar way that the Joomla User ID is recorded as the 'created_by' column in the quiz_responses table. To match up each user to their quiz responses I don't want to have to match against the Joomla User ID as we have over 35,000 users in our website. I would also need to import the Joomla Users table to get the quiz results for only a few students each time.

If I could just use the quiz_response table and match on email address that would be a lot smaller table to download as not all of our users ever take the quizzes.

Please let me know if I am making sense and sorry if I am asking for things off topic of the extension. The quizzes are so good and helpful to our office that these additions would be superb though.

Thanks as always for the time taken to read my enquiry.

 

Chris


Access to viewing replies is restricted.
Showing 11 of 11 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai