Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
exam_import_answer_key [2017/01/09 09:59] steveclarke |
exam_import_answer_key [2017/02/28 13:57] (current) michaelgallina |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== Exam Import from Answer Key File ===== | ===== Exam Import from Answer Key File ===== | ||
- | The Exam Import form Answer Key tool is used to create an Exam FIXME link from a spreadsheet consisting of a Section_Title, Answer and CompetencyID 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 for each row, create a new Item with the specified Answer that is linked to the specified Competency ID. In essence, it is a quick method of constructing and Exam with a new set of Items. | + | The Exam Import form Answer Key tool is used to create an [[exam_entry|Exam]] from a spreadsheet consisting of a Section_Title, Answer and CompetencyID 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 for each row, create a new Item with the specified Answer that is linked to the specified Competency ID. In essence, it is a quick method of constructing and Exam with a new set of Items. |
The reasons for creating an Exam using Exam Import from Answer Key File are: | The reasons for creating an Exam using Exam Import from Answer Key File are: | ||
- | * More rapid development of Exams, as the spreadsheet import method is faster than creating and linking each Item to the Exam using the Exam Layout (FIXME link) | + | * More rapid development of Exams, as the spreadsheet import method is faster than creating and linking each Item to the Exam using the [[exam_edit_layout|Exam Layout]]. |
* 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. | * 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. | ||
* Is ideal if not concerned with Item text or option text. | * Is ideal if not concerned with Item text or option text. | ||
+ | |||
+ | Exam Import from File is reached from the Main Menu, Item Writing → Exam Tools → New Exam from Answer Key File | ||
+ | |||
+ | {{:menuexamfromanswerkeyfile.png?200|}} | ||
+ | |||
{{:examanswerkeyimport.png?600|}} | {{:examanswerkeyimport.png?600|}} | ||
Line 37: | Line 42: | ||
|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.| | |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.| | ||
|ANSWER|This is an optional field. It represents the Answer for the new Item that will; be created and linked to the Section of the Exam. Valid values are A, B, C, D, E or 1, 2, 3, 4, 5.| | |ANSWER|This is an optional field. It represents the Answer for the new Item that will; be created and linked to the Section of the Exam. Valid values are A, B, C, D, E or 1, 2, 3, 4, 5.| | ||
- | |COMPETENCYID|This is an option field. If set, must be a valid Competency for Items in the Selected Exam/Item bank.| | + | |COMPETENCYID|This is an option field. If set, must be a valid Competency for Items in the Selected Exam/Item Bank. See [[concepts#Banks and Bank Level|Bank and Bank Level]]. See [[competency_entry|Competency Entry]] for more on Competencies.| |
==== Exam Import Sample ==== | ==== Exam Import Sample ==== | ||
Line 47: | Line 52: | ||
|Second Section|C|25| | |Second Section|C|25| | ||
- | 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 new Items created for it with Answers of A, C, D. The first Item is linked to Competency 25 and the second Item is linked to Competency 32. and **Second Section** has two Items (200,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 new Items created for it with Answers of A, C, D. The first Item is linked to Competency 25 and the second Item is linked to Competency 32 with the third Item having no Competency set up. The **Second Section** has two Items with Answers of A, C. The first Item has no Competency setup and the second Item is linked to competency 25. |