WaKIDS Extract and File Prep for Manual Upload

Extract data from OSPI’s EDS website.

1. Sign-in to your EDS account.
2. Click My Applications on the menu bar.
3. Choose Washington Assessment Management System (WAMS) from the list.
4. Choose your school district from the Organization drop down list.
5. Select File Downloads from the top menu bar.
6. From the left hand menu, select the School Year Administration you are loading to.

7. Scroll to the WaKids section

8. In the Score Files Section, find the score file with the Administration name you are looking to load (will have Fall, Winter or Spring in the name).

9. Click the File link to download it.
10. Save the file with a descriptive naming convention such as the following:
    • {SchoolDistrictName}_{assessment}_{time period covered}.xls
    • SchoolDistrict_WaKIDS Fall 2013 Scorefile_0513.xls

1. Open the Score file that was just saved, highlight and delete all columns except the following:
   • District name
   • School name
   • Ssid
   • Last Name
   • First Name
   • Social Emotional Scale Score
   • Physical Scale Score
   • Language Scale Score
   • Cognitive Scale Score
   • Literacy Scale Score
   • Math Scale Score
2. Using “Save As”, save the file as a .csv file with the same filename. The file is ready for uploading.

Last Edit: Dec 30th, 2020 12:53PM