Exporting and interpreting CSV session results

TAO Portal provides a beta version of a feature that 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.

Enabling CSV results

Follow the instructions in Customizing an account in the TAO Portal | Enabling-beta-features. Make sure the CSV results option is saved before you save your changes.

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.

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, and are described in datastoreDeliveryResults (with the exception of lti_Parameters.name).

• login

• lti_Parameters.name: The name of the test taker.

• score

• maxScore

• outcomes

  • SCORE_TOTAL_MAX

  • SCORE_RATIO

  • SCORE_TOTAL

• sessionStartTime

• sessionEndTime

• items

  • qtiTitle

  • qtiLabel

  • statusCorrect

  • responses

    • RESPONSE_x_correct

    • RESPONSE_X_value

  • duration

  • outcomes

    • SCORE

    • MAXSCORE

    • completionStatus

    • OUTCOME_x - like wordchoice