Viewing Quiz results for lots of users?

Events happening in the community are now at Drupal community events on www.drupal.org.
joebanks's picture

Quiz by itself is great. And it would be even greater with some ability for Quiz admins to view lots of quiz results in an organized way.

Specifically, I need a view that will list all users who have begun a Quiz. Seeing the status/score in this view would be great.

Does anyone have a suggestion? I have searched for hours on this, with no luck. The documentation provides nothing on setting up views for Quiz admins (like teachers). Without this ability, how could you possibly run an LMS site?

Comments

The admin section allows you

Fohsap's picture

The admin section allows you to see scores. When you create a long- or short-answer question, you can email the result to yourself. And yes, you can see how many people took the quiz, how far each user got by using a hit counter module, like "Counter", or the built-in statistics for hit counting "Count Content Views"/"Display Content Views".
Yesterday, someone else suggested result_id in quiz_node_results table, using SQL.

Thanks, but...

joebanks's picture

Only the main admin user can view the results you are referring to.

For example, I can use Views to create a view of quiz results. But any view which contains multiple quiz results will be inaccessible to users other than the primary admin (user id == 1).

I have set all quiz permissions to 'allow', yet only the primary admin user can view the results you speak of. Is that a deliberate feature... or a bug in my site?

Grant view any quiz results

sivaji_ganesh_jojodae's picture

Grant view any quiz results permission to quiz authors, this will allow them to access result from page Quiz management > quiz reports > quiz results (admin/quiz/reports/results).

Thanks but it doesn't work

joebanks's picture

I have granted 'view any quiz results' permission for every role on my site, including anonymous users. Unfortunately, only the primary admin (user id == 1) can view quiz results outside of a user profile. This is not the behavior I would expect.

Can anyone reproduce this? Here are my steps:

Install and enable Quiz. Make a Quiz. Have at least 2 other users on the site take the Quiz.
Grant view any quiz results' permission for every role on your site, including anonymous.
Create a new View using the Views module.
Type: Quiz
Fields:
- Quiz Results: User
- Quiz Results: Quiz Start Time
- Quiz Results: Quiz State
- Quiz Results: Score
Filters and Arguments: (none needed for testing this)

Make a Page display, give it a path, and test it. You should see a table with user ids, quiz times and quiz scores. This is the expected result.

Log out. Try accessing the same View. You will see empty text, even though anonymous has permission to view all quiz results. This is not expected.

Log in as a user other than primary admin. Try the view again. You will see empty text, even though all users have permission to view all quiz results. This is not expected.

Is this a feature or a bug? ...And is it Quiz, or me?

Any advice would be greatly appreciated. Thank you!

Aha!

joebanks's picture

Thanks, sivaji. Your tip worked. Results are available at:

admin/quiz/reports/results/%
(% = some node)

This looks great. Thank you!

Quiz

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: