If you're looking to pull quiz answers for multiple courses at once, Bridge makes this process simple with the "Download All Data" feature. This tool allows you to quickly and efficiently access quiz responses in bulk, saving you time and effort. In this article, we'll walk you through the steps to retrieve the quiz data you need, streamlining your course management tasks.
To get started, go to "Admin" and select "Tools", then click on "Download All Data".
Next, select the following reports:
- question_responses.csv
- attempts.csv
- enrollments.csv
- course_templates.csv
- slides.csv (optional)
- users.csv
After selecting the reports, click "Generate Report". Once the report is ready, you'll be able to click "Download" to access the files.
Now that you have the CSV files, select the columns listed below from each file. Then, combine them in a tool like Excel or Google Sheets to compile your report.
question_responses.csv
- Column B == Slide ID this can be x-reffed with slides.csv (optional)
- Column F == Attempt ID this will be x-reffed with the attempts.csv
- Column G == Answer selected by the user (will indicate a # that was selected for the answer)
- Column H == The question and answer text (will also provide the number by each answer so you can identify what the learner selected)
attempts.csv
- Column H will be used to identify the enrollment_id for the user, use column F from the question_responses.csv
enrollments.csv
- Column A here will be the one to use to pull the user_id and course_id
- Column B == User ID will be x-reffed with the users.csv to get the users name
- Column I == Course ID which can be used to identify the course using the course_templates.csv
course_templates.csv
- Column A == Course ID will be the same ID as Column I in the enrollments.csv to match the course to the enrollment
slides.csv (optional)
- Column A == the slide's ID this can be used with Column B from the question_responses.csv to identify the course
- Column B == The course id which you'd x-ref with course_templates column A
users.csv
- Column A == Users (Bridge) ID, will be used with Column B from the enrollments.csv to get the users name or login id (however they want to identify users
If you have questions or need further assistance in setting up groups within your account, please don’t hesitate to reach out to our support team.