# Upload Question Bank

## **To upload multiple questions**

<mark style="color:blue;">**Step 1:**</mark> Click the <mark style="color:blue;">**Upload Questions**</mark> tab and the <mark style="color:blue;">**Upload Questions**</mark> page is displayed.

![](https://4166026515-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkUUsnoCFHCrXLAM3d7e%2Fuploads%2FYlXg0EIeMEuJlCT0wSK6%2FUpload_Questions_550x234.png?alt=media\&token=fee8ef7e-19e6-49f5-ba2f-cec607822d7c)

<mark style="color:blue;">**Step 2:**</mark> Click the <mark style="color:blue;">**Question Upload Template**</mark> link to download the Microsoft Excel sheet template. Follow the instructions on the sheet named <mark style="color:blue;">**"Instructions"**</mark> in the template. The instructions are also listed below.

> #### Using the Bulk Question Upload Template
>
> **Opening the spreadsheet**
>
> This spreadsheet no longer requires the use of Macros. As of NexPort Campus v6.4, question bank spreadsheets can be uploaded directly.
>
> **About the spreadsheet:**
>
> This spreadsheet is organized into two worksheets. You are viewing the first tab (Instructions) now. The the second tab (Data) is where you should enter the actual data.
>
> **About the Example Questions:**
>
> Questions Section. The lower section of the Examples page holds the questions and answers for the exam. The column headings are Question Id, Question, Type, Response 1, Message 1, Response 2, Message 2, Response3, Message3, Response 4, Message 4, Response 5, Message 5 and Answer. Response Each row represents one exam question and the accompanying set of possible answers, plus the correct answer. Question Id represents the order in which the questions will appear. The Question Id has to be unique and is used when replacing existing questions.
>
> In the Answer field, enter 1,2,3,4,5, etc. to indicate the correct answer (1 = Response 1, 2 = Response 2, etc.). Messages to accompany each response are optional. To indicate multople correct answers, separate them by commas. Ex: "1,3,5"
>
> **Hiding Question area and Open Ended Questions**
>
> If the *ShowQuestion* column is set to no then the question and response area will be not be displayed. Setting the *ShowOpenEnded* column to yes will display the open ended question text and allow the student to enter an answer."
>
> **Randomize Response Display Order**
>
> In order to randomize the display order of the responses add a column named Randomize and set the column value to yes. If no value is given then no is the default. "

{% hint style="info" %}
As of NexPort Campus v6.4 the template macros are no longer required. The excel spreadsheet can be directly uploaded. Legacy XML files can still be uploaded as well.
{% endhint %}

<mark style="color:blue;">**Step 3:**</mark> In the <mark style="color:blue;">**How to handle existing IDs**</mark> section, do one of the following:

> Click <mark style="color:blue;">**Replace**</mark>, if a question in the existing question bank contains the same question ID as a question that you are now uploading.
>
> The question added previously is overwritten with the question bearing the identical question ID in the uploaded file.
>
> Click <mark style="color:blue;">**Skip**</mark> to omit overwriting questions that have an identical question ID.

<mark style="color:blue;">**Step 4:**</mark> Click <mark style="color:blue;">**Select File**</mark>.

<mark style="color:blue;">**Step 5:**</mark> The <mark style="color:blue;">**Open**</mark> dialog box is displayed. Navigate and select the XML template.

<mark style="color:blue;">**Step 6:**</mark> Click <mark style="color:blue;">**Open**</mark>, the XML template is uploaded. A confirmation message that the XML template is uploaded successfully is displayed.

<mark style="color:blue;">**Step 7:**</mark> Click <mark style="color:blue;">**Submit**</mark>. The questions are uploaded in the question bank.

#### © NexPort Solutions 2022. All Rights Reserved.