AIMSWEB Extract Procedure for Auto-Upload

Extracting the Data:

1. Login Page https://aimsweb.pearson.com
2. Enter customer ID, Username, Password
3. Select the Manage tab
4. Select Data Exports in the left navigation pane
5. Select Schedule Exports tab
6. Click Create New Export button
7. Enter the file name  (e.g. districtname_2013-2014_Fall-Winter_AIMSWEB.csv).  
   • Note:   AIMSWEB uses a different naming convention than OSPI’s EDS.  “2013” in the AIMSWEB default file name is a 2013-2014 school year data file.  EDS files with 2013 in the default file name are 2012-2013 data files.
8. Make sure comma delimited has been selected
9. Under Export Schedule and Frequency, leave default to one time (should default to current date)
10. For a district-wide export, choose export all data
11. Under Data to Export, select Student, Teacher, Class and Score Data
12. Check the Include Transferred Students box
13. Select the Benchmark/Strategic Monitoring Period(s)
14. Skip the National Percentiles, ROIs, and SGPs sections
15. Skip the option to email file and click Export
16. Return to Manage tab to confirm export has been scheduled.  Generally, file will be available in 24 hours.
17. When ready, return to Data Exports in the navigation pane; in the Exports tab under Actions, select download to retrieve the report.
18. Before auto-loading, it is recommended to open the .csv score file and make sure that all IDs are of the same type.  Multiple types of IDs will prevent successful uploading.  Student IDs can be SSID, Other ID or External ID but all must be of the same type in the file to be successfully uploaded. 

Auto-Uploading the File:

1. Log into Homeroom Admin
2. Select Uploads>>>Upload Assessment Scores>>>Automatic Score Loader / Review Uploads
3. From the Select Loader drop-down, choose “AIMSWeb”
4. From the Required Parameters, Student Identifier drop-down, select the type of student ID used in your file to upload
5. From the Select Assessment Score File(s) to Upload, navigate to the .csv file you saved in Step 3 above and choose the file
6. Submit for validation
7. Once validated, select Approve from the Review Uploads sections. You will also receive an email notification.