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.
To import data, you need to create a place to store and import the data. Make sure to have opened a previously created Summary Assessment or create a new one.
- Create Columns for the data you are expecting to import. Ideally to match the column headers of your data.
- Use your data file to guide you on the Columns you need to create.
- While the Column Name doesn't have to match, it is helpful in Step 5.
- Make sure to select the correct Column Type, which is how the data will be stored once imported into Illuminate.
- Select Save.
But what about Student ID or Name? No need. Since student data is in Illuminate already, there is no need to create a column for it. That will automatically be attached to the data by means of your imported 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
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.
The file must contain a column with Student or Local Student ID.
1. Click Responses.
2. Select Import Student Data from a 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.
- Your file columns should line up with your report columns. Since your naming convention may be a match, 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, you may select a different column if you want to change the order/association. Note that you must designate one of your file columns as the Student ID column.
- 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.
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.
Summary Assessments are a great way to add to data to your students story.