This article explains how to import questions (with additional category values) into the question pool using an Excel template.
Question categories are used for better question organization, search, and creating filters for test generators. Preconditions of importing questions with categories are that the categories must be created in the system settings.
One question can have multiple categories and multiple category values.
Creating question category
For more information on creating question categories, you can check this article.
Importing questions with assigned category values
Navigate to the “Tests” in the main menu, then choose the “Question pools” page.
Choose the question pool where you want to import the questions.
Navigate to the “Questions” tab, and click on the “Load questions” button. Choose the option “Without images (.xlsx format)”.
When the pop-up window shows up, click on the “Excel template” to download it.
Once you download the excel template, you should fill it out with relevant information.
Categories are specified in the column “Categories (Optional)” in the following format:
<QuestionCategory1>:<Value1>…;
<QuestionCategory2>:<Value2>…;…
Example:
Topic area: biology; Difficulty level: Easy;
How this looks like in the “System settings“:
How it looks like in the Excel file:
Once you fill in the template, you should:
- Select the created file by clicking the “Select file” button and choosing the file.
- Click the “Upload” button.
The questions with assigned question category values will be imported into the desired question pool.
For more useful instructional materials, please check these links: