Introduction:
Brightspace allows a teacher to upload quiz questions using a CSV file. This may be especially helpful if a teacher has multiple course offerings that need the same questions. The steps to download the template are available at How to Create A Quiz. Through the template, you can add the following question types:
This document will help to explain each.
Details:
Written Response
The CSV set-up for written response looks as follows:
Tips:
NewQuestion - Use WR for all written response questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
InitialText - This allows you to add additional text/context to the question.
AnswerKey - Use to include the ideal response for the question.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
- Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
Short Answer
The CSV set-up for short answer looks as follows:
Tips:
NewQuestion - Use SA for all short answer response questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
InputBox - In the second column, enter the number of rows you want (e.g., 3) and in the third column, the number of characters you want per row (e.g., 40).
Answer - In the second column, put 100 (correct answer) and in the third column, enter the text that is the best answer for the question.
Answer - If you want to award partial credit for another response, indicate how much in column 2 (out of 100) and then the text of the acceptable answer.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
Matching
The CSV set-up for matching looks as follows:
Tips:
NewQuestion - Use M for all matching questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
Scoring - Equally Weighted
Choice - In the second column enter the choice number (e.g., 1). In the third column, enter the text for that choice.
Choice - In the second column enter the choice number (e.g., 2). In the third column, enter the text for that choice.
Choice - In the second column enter the choice number (e.g., 3). In the third column, enter the text for that choice.
Match - In the second column enter the choice number that you want to match with (e.g., 3). In the third column, enter the text for that match.
Match - In the second column enter the choice number that you want to match with (e.g., 1). In the third column, enter the text for that match.
Match - In the second column enter the choice number that you want to match with (e.g., 2). In the third column, enter the text for that match.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
Multiple Choice
The CSV set-up for multiple choice looks as follows:
Tips:
NewQuestion - Use MC for all multiple choice questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
Option - In the second column enter the percentage of points you want to award for the answer (e.g., 100). In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Option - In the second column enter the percentage of points you want to award for the answer (e.g., 0). In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Option - In the second column enter the percentage of points you want to award for the answer (e.g., 0). In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Option - In the second column enter the percentage of points you want to award for the answer (e.g., 25). In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
True / False
The CSV set-up for true / false looks as follows:
Tips:
NewQuestion - Use TF for all true / false questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
True - In the second column, enter 100. In the third column, enter the feedback the student would see if they pick “True.”
False - In the second column, enter 0. In the third column, enter the feedback the student would see if they pick “False.”
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
- Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
Multiselect
The CSV set-up for multiselect looks as follows:
Tips:
NewQuestion - Use MS for all multiselect questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
Scoring - Enter “RightAnswers” in the second column. This will appear in the interface as “Correct answers.”
Option - In the second column, put a 1 for a correct answer or a 0 for an incorrect answer. In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Option - In the second column, put a 1 for a correct answer or a 0 for an incorrect answer. In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Option - In the second column, put a 1 for a correct answer or a 0 for an incorrect answer. In the third column, enter the text for that choice. Skip the fourth column. In the fifth, enter any feedback you want to provide after the student responds.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.
Ordering
The CSV set-up for Ordering looks as follows:
Tips:
NewQuestion - Use O for all ordering questions.
ID - You can leave the second column blank and the system will auto-assign an ID to the question.
Title - Enter the text you want to display as the question name. It will also be used as the short description.
QuestionText - Enter the text you want the student to see.
Points - Enter the number of points the question is worth. Default Points
Difficulty - Enter a number between 1 and 5 with higher numbers being more difficult.
Scoring - Enter “RightMinusWrong” in the second column.
Image - Any image referenced assumes image is inside the /content/<course path>/ directory
If no image, leave blank
If using an image, only add the part of the address that comes after the directory above.
Item- In the second column, put the text for the item. In the third column, if you are entering only text in the second column, then put “NOT HTML.” If you put html code in the second column, then enter “HTML.” In the fourth, enter any feedback you want to provide after the student responds.
Item- In the second column, put the text for the item. In the third column, enter XYZ?. In the fourth, enter any feedback you want to provide after the student responds.
Hint - Leave blank if you do not want to provide a hint. Otherwise, include the text that you want to be displayed for the hint. Note, students will see the hint text as part of the question prompt and will have it available before selecting a response.
Feedback -Leave blank if you do not want to provide feedback. Otherwise, include the text that you want to be displayed for the feedback. Note, students will only see the feedback text after answering the question.