This is an old revision of the document!
Item Import Notes
requires more copy editing
wiki colour insensitive. All colour cells must be changed to x or xx type references
more ties back to item, attachment, reference, author, copyright, etc.
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 (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) Items (4 option, 5 option, true/false) (link glossary item type), 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 pink highlighted 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 yellow highlighted 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 yellow highlighted fields.
Essay/Constructed Response/Rater Items
For non-mcq type Items you will want to include some or all of the pink 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 | Display Type must be 1, 2, 3, 4. | ||
| 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). | |
| VALUEIFSKIPPED1 | 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). | |
| VALUEIFSKIPPED2 | 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). | |
| VALUEIFSKIPPED3 | 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). | |
| VALUEIFSKIPPED4 | 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). | |
| VALUEIFSKIPPED5 | 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). | |
| VALUEOTHER1 | 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). | |
| VALUEOTHER2 | 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). | |
| VALUEOTHER3 | 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). | |
| VALUEOTHER4 | 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). | |
| VALUEOTHER5 | 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). | |
| WEIGHTING | 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). | |
| ITEMVALUEMAX | 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). | |
| ITEMVALUEDEFAULT | 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). | |
ITEMPASS Valid Values:
- Numeric
- ‘’ (empty)
Errors: - ‘ITEMPASS must be numeric.’
Rules: - Empty cell represents ‘do nothing’ (A new item receives the default value and an update will not replace the existing value). ITEMPASSTYPE Valid Values: - 0 - 1 - 2
Errors: - ‘Item Pass Type must be 0, 1, 2.’
Rules:
ITEMROUNDTYPE Valid Values: - 0 - 1 - 2
Errors: - ‘Item Round Type must be 0, 1, 2.’
Rules:
ITEMMUSTPASS ITEMTIME Valid Values: - Numeric - ‘’ (empty)
Errors: - ‘ITEMTIME must be numeric.’
Rules: - 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 Valid Values: - Date
Errors: - ‘Effective Date must be valid format.’
Rules: - Value must be in format YYYY-MM-DD (e.g. ‘2016-01-01’) EXPIRYDATE Valid Values: - Date
Errors: - ‘Expiry Date must be valid format.’
Rules: - 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). |
| OPTIONCORRECT1 | ‘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). |
| OPTIONCORRECT2 | ‘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). |
| OPTIONCORRECT3 | ‘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). |
| OPTIONCORRECT4 | ‘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). |
| OPTIONCORRECT5 | ‘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). |
| OPTIONVALUE1 | 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). |
| OPTIONVALUE2 | 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). |
| OPTIONVALUE3 | 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). |
| OPTIONVALUE4 | 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). |
| OPTIONVALUE5 | 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). |
| OPTIONENABLED1 | ‘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). |
| OPTIONENABLED2 | ‘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). |
| OPTIONENABLED3 | ‘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). |
| OPTIONENABLED4 | ‘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). |
| OPTIONENABLED5 | ‘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). |
| OPTIONDONOTSCRAMBLE1 | ‘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). |
| OPTIONDONOTSCRAMBLE2 | ‘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). |
| OPTIONDONOTSCRAMBLE3 | ‘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). |
| OPTIONDONOTSCRAMBLE4 | ‘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). |
| OPTIONDONOTSCRAMBLE5 | ‘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). |
fixme NOTES RATIONALE Valid Values: - Alphanumeric - ‘’ (empty)
Errors:
Rules: - If nothing entered, will replace existing values with blanks. ATTACHMENTID Valid Values: - Numeric - ‘’ (empty)
Errors: - ‘Attachment ID must be numeric’ - ‘Attachment x is not setup within the parent Bank’
Rules: - 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 Valid Values: - Numeric - ‘’ (empty)
Errors: - ‘REF1ID must be numeric’ - ‘REF1ID x is not setup within the parent Bank’
Rules: - REF1ID 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 Valid Values: - Alphanumeric
Errors: - ‘REF1SECTION has maximum length of 25 characters.’
Rules: - Value must be ⇐ 25 characters. - If nothing entered, will replace existing values with blanks. REF1PAGE Valid Values: - Alphanumeric
Errors: - ‘REF1PAGE has maximum length of 20 characters.’
Rules: - Value must be ⇐ 20 characters. - If nothing entered, will replace existing values with blanks. REF1DIAGRAM REF2ID Valid Values: - Numeric - ‘’ (empty)
Errors: - ‘REF2ID must be numeric’ - ‘REF2ID x is not setup within the parent Bank’
Rules: - REF2ID 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 Valid Values: - Alphanumeric
Errors: - ‘REF2SECTION has maximum length of 25 characters.’
Rules: - Value must be ⇐ 25 characters. - If nothing entered, will replace existing values with blanks. REF2PAGE Valid Values: - Alphanumeric
Errors: - ‘REF2PAGE has maximum length of 20 characters.’
Rules: - Value must be ⇐ 20 characters. - If nothing entered, will replace existing values with blanks. REF2DIAGRAM REF3ID Valid Values: - Numeric - ‘’ (empty)
Errors: - ‘REF3ID must be numeric’ - ‘REF3ID x is not setup within the parent Bank’
Rules: - 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 Valid Values: - Alphanumeric
Errors: - ‘REF3SECTION has maximum length of 25 characters.’
Rules: - Value must be ⇐ 25 characters. - If nothing entered, will replace existing values with blanks. REF3PAGE Valid Values: - Alphanumeric
Errors: - ‘REF3PAGE has maximum length of 20 characters.’
Rules: - Value must be ⇐ 20 characters. - If nothing entered, will replace existing values with blanks. REF3DIAGRAM
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 |
