If you already have an Excel spreadsheet with test questions you can import them to iSpring QuizMaker. To make QuizMaker automatically recognize questions, answer choices, points and other test details you have to use special formatting in your Excel file. For your convenience we're prepared a correctly formatted sample template file.
The following types of questions can be imported:
Those questions that are formatted incorrectly won’t be imported. The rows along with error descriptions will be listed in the Import Result window.
Quiz questions can be imported from a standard Microsoft Excel spreadsheet. The questions must be located in the first sheet. The Row 1 contains fields description, all the following rows – questions and answer choices.
You can learn about import format by opening a sample template file with correctly formatted example.
Field | Description |
---|---|
Question type | Question type abbreviation. |
Question text | Question text. |
Image | A path to an image file. It can be both absolute and relative path. The last has to be specified with regard to a source .XLS file. |
Video | A path to a video file. |
Audio | A path to an audio file. |
Answer 1 | Answer choices (up to 10 choices). The correct answer must begin with asterisk (*). Use a pipe (vertical bar) character "|" as a delimiter to separate premises and responses in the Matching questions. Each type of question has its minimal number of answer choices and correct answers (e.g. Multiple Choice question has to have at least 2 correct answer choices). Optional parameters can be specified in brackets "[]". If the fields Points, Correct / Incorrect Feedback are empty, the default values specified Quiz Properties is used. Note: You can check the sample template is in the "Sample" tab of the .XLS sample spreadsheet. |
Answer 2 | |
Answer 3 | |
Answer 4 | |
Answer 5 | |
Answer 6 | |
Answer 7 | |
Answer 8 | |
Answer 9 | |
Answer 10 | |
Correct Feedback | A feedback message for a correct answer (in a Graded Test) or a feedback for an answered question (in a Survey). If this field is empty, a message from Quiz Properties is used. |
Incorrect Feedback | An incorrect answer feedback message. |
Points | Points awarded for a correct answer. You can set any point value between 0,1 and 99999. Plus, you can use fractional points (up to 1 symbol after a decimal point). If points are not specified in the corresponding fields, values from Quiz Properties are used. |
Table 1. True/False
Field | Description |
---|---|
Question type | TF |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be 2 answer choices. A correct answer is preceded with an asterisk *. Only 1 correct answer is allowed for this type of question. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 2. Multiple Choice
Field | Description |
---|---|
Question type | MC |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be at least 2 answer choices. A correct answer is preceded with an asterisk *. Only 1 correct answer is allowed for this type of question. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 3. Multiple Response
Field | Description |
---|---|
Question type | MR |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 2. Correct answer choices are preceded with an asterisk *. There can be any number of correct answer choices between 1 and the overall number of alternatives. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 4. Type In
Field | Description |
---|---|
Question type | TI |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be at least 1 answer choice. List only correct answer alternatives in Answer fields. Thus, you don’t have to mark any with an asterisk *. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 5. Matching (Graded)
Field | Description |
---|---|
Question type | MG |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 2. Each answer choice is a pair of alternatives where matching items are separated with a pipe character |. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 6. Sequence
Field | Description |
---|---|
Question type | SEQ |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 3. Answers should be listed in the correct order. |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 7. Numeric (Graded)
Field | Description |
---|---|
Question type | NUMG |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 1. For this type of quiz question an answer choice is always a number. You can specify an exact number or a range: "=Х" – equal to Х "Х..Y" – any value between Х and Y ">Х" – greater than Х "<Х" – less than Х ">=Х" – greater than or equal to Х "<=Х" – less than or equal to Х "!= Х" – not equal to X |
Correct Feedback | A feedback message for a correct answer (optional). |
Incorrect Feedback | An incorrect answer feedback message (optional). |
Points | Points awarded for a correct answer (optional). |
Table 8. Yes/No
Field | Description |
---|---|
Question type | YN |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be 2 answer choices. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 9. Pick One
Field | Description |
---|---|
Question type | PO |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be at least 2 answer choices. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 10. Pick Many
Field | Description |
---|---|
Question type | PM |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | There must be 2 answer choices. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 11. Short Answer
Field | Description |
---|---|
Question type | SA |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | Not used. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 12. Matching (Survey)
Field | Description |
---|---|
Question type | MS |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 2. Each answer choice is a pair of alternatives where matching items are separated with a pipe character |. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 13. Ranking
Field | Description |
---|---|
Question type | RNK |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | The minimal amount of answer choices is 3. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 14. Numeric (Survey)
Field | Description |
---|---|
Question type | NUMS |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | Not used. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |
Table 15. Essay
Field | Description |
---|---|
Question type | ESS |
Question text | Question text. |
Image | A path to an image file (optional). |
Video | A path to a video file (optional). |
Audio | A path to an audio file (optional). |
Answer 1..10 | Not used. |
Correct Feedback | A feedback message for an answer (optional). |
Incorrect Feedback | Not used. |
Points | Not used. |