Select the Manage → Import → Questions tab.
Tip title What type of template must be used?
For Multiple Choice items or G-Type Cases, use the Get Sample Excel link.
For R-Type items, use the Get Sample Excel for R-Type link.
- Click the Get Sample Excel hyperlink under Select file (*.xls) region of the page, to download the sample exam template in Excel file format.
The Excel file has three sheets to enter data.
In this sheet, it is mandatory to specify the Type of item to be imported (selected from a drop-down list), Stem of the item which may have basic HTML tags, Option A and B (first and second Options for the item, which is the minimum requirement), and Correct Options (indicated by A or B or C or D, etc. Multiple Correct Options must be separated by commas). When SpreadSheet type questions are imported, MaxRows and MaxColumns are mandatory fields.
Optionally, you can specify additional data for Stem and Options such as assets, option labels, option shape labels, Case Name, Case Type (exhibit or item), External ID (imported items are assigned Ids in ExamDeveloper, this id is stored as a comment for each imported item), Language Group, Language Code Blueprint (is set to the default Language Code of the Item Bank if kept item is classified as “Unclassified” if left blank), Grouping Id (to be provided when language group is not provided and only used to internally reference the items before the import takes place), Blueprint Language Group, Language Code (item is classified as “Unclassified” if left is set to the default Language Code of the Item Bank if kept blank), StemImages,Shuffle Options (whether the options should be randomized when published on an exam. Valid values are "Yes" or "No"), References, Metadata, and Comments (multiple comments must be separated on multiple lines), ExhibitTitle, ExhibitIds, SpreadSheet AssetName, FrameHeight (for SpreadSheet type questions, enter the spreadsheet FrameHeight), Calculator, Minimum Response (enter the minimum number of responses for MCQ Multiple Correct Options and Point and Click item types), Maximum Response (enter the minimum number of responses for MCQ Multiple Correct Options and Point and Click item types), Enumerated (exclude an item from the numbering sequence in the review screen), Response Required (prevent candidates from navigating off any item they have not answered completely), Response Confirmation (prompt candidates to confirm their answer to an item before moving off of it), No Response Confirmation (prompt candidates for confirmation to move off an item if they did not respond to the item completely). Language Group can be provided here to be directly imported into the application, provided it doesn’t already exist. Similarly, Language Code can also be provided to be imported directly into the application, but its pairing with Language Group must not already exist in the application.
In the Correct Option column, the correct answer must be provided in a letter format. (e.g., A,B,C, etc.). If the item is a multiple choice item with multiple correct answers, the correct answers must be separated by a comma. Do not put a space between the comma and the next option. CORRECT A,C,D... INCORRECT A, C, D. The items only import the first correct answer if a comma is in place.
Here, you can specify optional additional information regarding references. You can read the detailed description on the Instructions sheet of the Excel sheet template.
Do not enter any data in the second row. Start entering data from the third row. Any data entered after an empty row is not imported.
It is mandatory to enter the ExhibitId (the Id that is used only to reference the case on the Questions sheet and is not passed to the application), ExhibitType (Split or Popup), and QuestionNumber (the question number to attach as exhibits).
- Save the Excel file template.
- Return to the Import Questions page, click the Choose File button to browse to the updated Excel file template, click OK button to select it, and click the Upload button.
- If the upload is successful, the imported items are listed below on the Import Questions page under the heading Import Question Queue in the same order as entered in the Questions sheet. The list includes the blueprint classification and question stem, and there is a check box for each item for selection. There are three buttons at the bottom of the list:
- Examine Question: This opens the selected item in the Examine Questions page.
- Accept Question: This accepts the item into the current project and sets its state to Review.
- Delete Question: The item is not allowed to enter the current project and is discarded.
Items imported with the corresponding Case Name blank, are imported as individual items.
A custom label for answer option can be specified via the node <optionlabel> in the XML template under <option> as can be seen below, where the alphabet “A” is specified as option label A. Nothing is to be entered for items not supporting custom labels for answer options.
While using the Excel file template to upload the item, the option label can be specified under the columns with headers Option A Label, Option B Label, etc., as shown below. It is to be left blank for items not supporting custom labels for answer options.