Item Import Notes
The grid below is a list of all accepted data fields for an Item imported via Word or Excel. The Word Import template consists of a table with two columns. The left column is the field name, the right column is the field value. Each row in the table corresponds to a different field name/value combination. The Excel Import consists of a header row of Column names, and one row per Item.
Field Names
Any field name that is unknown (not in this list) will not import and will log an error message.
All of the field names are case insensitive. So, will accept “STATUS”, “Status”, “status”, “StATUs””, etc.
No field is required. You can import with any combination of fields from the grid. Any row can be imported or can be excluded from the table. So, you do not need to have the “Enabled”” field or the “Substatus” field to import. Including some fields may also require the inclusion of other fields (e.g. Status and Substatus).
The fields can appear in any sequence. You can set “Substatus” before “Status”.
Field Values
Most of the time, any field that has no value (blank cell) is ignored. Some fields will set the value to blank if left blank.. The Field List below will indicate the no value expected behavior for each field.
All text values for fields that are looking for a specific value text are case insensitive. So, will accept “ACTIVE”, “active”, “Active”,“AcTiVE”, etc. This applies to Status, Substatus, Enabled, ItemMustPass and Answer fields.
When validating IDs, like the fields GroupID, AuthorID, CompetencyID, CopyrightID, AttachmentID or ReferenceID, the ID must be a whole number, the ID must be setup in CE and must be in the selected Bank being imported to. So, if Author “25” exists in the “Help-Import” Bank and you are importing to “LiveData-Production” bank, then the Author “25” does not exist in “LiveData-Production” bank and an error logged.
Item Types
Multiple Choice Items
For Multiple Choice (MCQ) type Items (4 option, 5 option, true/false) , you do not require the OptionText5, OptionCorrect5 or OptionValue5 fields, unless creating a 5 option item. For 4 option Items, you can omit these fields.
None of the red rows apply to MCQ type Items. If importing MCQ type Items, all of these fields can be omitted.
Dichotomous MCQ
For Dichotomous MCQ Items, it is not required to bring across OptionCorrectn, OptionValuen fields. You can alternately bring across the OptionTextn for each Option and also bring across the Answer field. The Answer fieldwill set the Option Correct for one option only and set its value to 1.
For Dichotomous MCQ you can omit the green field rows.
Non-Dichotomous MCQ
For Non-dichotomous MCQ type Items, each Optionn should have its corresponding OptionCorrectn and OptionValuen rows set if you require more than one correct option and different point values for the Options.
For non-dichotomous MCQ you will want to include the green field rows.
Essay/Constructed Response/Rater Items
For non-mcq type Items you will want to include some or all of the red rows to set max values, default values and alternate scoring options for the human rated Essay/Constructed Response type Items.
Update Item vs Add Item
When including the ITEMID field, a valid ITEMID is mandatory and an update to the existing Item will be performed.
When excluding the ITEMID field, a new Item will be created.
Do not mix and match the inclusion/exclusion of the ITEMID field within different tables in the a Word document. Either all tables require the ITEMID field to be included or all tables require the ITEMID to be excluded.
Field List
| Field | Description | Valid Values | Errors | Rules |
|---|---|---|---|---|
| ITEMID | Numeric | Item ID must be numeric. Item x is not setup within the Bank | ItemID must exist and within the selected Bank. When this column is included, an update will performed on the indicated Item. When this column is NOT included, a new Item will be added to the system. | |
| EXTERNALID | Alphanumeric | External ID has a maximum length of 30 characters. | Value must be ⇐ 30 characters. If nothing entered, will replace existing values with blanks. | |
| DISPLAYID | Alphanumeric | Display ID has a maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| STATUS | ‘Active’ or 1 ‘In Development’ or ‘Draft’ or 2 ‘Field Testing’ or 3 ‘Inactive’ or 4 | Status ‘x’ is invalid. | When set, SUBSTATUS is also required to be set. | |
| SUBSTATUS | Valid Values (depends on Status and Bank type): L&C Status ‘Active’ ‘Active’ or 1 Status ‘In Development’ ‘New’ or 2 ‘CPS and SME Reviewed’ or 3 ‘Held for Review’ or 4 Status ‘Field Testing’ ‘Field Testing’ or 5 Status ‘Inactive’ ‘Inactive’ or 6 TR Status ‘Active’ ‘Level 1’ or 1 ‘Level 2’ or 2 ‘Level 3’ or 3 ‘Level 4’ or 4 ‘Clone’ or 5 Status ‘In Development’ ‘New’ or 0 ‘Level 1’ or 1 ‘Level 2’ or 2 ‘Level 3’ or 3 ‘Level 4’ or 4‘ ‘Clone’ or 5 ‘Held for Review’ or 6 Status ‘Field Testing’ ‘Field Testing’ or 7 Status ‘Inactive’ ‘New’ or 0 ‘Level 1’ or 1 ‘Level 2’ or 2 ‘Level 3’ or 3 ‘Level 4’ or 4‘ ‘Clone’ or 5 ‘Held for Review’ or 6 | Substatus ‘x’ is invalid. | When set, STATUS is also required to be set. | |
| ENABLED | ‘False’ or 0 ‘True’ or 1 | ENABLED must be 0, 1, True or False | ||
| GROUPID | Numeric ‘’ (empty) | Item Group must be numeric Item Group x is not setup within the Bank | GroupID must exist and within the selected Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| GROUPSEQUENCE | Numeric ‘’ (empty) | Item Group Sequence must be numeric | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| DISPLAYTYPE | 1, 2, 3, 4, 5 | Display Type must be 1, 2, 3, 4, 5 1 = 4 Option 2 = 5 Option 3 = True/false (2 Option) 4 = Constructed Response (0 Option) 5 = 3 Option | ||
| AUTHORID | Numeric ‘’ (empty) | Author ID must be numeric Author x is not setup within the parent Bank | AuthorID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| COMPETENCYID | Numeric ‘’ (empty) | Competency ID must be numeric Competency x is not setup within the parent Bank | CompetencyID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| COPYRIGHTID | Numeric ‘’ (empty) | Copyright ID must be numeric Copyright x is not setup within the parent Bank | CopyrightID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEIFSKIPPED1</color> | Numeric ‘’ (empty) | VALUEIFSKIPPED1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEIFSKIPPED2</color> | Numeric ‘’ (empty) | VALUEIFSKIPPED2 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEIFSKIPPED3</color> | Numeric ‘’ (empty) | VALUEIFSKIPPED3 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEIFSKIPPED4</color> | Numeric ‘’ (empty) | VALUEIFSKIPPED4 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEIFSKIPPED5</color> | Numeric ‘’ (empty) | VALUEIFSKIPPED5 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEOTHER1</color> | Numeric ‘’ (empty) | VALUEOTHER1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEOTHER2</color> | Numeric ‘’ (empty) | VALUEOTHER1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEOTHER3</color> | Numeric ‘’ (empty) | VALUEOTHER1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEOTHER4</color> | Numeric ‘’ (empty) | VALUEOTHER1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>VALUEOTHER5</color> | Numeric ‘’ (empty) | VALUEOTHER1 ID must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>WEIGHTING</color> | Numeric ‘’ (empty) | WEIGHTING must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| ANGOFF1 | Numeric ‘’ (empty) | ANGOFF1 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| ANGOFF2 | Numeric ‘’ (empty) | ANGOFF2 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| ANGOFF3 | Numeric ‘’ (empty) | ANGOFF3 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>ITEMVALUEMAX</color> | Numeric ‘’ (empty) | ITEMVALUEMAX must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>ITEMVALUEDEFAULT</color> | Numeric ‘’ (empty) | ITEMVALUEDEFAULT must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>ITEMPASS</color> | Numeric ‘’ (empty) | ITEMPASS must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color red>ITEMPASSTYPE</color> | 0, 1, 2 | Item Pass Type must be 0, 1, 2. | ||
| <color red>ITEMROUNDTYPE</color> | 0, 1, 2 | Item Round Type must be 0, 1, 2. | ||
| <color red>ITEMMUSTPASS</color> | ‘False’ or 0 ‘True’ or 1 | ENABLED must be 0, 1, True or False | ||
| ITEMTIME | Numeric ‘’ (empty) | ITEMTIME must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). This field is only used for Online testing. It otherwise has no impact on Item Writing or Marking Center Exams. | |
| EFFECTIVEDATE | Date | Effective Date must be valid format. Effective and Expiry Dates | Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’) | |
| EXPIRYDATE | Date | Expiry Date must be valid format. Effective and Expiry Dates | Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’) | |
| CUSTOM01 | Alphanumeric | CUSTOM01 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM02 | Alphanumeric | CUSTOM02 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM03 | Alphanumeric | CUSTOM03 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM04 | Alphanumeric | CUSTOM04 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM05 | Alphanumeric | CUSTOM05 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM06 | Alphanumeric | CUSTOM06 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM07 | Alphanumeric | CUSTOM07 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM08 | Alphanumeric | CUSTOM08 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM09 | Alphanumeric | CUSTOM09 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM10 | Alphanumeric | CUSTOM10 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM11 | Alphanumeric | CUSTOM11 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM12 | Alphanumeric | CUSTOM12 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM13 | Alphanumeric | CUSTOM13 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM14 | Alphanumeric | CUSTOM14 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM15 | Alphanumeric | CUSTOM15 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM16 | Alphanumeric | CUSTOM16 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM17 | Alphanumeric | CUSTOM17 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM18 | Alphanumeric | CUSTOM18 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM19 | Alphanumeric | CUSTOM19 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CUSTOM20 | Alphanumeric | CUSTOM20 has maximum length of 50 characters. | Value must be ⇐ 50 characters. If nothing entered, will replace existing values with blanks. | |
| CLIENTCODE | Alphanumeric ‘’ (empty) | CLIENTCODE has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| ACCOUNT | 0, 1, 2 | Account must be 0, 1, 2. | ||
| MATRIX | Alphanumeric ‘’ (empty) | MATRIX has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| CLONE | Alphanumeric ‘’ (empty) | CLONE has maximum length of 255 characters. | Value must be ⇐ 255 characters. If nothing entered, will replace existing values with blanks. | |
| NOTNEAR | Alphanumeric ‘’ (empty) | NOTNEAR has maximum length of 255 characters. | Value must be ⇐ 255 characters. If nothing entered, will replace existing values with blanks. | |
| NOTWITH | Alphanumeric ‘’ (empty) | NOTWITH has maximum length of 255 characters. | Value must be ⇐ 255 characters. If nothing entered, will replace existing values with blanks. | |
| STATSEVALUATION | Alphanumeric ‘’ (empty) | STATSEVALUATION has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| VENDORTRANSFER | Alphanumeric ‘’ (empty) | VENDORTRANSFER has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| TEMPORARYTAG1 | Alphanumeric ‘’ (empty) | TEMPORARYTAG1 has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| TEMPORARYTAG2 | Alphanumeric ‘’ (empty) | TEMPORARYTAG2 has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| TEMPORARYSETTAG | Alphanumeric ‘’ (empty) | TEMPORARYSETTAG has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| KEYWORD | Alphanumeric ‘’ (empty) | KEYWORD has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| KSA | Alphanumeric ‘’ (empty) | KSA has maximum length of 255 characters. | Value must be ⇐ 255 characters. If nothing entered, will replace existing values with blanks. | |
| ITEMTITLE | Alphanumeric ‘’ (empty) | ITEMTITLE has maximum length of 255 characters. | Value must be ⇐ 255 characters. If nothing entered, will replace existing values with blanks. | |
| ITEMTEXT | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| OPTIONTEXT1 | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| OPTIONTEXT2 | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| OPTIONTEXT3 | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| OPTIONTEXT4 | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| OPTIONTEXT5 | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| ANSWER | ‘A’ or 1 ‘B’ or 2 ‘C’ or 3 ‘D’ or 4 ‘E’ or 5 ‘’ (empty) | Answer is Invalid. Must be A-E or 1-5. | Sets the Item OptionCorrect value to ‘True’ and it’s OptionValue value to 1. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONCORRECT1</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | CORRECT must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONCORRECT2</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | CORRECT must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONCORRECT3</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | CORRECT must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONCORRECT4</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | CORRECT must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONCORRECT5</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | CORRECT must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONVALUE1</color> | Numeric ‘’ (empty) | OPTIONVALUE1 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONVALUE2</color> | Numeric ‘’ (empty) | OPTIONVALUE2 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONVALUE3</color> | Numeric ‘’ (empty) | OPTIONVALUE3 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONVALUE4</color> | Numeric ‘’ (empty) | OPTIONVALUE4 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONVALUE5</color> | Numeric ‘’ (empty) | OPTIONVALUE5 must be numeric. | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONENABLED1</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | ENABLED must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONENABLED2</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | ENABLED must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONENABLED3</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | ENABLED must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONENABLED4</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | ENABLED must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONENABLED5</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | ENABLED must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONDONOTSCRAMBLE1</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | DONOTSCRAMBLE must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONDONOTSCRAMBLE2</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | DONOTSCRAMBLE must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONDONOTSCRAMBLE3</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | DONOTSCRAMBLE must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONDONOTSCRAMBLE4</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | DONOTSCRAMBLE must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| <color green>OPTIONDONOTSCRAMBLE5</color> | ‘False’ or 0 ‘True’ or 1 ‘’ (empty) | DONOTSCRAMBLE must be 0, 1, True or False | Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| RATIONALE | Alphanumeric ‘’ (empty) | If nothing entered, will replace existing values with blanks. | ||
| ATTACHMENTID | Numeric ‘’ (empty) | Attachment ID must be numeric Attachment x is not setup within the parent Bank | AttachmentID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| REF1ID | Numeric ‘’ (empty) | REF1ID must be numeric REF1ID x is not setup within the parent Bank | REF3ID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| REF1SECTION | Alphanumeric | REF1SECTION has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| REF1PAGE | Alphanumeric | REF1PAGE has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| REF1DIAGRAM | Alphanumeric | REF1DIAGRAM has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| REF2ID | Numeric ‘’ (empty) | REF2ID must be numeric REF2ID x is not setup within the parent Bank | REF3ID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| REF2SECTION | Alphanumeric | REF2SECTION has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| REF2PAGE | Alphanumeric | REF2PAGE has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| REF2DIAGRAM | Alphanumeric | REF2DIAGRAM has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| REF3ID | Numeric ‘’ (empty) | REF3ID must be numeric REF3ID x is not setup within the parent Bank | REF3ID must exist and within the selected parent Bank. Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). | |
| REF3SECTION | Alphanumeric | REF3SECTION has maximum length of 25 characters. | Value must be ⇐ 25 characters. If nothing entered, will replace existing values with blanks. | |
| REF3PAGE | Alphanumeric | REF3PAGE has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
| REF3DIAGRAM | Alphanumeric | REF3DIAGRAM has maximum length of 20 characters. | Value must be ⇐ 20 characters. If nothing entered, will replace existing values with blanks. | |
Sample Simple MCQ
Notes
- Have included only some of the fields from above.
- Rationale, which supports rich text allows for bold and underline.
- Dichotomous MCQ so am including Option1Text..Option4Text, but not the OptionxCorrect or OptionXValue.
| Status | Active |
| Substatus | Level 4 |
| CompetencyID | 37 |
| Angoff1 | .5 |
| Jurisdiction | California and Arizona |
| NotNear | 27, 28 and 35 |
| Keyword | Pets, cat, dog |
| KSA | 2-a-1 |
| ItemTitle | A Question about pets |
| ItemText | What is your favorite house pet? |
| Rationale | Sample type question |
| Option1Text | Cat |
| Option2Text | Dog |
| Option3Text | Fish |
| Option4Text | Bird |
| Answer | B |
| Ref1ID | 26 |
| Ref1Section | 2 |
| Ref1Page | 1-8 |
