Master School Identification File

1. Master School Identification File Presenter Rhonda Forbes June 2009

2. Master School Identification (MSID) File Background • Contains information about all PK-12 public schools in Florida • Also contains information about adult and vocational-technical schools run by school districts

3. Master School Identification (MSID) File • Changes, additions and deletions are sent to DOE each summer (and periodically thereafter) by the MSID contact. • There is an MSID contact in every district.

4. MSID Web Application http://doeweb-prd.doe.state.fl.us/EDS/MasterSchoolID/ • Displays MSID information for each school (active and inactive). • Look up by school and district and by school name or number.

5. MSID Web Application • Download files (Excel format): Active Schools; All schools, all fields; Schools by type • Three screens • Addresses & phone numbers • Administrative information • Accountability information (controlled by Evaluation and Reporting Office)

6. MSID Web Application (Address and Phone Numbers Screen)

7. MSID Web Application (Administrative Information)

8. MSID Web Application (Accountability Information)

9. Downloading MSID File • Access the MSID web site • Click on “Download files” button at bottom of page • Click on “Download” option on next page • Click on “Open” • Choose “File” and “Save As”

10. Downloading MSID File • Specify a destination and specify Excel as the file type. • Close the web application & open Excel • Open the saved file • Sort as needed & delete unneeded columns and rows.

11. Downloading MSID file (“Save As” Option)

12. MSID Layout • Provided in the MSID Technical Assistance Paper on the web • Appendix A • Lists each element name, size, short description and codes • Additional description is included in the body of the paper

13. Coordination • Program area offices within district need to work with MSID contact person to ensure information on the file is accurate. • Facilities • Finance • Title I • Charter • Accountability • Assessment • Alternative Programs • Career and Technical

14. Reporting to U.S. Department of Education • Common Core of Data/Education Data Exchange Network (EDEN). • All national statistics are based on these schools.

15. Reporting to U.S. Department of Education • Assignment of federal ID numbers for E-rate, etc. • Submit schools that will open in next two years.

16. Accountability • Provides universe for school grades and Adequate Yearly Progress (AYP) • Each school number designated an analysis unit (a school). • Department of Juvenile Justice schools (School Function/Setting = D). • Principal’s Name and Address for School Grade checks.

17. Editing Data • All Student, Staff and Finance database records are rejected if school is not on the MSID file. • Title I Supplemental Educational Services format.

18. Editing Data • TI SES School must be SINI 1+ on MSID or record is rejected. • Career Academy Participant must be in a school with a career academy. (Fed/St Indicator format).

19. Neglected/Delinquent • Institution Number, Neglected/Delinquent (Student Demo) must show as a Neglected/Delinquent school on MSID • Student generates funding for Title I, Part D • Institutions that house neglected/delinquent students, but do not provide on-site instruction- District-assigned number (AXXX) submitted to DOE.

20. Neglected/Delinquent • Designation as residential and non-residential has funding implications. • MSID categories used in Consolidated State Performance Report (CSPR) data aggregation.

21. FTE Funding • Must be an active school or the student course record used for FTE funding is rejected. • Must be DJJ (School Function/Setting = D) to receive summer FTE (surveys 1 and 4). • Every school should have FTE or the school should be Closed or Future on MSID.

22. Categorize Schools for Various Reports • Elementary, middle, high, and combination for most reports. • NCLB School Public Accountability Reports (SPAR).

23. Categorize Schools for Various Reports • Reports produced for Legislators that include all schools in their districts; Uses Senate and House districts. • Return on Investment reporting; Uses ROI type.

24. School Function Setting • A=Alternative • This code will be deleted for 2009-10: • All schools coded “A” will be changed to “Z” (not applicable).

25. Importance of Correct Grade Codes on MSID • Schools are pulled from MSID and used by the Reading Intervention office--enables districts to enter K-12 Reading Plans. • Schools are used by FACTS.org. Enables districts to submit data for EPEP and Major Areas of Interest (MAI).

26. Selecting Data for Reports and Files • Populating annual reports (charter schools, Title I, etc.) • Data files and mailing labels for schools with selected grade levels; Uses Grade Codes and School Types from Appendix C of TAP.

27. Selecting Data for Reports and Files • Reports for charter schools, alternative education schools, virtual schools, DJJ schools, Title I schools (school-wide and targeted) assistance), magnet schools, etc.

28. Assessment • Routing Codes • Used by approximately 19 districts • Indicates place to which the test company is to ship the school’s test documents

29. Assessment (Con’t.) • Comprehensive English Language Learning Assessment (CELLA). • FCAT-maybe in future.

30. Research • Does turnover in school principals correlate with school grades? • What are the characteristics of students who drop out from schools in urban vs. rural locations?

31. Research • How does the progress of students who moved away from schools in need of improvement compare to the progress of students who stayed at the schools in need of improvement?

32. District Virtual Schools • When a district establishes a virtual school, the district should contact DOE to submit an MSID application for the virtual school to be activated on MSID. • Special school numbers are already established for each district virtual school.

33. District Virtual Schools • 7001-Distirct Virtual School • 7004 –Approved franchises of the Florida Virtual School

34. School Verification Report • Sent to MSID District Contact Person by DOE each Summer • Required information updated by District • Return to DOE on time

35. School Verification Report • Important Items include: • School Name • Principal’s Name and Title • Physical/Location Address • Mailing Address • Telephone Number

36. Identifying Information • Web Address • Email Address • Magnet Status • Career Academy Status • Grade Code

37. Applying for a New School Number • Complete the MSID Application form • E-mail it to Rhonda Forbes (rhonda.forbes@fldoe.org) • DOE School Approval Committee will act on the request

38. Applying for a New School Number • Committee meets every other Friday • Rhonda will notify district of status • No school will be given “active” status until approved by the committee.

39. Guidelines for Assignment of School Numbers • Generally, a school number should follow the student body when a new school is built. This provides continuity for accountability purposes. • A school should have separate student and staff populations and its own school principal.

40. Guidelines for Assignment of School Numbers • One charter equates to one charter school number • Apply early because non-active schools will not generate FTE dollars • Specific numbers are not always available because non-public schools use the same pool of numbers

41. MSID Contact Person Rhonda Forbes Education Information Services Florida Department of Education rhonda.forbes@fldoe.org (850) 245-0400 FAX: (850) 245-9097

42. Follow Up Question and Answer Session Submit Questions to dbweias@fldoe.org Or call (850) 245-0400