Instead of adding question slides in SmartTutor 360 manually, you can choose to directly import question list from CSV files. Creating CSV format files and importing questions from them is useful if you have to add large number of questions in your courses.
CSV stands for Comma Separated Value, using which you can create questions using plain text. These files can be saved as csv files and can be imported into SmartTutor 360 or Moodle LMS.
If you do not have the questions in a CSV format, you can quickly format your questions in the CSV format. Then, save the files as simple .csv files, and then import them into Adobe Captivate Classic. Here’s the generic syntax of the CSV format:
| Question type | Multiple Choice, True/False, or others. |
| Points | Points assigned to the question. |
| Question Title | The quiz question. |
| Answer Option 1,2,… | Different answer options based on the type of question. |
How to create Quiz CSV Files
To create a CSV file, you open a text editor. For example, Microsoft Excel and Notepad are great text editors to write questions following CSV format.
Supported question types
- True/False
- Multiple Choice
- Multiple Response
- Short Answer
- Multiple Short Answers
- Fill in the Blanks
- Sequence
- Drag and Drop
- Essay
- Select in List
- Select in Lists
- Likert Scale.
Instructions
CSV format has its distinct generic syntax. Therefore, it’s necessary to know the syntax to write questions in CSV format accurately.
Here is the generic syntax you need to follow when composing questions in CSV format in Microsoft Excel:
| Rule | Use |
|---|---|
| Question type | Use the following characters to indicate the question type you want to create: TF – True/False MC – Multiple Choice, Multiple Response FIT – Short Answer FITS – Multiple Short Answer FIB – Fill in the Blanks SQ – Sequence MAT – Drag and Drop ES – Essay SID – Select in List SIDS – Select in Lists RS – Likert Scale Use the arrow next to the question type cell to choose the type of question you want to create. |
| Points | Points for the question. |
| Question Title | Input the title for a question.. A Question Title is required for all questions. |
| Answer Option 1,2,3, … | Answer Options are required. Enter the options sequentially. |
| * (Asterisk) | Mark a correct answer or answers with an asterisk (*) at the beginning of the answer. It is only applicable for True/False questions and Multiple Choice questions. For Multiple Choice questions, if there is more than one correct answer, append * to all the correct answer options.For Fill in the Blank and short Answer Option questions, all the Answer Options given are considered correct. For these question types, you need not append an asterisk(*) to an answer option. |
| * (Asterisk) | True/False questions require TRUE and FALSE answer Options. Prefix the correct answer asterisk (*). |
| %|% | Display a pipe | as a normal character. For Fill in the Blank and Drag and Drop questions, add %| % at the beginning of the answer option. For example,The sun rises in the |. |
| Note: When you add alternative characters in your CSV, the characters do not appear as expected in SmartTutor 360. For example, if you add the word Québec in a CSV, the output appears as Qu颥c in SmartTutor 360. To fix this, when we add alternative characters, save the CSV as a UTF-8 CSV. In Excel, click File > Save As > CSV UTF-8 (Comma delimited). |