(Updated Dec 30, 2014 11:17 am)

Extract and Upload Process for Pre Record Reconciliation WAMS Files 

Download the file:

1. Access your EDS account at:  https://eds.ospi.k12.wa.us.
2. Enter your username and password.
3. From the Home tab, select View My Applications.
4. From the application list, select Washington Assessment Management System (WAMS). 
5. Select the Profile tab.
6. From the menu on the left, select File Downloads.
7. From the current year administration of MSP-HSPE-DAPE-EOC, navigate to the Score Results section. There will be a file entitled: "{District Code District Name} SD HighSchool Scorefile {Date}.xls". Select it for download.
8. Open the file you downloaded and save it as a comma-separated value file (.csv) with a meaningful name.

Upload the scores:

1. Log in to Homeroom Admin.
2. Navigate to Uploads >> Upload Assessment Scores >> Automatic Score Loader / Review Uploads.
3. From the Select Loader dropdown, select "{School Year} OSPI Pre Record Reconciliation WAMS File Loader".  For Example: '2013-2014 OSPI Pre Record Reconciliation WAMS File Loader' is what you would see for the 2013/2014 school year loader.                                                                                                (**Note: if the loader does not indicate the current school year, please notify support@schooldata.net so we can update it.  Scores will be loaded to the school year indicated on the loader.)
4. Select Chose File, browse for the .csv file you saved above, then select Submit.
5. Once validated, select Approve from the Review Uploads sections. You will also receive an email notification. 

Once the reconciled files are released as an Administration in EDS Query, you may want to delete the WAMS score load before loading the released SPSS text file using the OSPI SPSS Autoloader.  This will prevent duplicate scores from appearing in your database and allow you to assign an Administration to the scores. 

Click Here for instructions on how to delete scores by data file upload id.

If you need assistance, please contact support@schooldata.net.