Export Assessment Scores and Import into a New Assessment in Item Bank Assessments – DnA & ISE

This lesson will guide you through exporting or moving assessment scores from one Item Bank assessment to another. This is useful when teachers accidentally enter data or administer the wrong assessment, and the student scores need to be moved to the correct assessment.

Access the Student Responses Report

The ELA Benchmark 1 assessment open to the Reports tab (1) and the Student Response Report highlighted (2).

Go to the Reports tab in the assessment.
Select the Student Responses report.

The Overview tab (3) of the ELA Benchmark 1 assessment open at the Average % Correct highlighted (4).

Select the Overview tab in the assessment.
Select the blue Average % Correct. This will also take you to the Student Responses report.

Download / Export Your Data File

The Student Response Report open with the download options of Excel (5) and Text (6) download options highlighted.

Scroll down to the section Download Raw Student Response Data. You have two export options:

Select the Excel Student Response option if you plan to make changes to your file, then re-save the file as a Comma, Tab, Semicolon, or Colon-delimited file.
Select the Tab-delimited Student Response option if you do not plan to make changes to your file.

The Student Responses Download pop up displaying that responses are loading.

A pop-up will appear and the file will be saved to your computer.

Access the Import Page for the Correct Assessment

The Administer tab of the New Item Bank Assessment open with Import highlighted in the middle column.

Access the new assessment.
Select the Administer tab.
Select Import.

Upload Your File

The Import page open of the New Item Bank Assessment with a dropdown menu to choose a delimiter (4), a choose file option (5), and upload button (6).

Select the file delimiter that matches your file (Comma, Tab, Semicolon, or Colon).
Select Choose File. Select the file from your computer.
Select Upload.

The Import Responses menu with drop downs available to map columns from the file to the new assessment.

Map the columns in your file to the columns in the assessment:

Select your Local Student ID column in the Student ID field.
Select your Date Taken column if your file contains this data. If your file does not contain a Date Taken date, choose your default Date Taken date.
Select one column of response data (typically Question 1) as the First Student Response Column.
Check that your columns are mapped appropriately, then Select Import.

After pressing Import, you will be re-directed to the Student Responses report and see the above message. Refresh the page and scroll down to verify student scores are visible.

Troubleshooting Tips and Tricks

It seems like I have duplicate student records. What do I do?

What if a student ID is listed twice on the same file, but the data differs between the two records?

The same student can only have one set of answers for an assessment. Thus, if you accidentally upload a file that features the same student ID multiple times (but with different response data), the last record on the file will be added, overriding any previous records (for example, data on row 23 for Student ID #12345 will override data on row 12 for Student ID #12345).

What do I do with the data in the original assessment?

You can keep the data in the original assessment if there are constructed response questions. Student constructed responses entered via online testing cannot be moved from one assessment to another at this time. Otherwise, you can delete the student scores from the original assessment by viewing the guide Delete Student Data from an Assessment.

Next Steps

After importing assessment scores, view your results using any of our Assessment Prebuilt Reports.