WELPA Extract Procedure for Auto Upload – School Data Solutions

Extract Data

Extract data from OSPI’s EDS website.

Sign-in to your EDS account.
Click My Applications on the menu bar.
Choose Washington Assessment Management System (WAMS) from the list.
Choose your school district from the Organization drop down list.
Select Profile on the top menu bar.
Select > File Downloads from the left menu.
Scroll down to target year for example: ‘2015 Administration’ and locate the assessment Score Files or Score Results. Select the link to the score files, this will download the file

Note: Usually the assessment is Item 5 in each school year.
Save the file as a CSV with a descriptive naming convention such as the following:
- {SchoolDistrictName}_{assessment}_{time period covered}.csv
- Toppenish SD_WELPA_1415.csv

Note: This process can be used for WELPA or WLPT-II

Log into Homeroom Admin
Select Uploads>Upload Assessment Scores>Automatic Score Loader / Review Uploads
From the Select Loader drop-down, choose "WELPA"
From the Required Parameters, select the School Year.
From the Select Assessment Score File(s) to Upload, navigate to the .csv file you saved in Step 8 and choose the file
Submit for validation.
Review validation report and click 'approve' to load the file.