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.
- Column A (Sr. No): This is the serial number of the question.
- Column B (QuestionID): This is the unique identifier for each question. Each question in the same question bank must have a different QuestionID.
- Column C (Language): This specifies the language in which the question will be uploaded.
- Column D (Questions): This column contains the text of the question.
- Column E (Type): Defines the type of question, which can be selected from the available dropdown.
- Column F (Topic): Specifies the topic of each question. Multiple topics can be defined here.
- Column G (Mark): Specifies the weightage of each question.
- Column H (Negative Mark): Defines the negative marks assigned to each question.
- Column I (Severity): Selects the severity level of each question from the dropdown.
- Columns J, K, L, M (Options): Contain the text of the options for the question.
- Column N (Correct Option): Indicates the correct option by entering A, B, C, or D. For example, if Option A is correct, input "A."
- Column O (Reference): Reference
numbers can match the corresponding question number.
- Column P (Passage): Contains the title of the passage associated with the questions.
- Column Q (Max Words): Defines the maximum word limit applicable for short answers and essay-type questions.
- Column R (File Type): Specifies the type of file that can be uploaded, applicable for file upload-type questions.
- Column S (File Size): Defines the file size limit for uploads, applicable for file upload-type questions.
- Column T (BTL): Selects the Bloom's Taxonomy Level from the dropdown menu.
- Column U (CLO): Specifies the Course Learning Outcome of a question.
- Column V (LOC): Defines the Learning Outcome of a question.
- 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.
- Column A (Passage No): Enter the serial number of the passage.
- Column B (Passage Title): Provide a title for the passage.
- 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!