This lesson will guide you through exporting or moving assessment scores from one 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.
If you would like to import or bring in outside scores into a new assessment in Illuminate, see the guide Import Student Response Data into a Flexible Assessment.
Where to Start
- Click the Reports tab in the assessment.
- Click the Student Responses report.
- Click the Overview tab in the assessment.
- Click the blue average % correct. This will also take you to the Student Responses report.
Scroll down to the section Download Raw Student Response Data. You have two export options:
- Click 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.
- Click 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 new assessment.
- Click the Administer tab.
- Click Import.
- Select the file delimiter that matches your file (Comma, Tab, Semicolon, or Colon).
- Click Choose File. Select the file from your computer.
- Click 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 click 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 Flexible Assessment.
After importing assessment scores, view your results using any of our Assessment Prebuilt Reports.