Overview

  1. Overview of the State Reporting Process
  2. Overview of XML in general and the state reporting files specifically
  3. Recommended Software

State Reporting Basics

Major Submissions

  • General Collections -Fall, Spring, EOY
  • Early Childhood - Fall, Spring, EOP
  • Student Record Maintenance (SRM)* - As Needed
  • Teacher Student Data Link (TSDL) - July/Year round (Migrant)

Center for Educational Performance and Information (CEPI)

Manual

  • Available on CEPI website
  • Details all components included in the reporting files
  • Legal values for all fields, and agency contacts for each one

MSDS Website

  • https://cepi.state.mi.us/msds/
  • Requires security agreement signed by district superintendent
  • Provides screens for uploading files, viewing errors, and entering, editing and deleting records
*SRM uploads are used to update and correct previously submitted data, and to exit and enroll students for state testing between the General Collections.
 

XML Files - Ana-Retentive Text Files

  • Composed of pairs of <tags></tags> and the stuff between them
  • Tags can wrap data (text or numbers), or other tags, but not both:

 ✔<tags>data</tags>

 ✔<tags>data<othertags></othertags></tags>
 ✗ 
<tags>data<othertags></othertags></tags>

Everything in the file is labeled, just like the items in the photo. 

 Structure of State Reporting Files: Example

<?xml version="1.0" encoding="utf-8"?>

<EOYGeneralCollectionGroup SchemaVersionMajor="2018-2019" SchemaVersionMinor="1" CollectionId="207" SubmittingSystemName="MISDmsds" SubmittingSystemVendor="MISD" SubmittingSystemVersion="2.2.3.5" xsi:noNamespaceSchemaLocation="http://cepi.state.mi.us/msdsxml/EOYGeneralCollection2018-20191.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<EOYGeneralCollection>

...  
</EOYGeneralCollection> 


<EOYGeneralCollection> 

...  
</EOYGeneralCollection> 

</EOYGeneralCollectionGroup>

The Header is just a signal to software so it knows what to do with the file.

The opening tag of the Group is what distinguishes a General Collection file from a Student Record Maintenance file, and a EOY General Collection from an EOY General Collection. 

The Reporting Process

  1. Export MSDS file from PowerSchool (PS)
  2. Export MSDS file from PowerSchool Special Programs (PSSP)
  3. Import PS file into Macomb MISDmsds
  4. Overlay Special Education components from PSSP file onto PS data in MISDmsds
  5. Review errors
  6. Fix errors in MISDmsds AND original source
  7. Export results file
  8. Upload file to state*
  9. Produce documents for auditors
*Data for students enrolled at the SEE schools (e.g. WAVE, WIHI, etc.) will be generated and provided by WISD; don't include them in your file.
 

The Toolkit

XML Notepad

Notepad++

Microsoft Office

  • Word: Wildcard feature in Find and Replace can add and/or remove complex pieces of data
  • Excel: Convert files to tab - or comma - delimited format for reimport into PowerSchool

Macomb MISDmsds

Final Notes

  • When in doubt, call WISD Technology at (734) 994-8100 x1286

ADA & Accessibility

Our School Strives To Ensure Our Website Is Accessible To All Our Visitors 

Washtenaw ISD is committed to providing a website that is fully accessible and we are currently in the process of developing a new website to better meet the needs of our customers. Our new website will include improvements to ADA compliance and accessibility, and during this transition, we remain committed to maintaining our existing website's accessibility and usability. 

ADA Compliance

Non Discrimination

It is the policy and commitment of the Washtenaw Intermediate School District not to discriminate on the basis of race, color, religion, national origin, sex, disability, age, height, weight, familial status, marital status, genetic information, sexual orientation or any legally protected characteristic, in its educational programs, activities, admissions, or employment policies in accordance with Title IX of the 1972 Educational Amendments, executive order 11246 as amended, Section 504 of the Rehabilitation Act of 1973 and all other pertinent state and Federal regulations.

Non Discrimination Information

Title IX Coordinator ADA and Title IX Coordinator
Brian Marcel
Associate Superintendent
1819 S. Wagner Road 
Ann Arbor, MI  48103
(734) 994-8100 ext. 1402
Cassandra Harmon-Higgins
Executive Director, HR & Legal Services
1819 S. Wagner Road 
Ann Arbor, MI  48103
(734) 994-8100 ext. 1311