Skip to main content
Import question & exercise pools

Import pools in Excel format

Import your question or exercise pools in addition to your exam subject.

Written By Florian Barral

Last updated About 7 hours ago

Click Import

Click Download template > Subject and pools to download the .xlsx template file and fill in the columns of the Subject and Pools tabs:

Note: by default the template file contains 2 tabs, Subject and Pools, which must keep exactly these names to be recognized during the import and for it to work correctly
However, if you only want to import your pools, you can delete the Subject tab and keep only the Pools tab

⚠️ An import that contains the Pools tab replaces all the pools already in the exam: importing a second file erases the pools of the first one. Gather all your pools in a single file. Likewise, a Subject tab replaces the existing subject.

Subject tab

  1. Section (optional column if you do not use sections)

  2. Section statement (optional column if you do not use sections)

  3. Number of items drawn: number of items (questions or exercises) drawn from the pool in the next column

  4. Drawn from pool: name of the pool (of questions or exercises) the questions or exercises are drawn from

  5. Exercise (optional column if you do not use exercises)

  6. Exercise statement (optional column if you do not use exercises)

  7. Tag category 1 (optional column if you do not use tags)

  8. Tag 1 (optional column if you do not use tags)

  9. Tag category 2 (optional column if you do not use tags)

  10. Tag 2 (optional column if you do not use tags)

  11. Question type
    Enter one of the following types, written exactly like this: QCM, QCU, True/False, Open, Code, Spreadsheet, Schema, File upload or Complementary statement. For a True/False question, enter True or False in the Correct choices column. The Matching question cannot be imported.

  12. Points
    Enter a decimal number

  13. Size limit (optional column)
    For an Open question, the maximum length of the answer, for example 200 words or 1000 characters.

  14. Question.
    Enter your question.

  15. Grading comment
    Enter the grading comment displayed on the graded submission.

  16. Correct choices
    Define which choices are correct. Example:

    • 1 if the 1st choice is correct

    • 2,4 if the 2nd and 4th choices are correct

  17. Choice 1
    Type one of the question’s choices

  18. Choice 2
    Type one of the question’s choices

  19. Choice 3
    Type one of the question’s choices or leave it empty.

  20. Choice 4
    Type one of the question’s choices or leave it empty.

  21. Choice 5
    Type one of the question’s choices or leave it empty.

  22. Choice 6
    Type one of the question’s choices or leave it empty.

  23. Choice 7
    Type one of the question’s choices or leave it empty.

  24. Choice 8
    Type one of the question’s choices or leave it empty.

  25. Choice 9
    Type one of the question’s choices or leave it empty.

  26. Choice 10
    Type one of the question’s choices or leave it empty.

⚠️ Be careful if you use random draws with the number of items drawn and drawn from pool columns: do not fill in the columns from question type onward (column K in the template file).

If you only use random draws, you can also delete all the columns from the question type column onward (column K in the template file).

Pools tab

  1. Pool

  2. Exercise (optional column if you do not use exercises)

  3. Exercise statement (optional column if you do not use exercises)

  4. Tag category 1 (optional column if you do not use tags)

  5. Tag 1 (optional column if you do not use tags)

  6. Tag category 2 (optional column if you do not use tags)

  7. Tag 2 (optional column if you do not use tags)

  8. Question type
    Enter one of the following types, written exactly like this: QCM, QCU, True/False, Open, Code, Spreadsheet, Schema, File upload or Complementary statement. For a True/False question, enter True or False in the Correct choices column. The Matching question cannot be imported.

  9. Points
    Enter a decimal number

  10. Size limit (optional column)
    For an Open question, the maximum length of the answer, for example 200 words or 1000 characters.

  11. Question.
    Enter your question.

  12. Grading comment
    Enter the grading comment displayed on the graded submission.

  13. Correct choices
    Define which choices are correct. Example:

    • 1 if the 1st choice is correct

    • 2,4 if the 2nd and 4th choices are correct

  14. Choice 1
    Type one of the question’s choices

  15. Choice 2
    Type one of the question’s choices

  16. Choice 3
    Type one of the question’s choices or leave it empty.

  17. Choice 4
    Type one of the question’s choices or leave it empty.

  18. Choice 5
    Type one of the question’s choices or leave it empty.

  19. Choice 6
    Type one of the question’s choices or leave it empty.

  20. Choice 7
    Type one of the question’s choices or leave it empty.

  21. Choice 8
    Type one of the question’s choices or leave it empty.

  22. Choice 9
    Type one of the question’s choices or leave it empty.

  23. Choice 10
    Type one of the question’s choices or leave it empty.

To learn more about Sections and Exercises, see Structure an exam subject .

Was this helpful?

Still need help? Ask the team