This lesson will guide you through exporting or moving assessment scores from one New 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
- Go to the Reports tab in the assessment.
- Select the Student Responses report.
- 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
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.
- A pop-up will appear and the file will be saved to your computer.
Access the Import Page for the Correct Assessment
- Access the new assessment.
- Select the Administer tab.
- Select Import.
Upload Your File
- Select the file delimiter that matches your file (Comma, Tab, Semicolon, or Colon).
- Select Choose File. Select the file from your computer.
- Select Upload.
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.
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).
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 a NEW Item Bank Assessment.
After importing assessment scores, view your results using any of our Assessment Prebuilt Reports.