Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
exam_item_usage_export [2017/02/28 13:56] 127.0.0.1 external edit |
exam_item_usage_export [2017/02/28 14:26] (current) michaelgallina |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Exam Import from File ===== | + | ===== Exam Item Usage Export ===== |
| - | The Exam Import tool is used to create an [[exam_entry|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 Exam Item Usage Export is used to generate a csv file (comma separated value) that lists every Item within the selected Bank that is currently being used on an Exam. Each row in the csv file represents a single occurrence of an Item on an Exam and shows information such as Item DisplayID, Item ID, Item Status, Item Version, Exam ID, Exam Version, Exam Status and Exam Sequence. |
| - | The reasons for creating an Exam using Exam Import from File are: | + | Exam Item Usage Export is reached from the Main Menu, Item Writing → Exam Tools → Exam Item Usage Export |
| - | * More rapid development of Exams, as the spreadsheet import method is faster than linking each Item to the Exam using the Exam Layout (FIXME 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 from File is reached from the Main Menu, Item Writing → Exam Tools → New Exam from File | + | {{::menuexamitemusageexport.png?200|}} |
| - | {{:menuexamfromfile.png?200|}} | + | ==== Export ==== |
| + | To start the Export process, click the **Export** button. | ||
| + | {{::examitemusageexport.png?600|}} | ||
| - | {{:examimport.png?600|}} | + | This will navigate you to a progress page. As the Items are exported, this page will indicate the progress. |
| - | ==== Import Files ==== | + | {{:itemimportprogress.png?600|}} |
| - | 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. | + | |
| - | {{:examimportsample.png?600|}} | + | When complete, a Download Result button will become enabled and green successful message will indicate success. The user can navigate back to the Exam Item Usage Export page via the hyperlink. |
| - | ==== Uploading an Import File ==== | + | {{::examitemusageexport_success.png?600|}} |
| - | To upload an Exam Import file, click the **Select** button. | + | |
| - | {{:examimportselect.png?600|}} | + | Pressing the **Download Result** button will begin downloading the resulting csv file using the browser. When complete, the browser will ask prompt you to Open or Save the file. |
| - | + | ||
| - | This will open a file dialog. Select the file and click **Open** button. | + | |
| - | + | ||
| - | {{:examimportupload.png?600|}} | + | |
| - | + | ||
| - | The import file will be uploaded but not Imported yet. To import the Items to the database click the **Import** button. | + | |
| - | + | ||
| - | {{:examimportuploaded.png?600|}} | + | |
| - | + | ||
| - | If no **New Exam Title** is specified, a warning message will appear. If no import file is selected, a warning message will appear. Otherwise the import file will be processed. | + | |
| - | + | ||
| - | 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. | + | |
| - | + | ||
| - | ==== Exam Import Notes ==== | + | |
| - | The Exam Import file consists of two columns. | + | |
| - | + | ||
| - | ^Field^Description^ | + | |
| - | |SECTION_TITLE|This is the Title that you want to give to the Section you are adding to the Exam. Each Item linked to an Exam must be linked to a Section that has been added to the Exam. For each distinct SECTION_TITLE value, a distinct Section is created. So if there are 3 distinct SECTION_TITLE values, there will be 3 Sections added to the Exam.| | + | |
| - | |ITEMID|This is the unique identifier of an [[item_entry|Item]] in the Exam/Item bank. The Item must be a valid Item in the currently selected Exam/Item Bank. See [[concepts#Banks and Bank Level|Bank and Bank Level]]. The Item cannot be Inactive.| | + | |
| - | + | ||
| - | ==== Exam Import Sample ==== | + | |
| - | ^Section_Title^ItemID^ | + | |
| - | |First Section|27| | + | |
| - | |First Section|28| | + | |
| - | |First Section|29| | + | |
| - | |Second Section|200| | + | |
| - | |Second Section|201| | + | |
| - | + | ||
| - | This will create an Exam with two Sections (**First Section** and **Second Section**) as there are two distinct Section Title values. **First Section** has 3 Items (27,28,29) and **Second Section** has two Items (200,201). | + | |
