This lesson will guide you through importing a file into a Summary Assessment or Demographic. This is useful for adding outside data into Illuminate such as attendance, assessment scores, etc. To learn how to create a summary assessment, see the lesson Create, Edit, or Delete a Summary Assessment or Demographic.
Note: The file size limit is 60 MB for a single upload. If your file is larger than 60 MB, please split your original file into smaller files.
Where to Start
1. Click the Assessments tab.
2. Under General, click View Assessments.
3. Click on the title of your summary assessment to open it.
You can import student response data into an assessment using a file that contains their data and their local student ID or state student ID (SSID) numbers. Your file needs to be in one of these formats:
- Comma Delimited
- Tab Delimited
- Semicolon Delimited
- Colon Delimited
Here (above) is an example of what my Excel/.xls file looked like before I turned it into a Tab Delimited file by opening the file, clicking File, selecting Save As, and selecting the new file format from the Save As Type drop down menu. Notice that I widened my columns sufficiently in the initial file so that none of my data will "jump columns" during the transfer. Also note that my file contains a column with Student ID data.
1. Click Responses.
2. Select Import Student Data from a File.
3. Select the file delimiter that matches your file (Comma, Tab, Semicolon, or Colon).
4. Choose importing option: Summary assessments have the ability to contain multiple rows of data per student. If you update student data, you are updating the existing records. If you add student data, you are adding a new row of data.
5. Choose student identifier: Select your import option based on the Student ID in your file.
6. Click Choose File. Select the file from your computer.
7. Click Upload File.
8. Your file columns should line up with your report columns appropriately. However, you may select different columns if you want to change the order/association. Note that you must designate one of your file columns as the Student ID column.
9. After making sure that your columns are paired appropriately, click Import.
10. You will receive the above message after your import starts.
If you also see the above message, revisit the Determine Columns step, as you might have accidentally created a Student ID column or you might have selected a wrong column format.
Verify that your data imported successfully by doing the following:
1. Check the number of records by going to the Overview page, then checking the # Records field.
2. Go to the Student Responses page.
1. Click the Overview tab.
2. Review the # Records count.
Want to add your summary assessment data to a custom report? See the lesson Add Columns or Data to a Custom Report if you would like to learn more.