Question Bank Import Overview

The question bank import function allows Administrators to create and edit question banks with large numbers of questions quickly and easily.

Accessing Question Bank Import

Question bank can be uploaded to TopClass using the Question Bank Import. Do the following to import:

1. Go to Activities and Learning > Content > Questions.
2. Click Import Questions. Questions must be uploaded in CSV file format. A CSV file sample is available to download for reference on required fields.
3. Select the CSV file from your computer.
4. Click Import.

📘

Note

If notifications are enabled, a notification is sent to you on completion of the import. For larger files, this may take a few minutes.

Creating/editing the CSV file to upload

The Question Bank Import in TopClass only supports the following question types: Boolean, Pick One, and Multiple Choice Answer. It is recommended that the CSV file is UTF-8 encoded.

Creating new Question Banks

To create new Question Banks, fill in the columns as follows:

• Column A (qPoolID) – Leave blank (TopClass will automatically create a new qPoolID on upload).

• Column B (qPoolTitle) - (required) Name the Question Bank.

• Column C (qPoolCategory) - Question Banks can be categorized for informational or reporting purposes.

• Column D (questionID) - Leave blank (TopClass will automatically create a new questionID on upload).

• Column E (questionTitle) - (required) Give your question a name.

• Column F (questionType) - (required) Set your question type (Boolean, Pick One or Multiple Choice Answer).

• Column G (questionMarks) - (required) Set the number of marks to be awarded for correctly answering the question.

• Column H (mandatory) - (required) Set as Yes if question is mandatory, set as No if question is not mandatory.

• Column I (question) - (required) Set the question.

• Column J (noOfAnswers) - (required) Set the number of answer options.

• Column K (answer1) - Set the answer.

• Column L (comment1) - Use this field to leave feedback comments for the answer. The test setup will determine when a student user sees the comment:

  • For tests where questions are one per page, once an answer is submitted, the feedback comment will appear.

  • For tests where all questions are on the same page, the feedback comments will appear once all answers are submitted on the results screen.

  👍

  Tip

  Questions, Answers, and Feedback Comments columns can be formatted using HTML within the CSV file field.

• Column M (isCorrectAnswer) - Set whether the answer is the correct answer.

📘

Note

A minimum number of two answer options is required. Additional answer options can be added, provided column naming convention is adhered to (e.g. columns K – M), and the number of answer options correspond with the number set in column J.

Editing existing Question Banks

To edit existing Question Banks, do the following:

1. Export the question bank from TopClass by doing the following:

   1. Go to Activities and Learning > Content > Questions.
   2. Highlight the question bank.
   3. Click Export Selected.

2. Open the exported CSV file.

3. To edit existing questions, change the affected column fields.

   🚧

   Warning

   Do not edit qBankID (column A) or questionID (column D).

4. To add new questions to the question bank, do the following:

   1. Go to a new row.
   2. Copy the qBankID (column A) to ensure the question is imported into the correct question bank.
   3. Fill in all other column fields as per the above instructions.

5. Import edited CSV file into TopClass.

🚧

Warning

Removing rows from the CSV file and re-importing will NOT delete the question from the question bank in TopClass.

Deleting questions from a Question Bank

To delete a question from a question bank, do the following:

1. Go to Activities and Learning > Content > Questions.
2. Select the question bank.
3. On the Questions tab, highlight the question.
4. Click the Delete button.

See Question Bank Import Troubeshooting for common troubleshooting examples. For further assistance, enter a Support Ticket.