Student Growth Percentile (SGP) Extract, File Prep for Auto Upload and Auto Upload Procedure

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 "Student Growth Percentiles (SGP)" section. Note: usually Item 7 in the school year.
Under the "Individual Student SGP" section choose the file named similar to: "your district name_Individual Student SGP 3-13-2015.xls", this will download the file.
Save the file.
Re-open the file and "Save As" a .csv (comma separated value file) with the same name.

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

Last Edit: January 26th, 2017, AM

Comments

4 comments

Randi Ivancich

November 19, 2013 20:24
These are clear and easy to follow.
0
Brian Graham

February 10, 2014 22:36
Great directions. Easy to follow. It's nice to be able to complete this process with calling customer support or emailing our rep. Nice work School Data Solutions.
0
Sharon Strauss

February 10, 2014 22:39
Thank you both for the feedback! It's good to hear from our customers that these directions are easy to follow and helpful. =)
0
Debbie Wentworth

February 11, 2014 18:17
I second Sharon's comment; your feedback helps guide us as we add additional instructional materials into the Help Center. Thank you for taking the time to submit your comments!
0

Please sign in to leave a comment.