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.
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.
Prepare Your Import File
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
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.
The file must contain a column with Student or Local Student ID.
Where to Start
- Go to Assessments.
- Click View Assessments.
- Select the title of the Summary/Demographic assessment.
Access the Import Page
- Click Responses.
- Select Import Student Data from a File.
Select Your File
- Select the file delimiter that matches your file (Comma, Tab, Semicolon, or Colon).
- 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.
- Choose student identifier: Select your import option based on the Student ID in your file.
- Click Choose File. Select the file from your computer.
- Click Upload File.
Map Your File Columns / Import
- File columns should line up with your assessment columns. The tool will automatically match which columns of data you are importing into the matching column of the Summary Assessment.
- If necessary or a match isn't found, select a different column if you want to change the order/association.
- Click Import.
The above message will appear after the import starts.
Troubleshooting
Chances are you accidentally uploaded the wrong file type. Try uploading the file again or reviewing your original file, and saving it appropriately.
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.
Next Steps
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.