An Incorrect Question Bank is the Cause of Performance Issues in the Old Version of eLearning
After many years of using the Moodle platform, it has become clear that certain structures of the Question Bank significantly impact server load and its slow performance. In the new version, we want to avoid transferring bad habits and not replicate these mistakes - for the sake of the efficient operation of the entire platform.
WARNING! In some courses, the Question Bank contains so many errors that it may be impossible to transfer it between the old and the updated version of Moodle.
The authors of the Moodle software do not indicate the best way to use the Question Bank. The software allows for quite free use of this solution. For this reason, it is not possible to carry out the optimization process automatically and on a large scale.
Copying the Question Bank
1. Introduction
In this instruction, we mainly use English names for options and images from the old version of enauczanie.pg.edu.pl in EN.
The course visible in the images was created for presentation purposes and combines multiple cases.
QB = Question Bank
2. Checking the size of the QB
Error loading QB - it may happen that access to the QB will not be possible at all (error 404, loading indefinitely).
This means that the given course has such a complicated QB structure that exporting with questions will not be possible.
Before proceeding with the migration of the course to the new platform, if quizzes from the QB are used in the course, the structure of the questions should be checked.
To do this, we enter the course, from the More menu, we select QB (Question Bank), and after the page loads, we choose the Categories option from the dropdown list on the left side.
We are examining the structure of nested questions in categories. If a given course has at least one of the issues listed below, it likely qualifies for optimization, and transferring it may generate errors.
The problematic structure is the occurrence of at least one of the following:
multiple levels of nested categories
a very large number of categories
duplicate categories
a large number of empty categories (0)
a large number of redundant/unnecessary questions
Examples of undesirable structures:
Multiple nested categories, a large number of categories:
Problems: multiple nested categories, large number of categories
The lowest level categories are empty:
Problems: a large number of categories, empty categories, duplicated categories.
Duplicated categories, a large number of categories, many unnecessary questions:
Problems: duplicated categories, too many categories, too many unnecessary questions
Unnecessary questions (not used in any Quiz):
Problems: none of the questions in this category are used in any quiz - redundant
3. Organization
Organizational work mainly involves removing excess questions and deleting empty categories and moving questions to the main category.
These tasks can be performed in any order, but the goal of the process is to achieve a simple structure with as few categories as possible encompassing all necessary questions. The main storage location for questions is the main area of the course or the first category in that space. For example, Question categories for 'Course: Mathematical Statistics 2024/25 copy with clean QB'.
Deleting empty categories
We click the trash icon next to the category name that has a zero number of questions (marked as (0)). Clicking the button deletes the category without any additional confirmation. If the category has a subcategory, it will be moved up one level along with the questions.
Trash button at position proportions (0)
The subcategory has been moved along with the questions.
Removing Excess Questions
By entering a category, we can display questions from that category. In the Usage column, there is the number of quizzes in which the question has been used (attached). For example, the category NY_QUIZ (0) has no questions, but by selecting the option Also show questions from subcategories, questions from the categories: ttest - mcq (10) and ttest_num_2024_2025 (4) will appear.
Removing Questions One by One
We review the questions and remove all unnecessary ones. We do this from the Edit menu.
Deleting multiple questions at once
You need to check
next to the question and use the button at the bottom With selected. This type of deletion will show a confirmation window for the operation.
Some questions may contain multiple versions
In that case, each version of the question should be removed using the menu Edit -> History (Edit → History).
Organizing - moving questions to the main category
If the Quiz does not use questions of the type random question (from the category), and therefore does not require specifying any category from QB, a good solution is to move all questions to the main category.
Questions can be moved to the parent category by selecting individual questions using checkboxes and using the menu option With selected → Move to… (With selected → Move).
4.Export and Import of Question Base
Before exporting the question category, it is worth assigning it an identifier - this way, it is easier to avoid duplicate categories in the new eLearning.
To export an organized question bank, in the course click More -> Question bank.
After loading the Question Bank, go to the Export option.
Select the file format “Moodle XML” and the category of questions you want to export.
Specify whether you also want to export the category and context.
In the new eLearning, enter the course in More -> Question bank -> Import. Select the Moodle XML format, choose the previously exported file, and then confirm Import.