How to upload questions in bulk

How to upload questions in bulk

Step – 1

After logging in to the "Exam Online Administration Portal" with the shared credentials,

You have to first create a question bank. (Note: You can check the process in another article, by clicking Create a Question Bank. )


Step – 2
Navigate to the action buttons of the question bank, under question bank module and click on "Upload question".




Step – 3
A pop-up will appear with a sample file available for download. This file needs to be edited and uploaded back.

                                               



Step – 4
After downloading the excel file, open it, and the user is required to fill in the details in Sheet 2, i.e., "Question," 



Lets learn more about each field.
  1. Column A (Sr. No): 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 (Questions): This column contains the text of the question.
  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.
  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 (Passage): Contains the title of the passage associated with the questions.
  14. Column Q (Max Words): Defines the maximum word limit applicable for short answers and essay-type questions.
  15. Column R (File Type): Specifies the type of file that can be uploaded, applicable for file upload-type questions.
  16. Column S (File Size): 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.


Step – 5
After entering Sheet 2, the user is required to fill in the details in Sheet 3, i.e., "Passage".


Lets learn more about each field.
  1. Column A (Passage No): Enter the serial number of the passage.
  2. Column B (Passage Title): Provide a title for the passage.
  3. Column C (Passage): Enter the text of the passage.

Step 6: 
Save the edited file and navigate back to the Question Bank module. Upload the file there and click on the Upload option.
                                                 

Step 7:
Navigate to the notification icon to view the status of the bulk upload file. 





Hence the Question paper is uploaded successfully.


Thank You!


    • Related Articles

    • 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 ...
    • How to Upload/Register candidates in bulk

      Step – 1 Navigate to the “Candidate” from the left side menu provided and click on “Create List” tab. Step – 2 Assign a name to “Candidate List” and you need to click on Save and proceed. Step – 3 Now you are required to click on the "Three Dots" ...
    • How to create a question bank and upload the questions and review the paper

      Step – 1 Select the third option “Question Bank” from the left side menu provided and click on “Create Question Bank” tab. Step – 2 Once you assign the name to Question Bank you need to click on Save and proceed to next Step. Adding Questions ...