Bulk Upload Questions

...

1. Support Multiple Choice Question (MCQ) with validations such as

   1. Minimum 2 options, maximum 4 options

   2. At least and only one correct option

2. Question and Options can have images - provided as Google Drive public link. Google Drive path for image is provided by user which is extracted by system (bulk upload tool).

   1. Images will be placed at the beginning of the text with left align and small size (25%).

3. Question and Options can have either Images only or text only or both.

4. User can download sample bulk upload format. User provides CSV in the prescribed format filled with required details.

5. Mandatory columns (configurable) are coloured in red.

6. Basic validations such as

   1. Text contains only unicode characters

   2. Any cell does not contain any images

   3. All mandatory columns are filled for a particular row in CSV

...

1. Name is set to default as Multiple Choice Question for this version.

2. Question Category will be Multiple Choice Question for this version.

3. Additional Category is derived from the question set

4. Question Text will support text as per the Text validations listed below. Maximum character limit for Question Text is 1000 (configurable). Question Text and Question Image are merged to compose the Question Body. Question Body is required to create a question in the platform.

5. Question Image will support Google Drive path (publicly accessible) for images. Images will be placed at the beginning of the Question Text with left align and small size (25%) styling.

6. Option Layout will support three possible values: Horizontal, Vertical, Grid OR 1, 2, 3. Default value = Vertical.

7. OptionX will support text as per the Text validations listed below. Maximum character limit for Option Text is 500 (configurable). Option Text and Option Image are merged to compose the Option Body. Option Body is required to create a question in the platform.

8. OptionXImage will support Google Drive path (publicly accessible) for images. Images will be placed at the beginning of the Option Text with left align and small size (25%) styling.

9. Answer No will be a number between 1 to 4.

10. Question Set ID to be auto-derived when user is uploading questions within a question set

11. Level 1 Question Set Section will be Level 1 Section’s (unit) Name so that question can be linked to that folder.

12. Taxonomy Framework Categories: These will derived from the Question set when questions are being uploaded within a question set. The column headings are:

    1. Org_FW_Board

    2. Org_FW_Medium

    3. Org_FW_Class

    4. Org_FW_Subject

13. These can be edited by using the editor

    1. Org_FW_Topic

    2. Org_FW_LearningOutcome is not supported in bulk upload sheet. User can edit from UI.

    3. Org_FW_Skill is not supported in bulk upload sheet. User can edit from UI.

    4. DifficultyLevel is not supported in bulk upload sheet. User can edit from UI.

14. Additional Details about the question can be edited by using the editor

    1. Keywords

    2. Audience

    3. Author

    4. Copyright

    5. License

    6. Attributions

15. Math Formulae etc can be edited using editor.

Milestone 2: Link Questions to a Question Set which are being bulk uploaded

...

1. When a contributor logs into contribution portal and opens a target collection page of a project to which she can contribute (i.e. her nomination is accepted), currently against each target collection there is a “Create New” action using which user can create a question set.

2. Given user has access to a sourcing project where she can contribute, When she creates a question set within the sourcing project, Then she can upload questions to the question set

3. User will see an option to “Bulk Upload Question” in the question set similar to “QR codes” in the collection/question set editor.

4. Clicking “Bulk Upload Question” option, Bulk Upload Question screen should open up. The screen should have following options

   1. Option to select a Bulk Upload Question (metadata) file from local folder (of user’s system)
      Assumption: the metadata file will have publicly accessible URLs to the question related files

   2. There is a link to sample metadata file: “Sample Bulk Upload Question metadata file”

   3. User selects metadata file, user clicks “Upload”. System provides a message “Validating file”

   4. The system should first validate metadata file against the selected files. Following are the validations:

      1. All the columns are available

      2. All the mandatory columns have values filled in

5. In case there are errors in the metadata file validation, display relevant error message on the Upload dialog

   1. Some columns are not available:
      “Metadata file validation failed. Following columns are not found in the file. Please check and upload again: <list the missing column names>”

   2. Some mandatory columns have values missing:
      “Metadata file validation failed. Following rows have missing values. Please check and upload again: <list the row numbers (starting from 1) with missing values>“

6. In case of metadata file validation errors, “Upload” button is disabled unless user re-selects a metadata file again.

7. In case metadata file doesn’t have any validation errors, the dialog shows
   “Bulk Upload is in progress.
   Number of questions uploaded successfully: <no.>
   Number of questions failed: <no.>
   Number of questions pending: <no.>”

8. After the bulk upload is complete. There is an option to download status report as a csv. The status report should include identifier of the question (as generated by the system i.e. API response) and status (Success, Failure, Error, Invalid, etc)

9. There is a “Close” button to close the dialog. When user clicks it, it is returned to Question set editor. User cannot close it while bulk upload is in progress.

10. In the Question Set page, whenever user clicks “Bulk Upload Questions”, in case a bulk upload is in progress, it shows the status dialog as described in point 8. (This will be in future since we do not have support for background / minimised upload in the first version)

11. User can edit any question after it is uploaded and saved as draft in the question set. Using this user can Learning Outcome or any other detail of the question.

...