You can import a data file to any assessment created by you or created by someone who has given you the Can Administer permission for an assessment. Use the Import option in the assessment Administration tab to upload your data file.
Where to Start
1. Prepare Your Data File
You can import student response data into an assessment using a file that contains their answers (multiple choice items), rubric scores (constructed response and explicit constructed response items), and their local student ID numbers. Your file needs to be in one of these formats:
- Comma Delimited
- Tab Delimited
- Semicolon Delimited
- Colon Delimited
Keep in mind that you can typically turn another file type (such as Excel/.xls) into one of these formats (such as Tab Delimited) by opening the file, clicking File, selecting Save As, and selecting the new file format from the Save As Type drop down menu. Just be sure you widen your columns sufficiently in the initial file so that none of your data "jumps columns" during the transfer. Also, your file must contain one column with Student ID data.
2. Access the Import Page
- Click the Administer button.
- Click Import.
3. Upload Your File
- 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).
After importing assessment scores, view your results using any of our Assessment Prebuilt Reports.