How to upload questions in bulk

How to upload questions in bulk


Overview

This guide provides a step-by-step process to upload questions in bulk using an Excel template along with an optional Images ZIP file. It covers everything from downloading the sample template, correctly filling in question and passage details, adding image references, preparing the ZIP file, and completing the upload.
By following these instructions, users can ensure that questions, options, and associated passages (including images) are uploaded accurately without errors. Special attention should be given to maintaining the Excel format, correctly mapping image names, and following ZIP file guidelines to avoid upload failures. This process is designed to streamline bulk question creation while ensuring consistency, accuracy, and compatibility with the platform.

Step 1: Download Sample Excel Template

  1. In the upload popup, click Download Sample Excel File
  2. Download and open the Excel file

Step 2: Fill the Excel File

Sheet 1: Instructions

  • Retain the sheet in its original format without any modifications.

Sheet 2: Question

  • Enter all information in the sheet before upload

Sheet 3: Passage (Optional)

  • Fill only if required
⚠️ Do NOT modify headers or column structure



Columns In Question Sheet:


  1. Column A (SNo): This is the serial number of the question.
  2. Column B (QuestionId): This is the unique identifier for each question. Each question in the same question bank must have a different QuestionId.
  3. Column C (Language): This specifies the language in which the question will be uploaded.
  4. Column D (Question): This column contains the text of the question. Images can be inserted using '$$' symbol Example: $$q1.png$$. Image name must exactly match the file in the ZIP (case-sensitive, no extra spaces)
  5. Column E (Type): Defines the type of question, which can be selected from the available dropdown.
  6. Column F (Topic): Specifies the topic of each question. Multiple topics can be defined here.
  7. Column G (Mark): Specifies the weightage of each question.
  8. Column H (Negative Mark): Defines the negative marks assigned to each question.
  9. Column I (Severity): Selects the severity level of each question from the dropdown.
  10. Columns J, K, L, M (Options): Contain the text of the options for the question. Images can be inserted using '$$' symbol Example: $$q1.png$$. Image name must exactly match the file in the ZIP (case-sensitive, no extra spaces)
  11. Column N (Correct Option): Indicates the correct option by entering A, B, C, or D. For example, if Option A is correct, input "A."
  12. Column O (Reference): Reference numbers can match the corresponding question number.
  13. Column P (PassageTitle): Contains the title of the passage associated with the questions.
  14. Column Q (MaxWords): Defines the maximum word limit applicable for short answers and essay-type questions.
  15. Column R (FileType): Specifies the type of file that can be uploaded, applicable for file upload-type questions.
  16. Column S (FileSize): Defines the file size limit for uploads, applicable for file upload-type questions.
  17. Column T (BTL): Selects the Bloom's Taxonomy Level from the dropdown menu.
  18. Column U (CLO): Specifies the Course Learning Outcome of a question.
  19. Column V (LOC): Defines the Learning Outcome of a question.
  20. Column W (Matching Criteria): Select the criteria from the dropdown and is applicable for short answer-type questions.

Columns In Passage Sheet:

  1. Column A (Passage No.): Enter the serial number of the passage
  2. Column B (Passage Title): Enter the title of the passage. The same title must be used in the Passage column of the Questions sheet to associate relevant questions.
  3. Column C (Passage): Enter the passage text that will be displayed on the candidate’s screen when the associated question appears. Images can be inserted using '$$' symbol Example: $$q1.png$$. Image name must exactly match the file in the ZIP (case-sensitive, no extra spaces)

Step 3: Prepare Images ZIP File

1. Collect all images used in Excel
2. Ensure names match exactly
3. Compress all images into a ZIP
Notes
Important Rules:
• No folders inside ZIP
• Only image files (.png / .jpg / .jpeg)
• Do NOT rename after zipping
• ZIP must not be password protected

Step 4: Upload Files

  1. Upload the Excel file first
  2. Upload the Images ZIP file
  3. Click Upload

Step 5: Wait for Processing

  • Upload runs in background
  • Do NOT close the application
  • You can monitor the upload progress from the Notification Center by clicking the bell icon located at the top right of your screen.