Data Overview

The financial data files contain data commonly reported for MI school districts including expenditure, revenue, and balance data. Data are sourced from the State of Michigan’s Financial Information Database (FID). Data from the 2004-2017 school years are available. Future year's school year data will be added on.

K-12 Finance Balance

The district finance balance dataset contains information on the balances in specific district allocation accounts.

K-12 Finance Expenditures

The district finance expenditures dataset has information describing district spending and what specific district allocation account or grant its coming from.

K-12 Finance Revenue

The district finance revenue dataset holds information on sources of income for districts with specific amounts and descriptive categories they fall under.

The K-12 staffing data contain individual-level records on education personnel (teachers and other non-teacher employees). Coverage is EOY 2012 - Fall 2016. Available data reflect information about staffing demographics, assignments, and endorsements/credentials. Personnel from both private and public schools are included in this dataset. It is optional for private schools to participate in the data collection and therefore the data for this type of school is incomplete. The datasets cover both part-time as well as full-time staff from all schools in MI. The data also includes information on those who end their employment with the school system during the year.

K-12 Staff Base

The “base” dataset contains staff demographics: race, gender, and birth year.

K-12 Staff Employment

The employment dataset has the district staff are contracted to work with, range of dates employed, salary, and educational attainment.

...

The K-12 student data contain commonly requested longitudinal student-level educational data from the K-12 environment. Available datasets reflect information about K-12 graduation, enrollment, demographics and program participation. Sources for these data include the Michigan Student Data System (MSDS) Fall, Spring, and End-of-Year General Collection Submissions, MSDS Teacher Student Data Link (TSDL) Collection, Educational Entity Master (EEM), and the Graduation and Dropout Application (GAD).

Only public school students are included in the data sets. In addition to K-12 students, these data include pre-K students and special education transition students over the age of 18. Students attending non-public schools and students using a non-public residency code at a public school (i.e., home school and private school students), as well as students enrolled only in Adult Education, are excluded.

The geocoded student data contains census block information for each student...

The postsecondary data files contain commonly requested longitudinal student-level data from the postsecondary educational environment. Available datasets reflect information about postsecondary student demographics, enrollments, programs, courses, cumulative progress, and degrees/certifications (referred to as awards).
The primary data sources for the postsecondary researcher data are the Student Transcript and Academic Record Repository (STARR) and the National Student Clearinghouse (NSC). The former is collection of student data from all Michigan public institutions and some independent institutions. The latter is a national database of postsecondary student information from most colleges nationwide.

Post-Secondary Student Base

The ‘base’ dataset contains information on student demographics: race, gender, and date of birth.

Post-Secondary Student Enrollment

The enrollment dataset has the institutional...

The early childhood researcher files contain commonly requested longitudinal student-level demographic and program data reported in the early childhood MSDS collection. Available datasets reflect information about early childhood demographics, and program participation. Currently, only four early childhood programs are required to report data to CEPI: GSRP, GSRP/Head Start Blend, Sec 32p, and Sec 32p(4). However, several other early childhood programs are included. Data from the 2012-2019 school years are available. Future year's school year data will be added near the end of the following summer.

Early Childhood Base

The “base” dataset contains the time invariant demographic information, such as gender and race, for students that participated in the the early-childhood programs that are required to report data to the state.

Early Childhood Main

This file includes demographic variables by data collection. It includes...

Highlights

Level: Student by Year by Assessment
Population: Students in the Michigan K12 educational system
Information Contained: Assessment scores
Years Covered: 2007-2019

Description

The Career and College Readiness researcher file contains commonly requested student-level assessment data from the K-12 environment pertaining to college and career readiness for students.This dataset reflects information about career and college readiness assessments administered by the Michigan Department of Education and also Advanced Placement examinations throughout the state. Administered tests include SAT (current), ACT (retired), PSAT (current), and Work Keys (current). Data covers all students from private, home schooled and public schools who have participated in these assessments. Prior to 2014-2015, ACT was a component of the MME assessment. For 2014-2015, it was given as its own assessment. Tests were administered during the spring each year....

The Postsecondary Entity researcher file contains information about higher education institutions such as physical address, level, and control. This includes both Michigan IHEs and out-of-state institutions. However, some fields (e.g. HIGHER_ED_CODE, OPEN_DATE and physical address) are only provided for Michigan institutions. Data from the EOY 2008 collection forward are available. Data are collected annually, and are regenerated in entirety annually, merging all previously reported data with the most current reporting year’s data.

The K-12 Special Education Finance researcher files contain information about transportation expenditures and other expenditures regarding special education services. The files contain special education expenditures reported by school districts (LEAs & ISDs) on the SE-4094 and SE-4096 forms. Future year's school year data will be added on.

K-12 Special Education Finance Expenditures

The special education expenditures dataset contains information on expenses related to providing special education services to students. Data from the 2018 fiscal year is available.

K-12 Special Education Finance Transportation

The special education transportation dataset has details on the expenses around transporting students that receive special education services; this includes personnel and materials. Data from the 2007-2018 fiscal year are available.

Highlights

Record Level: Student by Year by Assessment
Population: Students in the Michigan K12 educational system
Information Contained: ELPA and WIDA Assessment scores
Years Covered: 2007-2019

Description

This English Language Learner Assessment Researcher file contains commonly requested student-level assessment data from the K-12 environment pertaining to English language learner assessments. These assessments are composed of the English Language Proficiency Assessment (ELPA) and the WIDA. The ELPA was administered to K-12 students identified as English Learners until the 2012-13 school year, and the WIDA has been administer since the 2013-14 school year. We have data from the 2007-2008 school year forward. We anticipate to have future years' data as it becomes available.

Number of Individuals with Records

We have English Language Learner Assessment records for over 260 thousand students in total. With regards to each...

This Assessment Accommodations Researcher file contains commonly requested student-level assessment data from the K-12 environment pertaining to accommodations on state administered tests, such as MI-Access, MEAP-Access, M-STEP, MEAP, MME, ELPA and WIDA. Data covers all students from private, home schooled and public schools who have participated in these assessments. Data from the 2007-2008 school year forward will be included. Future years' data will be added on an annual basis as data become available.

Number of Individuals with Records

We have records on accommodations on assessments for over 500 thousand students. With regards to each specific assessment, we have records for 170 thousand students that were given accommodations when they were assessed using the MEAP, 60 thousand students that were given accommodations when they were assessed using the...

The staff mobility datasets show educator (i.e., teachers) movements across the schools and districts. The staff mobility datasets show educator (i.e., teachers) movements across the schools and districts. The data in these datasets categorize educators into three groups in each school year compared to the previous year: "Leaver" (a staff who was a teacher in Year 1 and has left the education workforce in Year 2), "Stayer" (an educator who has stayed in the same School / District since the previous year) and "Mover" (a staff who has moved from one School to another School or from one District to another District in year 2 compared to Year 1- but does not exit the workforce).
One of the mobility datasets provide data at the individual level (i.e., by RPIC) and have variables based on the School Year and the School / District the person was assigned to. It’s possible an individual is assigned to more than one School / District, so for those educators the word “Multiple” is...

Standard Assessments

Highlights

Record Level: Student by Year by Assessment
Population: Students in the Michigan K12 educational system
Information Contained: MSTEP, MEAP, and MME Assessment scores
Years Covered: 2007-2019

Description

The K-12 Student Assessments - Standard data contains student-level assessment data from the K-12 environment. Available datasets reflect information about the standard assessments which are (typically) required to be taken by Michigan students to capture the performance of the K-12 educational system. Each record (row) in the dataset is a student's assessment scores for a single year. Michigan Education Assessment Program (MEAP) was administered in the Fall from 2007 to 2013. Michigan Merit Exam (MME) was administered in the Spring from 2008 to 2014. Michigan Student Test of Educational Progress (M-STEP) has been administered in the Spring from 2015 to 2019. The current standard...

Data from the 2012-2019 school years are available. Future year's school year data will be added on.

K-12 Staff Endorsements

The endorsement dataset contains staff’s license type and more specific information on their certification(s).

K-12 Staff Professional Development

The professional development dataset contains information about training completed by individual staff during a particular year.

K-12 Staff Michigan Test for Teacher Certification (MTTC)

The MTTC dataset holds instructional staff’s assessment scores for their mandated certification examination.

The building dataset holds information on the various educational entities in the state, from schools to districts. Data from the 2006-2019 school years are available. Future year's school year data will be added near the end of the following summer. This dataset includes entities for grades K-12. It also includes administrative facilities (non-instructional). There is one record per collection per building in the K-12 Educational Entity Information file. Each entity will have it's own primary record, but will also be seen in records that it relates too. For example: A district will have it's own record, but you'll also see the district name and code on the school records that reside within that district. Data from the 2006-2019 fiscal year are available. Future year's school year data will be added on.

The K-12 Student Coursework dataset is course-level data that provides information on each course taken by students. Taken from the Michigan Department of Educations Teacher-Student Data Link (TSDL) system and beginning in 2011-12, Michigan public schools were required to submit course taking information to the state; failure to submit information may reduce a school or district’s performance scorecard. Within the coursework data, we can observe the courses students take, the grade received, credits earned, and the assigned teacher and course section.

Approximately 95% of students in the main K12 student enrollment data are accounted for in the coursework data during the years for which we have comprehensive data (2012-2015). The student’s unique ID (RIC) can be linked to the student and assessment databases. The teacher’s unique id (RPIC) can be linked to the Employment database, which includes more detailed data on the teacher’s background) and certifications.

...

The courses dataset contains the details about courses that students signed up for.

The awards dataset has the particulars about the degree that students earned.

The State of Michigan provides discipline data in a single dataset that includes all reported disciplinary incidents in Michigan schools from 2011 to present. There is a large increase in reporting starting in the 2017-2018 school year, when reporting suspensions for all students became mandatory for all Michigan schools. From 2011-2017, reporting suspensions was only required for students with IEPs. Reporting expulsions for all students is required in all years.

The raw data included identifiers such as student Id (RIC), school year, school and district code; incident ID, incident date, and type of incident; type and length of disciplinary action; and any administrative follow up to address the incident (e.g. referred to mental health agency). These data are intended to be unique at the student x year x incident level, but additional de-duplication will be required to get the data to this level of uniqueness.