DR. JENNIFER LYNN WAGNER

Brightspace by D2L Tips: Download/Export Quiz Questions

Downloading or exporting quiz questions from within D2L to CSV or Excel formats is possible as long as the questions have been added to a quiz and at least one attempt exists for the quiz. If using question pools, all pool questions will be included even if no students were given a certain pool question.

It is currently not possible to download all questions directly from the Question Library in D2L. Questions must be added to quizzes in order to be downloaded, including via the Brightspace data sets. It is also currently not possible to generate a print version of a quiz for in person courses. Previewing the quiz and printing to PDF or copying and pasting into Word are possible; however, copying and pasting plain text will provide more flexibility when creating print versions. (Alternatively, if a quiz already exists as a Word doc, try using Respondus 4.0 to import the questions into D2L.)

Download Quiz Questions and Possible Answers in D2L

Statistics is the quickest option for downloading quiz questions.

  1. Go to the Quizzes tool and click the down arrow next to the name of the quiz.
  2. Choose Statistics and go to the Question Details tab.
  3. Click either Export to CSV or Export to Excel to download the file.

Setting up a report is another option for downloading quiz questions.

  1. Go to the Quizzes tool and click the down arrow next to the name of the quiz.
  2. Choose Setup Reports and Add Report.
  3. Enter a name for the report.
  4. Click the Question Details radio button and check any desired options, such as Include text responses.
  5. Under Release Report To, check the box next to your role.
  6. Click Save, then Save and Close. This will take you back to the Manage Quizzes tab.
  7. Click the down arrow next to the name of the quiz again, and choose View Reports.
  8. Click on the name of the report.
  9. Enter From and To dates, if desired, and click Generate CSV or Generate Excel.

Download Quiz Questions and Student Responses in D2L

  1. Go to the Quizzes tool and click the down arrow next to the name of the quiz.
  2. Choose Setup Reports and Add Report.
  3. Enter a name for the report.
  4. Click the Attempt Details radio button and check any desired options, such as Display attempt duration.
  5. Under Release Report To, check the box next to your role.
  6. Click Save, then Save and Close. This will take you back to the Manage Quizzes tab.
  7. Click the down arrow next to the name of the quiz again, and choose View Reports.
  8. Click on the name of the report.
  9. Enter From and To dates, if desired, and click Generate CSV or Generate Excel.

Query Brightspace Data Sets

If you or a colleague have access to the data sets via Insights Report Builder, these ETL workflows will allow you to download questions, possible answers, and/or student responses on a per quiz or per course basis. Quiz questions and possible answers can be exported this way without the need for an attempt on the quiz.