2009 STAR Demographic Data Corrections

1. 2009 STARDemographic Data Corrections Webcast September 30, 2009 Start time 9:00 a.m. Demographic Data Corrections

2. Objectives District STAR coordinators will understand: • Why data should be corrected • What data can be corrected • What the cost is for correcting data • When data can be corrected • How to make data corrections • Data corrections vs. handscoring end-of-course mathematics and science tests Demographic Data Corrections

3. What’s New? • New fields • Testing start date • Special conditions X (student refused accommodation/modification) • Accommodation/modification G (braille) • Testing irregularities (not assigned) • Deleted fields • Accommodation/modification I (applicable to CAT/6 Survey only) • Accommodation/modification N (dictionary); for CMA only • Receiving Title I Services Demographic Data Corrections

4. What’s New? (cont.) • New fields • CMA-writing specific • Updated fields and sections • Revised update rules and acceptable values Demographic Data Corrections

5. Why Correct Data? • Correct API and AYP calculations • Corrected data is sent to the CDE’s Academic Accountability Unit for recalculation • Score uncoded and rescore miscoded end-of-course mathematics or science tests • Other option is to hand score • Obtain corrected data CD Demographic Data Corrections

6. Fields used for API and/or AYP calculations that may be corrected • SSID • CAPA Level • County/District code for student’s residence if residence is other than where student attends school/receives services • Special Testing Conditions (except for certain fields) • Modifications Used • Adult Testing Irregularities • Inappropriate Test Preparation Demographic Data Corrections

7. Fields used for API and/or AYP calculations that may be corrected • Student’s English Proficiency • English Learner Date First Enrolled in U.S. School • R-FEP students in grades 5–11 scored PRO or ADV 3 years on ELA CST • National School Lunch Program (NSLP) • Primary Disability • Special Education Exit Date Demographic Data Corrections

8. Fields used for API and/or AYP calculations that may be corrected • Primary Ethnicity • Parent Education Level • CBEDS Enrollment—District • CBEDS Enrollment—School • CST for Mathematics Test Taken • CST for Science Test Taken • Attends Nonpublic, Nonsectarian School Demographic Data Corrections

9. Demographic fields that may NOT be corrected • District Name • County District School Code • School Name • School Code • Grade Level of Test Taken (enrollment grade may be changed, however) Demographic Data Corrections

10. How much does it cost? • One set up fee of $630 • Regardless of number of administrations changed • 16 cents per record • ALL students tested on the administration • Additional cost for replacement reports and CD Demographic Data Corrections

11. Example • Two administrations • 1,000 students tested on admin. 1 • 5,000 students tested on admin. 2 • Correct 900 students on admin. 1 • Cost = $630 + (0.16 x 1000) = $790 • Correct 3,000 students on admin. 2 • Cost = $630 + (0.16 x 5000) = $1,430 • Correct 900 students on admin. 1 plusCorrect 3,000 students on admin. 2 • Cost = $630 +(0.16 x 6000) = $1,590 Demographic Data Corrections

12. Cost of Replacement Reports Demographic Data Corrections

13. Timeline • Submit Form • Form available on www.startest.org • Last day for submissions is October 16 • System OPEN for corrections on September 28 • System CLOSED for corrections on November 6 • Last day to request file download is November 5; corrected file then must be uploaded by November 6 • Corrected STAR Internet reports to be posted in December • Not the same as accountability reports Demographic Data Corrections

14. The Process • Complete and submit form • Obtain new password • Access “STAR 2009 Administration” • Data corrections • Online • Offline • Match unmatched records (optional) • Online only • “Approve – District Complete” • If this step is NOT completed, NO data changes will be sent to CDE • Must be completed by 6:00 p.m. (PST) November 6 Demographic Data Corrections

15. Online & Offline Updates Demographic Data Corrections

16. Download & Upload Format • Based on STAR Student Data Layout • Includes ALL data in one file • Includes additional control data fields • Includes records for ALL administrations • File includes CST, CMA, and CAPA records • STS records not included Demographic Data Corrections

17. Format of Data File • Appendix C of Demographic Data Corrections Manual Demographic Data Corrections

18. Header Record – Do NOT remove or alter Trailer Record – Do NOT remove or alter Sample Data File Demographic Data Corrections

19. After Download • Save a COPY of download file to desktop. • Do NOT make online data changes in between downloading and uploading • Use text editor to make data changes • Do not use Excel • Keep data in same columns and sequence • Do NOT remove records • Do NOT change fields UIN(3–22) and Checksum (856–887) • DoNOTadjust header or trailer records Demographic Data Corrections

20. Upload File Phase 1, File Check • Unsuccessful • All records rejected • Possible errors • Header record error • Trailer record error • Records deleted or added • Latest download file not used for upload • File format Demographic Data Corrections

21. Upload File Phase 1, File Check • Successful • Proceed to Phase 2 • Record check • Only modified records will be checked Demographic Data Corrections

22. Upload File Phase 2, Record Check • Data for entire record has to be valid • Updates record if all data valid • Rejects record if ANY data on the record is invalid • E-mail sent to inform that Phase 2 has been completed Demographic Data Corrections

23. E-mail Demographic Data Corrections

24. Resubmit • Download data • Locate records in error • Correct errors • Upload ENTIRE file • Not just the corrected error records Demographic Data Corrections

25. SoftwareDemonstration Online Updates Matching Records Download & Upload Files Demographic Data Corrections

26. Login to 2009 Database Demographic Data Corrections

27. Welcome Screen Demographic Data Corrections

28. Online CorrectionsSearch for Student Demographic Data Corrections

29. Online CorrectionsSearch for Student Results Demographic Data Corrections

30. Online CorrectionsUpdate Student Data • Cannot update online • Special test conditions • Modifications and accommodations • Must make these corrections offline Demographic Data Corrections

31. Online CorrectionsMatching Records • Matching only available online • Grades 4 and 7 multiple choice/ writing Demographic Data Corrections

32. Online CorrectionsMatching Records Demographic Data Corrections

33. Offline CorrectionsRequest File Demographic Data Corrections

34. Offline CorrectionsDownload File • Available the next day for download Demographic Data Corrections

35. Offline CorrectionsEdit File • Text editor Demographic Data Corrections

36. Offline CorrectionsUpload File Demographic Data Corrections

37. Upload Messages Success Failure Demographic Data Corrections

38. Offline CorrectionsCheck File Status Demographic Data Corrections

39. Approve Demographic Data Corrections

40. Final Step • Approve – District Complete • Sends data for inclusion in January Internet posting • Sends invoice from ETS Demographic Data Corrections

41. Score uncoded and rescore miscoded end-of-course mathematics or science tests • Two options • Demographic data corrections • Handscore Demographic Data Corrections

42. Data Corrections vs. Handscoring FAQs for EOC Mathematics or Science Demographic Data Corrections

43. Questions? Demographic Data Corrections

44. Next Webcast2010 STAR Order Management System October 28, 2009 Webcast starts at 9:00 a.m. Demographic Data Corrections