Datastore Item Results

This topic lists Date Explorer and API fields (and their descriptions) associated with items. The fields described in this topic are considered to be the most meaningful when performing a query of this data - not all fields returned with a query are listed.

Delivery / Test level data

`isDeleted`

The value of this API field is always set to false, as only the most recent delivery results currently display.

If the same delivery has been taken multiple times by the test taker, previous results are marked as isDeleted=true.

This field is only valid if you are launching the delivery via LTI with multiple attempts parameter. For more information, see Custom parameters (delivery launch).

Identification fields

Data Explorer	API	Description
	CODE `metadata: { label: }`	The label of the test, which can be found in the Label field in Test Properties.
Delivery Id	`deliveryId`	Delivery identifier as provided by the delivery tool.
Test Qti Id	`testQtiId`	The Identifier for the test, which can be viewed and changed from the general properties panel in test authoring.
Test Qti Label	`testQtiLabel`	The label provided for a test in the Test properties form.
Full Test Resource Id	`fullTestResourceId`	The Resource Identifier located in the delivery’s Properties panel.
Login	`login`	The test taker’s ID/username (not name).
Delivery Execution Id	`deliveryExecutionId`	Unique identifier for the delivery execution (the session for a given test taker/delivery combination).
Message Id	`messageId`	The unique identifier for a message or transaction between the client and the API.
Tenant Id	`tenantId`	The unique identifier for the TAO environment on which the delivery was executed.

Scoring

Data Explorer

API

Description

cutScoreRatio

If a cut score is configured for the test, the percentage of the cut score (a cut-off point for passing the test) achieved by the test taker’s score will display. This percentage is displayed as a decimal value. If no cut score is defined for the test, the value of this field will be null. For more information, see Configuring scoring for tests.

score

The amount of points achieved by the test taker, if defined by the test scoring. The value of this field should match the value of SCORE_TOTAL in outcomes.

Total Max Score

Cut Score Threshold

Total Score

CODE

outcomes:{
SCORE_TOTAL_MAX:
SCORE_RATIO:
SCORE_TOTAL:
}

Any scoring outcome defined on the test level (in Test authoring) will be listed here. For more information, see Configuring scoring for tests.

Total Max Score	CODE `SCORE_TOTAL_MAX`	The maximum score defined for the test.
Cut Score Threshold	CODE `SCORE_RATIO`	The total score achieved by the test taker divided by the maximum possible score). This value should be a decimal number between 0 and 1.
Total Score	CODE `SCORE_TOTAL`	Total score from the given test taker for the test.

Timestamps

Data Explorer	API	Description
Session End Time	`sessionEndTime`	The time that the test was submitted (provided as a unix timestamp).
Last_update_date	`lastUpdateDate`	The date the session was last updated (provided as a unix timestamp). For tests with manual scoring, this value will display the time at which scoring was completed. Until all manual scoring is performed (if any), the value of this field should be the same as the `sessionEndTime`.
Publication Time	`publicationTime`	The exact time the delivery was published (provided as a unix timestamp).

Item level data

Item fields

This section lists each item in the test individually with details about the item, and how the test taker responded to it in the test.

Data Explorer	API	Description
Item Id	Listed first after CODE `items: { }`	Each item’s reference ID, which can be found in the item’s general properties in Test authoring.
Num Attempts	`numAttempts`	How many times the item was seen (or attempted) by the test taker. Only the last attempt’s results are displayed and taken into account for the item’s scoring.
	`metadata`	The metadata defined for an individual item `label`: The label of the item in the Item properties (in the Edit Item form). Metadata properties (`propertyLabel`), such as subject matter, are listed here with each property name and the value assigned to the given item.
Full Item Resource Id	`fullItemResourceId`	The item’s Identifier, which can be found in the Item Properties (in Item authoring).
Status Correct	`statusCorrect`	Whether the item’s score was correct, false, partially correct, or skipped.
Qti Title	`qtiTitle`	The title of the item in the Item Properties (in Item authoring).
Max Score	`maxScore`	The maximum score available for the item.
Submission Time	`submissionTime`	The exact time the answer to the item’s question was submitted. This time is provided as a unix timestamp.
Qti Id	`qtiId`	The Identifier, which can be viewed and modified in the Item’s Properties (in item authoring).
Qti Label	`qtiLabel`	The label of the item in the Item properties (in the Edit Item form).
Duration	`duration`	The duration value reflects the time (in seconds) a test taker spent on a given item. The duration value excludes the time the item took to load and become available, as well as any time a test taker had their session paused.
Score	`score`	The score achieved by the test taker for the particular item.
Item End Time	`itemEndTime`	The exact time the item was completed/submitted by the test taker (for linear tests) or last interacted with (for non-linear tests). This time is provided as a unix timestamp.
Item Start Time	`itemStartTime`	The exact time the test taker opened the item in the test for the first time. This value is provided as a unix timestamp.
Completion Status	CODE `outcomes: { SCORE: MAXSCORE: completionStatus: }`	In API results, all outcomes defined on the item will be listed here (especially the ones defined for manual scoring). Completion Status: The completion status of the item. The possible values are `incomplete`, `not_attempted`, `unknown`, or `completed`. `not_attempted` means the item was seen but no response was given. `completed` means the item was seen and a response was given. `unknown` and `incomplete` display when an item was not seen by the test taker. In API results, SCORE AND MAXSCORE will display repeated values.
	`responses`	`RESPONSE_x` : This value is the response identifier of all the interactions defined in the current item. It is editable from the item authoring screen. If you have multiple interactions in an item, you will have multiple entries here. `correct`: Whether or not the test taker’s answer was correct. `value`: The value provided by the test taker for the interaction. For information on the format of the `baseType` value as an interaction response, see the table below.
Manually Graded	`manuallyGraded`	Displays if a manually scored item has been scored or not. This value will display as `true` if the item has been scored, and `false` if it is awaiting scoring.
Manually Graded At	`manuallyGradedAt`	The time an item was manually graded (if applicable). This value is provided as a unix timestamp. It will display as `null` if the item is awaiting scoring.