Data Services



The Data Services team is part of the Technology Resource Center. The department supports Troy School District for data requests and has responsibility in the following areas

  • Business Intelligence and Analytics
  • System Administration of PowerSchool
    • Including PowerSchool Support Helpdesk
  • System Administration of Illuminate
  • System Administration for online textbooks
  • State Reporting submissions for
    • General Collections
    • SRM
    • REP
    • TSDL
    • Early Childhood
    • Graduation
    • MCIR
    • CRDC
  title   Ext building ADDRESS eMAIL
Troy School District
Data Specialist Isabella Ball 5069 4420 Livernois, Troy, MI 48098
Troy School District
Data Specialist Jerome Ohnui 5064 4420 Livernois, Troy, MI 48098
Troy School District
Data Services Secretary Gillian Dowding 5067 4420 Livernois, Troy, MI 48098

State Reporting


Civil Rights Data Collection

Since 1968, the U.S. Department of Education (ED) has conducted the Civil Rights Data Collection (CRDC) to collect data on key education and civil rights issues in our nation's public schools. The collection was formerly administered as the Elementary and Secondary School Survey (E&S Survey). 

The CRDC collects a variety of information including student enrollment and educational programs and services, most of which is disaggregated by race/ethnicity, sex, limited English proficiency, and disability. The CRDC is a longstanding and important aspect of the ED Office for Civil Rights (OCR) overall strategy for administering and enforcing the civil rights statutes for which it is responsible. Information collected by the CRDC is also used by other ED offices as well as policymakers and researchers outside of ED.

Early Childhood Collection

Early Childhood Collections are used to report specific programs in which early childhood students are participating. Data is submitted twice during the school year and again at the end of the year.

Data submitted in the Fall Early Childhood Collection are used with other MSDS data to report fall preschool student headcounts. The Michigan Department of Education plans to use the Great Start Readiness data reported in the spring collection. Data collected in the early childhood collections are also reported to the U.S. Department of Education.

General Collection

General Collections take place in October, February and June. These collections are directly related to State School Aid Act funding and are commonly known as Count Day.

Data submitted includes

  • Student Demographics
  • General Education FTE
  • Special Education FTE
  • District / School /Grade
  • Attendance

Discipline (for Special Education Students)

Further submissions take place weekly between the October and February Count Days to adjust new and dropped students transferring within Michigan School Districts.


Graduation and Dropout Information (GAD)

The State publishes GAD data every year. It is the districts responsibly to verify data is correct and request adjustments to ensure the rates reported as accurate.


Michigan Care Improvement Registry

The Michigan Care Improvement Registry was created in 1998 to collect reliable immunization information for children and make it accessible to authorized users.

MCIR is a lifespan registry utilized by healthcare organizations, licensed childcare providers, schools and pharmacies. It consolidates immunization information from multiple providers into a comprehensive immunization record.

Schools are required to submitted data on all students in grades K and 7, along with all student new to the district.

Troy Pre-School programs are required to submit data for each student on an annual basis.

Students must be fully up to date with immunizations before the first day of school or obtain an immunization waiver from Oakland County dated in the current calendar year.


Registry of Educational Personnel

Effective January 1, 2006, Michigan law requires that criminal history checks be conducted by the Michigan State Police and the Federal Bureau of Investigation for all regular and contract employees hired or assigned by public schools in Michigan. Therefore, all school districts in the state of Michigan are required by statute to submit all school personnel data to the state via the Registry of Educational Personnel so that the checks may be conducted.

Data is submitted twice a year and includes

·         PIC Code

·         Credential License

·         Demographics

·         Ethnicity

·         Date of Hire

·         Employment Status

·         FTE

·         Salary

·         School Assignments

·         Date of Termination (if applicable)

·         Level of Education

·         Professional Development


Student Record Maintenance

Submissions are made throughout the year to adjust the status of individual students.


Teacher Student Data Link

The TSDL Collections in the Michigan Student Data System report links between students and the teachers who provide instruction to them. This data is necessary to meet the requirements of the America Competes Act, The State School Aid Act of 1979, and are used by the Michigan Department of Education in calculations for the Parent Dashboard for School Transparency. Data reported in the collection reflect the student's performance in classes taken throughout the current academic year.

Districts must submit full course data for the following populations:

  • Migrant education participants (Grades 9-12)
  • Dual enrollment participants (Grades 9-12)
  • Early Middle College participants (Grades 9-12)
  • Advanced and accelerated learning participants (All Grades)
    • Advanced Placement (Grades 9-12)
    • International Baccalaureate (All Grades)
  • Virtual/online learning participants (All Grades)