State Data Extract Procedure for Auto-Upload: SPSS Text File (HSPE, MSP, DAPE, EOC, SBA, WA-AIM)

Extract data from OSPI’s EDS website: https://eds.ospi.k12.wa.us/Login.aspx

1. Sign-in to your EDS account.
2. Click My Applications on the menu bar.
3. Choose Washington Query from the list.
4. Choose your school district from the Organization drop down list.
5. Choose the school year from the School Years drop down list.

6. Choose the administration of the test from the Administration drop down list. Click Next.

   Note: If you’re downloading multiple data versions it is very important that you click Next each time you choose a new data version.

7. Select the SPSS 'Text File' link to download the file.  (NOT the SPSS Syntax link)
8. Save the file with a descriptive naming convention such as the following::
   • {SchoolDistrictName}_{time period covered}_{assessment}.txt
   • Toppenish School District_12-13_State.txt

Auto Load

1. Log into Data Admin: [yourdistrictname].schooldata.net/admin
2. Select Uploads>Upload Assessment Scores>Automatic Score Loader / Review Uploads
3. From the Select Loader drop-down, choose the appropriate school year "OSPI SPSS File Loader"
4. *From the Required Parameters drop-down, choose the Administration term (August, November, Winter, Spring) that corresponds to the term of the file being loaded.  If ‘Do Not Use an Administration’ is selected, there will be no administration associated to the scores.   Related Article: https://sdshelpdesk.zendesk.com/entries/41921418-SPSS-File-Auto-Loader-Test-Administration-Selector  *(May not apply to ALL Loaders). NOTE: This only applies up to the 14-15 SPSS File Loader. Later years do not have the Administration term selector.
5. From the Select Assessment Score File(s) to Upload, navigate to the .txt file you saved in Step 8 and choose the file
6. Submit for validation.
7. Review validation report and click 'approve' to load the file.

(Updated January 26, 2017 AM)