Importing statistical analysis results in the item bank

This feature needs to be enabled by an administrator. Please contact your administrator if you want to use it.

This feature allows admins to import the results of a statistical analysis from a CSV file into items or tests in the Content Bank. Each value resulting from the analysis (difficulty, discrimination…) will be set as a property on the corresponding items or test.

Create the properties to host the data

Navigate to the Content Bank (authoring) from the main menu in the TAO Portal.
Select the item/test folder where you want the properties to be defined and select Manage Schema. This will bring up Manage item class schema form that shows the Metadata properties set for all the Items in that class.
Select Add Property.
Click the Edit icon (pencil) to edit the property.
Configure the following property attributes:
1. Label: Enter the new name (to be changed from Property_X). This field is required. Example: “Item difficulty”.
2. Alias: This field is used as an alternative to the label, to be able to differentiate between various resources which have the same name (in Search, for example). An alias is required to be able to reference the property in the CSV file. Example: “difficulty”.
3. Is language dependent? : This indicates if the value of this field can be translated (the default is false).
4. Is statistical? : Only properties flagged as statistical (“true”) can have their value set by the CSV import. They are read only from the user interface.
5. Form Field Order: This defines the position of the new Property in the list of all the properties pertaining to that item. Use number values for this field.
6. Validation Rules: Default is empty. If this is checked, that property value cannot be empty for a given resource. It enforces validation, checking that there is a value set for it.
7. Type: This is important as it describes how the Property is defined and modified from each individual item (within the class). Example: “Text - Short - Field”.
Click Save.
Repeat for all needed properties

Create the CSV file

Add rows (or selection fields) to the table in a plain text file or table and populate with your information according to the entities defined in each column.
Save or export the document as a CSV file.

Sample CSV

TEXT

itemId;testId;metadata_guessing;metadata_discrimination;metadata_difficulty
https://lutpr01sbp.eu.premium.taocloud.org/#i171162678612366335;1;2;3

The top line or row designates the entities for which you will enter values according to each item class or test.

The CSV file must contain the following columns/entities:

Column

Type

Description

testId

string

The test’s full Reference Identifier URL, which can be found in the test’s general Properties (when the test is selected from the test bank). This value designates on which item to set the properties values. This field is only valid if the itemId value is not provided.

itemId

string

The item’s full Reference Identifier URL, which can be found in the item’s general Properties (when the item is selected from the item bank). This value designates on which item to set the properties values. This field is only valid if the testId value is not provided.

metadata_{alias}

string|numeric

The Property value. The value of the {alias} field should match the Alias defined on the target property, for example metadata_difficulty.

There can be as many property values (alias columns) as needed (see example).

Import the CSV file

From the Settings menu (gear icon in the top right) in the Content Bank, select Import statistical analysis metadata.
Select the CSV file and click Import.

Update

The import CSV action can be used as needed to assign and update the value of any property (metadata) flagged as statistical.