LearnDash Quiz Import/Export - Overview

Installation:


How To Export A Quiz:

When the Learndash Quiz Import/Export add-on is active on your site, a new Export button will appear in the quizzes table, under the “Quiz Export” column. To export the quiz, simply click on the export button. The quiz will be downloaded as a .xls file, which can be imported to another site using this add-on.

How To Import A Quiz:

To import a quiz, go to the “Import Quiz” tab from the Quiz Import/Export menu located under the main LearnDash LMS plugin menu. Here, you will find the input area for the quiz file to be imported. To complete the import, select the Microsoft Excel .xls file and click on the import quiz button.

 Note: Only a single sheet will be imported. For additional guidance, see the video tutorial on How to Import A Quiz.

Activate Your License Key:

The license key can be configured from the License Settings section, found under the main LD Quiz Import menu. License keys will be sent to your email address when you purchase the addon.

Insert your license key in the field and then click on Activate.

Learndash Quiz Import/Export Settings:

To modify the plugin settings, go to the Settings tab from the main Quiz Import/Export menu under the main LearnDash LMS plugin menu. All the default LearnDash quiz options are listed here. Any new imported quiz will adopt these quiz settings.

Plugin Option

Apply quiz settings from:

This dropdown menu allows the admin to select what type of user role can access and use this plugin. If you want any teacher or Instructor to be able to import and export quizzes, you should select their respective role.

Publish quiz on import?

When this option is enabled, the quizzes will be published as soon as they are imported; disabling this option will keep quiz status as pending.

Discard existing Questions

With this option enabled, previously imported questions from the same quiz will be discarded. This helps prevent previously imported questions from being repeated again and again in the same quiz.

If you import a quiz, let’s call it Final Quiz, with questions A, B, C, and D, and you want to import the additional questions  E, F, and G into the same quiz, with the “Discard existing Questions” option enabled, after all the questions are imported, the old questions, i.e., A, B, C, and D will be discarded, and only new questions, i.e., E, F, and G will be added. If the Discard Old Questions in Import option is unchecked, then all questions will be imported, including pre-existing questions, i.e., A, B, C, D, E, F, and G.

Import Existing Questions

With this option enabled, you can add an additional step to the import process that allows you to select which existing questions you want to be imported.

There will be a dropdown menu after the upload of the quiz import file that will display all the unassociated questions so that they can be associated with the new quiz while importing.

How to Import Quiz:

Latex Text:

This plugin now has the latex text support for math equations in LearnDash quiz questions.

 There are three steps to use latex text in your LearnDash quiz.

  1. Install the free MathJax LaTeX plugin
  2. Add the code snippet (provided in the instructions below) in your theme's functions.php file
  3. Create a quiz with latex text

This format should be needed to use the latex text [latex]E=mc^2[/latex]

Note: F ollow this article Using LaTeX in LearnDash to use the latex text in LearnDash quiz questions.

LearnDash Quiz Import/Export Template Guide

LearnDash Quiz Import/Export uses a standard template to import and export all LearnDash question types. This template should be filled in the given order to create your own templates for import/export.

Downloading The Template: 

The standard template can be found in the plugin folder:

LearnDash-quiz-import-export > Documentation > Standard Template.xls

The template contains the standard LearnDash question field names as column names. You will use the following columns which translate to LearnDash quiz questions:

1. Quiz Title

This column will hold the quiz title for the quiz to be imported.

2. Question Type

The column represents the type of LearnDash question. This column can have the following values corresponding to the LearnDash question types.

Single  => Single choice

Multiple  => Multiple choice

Sort_answer  => Sorting choice

cloze_answer  => Fill in the blank

free_answer  => Free choice

matrix_sort_answer  => Matrix Sorting choice

assessment_answer  => Assessment

essay => Essay / Open Answer

Note: The left column above contains the template values and the column on the right lists the corresponding LearnDash question types.

3. Category

The column should contain the value for the LearnDash question category field.

4. Title

This represents the question title for a LearnDash quiz question.

5. Total Points

The column represents the total points for each answer. It can be left empty for all question types except the essay type questions. For all other question types, the total points are calculated from their individual answers. However, in essay type questions, the column is used to assign a point value to each essay question.

6. Different Points for each answer

This option should be set to “yes” if you need to set different points for each answer and “no” If you want to set a standard number of points for all answers.

7. Question Text

This column would fill up the question text area. 

8. Answer Type

In LearnDash, there is an option to add media to the answers for some question types. If you want to display your answer with image, text, audio, or video, then set the value as Html for this column else set the value as text.

Note: I f we select the value as Html on matrix sorting question, then it will apply on both fields i.e element and criterion.

9. Answer # and Point # Columns

These columns should be set according to the maximum number of answers present in any of the questions for the particular quiz import.

If a quiz contains 13 answers for a particular question inside it, there should be 13 columns in the template.

From:

Answer 1 – Answer 13

Point 1 – Point 13

This column will contain all the answers which are available for a question. If a question has fewer answers than the maximum answer # column, then simply leave the unused columns empty. The point # column associates points with each answer. This column is used when the “different points for each answer” option is enabled.

Note:

1. For a matrix sort answer, the value inside these answer columns should be in  this format {criterion}{element}

2. To put an image as an answer, the value inside these answer columns should be in this format [image_url].

10. Answer Column

After the individual answer and points column, you will find a column titled “Answer”. This column serves multiple purposes that vary according to the question type.

Single choice

→ For a single choice answer, this column represents the correct answer from all the choices.

Multiple choices

→ For a multiple-choice answer, It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to signal is used to separate answer numbers in a list. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore incorrect answer should be deleted. For example, if only answers 2,3, and 5 were correct you should fill this column as follows ||2|3||5. If all answers are correct, then all answers should be listed.


Additional Example:

||2||4||6 → This indicates that answer # 2,4 and 6 are correct for this multiple choice question and answer # 1,3 and 5 are not correct.

Free choice

→ For a free choice answer, the column represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line break. To add multiple answers for a free choice using this column, you need to add line breaks in the spreadsheet cell.

For.eg:

value1

value2

value3

(To add a line break in excel file use ALT + Enter when typing in the selected column cell)

Assessment

→ For an assessment answer, the answer column represents the single answer values for this question type. The answer should be typed in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a closed (fill in the blank) answer, the column represents the value for the single correct answer for this question type. The answer should be typed in the following format:

This is a sample {cloze|5} question and It represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable a different number of points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, the column represents the answer submit method and the grading criteria. The following combination of values can be added to define the above values for this answer type.


Text submit, not graded and full points

awarded (text | not-graded-full)

Text submit, graded and full points

awarded (text | graded-full)

Text submit, not graded and no points

awarded (text | not-graded-none)

Upload submit, not graded and full points

awarded (upload | not-graded-full)

Upload submit, graded and full points

awarded (upload | graded-full)

Upload submit, not graded and no points

awarded upload | not-graded-none

11. Total Answer

This corresponds to the total number of answer columns in the sheet. Set this column value according to the maximum number of answers present in the sheet.

12. Message with correct answer

The text added to this column will be visible if a question is answered correctly. It can be used to provide an explanation for complex questions.

13. Message with incorrect answer

This text will be visible if a question is answered incorrectly. It can be used to provide an explanation for complex questions.

14. Hint

Here you can enter a hint for the question-answer.

15. Shared Question

If the question is a shared question, denote “1” for it and vice versa.

Note: You can also use latex for the LearnDash quiz question. To use this method, follow this article.

LearnDash Advanced Quizzes Add-on Support

The LearnDash Advanced Quizzes add-on offers new question types and some advanced quiz settings that are not offered by the default by LearnDash LMS.

The 3 new question types offered by LearnDash Advanced Quizzes add-on are:

  1. Jumbled Questions
  2. Swipe Questions
  3. Calculated Formula 

The advanced questions setting as:

  1. Negative Marking
  2. Different Time Limits for each question

With the updated LearnDash Quiz Import/Export v3.4, the three new question types i.e Jumbled questions, Swipe questions, and Calculated formulas introduced by the LearnDash Advanced Quizzes plugin are now supported by the LearnDash import/export plugin. The plugin also supports the Advanced Quizzes plugin options such as Negative Marking and different time limits for each question. 

The questions with these settings can be exported to the Microsoft .xls file and imported from that file format as well. 

LearnDash Advanced Quizzes Support (Template) Guide

To use LearnDash Quiz Import/Export and Advanced Quizzes together, you’ll need to use a standard template to import and export all LearnDash question types and the advanced quizzes question types and settings. This template should be filled in the given order to successfully import/export quizzes that include the Advanced Quizzes question types and settings.

Downloading The Template: 

The advanced quizzes supported template can be found in the plugin folder:

LearnDash-quiz-import-export > Documentation > learndash-advance-quizzes-sample.xls

The template contains the standard LearnDash question fields represented as columns with support for LearnDash Advanced Quizzes add-on features. On this template, the following columns should be filled to import information from the spreadsheet and translate data to LearnDash quiz questions:

1. Quiz Title

This column will hold the quiz title for the quiz to be imported.

2. Question Type

This column represents the LearnDash question type and includes support for the question types and settings offered by LearnDash Advanced Quizzes Addon. This column can have the following values which correspond to the LearnDash question types.

Single => Single choice

Multiple => Multiple choice

Sort_answer => Sorting choice

cloze_answer => Fill in the blank

free_answer => Free choice

matrix_sort_answer => Matrix Sorting choice

assessment_answer => Assessment

essay => Essay / Open Answer

laq_jumbled_sentence => Jumbled Sentence Question

laq_swipe_questions => Swipe Question

laq_calculated_formula => Calculated Formula 

Note: The left column above contains the template values and the column on the right lists the corresponding default LearnDash and LearnDash Advanced Quizzes Addon question types.

3. Category

The column should contain the value for the LearnDash question category field.

4. Title

This represents the question title for a LearnDash quiz question.

5. Total Points

The column represents the total points for each answer. It can be left empty for all question types except the essay type questions. For all other question types, the total points are calculated from their individual answers. This column is only significant for essay type questions since it is used to assign points to each essay question.

6. Different Points for each answer

This option should be set to “yes” if you need to set different points for each answer and “no” If you want to set a standard number of points for all answers.

7. Question Text

This column would fill up the question text area. 

8.Sub Question Text

This column will be of use if your Question type is Jumbled Sentences or Calculated Formula. 

For Jumbled Questions, use this column to add your question’s text with the variables enclosed in square brackets. 

Eg. By landmass earth's biggest continent is [x] and the country is [y].

The ‘[x]’ and ‘[y]’ being the variables for which answers are given in the following columns.

For Calculated Formula Questions, use this column to denote your calculation formula along with the variables. Variables should be enclosed in square brackets.

Eg.  [x]+[y]=? | [a]+[b]=?

The ‘[a]’, ‘[b]’,‘[x]’ and ‘[y]’ being the variables for which answers are given in the following columns.

9.Additional Question Settings

Use this column if your question contains Negative Marking. You can use this column too if you want to if you want your quiz to have different time limits for each question.

The Negative Marking and Different Time limits can be denoted in this column following the formatting example below:

“{"negative_points":4,"time_limit":40}” 

Here “4” are the negative points assigned for wrong answers and 40 is the number of seconds allotted for the question.

If you don’t want the question to contain Negative marking nor Different Time limits add ‘0’ in the spot where these numbers would be added.  

10. Answer Type

In LearnDash, there is an option to add media to the answers for some question types. If you want to display your answer with image, text, audio, or video, then set the value as Html for this column else set the value as text.

Note: If we select the value as Html on matrix sorting question, then it will apply on both fields i.e element and criterion.

11. Answer # and Point # Columns

These columns should be set according to the maximum number of answers present in any of the questions for the particular quiz import.

If a quiz contains 13 answers for a particular question inside it, there should be 13 columns in the template.

From:

Answer 1 – Answer 13

Point 1 – Point 13

This column will contain all the answers which are available for a question. If a question has fewer answers than the maximum answer # column, then simply leave the unused columns empty. The point # column associates points with each answer. This column is used when the “different points for each answer” option is enabled.

If your Question type is a jumbled sentence, the answer columns will be dependent on the number of variables your question contains. Answer 1 will contain the number of choices offered for the First variable of your question and Answer 2 column will have the choices offered for the second variable of the question respectively.

If the Question type is Swipe Question this will contain the choices for the swipe questions.

If your question type is Calculated Formula, this column will contain the Calculation formula as well as the values of the variables of the questions you want to offer.

Eg. If our calculation formula for the question is ‘[x] + [y]’ and we want to offer value of x as 1 or 2 and the  value of y as 3 or 4, we will fill the column as

 “ [x] + [y] | 1,2|3,4  ”


Note:

1. For a matrix sort answer, the value inside these answer columns should be in this format {criterion}{element}.

2. To put an image as an answer, the value inside these answer columns should be in this format [image_url].

12. Answer Column

After the individual answer and points column, you will find a column titled “Answer”. This column serves multiple purposes that vary according to the question type.

Single choice

→ For a single choice answer, this column represents the correct answer from all the choices.

Multiple choices

→ For a multiple-choice answer, It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to signal is used to separate answer numbers in a list. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore incorrect answer should be deleted. For example, if only answers 2,3, and 5 were correct you should fill this column as follows ||2|3||5. If all answers are correct, then all answers should be listed.


Additional Example:

||2||4||6 → This indicates that answer # 2,4 and 6 are correct for this multiple choice question and answer # 1,3 and 5 are not correct.

Free choice

→ For a free choice answer, the column represents the single answer for this question type, as there can only be one answer. The answers can, however, be separated through line break. To add multiple answers for a free choice using this column, you need to add line breaks in the spreadsheet cell.

For.eg:

value1

value2

value3

(To add a line break in excel file use ALT + Enter when typing in the selected column cell)

Assessment

→ For an assessment answer, the answer column represents the single answer values for this question type. The answer should be typed in the following format:

{[ans1][ans2][ans3]}

Fill In the Blank

→ For a closed (fill in the blank) answer, the column represents the value for the single correct answer for this question type. The answer should be typed in the following format:

This is a sample {cloze|5} question and It represents a sample cloze {type} question.

Note: A blank answer should be enclosed in {} and to enable a different number of points for each blank answer, the point has to be added after the pipe (|). If there is no separate point for each blank then there is no need to add the pipe (|) symbol.

Essay

→ For an essay answer, the column represents the answer submit method and the grading criteria. The following combination of values can be added to define the above values for this answer type.


Text submit, not graded and full points

awarded (text | not-graded-full)

Text submit, graded and full points

awarded (text | graded-full)

Text submit, not graded and no points

awarded (text | not-graded-none)

Upload submit, not graded and full points

awarded (upload | not-graded-full)

Upload submit, graded and full points

awarded (upload | graded-full)

Upload submit, not graded and no points

awarded upload | not-graded-none

Jumbled Questions

→This column contains the correct answer to the question. It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to signal is used to separate answer numbers in a list when your question has more than 1 variable. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore numbers representing incorrect answers should be deleted). For example, if only answers 2,3, and 5 were correct you should fill this column as follows ||2|3||5 and leave other spaces blank. If all answers are correct, then all answers should be listed.

 Additional Example:

||2||4||6 → This indicates that answer # 2,4 and 6 are correct for this multiple choice question and answer # 1,3 and 5 are not correct.

Swipe Questions

→It contains the correct answer to the question. It represents the correct answer(s) from all the choices. The pattern to indicate the correct choice is as follows:

The pipe (|) sign is used to signal is used to separate answer numbers in a list if there are more than one correct accepted answer. For example, if a question has 5 different answers, the formatting would look as follows: |1|2|3|4|5. However, only the correct answer numbers should be included in this format (therefore incorrect answer should be deleted. For example, if only answers 2,3, and 5 were correct you should fill this column as follows ||2|3||5. If all answers are correct, then all answers should be listed.


Additional Example:

||2||4||6 → This indicates that answer # 2,4 and 6 are correct for this multiple choice question and answer # 1,3 and 5 are not correct.

Calculated Formula Questions

→If your question type is a calculated formula question then leave this column as empty.

13. Total Answer

This corresponds to the total number of answer columns in the sheet. Set this column value according to the maximum number of answers present in the sheet.

14. Message with correct answer

The text added to this column will be visible if a question is answered correctly. It can be used to provide an explanation for complex questions.

15. Message with incorrect answer

This text will be visible if a question is answered incorrectly. It can be used to provide an explanation for complex questions.

16. Hint

Here you can enter a hint for the question-answer.

15. Shared Question

If the question is a shared question, denote “1” for it and vice versa.

Note: You can also use latex for the LearnDash quiz question. To use this method, follow this article.