What is the file format for the Questionmark Live CSV import?
A template is available to assist anyone who wishes to create questions using the Questionmark Live CSV format. The template can be downloaded below:
The way this CSV template works is by allowing you to create a question in each row of the questions table. 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 in to each row of the spreadsheet. What data is entered will depend on the type of question you are creating. See the relevant section below.
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||Feedback N|
|MC||Where in Canada is the Questionmark office?||Edmonton||1||That is correct.||Calgary||0||That is incorrect.||
|0||That is incorrect.|
|MR||Where in Canada is the Questionmark office?||Edmonton||1||That is correct.||Alberta||1||That is correct.||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 have added all your questions in to the spreadsheet using the particular layout for the question types, as indicated above, you will need to save the file as a CSV file. To do this in Excel:
- From the File menu, click Save As.
- In the Save as type drop-down list, select CSV (Comma delimited).
- Enter a filename, and click Save.
The file can now be imported in to Authoring.