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

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

  1. Log In to the platform
  2. Navigate to Question Bank from the left menu
  3. Click Create Question Bank



Step 2: Create Question Bank

  1. Enter:
    • Question Bank Name (unique)
    • Question Bank Code (unique)
  2. Click Save


Step 3: Go to Upload Section

  • Find the Question Bank

  • Click on Three Dots (⋮) next to your question bank

  • Select Upload Question


Adding Questions Manually

Step – 4:
After clicking on Save in previous step a user is required to click on “Three Dots” which are provided just below “Actions” column.
Once user clicks on those three dots presented, a dropdown menu of
  1. Add Questions
  2. View/Review Question
  3. Upload Question
  4. Rename
  5. Archive
  6. Download 
  7. Clone
 Will pop-up and after that a user is required to click on Add Questions


Step – 5:
Once user clicks on Add Question, User will be directed to add questions page where he/she will get a Dropdown Menu of numerous options namely
  1. Multiple Choice Single Answers
  2. Multiple Choice Multiple Answers
  3. True or False
  4. Essay Type Descriptive Answers
  5. Short Answers
  6. File Upload
  7. Typing Test
  8. Likert Scale
  9. Calculated Numeric


Step – 6:
After selecting the type of question a user is required to enter the passage provided by the client in “PASSAGE GROUP” section if the type of Questions are
  1. Essay Type Descriptive Answers
  2. Short Answers

Step – 7:
Topic: General and Others According to the requirements of the Candidate.

Step – 8:
BTL stands for Bloom’s Taxonomy Level, which has various options
  1. Create
  2. Evaluate
  3. Analyze
  4. Apply
  5. Understand
  6. Remember
Step – Extra Point: 
Severity here refers to difficulty level.

Step – 9:
Marks & Negative Marking

Step – 10:
CLO (Course Learning Outcome) & LOC (Learning Outcome)
( Optional )


Uploading the Question Paper in Bulk

Step 11: Download Sample Excel Template

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

Step 12: 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



Notes
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.
Notes
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 13: Prepare Images ZIP File
1. Collect all images used in Excel
2. Ensure names match exactly
3. Compress all images into a ZIP
Info
Important Rules:
• No folders inside ZIP
• Only image files (.png / .jpg / .jpeg)
• Do NOT rename after zipping
• ZIP must not be password protected

Step 14: Upload Files

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

Step 15: 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.


Step 10: Verify Uploaded Questions

1. Go to Question Bank

2. Click Three Dots (⋮)

3. Select View/Review Questions

Check:

• Questions are correct

• Options are correct

• Images are visible



Marking as Review Process

The user needs to log in with their credentials, click on the Question Bank, then click on the three dots on the question they need to review. Four options will appear



  1. Review

  2. Candidate View

  3. Edit

  4. Delete

For reviewing:

  • Click on Review. The question will open along with its options.

  • If there are no errors in the question, click on Mark as Reviewed.

  • If you find any errors, click on Edit. You will be redirected to a page where you can edit the question and its options. After editing, before marking as reviewed, click on Candidate View to see how the question will appear to the candidate on the exam portal.

  • If everything looks correct, click on Mark as Reviewed and then Next to view the next question.

    • Related Articles

    • How to Create an Exam

      Step – 1 You can access the 'ExamOnline Administration Portal' by logging in with the provided credentials. Configuring an Exam Step – 1 Name of the Exam – Give the name to the Exam. Note: When specifying the "Name of the exam", it's essential to ...

    • 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 & ...

    • How to create a question bank

      Step – 1 After login in to your examonline admin interface Select the Third option “Question Bank” from the Left side Menu provided and click on “Create Question Bank” tab. Step – 2 When you click on Create Question Bank, a pop-up will appear asking ...

    • 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 ...

    • How to View/Review the Questions in a Question Bank

      Step – 1 Clicking on the option of the question bank, then selecting 'View/Review Questions' and reviewing the questions. Step – 2 Now new page will open where you can View/Review Question which you have uploaded, then a user is required to click on ...