What's the file format for the Questionmark CSV import?
A template is available to help create questions using the Questionmark CSV format. Download the template here.
The way this CSV template works is by allowing you to create a question in each row of the questions worksheet. Each row of data represents different details or question data.
The questions that can be created using the CSV file are listed below along with the question type code to use in the CSV:
- Multiple Choice - MC
- Multiple Response - MR
- Multiple Response (right/wrong) - MRWR
- True/False - TF
- Yes/No - YN
- Text Match - TM
- Likert Scale - LKS
The data must be added to each row of the spreadsheet. What data is entered will depend on the type of question you're creating. See the relevant section below.
Note: Because the Questionmark CSV file format is comma delimited, if you need to use commas in a text field such as the stimulus or a choice, you must enclose the text in quotations. Neglecting to do so will cause errors.
Multiple Choice and Multiple Response question types
|Question type code||Stimulus||Choice 1||Score||Feedback 1||Choice 2||Score||Feedback 2||Choice N||Score N||Feedback N|
|MC||Where in Canada is the Questionmark office?||Edmonton||1||That is correct.||Calgary||0||That is incorrect.||Toronto||0||That is incorrect.|
|MR||Where in Canada is the Questionmark office?||Edmonton||1||That is correct.||Alberta||1||That is incorrect.||Toronto||0||That is incorrect|
Multiple Response (right/wrong)
|Question type code||Stimulus||Score for correct answer||Feedback for correct answer||Score for incorrect answer||Feedback for incorrect answer||Choice 1||Is answer?||Choice 2||Is answer?||Choice N||Is answer?|
|MRWR||Where in Canada is the Questionmark office?||1||Correct||0||Incorrect||Edmonton||1||Alberta||1||Toronto||0|
True/False and Yes/No
|Question type code||Stimulus||Choice 1||Score||Feedback 1||Choice 2||Score||Feedback|
|TF||The Questionmark offices are in Edmonton.||TRUE||1||That is correct.||FALSE||0||That is incorrect.|
|YN||Questionmark has an office in Edmonton.||Yes||1||That is correct.||No||0||That is incorrect.|
|Question type code||Stimulus||Score for incorrect answer||Feedback for incorrect answer||Correct answer 1||Score for correct answer 1||Feedback for correct answer 1||Correct answer 2||Score for correct answer 2||Feedback for correct answer 2||Correct answer N||Score for correct answer N||Feedback for correct answer N|
|TM||Where in Canada is the Questionmark office?||0||That is incorrect.||Edmonton||1||That is correct.||Alberta||1||That is correct.||Edmonton, Alberta||1||That is correct.|
|Question type code||Stimulus||Scale N description||Scale N score||Scale 3 description||Scale 3 score||Scale 2 description||Scale 2 score||Scale 1 description||Scale 1 score|
|LKS||How nice was your last airline flight?||Nice||3||Average||2||Not nice||1||Terrible||0|
Saving the data as a CSV file
Once you've added all your questions to the Excel spreadsheet using the particular format for the question types, as indicated above, you'll need to save the file as a CSV file. To do this:
- From the File menu, click Save As.
- Select a location in which to save the CSV file.
- Enter a file name.
- Fromt the drop-down list, select CSV UTF-8 (Comma delimited).
- Click Save.
The CSV file can now be imported into Authoring.
Importing a CSV file into Authoring
To import a Questionmark CSV file, follow the steps in Importing questions.