See here how to create a Survey, assign it in your content, and export your survey answers from the Dashboard.
You can export your quiz results in multiple ways:
Quizzes can be exported in two versions. Examples are provided below.
All answers a user submits to all questions in a quiz are stored in a singular row. So for a single quiz with 5 questions required, there should be a maximum of 1 row of data per user.
NB: For checkbox and sequence question types, the user’s responses are stored as a stringified array. For example [”option 1”, “option 2”]
| Full Name | API Token | Phone Number | Date Taken (DD-MM-YYYY hh:mm:ss) | What is the name of Ghana’s national football team? | What are your favourite colours (select all that apply)? | |
|---|---|---|---|---|---|---|
| John Doe | j0hnd0e | +00112233445566 | [email protected] | 07-06-2023 21:29:00 | Black Stars | [”Red”] |
| Jane Doe | j4n3d0e | +998877665544 | [email protected] | 07-06-2023 21:29:00 | Black Starlets | [”Red”, “Gold”, “Green”] |
Each answer a user submits per question is stored as a new row. So for a single quiz with 5 questions required, there should be a minimum of 5 rows of data per user.
NB: For sequence question type, the user’s responses are stored as a stringified array. For example [”option 1”, “option 2”]
| user id | full name | question | type | answer | date taken |
|---|---|---|---|---|---|
| 1 | John Doe | What is the name of Ghana's national football team? | short_exact | Black Stars | 2023-06-07 21:29:00 |
| 1 | John Doe | What are your favourite colours (select all that apply)? | checkbox | Red | 2023-06-07 21:29:00 |
| 2 | Jane Doe | What is the name of Ghana's national football team? | short_exact | Black Starlets | 2023-06-07 21:29:00 |
| 2 | Jane Doe | What are your favourite colours (select all that apply)? | checkbox | Red | 2023-06-07 21:29:00 |
| 2 | Jane Doe | What are your favourite colours (select all that apply)? | checkbox | Gold | 2023-06-07 21:29:00 |
| 2 | Jane Doe | What are your favourite colours (select all that apply)? | checkbox | Green | 2023-06-07 21:29:00 |