This article will walk you through how to interpret the exported item responses file for deliveries. When the export is download is opened, it will be presented as a text file. It is more simple to read as an Excel document. This guide will also cover how to open the item responses file in Excel. This article assumes that you have already exported the file, if you need help exporting the file, see the following articles:
- How to Open the File as a Excel Document Using Windows
- How to Read Data in Excel
How to Open the File as a Excel Document Using Windows
1- Find the file in file explorer (probably in your downloads folder). Right click the file and hover you mouse over Open with.
2- If the Excel option appear click on that. If Excel does not appear, click on the Choose another app option.
3- Click on the Excel option. If the Excel option does not appear click on More apps, then choose Excel.
How to Read Data in Excel
Most of these columns are self explanatory, some of the columns are more difficult to understand. This list every column and gives a descriptions.
The delivery_id column is shows the delivery ID, which is the unique ID for deliveries in the database.
The item_id column shows the item ID, which is the unique ID for individual items in the database.
The item_name column shows the item name.
The item_version_name column shows the item name and version.
The score column shows the score received for the item. Score in Scorpion is a value between zero and one, which shows how correct the candidate was in the response. This will show decimals when partial scoring is set up, otherwise it will be a zero or a 1.
The manual_score column shows the modified score of the item.
The points column shows the possible amount of points for the item.
The total_seconds column shows the total amount of time in seconds the examinee used to answer the item.
The start column shows the time and date when the examinee was presented the item in UTC. If multiple items are presented on the same page during a exam, this time will be the same for all of the items on the page.
The end column shows the time the examinee was no longer presented the item in UTC. This end time will change if the examine goes back and look at items. This includes all items on a page.
The block_idx column shows the page number that the item was presented on.
The block_len column shows the number of items this item was presented with. per page
The is_excluded column shows whether a item is excluded from the scoring. This can be due to the item needing to be scored manually or was excluded manually from the scoring.
The item_idx column shows the order the item was presented on the exam.
The item_type column shows the item type.
The key column shows the correct responses as it relates to how they are presented in the Scorpion UI when editing the item.
Example for the second cell:
The option_score column is only for domc items and shows whether the candidate was right or wrong with 1 being right 0 being wrong with the response given.
The option_scores column shows the if the examinee got the option right for each option present.
The presented column shows the order the items options were presented in.
The response column shows the response the examinee choose.
The response_text column shows if applicable the text response the examinee gave when answering the item.
The status column shows if the item score was changed manually or if the item is not able to be automatically graded.
The group_id column shows the form section the item belongs to.
The delivery_score column shows the score on the delivery.
The delivery_passed column shows if the delivery was passed or not.
The form_id column shows the form ID, which is the unique ID for individual forms in the database.
The form_name column shows the form name in the ui.