Import to WPLMS from Excel -10 Quiz Types

import quiz question wplms

Our Excel to WPLMS Quiz Import plugin can easily import ten types of quiz questions directly from the excel spreadsheet to WPLMS . The secret of easiness is special excel templates that can be downloaded directly from within setting page of the plugin in the WordPress admin area.

DB0HWx3jqo9OCpSJ3alxKFK65KPUYkyO lJf9 HXCorFqS EHG WZVoJ8zpEbpde9PsSxwukyvASMQZTyd Aldy04wm0Lebtp8PlGiuybl Vx UOB1G6u8pbQCDVEhjLH UjYdAe

Just remember do not delete or change anything in first row.

What are 10 types of quiz in WPLMS that you can import ?

After this plugin is installed on your WordPress site, you can easily import following types of quiz questions for WPLMS

  1. Multiple Choice having Single Correct Answer .
  2. Multiple Choice with Multiple Correct Answer
  3. Fillblank type of questions
  4. Sort type questions
  5. Match answer type
  6. True/False
  7. Large Text type
  8. Small Text type
  9. Dropdown select type
  10. Survey type

Type 1 : Multiple Choice 

Points to remember while filling excel template -Multiple Choice 

  1. Write single in “Question Type” column (In lower Case letter).
  1. Write your question options in “Question Options” column. Note that options are separated by comma(,).
  1. Fill the correct serial number of the correct answer. Like 1,2,3,…

Type 2 : Multiple Correct



Points to remember while filling excel template – Multiple Correct Xlsx template 

  1. Write multiple in “Question Type” column (In lower case letter).
  2. Write your question options in “Question Options” column. Note that options are separated by comma(,).
  3. Fill the correct serial numbers of the correct answer. Note that correct answers are comma separated.

Type 3 : Fill in the blanks

Points to remember while filling excel template – Fill in the Blanks  template 

  1. Fill actual question in “Question Text”  column. Use [fillblank] shortcode to give big gap.
  2. Write fillblank in “Question Type” column (In lower case letter).
  3. In case of Fill in the blank “Question Options” column is blank.
  4. Fill the correct answer in the “Correct Answer”  column.

Type 4 : Sort Answer

Points to remember while filling excel template – Sort Answer type

  1. Fill actual question in “Question Text”  column. 
  2. Write sort in “Question Type” column (In lower Case letter).
  3. Write your question options in “Question Options” column. Note that options are separated by comma(,).
  4. Write the correct order of the options in the “Correct Answer”  column. 

Type 5 : True / False

Points to remember while filling excel template -True/False template

  1. Write truefalse in “Question Type” column (In lower Case letter). 
  2. Write 1 or 0 in Correct answer column. 1 = True and 0 = False

Type 6 : Match Answer 

Points to remember while filling excel template – Match Answer  template 

  1. In case of Match Answer type as the following example in “Question Text”  :
[match]<li>Donald Trump</li>
<li>Narandra Modi</li>[/match]
  1. Write match in the “Question Type”.
  2. Write match options in “Question Options” column. Note that all options are separated by comma.
  3. Correct answers are separated by comma(,).

Type 7 : Large Text

Points to remember while filling excel template – Large Text template 

  1. Write largetext in “Question type” column (In lower Case letter).

Type 8 : Small Text

Points to remember while filling excel template – Small Text template 

  1. Write smalltext in “Question type” column (In lower Case letter).
  1. Small Text options are separated by comma.

Type 9  : Dropdown Select

Points to remember while filling excel template – Dropdown Select template 

Write select in “Question type” column (In lower Case letter).

For select dropdowns the options are picked from the options created in the question, to have different options for different select drop downs you can add an options parameter to the shortcode which has the option numbers separated by comma, example [select options=”1,2,3″]

The correct answer for each of the shortcode usage must be separated by a pipe |(see image below)

SroaO1uudsGWEvSkEtORuvY0olRekX2rOll08w15cQVY4sCvskmeLDh5Q

Type 10 :  Survey Questions

Points to remember while filling excel template – Survey template 

Write survey in “Question type” column (In lower Case letter).

The main aspect of this question type is that there is no correct answer for this question and it is only used for collecting responses from users. For existing quizzes, make sure you set the question score as 0.

These questions can be added to any quiz and to create a full survey user can add all the questions of survey type.

Apart from this WPLMS has also extended this to create informational quizzes wherein users can participate and get a response based on the score in the quiz, since there is no correct answer the option number is multiplied by the score for the question, this can be used to display custom messages to the user based on the feedback.