Highlights

Record Level: Student by school by year 
Record Count: approx. 1.7 million students per year 
Years Covered: 2004-Present 
Population Coverage: Public school students in Michigan

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). While the panel extends back to 2004, availability of specific variables will vary for earlier years.

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.

Prior to school year 2017-18, a student was counted as absent by a district only if they missed a full day of school. Beginning with school year 2017-18, that criteria changed so that students are counted as absent if they miss more than 50 percent of the school day. This aligns with Every Student Succeeds Act requirements. For details on this reporting, exemptions and other information, please see the MSDS Collection Details Manual on the CEPI website. Specifically, the definition of what counts as attendance changed in the following way as described in the Michigan collection manual.

What counts as attendance prior to 2017-18?What counts as attendance starting in 2017-18?
Count attendance for any part of the school day as a day in attendance. Report participation in half-day kindergarten, special education for preprimary-aged students (3-5 years of age), or any other pupil program as a day in attendance.Count attendance for a student who is present at least 50% of the school day as a day in attendance. Report participation in half-day kindergarten, special education for preprimary-aged students (3-5 years of age), or any other pupil program as a day in attendance.

The geocoded student data contains census block information for each student enrolled in a K-12 school in Michigan, where one or more parent or guardian addresses have been geocoded successfully. The dataset covers PK-12 students (i.e., K12 students, those in Early On, Early Childhood Special Education, Early Childhood and Pre-Kindergarten programs) for 2010 - present. Data for 2003 - 2009 only includes K12 students. It does not have any post-secondary student, since CEPI does not provide any demographics for those students beyond what's in the post-secondary datasets. The data are on the Student x Year x Building Code x Census Block level for records preceding the 2010 school year. Starting in 2009-2010, the census block is also resolved at the collection level (Spring, Fall, End of Year) meaning the order of census blocks resided in is now knowable. New data are delivered on a yearly basis. Data from the 2002-2003 EOY collection forward are available. Due to the addition of ISD code and name variables in the 2016-2017 EOY delivery, previous years have null values for these variables.

The academic years covered by the K12 student data vary. Student demographic, enrollment and program data currently span from 2013 to present. MEDC has expanded the panel back to 2003 using archived data for certain demographic and enrollment variables. Audited graduation or cohort records begin in 2008. Census block data begin in 2003.

Note: There are variables under the Category of Program Participation that could be assumed to fall under the Category of Demographics, but they do not . Those variables indicate participation in programs designed to meet the needs of particular populations, but the variables do not specify fulfillment of any particular criteria to receive those services.

Codebook

Showing 801 - 900 of 1138 results
Category Sort descending Variable Description
Category: K12 Building Variable: EMC_FOCUS_NT Description: 

Flag to specify if this EMC has a NT focus

Category: K12 Building Variable: EMC_FOCUS_IT Description: 

Flag to specify if this EMC has an IT focus

Category: K12 Building Variable: EMC_FOCUS_HEALTH Description: 

Flag to specify if this EMC has a Health focus

Category: K12 Building Variable: EMC_FOCUS_CTE Description: 

Flag to specify if this EMC has a CTE focus

Category: K12 Building Variable: FACE_VIRTUAL_SCHOOL Description: 

Virtual with face to face options; the school focuses on a systematic program of virtual instruction but includes some physical meetings among students or with teachers.

Category: K12 Building Variable: GR_08_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Eighth grade students.

Category: K12 Building Variable: GR_08_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Eighth grade students.

Category: K12 Building Variable: DELINQUENT_INSTITUTION Description: 

Flag to specify if this entity is authorized to offer instruction in a Delinquent Institution setting. A public or private residential facility that is operated primarily for the care of children who have been adjudicated as delinquent or in need of supervision.

Category: K12 Building Variable: GR_07_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Seventh grade students.

Category: K12 Building Variable: GR_07_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Seventh grade students.

Category: K12 Building Variable: GR_06_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Sixth grade students.

Category: K12 Building Variable: GR_06_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Sixth grade students.

Category: K12 Building Variable: GR_05_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Fifth grade students.

Category: K12 Building Variable: GR_05_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Fifth grade students.

Category: K12 Building Variable: GR_04_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Fourth grade students.

Category: K12 Building Variable: GR_04_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Fourth grade students.

Category: K12 Building Variable: GR_03_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Third grade students.

Category: K12 Building Variable: GR_02_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of Second grade students.

Category: K12 Building Variable: ENTITY_TYPE_GROUP Description: 

Identifies whether the entity is a school, district, unique education provider, or non-instructional ancillary facility.

Category: K12 Building Variable: FAITH_BASED_INSTITUTION Description: 

Flag denoting a faith based institution. A faith based institution has a religious aspect or focus.

Category: K12 Building Variable: FAMILY_RESOURCE_CENTER Description: 

Flag denoting a family resource center. Department of Human Services workers deliver services on-site at school.

Category: K12 Building Variable: FULL_TIME_VIRTUAL_SCHOOL Description: 

Full Virtual; the school has no physical building where students meet with each other or with teachers, all instruction is virtual.

Category: K12 Building Variable: GENERAL_EDUCATION Description: 

Flag denoting this school provides general education in grades K-12. A public elementary/secondary school that does NOT focus primarily on vocational, special or alternative education, although it may provide these programs in addition to a regular curriculum.

Category: K12 Building Variable: GEO_DISTRICT_CODE Description: 

The Local Education Agency (LEA) District Code in which the entity is located.

Category: K12 Building Variable: GEO_DISTRICT_NAME Description: 

The Local Education Agency (LEA) District Name in which the entity is located.

Category: K12 Building Variable: GR_01_ACTUAL Description: 

Flag to specify if this entity is offering instruction of First grade students.

Category: K12 Building Variable: GR_01_AUTH Description: 

Flag to specify if this entity is authorized to offer instruction of First grade students.

Category: K12 Building Variable: GR_02_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Second grade students.

Category: K12 Building Variable: GR_03_ACTUAL Description: 

Flag to specify if this entity is offering instruction of Third grade students.

Category: Michigan Test for Teacher Certification Variable: MTTC_INSTITUTION_NAME_3 Description: 

Institution 3 that the examinees had their scores sent to (MI Examinees only)

Category: Michigan Test for Teacher Certification Variable: SCALED_SCORE Description: 

Scaled Score

Category: Michigan Test for Teacher Certification Variable: FIELD_NAME Description: 

Field name corresponding to the test code

Category: Michigan Test for Teacher Certification Variable: TESTING_DATE Description: 

Date the MTTC test was taken

Category: Michigan Test for Teacher Certification Variable: PASS_FAIL Description: 

P (Pass), F (Failed)

Category: Michigan Test for Teacher Certification Variable: GRADE_LEVEL_DESC Description: 
Category: Michigan Test for Teacher Certification Variable: TEST_CODE Description: 

MTTC Test Code

Category: Michigan Test for Teacher Certification Variable: GRADE_LEVEL_CODE Description: 

A (Elementary), B (Secondary)

Category: Michigan Test for Teacher Certification Variable: MTTC_INSTITUTION_NAME_2 Description: 

Institution 2 that the examinees had their scores sent to (MI Examinees only)

Category: Michigan Test for Teacher Certification Variable: STATE Description: 

State for out of state examinees only

Category: Michigan Test for Teacher Certification Variable: MTTC_INSTITUTION_NAME_1 Description: 

Institution 1 that the examinees had their scores sent to (MI Examinees only)

Category: Michigan Test for Teacher Certification Variable: MAJOR_OR_MINOR_DESC Description: 
Category: Michigan Test for Teacher Certification Variable: MAJOR_OR_MINOR_CODE Description: 

A (Major), B (Minor)

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_7 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_4 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_2 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_6 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_1 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_2 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_TYPE_3 Description: 

The code to identify the reason a modification was made to the student’s curriculum.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_2 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_1 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_1 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_5 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_3 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_6 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_5 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Personal Curriculum Modification Variable: ERD_ACTIVITY_CODE_4 Description: 

The code to identify the type of additional instruction time related activities delivered to the student.

Category: Personal Curriculum Modification Variable: PERSONAL_CURRICULUM_MOD_3 Description: 

The code for the academic area(s) for which the student has a Personal Curriculum Credit Modification.

Category: Postsecondary Building Variable: IHE_PHYS_ADD_LINE_TWO Description: 

The second line of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_STATE Description: 

The state of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_CITY Description: 

The city of the physical address for the entity.

Category: Postsecondary Building Variable: SNAPSHOT_DAY Description: 

The date in which the snapshot was created. These static 'Snapshots' of data are what is loaded to the MSLDS

Category: Postsecondary Building Variable: HIGHER_ED_CODE Description: 

The unique identifier of the IHE entity in the Educational Entity Master (EEM).

Category: Postsecondary Building Variable: IHE_CONTROL Description: 

Designates whether an IHE is publicly or privately controlled.

Category: Postsecondary Building Variable: IS_OPEN Description: 

A Y or N flag stating the Open Status of most Michigan Institutions.

Category: Postsecondary Building Variable: IPEDS_CODE Description: 

IPEDS (Integrated Postsecondary Education Data Systems) IHE identification code.

Category: Postsecondary Building Variable: IHE_NAME Description: 

The official or legal name of the institution.

Category: Postsecondary Building Variable: IHE_LEVEL Description: 

Designates whether an IHE is a 2-year or 4-year institution.

Category: Postsecondary Building Variable: IHE_PHYS_ZIP_LINE_ONE Description: 

The zip code of the physical address for the entity.

Category: Postsecondary Building Variable: IHE_PHYS_ADD_LINE_ONE Description: 

The first line of the physical address for the entity.

Category: Professional Development Variable: HOURS_ENGAGED Description: 

Number of hours of training. Semester credit hours are converted to hours here using this formula: one semester credit hour = 25 education-related professional learning hours. Similarly, # of days of PD from REP is converted to hours by multiplying #of days by 6.

Category: Professional Development Variable: PROF_DEV_CATEGORY Description: 

The District Provided Professional Development (DPPD & those for the new teachers) training categories. For other types of training N/A is entered.

Category: Professional Development Variable: PROF_DEV_TYPE Description: 

The type of training the staff have received. There are three types of training: State Continuing Education Clock Hours (SCECHs) are organized professional development activities that teachers use for progression. District Provided Professional Development (DPPD) could also be used by educators to renew their certificate or progression.College Credits are also used for professional development and certificate renewal/progression. Please note that in order to distinguish DPPD information entered by the educators from the DPPD offered to new teachers by the districts, a fourth PD type is created here, called DPPD-New Teacher Training.

Category: Professional Development Variable: ENTITY_CODE Description: 

Code of the facility that the staff received training. The IPEDS are extracted from EEM and NCES IPEDS datasets by joining the MOECS data with those two datasets on the entity name. So, if the college name was abbreviated or misspelled, N/A is entered.

Category: Professional Development Variable: PD_TRAINING_COURSE_NUMBER Description: 

The college credit course number. For other training types, "N/A" is entered.

Category: Professional Development Variable: PD_TRAINING_NAME Description: 

Name of the training received by the staff

Category: Professional Development Variable: ENTITY_NAME Description: 

Name of the college, district, or other facilities that the staff received training (as entered by the educator) or offered the training (as entered in REP by the districts).

Category: Program Participation Variable: PROGRAM_CIP_DESCRIPTION Description: 

The description of the discipline or field of study of the student's program, as defined in the Classification of Instructional Programs (CIP) by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: PROGRAM_CIP_CATEGORY Description: 

The high-level category description of the discipline or field of study of the student's program, as defined in the 2-digit Classification of Instructional Programs (CIP) by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: PROGRAM_TYPE Description: 

The type of academic program the student is working toward at the IHE during the session. Examples: Major, Minor, SecondMajor, Concentration.

Category: Program Participation Variable: PROGRAM_NAME Description: 

The institution's internal name of the program, major, minor or field of study the student is working toward at the IHE during the session.

Category: Program Participation Variable: PROGRAM_CIP_CODE Description: 

The code indicating a discipline or field of study for the academic program the student is working toward. As submitted by the IHE, sourced from the Classification of Instructional Programs (CIP), by the US Department of Education's National Center for Education Statistics (NCES).

Category: Program Participation Variable: IS_STARR_PROGRAM Description: 

Designates if the session record came from the STARR collection.

Category: Program Participation Variable: IS_INTERNATIONAL_STUDENT_PROG Description: 

Indicates student is an international student participating in a foreign exchange program.

Category: Program Participation Variable: HOMELESS Description: 

Indicates if the student is homeless.

Category: Program Participation Variable: MIGRANT Description: 

Indicates if the student is a migrant student.

Category: Program Participation Variable: ALTERNATIVE_EDUCATION Description: 

Indicates this student is currently participating in an alternative education program (including seat-time waiver programs).

Category: Program Participation Variable: IS_IMMIGRANT_PROGRAM Description: 

Indicates the student has immigrated to the United States from another country and is aged 3 through 21 years, was not born in any state in America and has not attended one or more schools in any one or more states for more than three full academic years. NOTE: The United States Department of Education (USED) includes foreign exchange students as eligible for Title III immigrant programs.

Category: Program Participation Variable: IS_AT_RISK_PROGRAM Description: 

Flag indicating a student is eligible for at-risk (section 31a) funding.

Category: Program Participation Variable: IS_SEAT_TIME_WAIVER Description: 

Indicates this student is receiving his/her instruction for three or more courses through a virtual education program.

Category: Program Participation Variable: IS_MIGRANT_ELIGIBLE Description: 

Flag indicating if the student was eligible for Migrant services.

Category: Program Participation Variable: IS_ENGLISH_LEARNER Description: 

Flag that indicates if the student was eligible to receive Limited English Proficient (LEP) services.

Category: Program Participation Variable: IS_TITLE_I_TAS_PROGRAM Description: 

Student participated in a targeted assistance school (TAS) program.

Category: Program Participation Variable: SPECIAL_ED Description: 

Indicates that the student is in a special education program.

Category: Program Participation Variable: IS_HOMELESS_PROG Description: 

Flag indicating that the homeless code field has a value greater than 0 for the student.

Category: Program Participation Variable: IS_SECTION_504_PROGRAM Description: 

Indicates this student is considered disabled under Section 504 of the Rehabilitation Act of 1973.

Category: Program Participation Variable: IS_DEVELOPMENTAL_KINDERGARTEN Description: 

Indicates this student participated in a Developmental Kindergarten program (a defined two-year Kindergarten program that precedes entry into first grade).

Category: Program Participation Variable: IS_OUT_OF_STATE_RES_PROGRAM Description: 

Indicates the student attends the district from a state or a province other than Michigan.

Category: Program Participation Variable: IS_ALTERNATIVE_EDUCATION Description: 

Indicates this student is currently participating in an alternative education program (including seat-time waiver programs).

Category: Program Participation Variable: IS_EARLY_MID_COLLEGE_PART_PROG Description: 

Indicates the student is enrolled in an early/middle college program. This program could reside at a public high school, community college or a state public university. Students may attend as early as ninth grade.