Quizmaker 360: Importing Questions

You can import questions into Quizmaker 360 to save development time. This is helpful when you need to reuse questions from another quiz or when a subject matter expert (SME) drafts questions for you.

• Importing Slides from Another Quiz
• Importing Slides from a Quiz Template
• Importing Questions from an Excel Spreadsheet
• Importing Questions from a Text File

Importing Slides from Another Quiz

1. Open an existing quiz or create a new one.
2. Then do either of the following:
   • Go to the File tab on the ribbon and click Import Questions.
   • In Question List View, go to the Home tab on the ribbon and click Import Questions.
3. Browse to the quiz file that contains the slides you want to import and click Open.
4. Quizmaker will display a list of slides from the quiz you selected. Mark the ones you want to import.
5. If you want to import the result slide, be sure to mark Import and replace result slide in the lower left corner.
6. Click OK to complete the import process.

Importing Slides from a Quiz Template

1. Open an existing quiz or create a new one.
2. Then do either of the following:
   • Go to the File tab on the ribbon and click Import Questions.
   • In Question List View, go to the Home tab on the ribbon and click Import Questions.
3. Browse to the quiz template that contains the slides you want to import and click Open.
4. Quizmaker will display a list of slides from the quiz template you selected. Mark the ones you want to import.
5. If you want to import the result slide, be sure to mark Import and replace result slide in the lower left corner.
6. Click OK to complete the import process.

Tip: You can also start a new quiz directly from a quiz template without going through the process of importing questions. See Using Custom Quiz Templates.

Importing Questions from an Excel Spreadsheet

First, populate an Excel spreadsheet with your questions and answers. Here's how:

1. Download this template. (A sample question is provided for you.)
2. Enter the Question Type, Points, Question Text, and Answer Choices for each question. See the table below for notes regarding each field.
3. Save and close the spreadsheet. (Save in XLS or XLSX format.)

Question Type	Question type is required. Use these abbreviations for supported question types: 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
Points	Points are required for graded questions. Enter points for the correct answer. Points can range from -1000 to 1000. Points for incorrect answers aren't supported via import.
Question Text	Question Text is required for all questions.
Answer Choices	Answer Choices are required for all question types except Short Answer, Essay, and How Many. Enter up to 10 answer choices for each question. Designate correct answers for graded questions with an asterisk (*) at the beginning. Example: *True For choice-level feedback, separate each answer choice and its feedback with a pipe (|). Example: Houston | Sorry, the capital of Texas is Austin. For matching questions, separate each answer choice and its match with a pipe (|). Example: Texas | Austin Numeric questions only support "Equal to" answers via import.

 

After populating an Excel spreadsheet with your questions, import it into Quizmaker:

1. Open an existing quiz or create a new one.
2. Then do either of the following:
   • Go to the File tab on the ribbon and click Import Questions.
   • In Question List View, go to the Home tab on the ribbon and click Import Questions.
3. Browse to the Excel spreadsheet (XLS or XLSX) and click Open.
4. Quizmaker will display a list of questions from the spreadsheet you selected. Mark the ones you want to import.
5. Click OK to complete the import process.

Tips for importing questions from an Excel spreadsheet:

• If there are any errors in your workbook, Quizmaker will list them. You can click Continue to import the questions that don't have errors and skip those that do, or you can click Cancel to correct the errors in your workbook and import it again.
• Formatting in your spreadsheet will be removed during import (italics, font size, hyperlinks, etc.).
• Text that follows two forward slashes (//) is identified as a comment. Comments will be ignored during import. (Leave the slashes in the column headers.)
• Only questions in the first worksheet (tab) of your Excel workbook will be imported. Additional worksheets will be ignored.
• Questions will be imported into the question list after the currently selected slide or, if a slide isn't selected, at the end of the quiz.
• The more questions you import, the longer it'll take to process and create them in Quizmaker.

Importing Questions from a Text File

First, populate a text file with your questions and answers. Here's how:

1. Download this template. (Tip: Right-click the download link and choose Save link as from the context menu.) A sample question is provided for you in the template.
2. Enter the Question Type, Points, Question Text, and Answer Choices for each question. Enter each item on a new line in the text file. See the table below for notes regarding each item.
3. Save and close the text file. (Save in TXT format.)

Question Type	Question type is required. Use these abbreviations for supported question types: 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
Points	Points are required for graded questions. Enter points for the correct answer. Points can range from -1000 to 1000. Points for incorrect answers aren't supported via import.
Question Text	Question Text is required for all questions.
Answer Choices	Answer Choices are required for all question types except Short Answer, Essay, and How Many. Enter up to 10 answer choices for each question. Designate correct answers for graded questions with an asterisk (*) at the beginning. Example: *True For choice-level feedback, separate each answer choice and its feedback with a pipe (|). Example: Houston | Sorry, the capital of Texas is Austin. For matching questions, separate each answer choice and its match with a pipe (|). Example: Texas | Austin Numeric questions only support "Equal to" answers via import.

 

After populating a text file with your questions, import it into Quizmaker:

1. Open an existing quiz or create a new one.
2. Then do either of the following:
   • Go to the File tab on the ribbon and click Import Questions.
   • In Question List View, go to the Home tab on the ribbon and click Import Questions.
3. Browse to the text (TXT) file and click Open.
4. Quizmaker will display a list of questions from the text file you selected. Mark the ones you want to import.
5. Click OK to complete the import process.

Tips for importing questions from a text file:

• If there are any errors in your text file, Quizmaker will list them. You can click Continue to import the questions that don't have errors and skip those that do, or you can click Cancel to correct the errors in your text file and import it again.
• Text that follows two forward slashes (//) is identified as a comment. Comments will be ignored during import.
• Questions will be imported into the question list after the currently selected slide or, if a slide isn't selected, at the end of the quiz.
• The more questions you import, the longer it'll take to process and create them in Quizmaker.