Create an Excel sheet with the following columns:
- Quiz Question Type
- Score Points
- Questions
- Answer Choices (Answer Option1,Answer Option2,...)
In Quiz Question Type we can use abbreviations like:
Abbreviation | Question Type |
TF | True/False |
MC | Multiple Choice |
MR | Multiple Response |
FIB | Fill in the Blank |
WB | Word Bank |
MD | Matching Drag and Drop |
MDN | Matching Drop-down |
SD | Sequence Drag and Drop |
SDN | Sequence Drop-down |
NUM | Numeric |
LIK | Likert |
PO | Pick One |
PM | Pick Many |
WW | Which Word |
SA | Short Answer |
ESS | Essay |
RD | Ranking Drag and Drop |
RDN | Ranking Drop-down |
HM | How Many |
Score Pointscolumn is used for graded questions, we can allot marks to correct answers in each quiz. The Points can range from -1000 to 1000. Points for incorrect answers are not supported.
Answer Choices are required for all graded question types.
You can make upto 10 columns for answer choices and the correct answers are denoted by an Asterisk (*). In the example given below * True and all the underlined options are the correct answers.
For choice-level feedback, separate each answer choice and its feedback with a pipe (|) as shown in the image below.
For matching questions, separate each answer choice and its match with a pipe (|).
Click HERE to download the free excel spreadsheet used in this demonstration.
