You can instantly export quiz questions into an .xls file and import them from a simple spreadsheet template. Quizzes can be exported into .xls/.xlsx files where you can quickly edit or update questions and re-import them later into LifterLMS LMS
Table of Content
Installation
The following are the step by step instructions to setup LifterLMS Quiz Import/Export add-on
- As a prerequisite, you’ll first need to install and activate the LifterLMS plugin.
- Next, download the LifterLMS Quiz Import/Export add-on.
- From the WordPress dashboard select Plugins and click on Add New
- Select the Upload Plugin button and then select the Add-on .zip file
- Next, activate the Add-on
- A new sub-menu “Quiz Import/Export” will be added under the LifterLMS menu
Entering Your Product License Key
From the dashboard, go to LifterLMS and select Quiz Import Export. Then click on the > License Option tab. Here you’ll find a box where you can insert the license key for the Add-on and get automatic product updates.
Settings
To access the Add-on’s general settings, you have to navigate to the WordPress Dashboard and select Quiz Import/Export under the LifterLMS Menu
The settings specified here will be applied to all the imported quizzes. You can change the setting from the specific quiz edit window.
Quiz Import/Export
Passing Percentage:
In this section, you can set a minimum percentage of the total points a student requires to pass a quiz.
Allowed Attempts:
Enter the maximum number of times a student can take the quiz.
Time Limit:
In this section, you can enter the maximum number of minutes a student can spend completing a quiz on each attempt.
Show Correct Answers:
When this setting is enabled, students will be shown the correct answer to any question they answered incorrectly.
Randomize Question Order:
When enabled, this setting allows you to display quiz questions in a random order, resulting in different question orders for each attempt. Content questions are locked into their defined positions.
Import
To import a quiz, navigate to WP Dashboard and click on LifterLMS. Then select Quiz Import/Export and go to the Import tab.
Then simply select the quiz file by clicking the button next to the Import Quiz heading. Keep in mind that your quiz file should be in .xls or .xlsx format
If you want to delete any existing questions and replace them with new questions from the selected file, check the box next to Delete Existing Questions. When enabled, existing questions in the same quiz will be deleted before importing new questions
Exporting Your LifterLMS Quizzes
Using LifterLMS Quiz Import/Export Add-on you can also export any quizzes you create into a .xls or .xlsx file. This file can then be imported into another site using this add-on.
To export the quiz follow these steps:
- Navigate to LifterLMS, select Courses, and then select Lessons.
- An export button will be listed next to every lesson that has a quiz available.
- To export a quiz, click on the Export button next to the Lesson containing the quiz you want to download. The quiz will be downloaded as a .xls file.
To export multiple quizzes follow these steps:
- Navigate to LifterLMS, select Courses, and then select Lessons.
- An export button will be listed next to every lesson that has a quiz available.
- Select the quizzes you want to export using the checkboxes to the left and then select “Export Quiz” from the bulk options dropdown
- Click “Apply” and selected quizzes will be downloaded as .xlsx files.
LifterLMS Quiz Import/Export Template Guide
LifterLMS Quiz Import/Export uses a standard template to import and export all LifterLMS question types. This template should be followed in order to create your own files for import/export. The standard template can be generated by exporting an existing quiz from LifterLMS > Lessons listing page.
Each column corresponds to LifterLMS quiz information. When filled, the information you input into each field can be translated into a LifterLMS Quiz.
The following columns contained in the template can be used to create a new LifterLMS quiz to import into your e-learning site:
Lesson ID:
In this column, you can specify the Lesson ID for the lesson you wish to associate your new quiz to. When left empty, you can associate the quiz with any lesson later on directly from the Course Builder. To do this just select Add Quiz and then select Add Existing Quiz. Next, you will be able to select the specific quiz from the drop-down menu.
Quiz Title:
The Quiz Title column represents the quiz title you want to assign for the LifterLMS quiz.
Question Title:
In the Question Title column, you can assign each question you create for your quiz its own question title. Just add the chosen title in the specific field.
Question Type:
This column allows you to specify what type of LifterLMS question you want to add to your quiz. The fields in this column can take any of the following values:
Multiple Choices:
Entering Yes in this column indicates that you have more than one correct answer for a multiple-choice question type. If there’s only one correct answer to the question, simply enter No.
Description:
By filling out a field in this column, you can provide a question description to display with your question.
Clarifications:
In the clarifications column, you can add solution hints that students can be able to see if they need help figuring out the answer to the question.
Image:
If your question includes images, this column provides you a field to enter the image URL.
Video:
To add video content to a quiz question, use this column to enter the video URL.
Points:
This column represents the total points a student will be awarded for each answer.
Correct Answers:
The correct answers column is the place where you should enter all the correct answers for the different types of questions. For the multiple-choice question type, you can add multiple correct answers by separating them with a comma (,).
Answer: (A, B, C)
Different answer columns, allow you to add your different answer options. For True False questions, you can use the Answer A and Answer B column for True and False respectively. For multiple-choice questions simply use a separate answer column to enter each one of the possible answer choices.
FAQ
Does the Add-On support all question types present in LifterLMS?
The LifterLMS Quiz Import/Export add-on supports all the default question types that are available in the free version and also supports LifterLMS Advanced Quizzes question types.
What will happen if I re-import a quiz?
When a quiz is re-imported, its content will be updated with the changes made to the Excel file.
Which excel file extension does this add-on support?
LifterLMS Quiz Import/Export only supports the .xls and .xlsx file extensions.
What does the “Delete Existing Questions” option do?
If you have enabled the “Delete Existing Questions” option any existing questions from the quiz will be deleted first when importing an excel file. Afterward, the questions included in the file will be added to the quiz. This will prevent any questions that had been previously imported from being duplicated.
Where can I configure the default quiz options that will be applied to imported quizzes?
You can find these settings on LifterLMS > Quiz Import/Export > Quiz Import Options tab.
Where can I find a standard XLS template?
The LifterLMS Quiz Import/Export .zip file includes a standard XLS template for quiz imports. You can locate this template in the Documentation folder stored in the main LifterLMS-quiz-import-export folder.
Changelogs
1.1
Bug Fixes:
- Fixed lesson id issue on import
