The Exam Import tool is used to create an Exam link from a spreadsheet consisting of a Section_Title and ItemID columns. The import process will create an Exam with a specified Title, add a distinct set of Sections to the Exam with specified Section Titles, and link the Items specified by their ItemID to the various sections. In essence, it is a quick method of constructing and Exam with a known list of Items.

The reasons for creating an Exam using Exam Import from File are:

• More rapid development of Exams, as the spreadsheet import method is faster than linking each Item to the Exam using the Exam Layout ( link)
• Limiting exposure of your Exam Banks to external users. By using Exam Import from Ffile, external users to CE such as subject matter experts (SME) or contract authors do not have to be trained to use CE or be exposed to the system at all.

Exam Import supports importing Exams from Microsoft® Excel (.xlsx). The user can download the import templates using the template hyperlink. Note: Microsoft® Excel must be installed to open or maintain these files.

To upload an Exam Import file, click the Select button.

This will open a file dialog. Select the file and click Open button.

The image file will be uploaded but not Imported yet. To import the Items to the database click the Import button.

This will navigate you to a progress page. As the Items are imported and processed, this page will indicate the progress.

When complete, a message area will appear indicating how many records were processed and any validation issues that occurred. If successful a green message are will indicate success. If there were validation issues a yellow message are will appear. The user can navigate back to the Item Import page via the hyperlink.

For more on Item Import field types, validation, requirements, see Item Import Notes.