Question Library CSV file generator (v. 1.2) - Instructions
This program allows you to easily create VU Collaborate-ready CSV (comma separated value) files from existing quiz or exam documents. Instead of using the time-consuming VU Collaborate question creation interface, you can copy your question & answer text directly from programs such as Microsoft Word, iWork Pages or any other word processing/text editing programs, perform some slight reformatting and simple markup addition, and then quickly import your questions & answers into a VU Collaborate Question Library.
Important note for Mac OS users: when text is copied directly from Microsoft Word in Mac OS, carriage returns or line breaks may not be correctly recognized within the generator’s text box. This will result in your pasted text being converted into one large Long Answer question. It is highly recommended that you first paste the text from Word into the TextEdit application (included with all Mac OS versions), and then copy all of the text again from TextEdit and paste into the generator text box. This will restore all of the line breaks that were present in the original Word document.
Basic information – formatting the text for import
The following formatting may be done to your quiz/exam text before or after it is pasted into the main text box of the generator.
Question text should begin with an identifier, typically a number or letter, followed by a period or right-parenthesis and one space.
i.e.: 1. Text for the first question
or: B) Another question
All possible answers should immediately follow the question, with each answer separated on a new line (using a return character or the enter key—see examples below). Do not use return characters except when you are proceeding to the next answer. This is especially important if you are copying questions from another program like Word.
Answers may start with a single identifier (a number or letter), followed by a period or parenthesis. i.e. 1. 9) a. B)
Do not use more than one number or letter for an answer identifier. If you want to remove the answer identifiers in your final CSV
question file (for instance, to later add them directly in VU Collaborate), select the “Check to remove enumeration from answers” checkbox.
Separate your new questions from the previous answers with a blank line. (See the Multiple Choice example below.)
At this time, the generator can format the following question types & information items for import into VU Collaborate:
Multiple Choice, Multi-select (multiple answer), True/False, Long Answer (essay), Short Answer (also works for “Fill in the blank”), Matching, Ordering, text information & image information.
- Enter your question on a single line. (Auto word-wrapping is ok, just don’t use the return/enter key until the end of the question text.)
- Answers immediately follow the question, each on a new line.
- Place an asterisk (*) in front of the correct answer choice.
- If you want to include credit for partially correct answers, place a plus sign (+) in front of each partially correct answer choice. You will need to set a weight value for the scoring of all partially correct answer choices; see “Setting the default scoring weight value (percentage) for partially correct answers” section below.
- Follow the same format as a multiple choice question (described on the previous page).
- The question and answer choices are each on a separate line.
- Place an asterisk (*) in front of all correct choices. Do not use a plus sign (+) for partially correct.
- Enter your question on a single line. (Again, auto word-wrapping is ok; use the enter/return key only at the end of the question text)
- Enter the answer on the next line. This can be any of the following:
T, t, True, TRUE, true, F, f, False, FALSE, false
- Do not use an identifier or enumerator in the answer line.
Long answer (essay)
This is simply a question with no answer provided. Be sure to leave a blank line in- between this question and the next question text following it.
- Type SA directly before your question text, followed by a space.
- All possible correct answers should follow the question text, each on a new line and with no identifiers or enumeration. By default, answers are evaluated as “case insensitive” by VU Collaborate. This can be manually changed for each short answer question after being imported into VU Collaborate.
- To use regular expressions in your answer choices, type E$ or e$ directly before the answer. (For more information on using regular expressions, consult the VU Collaborate Regular Expressions user guide.)
- To set a specific grading weight value for an answer: on a separate line immediately below the answer, type a percentage symbol (%) followed by the weight amount (1-100). For instance, typing %50 underneath an answer would award half of the total point value of the question for that response.
- “Fill in the blank” questions can also be created this way. However, only one blank is allowed in the question, and the question will be identified as a “short answer”-type question once imported into VU Collaborate.
- Type match directly before your question text, followed by a space.
- In each answer line, separate the choice and its correct match with a slash (/) and one space on each side of the slash. Do not include more than one slash character in each answer line.
- You can include extra choices that have no corresponding match. Simply place no text to the left of the slash—see the last choice/match entry in the example at the right (“/fore”).
- Any identifiers or enumerators included at the beginning of choice/match text lines will be automatically removed, regardless of the selection made in the “Remove enumeration from answers” box.
- The answer match entries will be automatically randomized when this question is presented in a VU Collaborate quiz.
- All matching-type questions created with this tool will be scored as “Equally weighted” by default. This can be manually changed for each matching question within your site’s quiz question editor.
- Type order directly before your question text, followed by a space.
- Following the question, list the answers in the correct order, each answer on a separate line.
- Each answer line may begin with an identifier/enumerator.
- The order of the answer list choices will be randomized when this question is presented in a VU Collaborate quiz.
- All ordering-type questions created with this tool will be scored as “Right minus wrong” by default. This can be manually changed for each matching question within your site’s quiz question editor.
- To add a text-only information entry to your quiz (for instance, to provide supplementary information for the quiz), type text directly before your question text, followed by a space. A number or letter identifier is not necessary.
- The text should not contain any return/enter key line breaks.
- Text information entries have no point or difficulty values associated with them.
- To add an image-only information entry to your quiz (for instance, to provide a reference image for several questions), type image directly before the text that you want to use as the image caption, followed by a space. A number or letter identifier is not necessary. Again, this text should not contain any return/enter key line breaks.
- Important: All images that you reference must be preloaded into the Content area using the “Manage Files” tool. It is recommended that you create a unique folder within your files area to store your quiz images.
- Type img= directly in front of the image file name, with no space between the equal sign and the file name. You should also include a folder path (within your files collection) of the image file. Separate the folder name and the image file name with a slash (/)…see the example to the right.
To add image displays to other types of questions, see Add image displays to questions” further below.
Adding image displays/references to questions
You can identify an image to be displayed within any question type. All images that you want to include in your quiz questionsshould be first uploaded into your VU Collaborate site file collection (using “Manage Files” in the Content area) before you add quizquestions using this generator. (Sorry, but there is currently not a way to directly import image files along with your questions using the CSV quiz format.) It is good practice to create a unique folder in your site file collection specifically for your quiz images.
To include an image within a question, type img= directly in front of the image file name, with no space between the equal sign and the file name. If you placed the image in a unique folder within your sites’ file collection, you should include a folder path for the image file. Separate the folder name and the image file name with a slash (/).
Adding feedback for questions
To add overall feedback for a question:
In a separate line under the question text, type an “at sign” (@) immediately followed by your feedback text (see example at the left below). Feedback can be included only for questions, not for text-only or image-only items.
To add feedback for individual answer choices (in multiple choice, multi-select and ordering questions)
In a separate line under the answer text, type @@ (two “at symbols” instead of just one) immediately followed by your feedback text for that particular answer (see example in middle below).
Note: you do not have to provide feedback for every answer—in the multiple choice question below, notice that answer C has no feedback associated with it. You can also include feedback for both the entire question (@) and for individual answers (@@) within the same question.
To add feedback for true/false questions:
For a “true” response choice, on a separate line type T@@ immediately followed by the feedback text. For a “false” response choice, on a separate line type F@@ immediately followed by the feedback text. See example on the right below.
Adding hints for questions
In a separate line under the question text, type a question mark (?) immediately followed by the hint text (see example at the left above). Hints can be included only for questions, not for text-only or image-only items.
Setting the point value for questions
Point values for questions can be set by using either of these methods:
- Enter the default point value that you want to assign for all questions in the “Default point value for each question” box.
You can either type the value number in the box or change the value using the up/down arrow buttons.
- To set a unique point value for an individual question:
In a separate line after the question text and above any answer lines, type an equal sign (=) followed immediately by the point value for that individual question. This will override the default value set for questions in the ”Default point value” box at the bottom, and it affects only the question that it follows. (see example at right)
Setting the difficulty value for questions:
Difficulty values for questions can be set by using either of these methods:
- Enter the default difficulty value that you want to assign for all questions in the “Default difficulty value for each question” box. You can either type the value number in the box or change it using the up/down arrow buttons.
To set a unique difficulty value for an individual question:
- In a separate line after the question text and above any answer lines, type an exclamation point (!) followed immediately by the difficulty value for that individual question. This will override the default value set for questions in the “Default difficulty value” box at the bottom, and it affects only the question that it follows.
Setting the default scoring weight value (percentage) for partially correct answers:
For answers to multiple choice questions that have been marked partially correct with a plus sign (+), you can set the scoring weight
value using the “Weight value for partially correct answer” drop-down box. Weight choices are 0, 20, 25, 33.33, 40, 50, 60, 66.67,
75, 80 or 100%.
Removing enumeration/identifiers in answer text:
If you want enumeration or identifiers for all answer text removed in the CSV file, check the “Remove enumeration from answers”
box. You can then later manually add enumeration to answers for each question by using the question edit tool in D2L.
Example: removing enumeration from the answer “1. The sun” will change the text to only “The sun” in the CSV file.
Note: Do not check this box if your answers contain no enumeration.
Clear text:Clicking the “Clear text” button empties the main text box
To import the CSV file into a VU Collaborate Question Library:
- In your VU Collaborate site, choose Quizzes in the top horizontal menu.
- Choose Question Library in the main panel window that appears.
- Click the Import button next to the “Create New:” dropdown box.
- For “Import Source:”, choose From a Desire2Learn Text Format File. Then click the Browse button that appears.
- Open your saved CSV file, then click the Save button at the far right side of your site’s main panel window.
- After a few moments, the CSV file data will be added to the Question Library. You can then edit and view the questions as you would with questions created directly in VU Collaborate.