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 File Downloads from the top menu bar.
- From the left hand menu, select the School Year Administration you are loading to.
-
Scroll to the WaKids section
-
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).
- Click the File link to download it.
- 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
Prepare File
- 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
- 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
Comments
0 comments
Please sign in to leave a comment.