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.

    • Related Articles

    • How to create a question bank and upload the questions and review the paper

      Overview This feature allows you to upload questions in bulk using an Excel file and optionally attach images via a ZIP file. Please follow all instructions carefully to avoid upload failures. Step 1: Go to Question Bank Section Log In to the ...

    • How to Associate Questions to the exam

      Note: This step should be done after the creation and review of the Question Bank. Step - 1 To associate questions with the exams, click the 'Plus Icon' to expand the tabs, and then navigate to the 'Questions' tab. Step - 2 Now the “Sections & ...

    • Bulk Attendance Report

      Bulk attendance report is a consolidated report to fetch scores for multiple exams at once, saving time and effort. Step 1: Navigate to the report module and click on "Bulk Reports". Step 2: Click on the option of "Attendance Report". Step 3: Select ...

    • How to create exams in bulk

      Step – 1 Navigate to the "Exam" tab. Now click on “Upload icon”. Step – 2 You will have to download "Sample File". Step – 3 Once the "Sample File" is downloaded, you can configure the exam according to your requirement. There is an existing entry in ...

    • Bulk Score Report

      Bulk score report is a consolidated report to fetch scores for multiple exams at once, saving time and effort. Step 1: Navigate to the report module and click on "Bulk Reports". Step 2: Select the Exam/Exams from the drop down menu available. Step 3: ...