Skip to main content
Skip table of contents

Exporting and interpreting CSV session results

TAO Portal allows you to download a session’s results in a CSV file. This topic describes how to download a CSV file for a session’s results, and how to interpret the file.

Exporting the CSV results file

  1. Enter the session for which you want to obtain a results file.

  2. In top-right, select Export CSV. This will trigger the CSV file to be created in TAO.

    Export CSV button

    Export CSV button

  3. When the file is ready, select Download CSV in the green notification box. The CSV file containing the session’s results will now be available in your Downloads.

CSV file fields and descriptions

The fields listed below are present in the CSV session results file.

Session level fields

Field

Description

login

The test taker’s ID/username (not name).

lti_Parameters.name

The name of the test taker.

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.

maxScore

The maximum possible score for a delivery (test). The value of this field should match the value of SCORE_TOTAL_MAX in outcomes.

outcomes

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

  • SCORE_TOTAL_MAX: The maximum score defined for the test.

  • 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.

  • SCORE_TOTAL: Total score from the given test taker for the test. 

sessionStartTime

The exact time the test was started by the test taker (provided as a unix timestamp). 

sessionEndTime

The time that the test was submitted (provided as a unix timestamp). This will typically be the same value as submissionTime.

deliveryId

The delivery ID of the test.

deliveryLabel

The label provided for a delivery in the Delivery properties form. 

Item level fields

Field

Description

qtiTitle

The title of the item in the Item Properties (in Item authoring).

qtiLabel

The label of the item in the Item properties (in the Edit Item form).

statusCorrect

Whether the item’s score was correct, false, partially correct, or skipped. 

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.

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.

outcomes

All outcomes defined on the item will be listed here (especially the ones defined for manual scoring). An example of an outcome could be WORDCHOICE in a manually scored item.

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.

SCORE AND MAXSCORE will display repeated values.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.