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-Present
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 2023, excluding 2020 due to the COVID-19 pandemic. The current standard assessment is the M-STEP, which was predated by the MEAP and MME.
COVID-19 Data Warning
Due to the COVID-19 pandemic, Michigan state standardized assessments were not administered in the 2020 academic year. In addition, Michigan state standardized assessments were voluntary in the 2021 academic year. We have fewer records in 2021 than we do in years where standardized assessments were mandatory - about 500 thousand records, compared to over 680 thousand in 2022 and 740 thousand in 2019.
Number of Individuals with Records
We have assessment records for over 11.5 million student by year records in total from AY2008 to AY2022. With regards to each specific assessment, we have records for 4.9 million student by year observations that were assessed using the M-STEP, 800 thousand student by year observations that were assessed using the MME, and 5.7 million student by year observations that were assessed using the MEAP. This amounts to over 2.8 million total students, 1.8 million of whom ever took an MSTEP exam, 1.6 million of whom ever took a MEAP exam, and over 800 thousand of whom ever took an MME exam.
Grades Assessments are Administered
The M-STEP is administered to students in the 3rd-8th grade,11th grade, and a few 12th graders. The MME was administered to students in the 11th grade and a few 12th graders. The MEAP was administed to students in the 3rd-9th grade.
Subjects Assessed by Academic Year and Grade
- For the 2019, 2021, 2022, and 2023 Academic Years (AY), we have M-STEP's English Language Arts and Math scores for students in the 3rd through 7th grade and Social Studies scores for 5th, 8th, 11th, and a few 12th graders. The PSAT 8/9 replaces the M-STEP ELA and Mathematics assessment in grade 8 and will be part of Michigan's accountability system for 2019 and beyond.
- For the 2018 Academic Year (AY), we have M-STEP's English Language Arts and Math scores for students in the 3rd through 8th grade and Social Studies scores for 5th, 8th, 11th, and a few 12th graders.
- For the 2016 and 2017 Academic Years (AY), we have M-STEP's English Language Arts and Math scores for students in the 3rd through 8th grade; Social Studies scores for 5th, 8th, 11th, and a few 12th graders; and Science scores for 4th, 7th, 11th, and a few 12th graders.
- For the 2015 Academic Year (AY), we have M-STEP's English Language Arts and Math scores for students in the 3rd through 12th grade; Social Studies scores for 5th, 8th, 11th, and a few 12th graders; and Science scores for 4th, 7th, 11th, and a few 12th graders.
- For the 2011, 2012, 2013, and 2014 Academic Years (AY) we have MEAP's Reading and Math scores for students in the 3rd through 8th grade; Social Studies scores for students in 6th and 9th grade; Science scores for students in 5th and 8th grade; and Writing scores for students in the 4th and 7th grade. In addition, we have MME's Math, Reading, Science, Social Studies, and Writing scores for 11th and a few 12th graders.
- For the 2010 Academic Year (AY) we have MEAP's Reading and Math scores for students in the 3rd through 8th grade; Social Studies scores for students in 6th and 9th grade; and Science scores for students in 5th and 8th grade. In addition, we have MME's Math, Reading, Science, Social Studies, and Writing scores for 11th and a few 12th graders.
- For the 2008 and 2009 Academic Years (AY) we have MEAP's Reading, Math, and Writing scores for students in the 3rd through 8th grade; Social Studies scores for students in 6th and 9th grade; and Science scores for students in 5th and 8th grade. In addition, we have MME's Math, Reading, Science, Social Studies, and Writing scores for 11th and a few 12th graders.
Subject Test Key Variables
Multiple variables are associated with each subject test, and the main one is the scaled score. It is important to note that subject test scores are scaled by grade, so different grades' scaled scores cannot be compared. There is a variable that indicates whether the student was proficient on a given subject portion of the assessment, with categories including, "Advanced", "Advanced Proficient", "Partially Proficient", and "Not Proficient". Starting in 2015, we also have students' Student Growth Percentile and Adequate Growth Percentile scores. The Student Growth Percentile is measured against students who scored similarly to the student in the previous year. The Adequate Growth Percentile is the minimum percentile rank the student needed to achieve to reach "catchup" growth. If interested in Student Growth Percentiles in the years 2019-2023, we recommend reading this memo regarding changes to Student Growth Percentile in these years around the COVID-19 Pandemic.
Standard Assessment Subscores
The standard assessment subscores dataset provides a more nuanced breakdown of the subject test scores in the current standard assessment, M-STEP.
Number of Individuals with Records
We have M-STEP subscores records for around 1.8 million students in total.
Number of Test Takers by Grade
We have scores for over 500 thousand individuals that were tested in each grade from 3rd to 8th and 11th grade. In addition, we have scores for 16 thousand 12th graders.
Subject Subscores by Academic Year and Grade
- For the 2016, 2017,2018, 2019, 2021, 2022, and 2023 Academic Years (AY), please see above for Standard Assessments' Subjects Assessed by Academic Year and Grade Section. The subscores we have for particular grades during these years correspond to the M-STEP subjects assessed in those years.
- For the 2015 Academic Year (AY), we have M-STEP's English Language Arts and Math scores for students in the 3rd through 8th grade, 11th grade, and a few 12th graders; Social Studies scores for 5th, 8th, 11th, and a few 12th graders; and Science scores for 4th, 7th, 11th, and a few 12th graders.
Key Variables
Within the dataset, each row represents one students' subscore in a particular year. A row provides hierarchical information in the variables "SUBJECT" and "SUBSCORE_RPT_LEVEL_DESC". The subjects include 'Mathematics', 'English Language Arts', 'Science', and 'Social Studies'. Those subjects each have multiple components to them, which is what "SUBSCORE_RPT_LEVEL_DESC" provides. See below for the "SUBJECT" and their "SUBSCORE_RPT_LEVEL_DESC" (referred to as components) during specific years.
- The Mathematics components during the 2015 Academic Year include:
Alternative Assessments
The Alternative Assessments Researcher file contains commonly requested student-level assessment data from the K-12 environment pertaining to alternative state administered tests. For this file, the assessments are MI-Access (current) and MEAP-Access (retired 13/14). Data covers all students from private, home schooled and public schools who have participated in these assessments. While private and home schooled students are included in this dataset, they are not advised for reporting unless specifically researching questions around those groups of students. MDE & CEPI do not include private or home schooled students in their reporting.
Number of Individuals with Records
We have Alternative Assessment records for over 320 thousand student by year observations, with over 115 thousand total students. With regards to each specific assessment, we have records for 40 thousand students that were assessed using the MEAP-Access and 80 thousand students that were assessed using the MI-Access.
Number of Test Takers by Grade
We have scores for 30 to 40 thousand individuals that were tested in each grade from 3rd to 11th grade.
Subjects Assessed by Academic Year and Grade
- For the 2015, 2016, 2017,2018, 2019, 2021, 2022, and 2023 Academic Year (AY), we have Mi-Access English Language Arts and Math scores for student in the 3rd-8th and 11th grade; Social Studies scores for 5th, 8th, and 11th graders; and Science scores for 4th, 7th, and 11th graders.
- For the 2012, 2013, and 2014 Academic Year (AY), we have Mi-Access Reading and Math scores for 3rd through 8th graders and 11th graders; Science scores for 5th, 8th, and 11th graders. In addition, we also have MEAP-Access Reading and Math scores for 3rd through 8th graders; Writing scores for 4th and 7th gradeers.
- For the 2011 Academic Year (AY), we have Mi-Access Reading and Math scores for 3rd through 8th graders and 11th graders; Science scores for 5th, 8th, and 11th graders.
- For the 2010 Academic Year (AY), we have Mi-Access Reading and Math scores for 3rd through 8th graders and 11th graders; Science scores for 5th, 8th, and 11th graders. In addition, we also have MEAP-Access Reading and Math scores for 3rd through 8th graders.
- For the 2008 and 2009 Academic Year (AY), we have Mi-Access Reading and Math scores for 3rd through 8th graders and 11th graders; Science scores for 5th, 8th, and 11th graders.
Codebook
Category Sort descending | Variable | Description |
---|---|---|
Category: Assessment Score | Variable: SCI_RSCH_Z_SCORE |
Description: A standardized score assigned to each student that describes each students relationship to the mean of all students with a score. |
Category: Assessment Score | Variable: SOC_THETA_SE |
Description: The Theta standard error for the social studies portion of the assessment. |
Category: Assessment Score | Variable: SCI_OVERALL_AGP |
Description: The adequate growth percentile (AGP) for the science portion of the assessment. |
Category: Assessment Score | Variable: MTH_PL_NAME |
Description: The performance level name for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: SCI_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the science portion of the assessment. |
Category: Assessment Score | Variable: RDG_PL_CHANGE |
Description: Performance level change is used to compare student performance from year to year for the reading portion of the assessment . Transition categories are: Significant Decline, Decline, Maintaining, Improvement, or Significant Improvement. Abbreviations are not used in this field, rather the actual descriptions are used. |
Category: Assessment Score | Variable: WRI_SS |
Description: The scaled score for the writing portion of the assessment. |
Category: Assessment Score | Variable: WRI_SS_SE |
Description: The scaled score standard error for the writing portion of the assessment. |
Category: Assessment Score | Variable: SOC_SS |
Description: The scaled score for the social studies portion of the assessment. |
Category: Assessment Score | Variable: MTH_PL_RANGE |
Description: A distinction which further differentiates whether the student was Low, Mid or High within their designated performance level for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: MTH_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: SCI_PL_NAME |
Description: The performance level name for the science portion of the assessment. |
Category: Assessment Score | Variable: ELA_SGP |
Description: The student growth percentile (SGP) for the English language arts portion of the assessment. |
Category: Assessment Score | Variable: RDG_PL_NAME |
Description: The performance level name for the reading portion of the assessment. |
Category: Assessment Score | Variable: MTH_THETA_SE |
Description: The Theta standard error for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: ELA_PL_NAME |
Description: The performance level name for the English language arts portion of the assessment. |
Category: Assessment Score | Variable: SOC_SS_SE |
Description: The scaled score standard error for the social studies portion of the assessment. |
Category: Assessment Score | Variable: MTH_RSCH_Z_SCORE |
Description: A standardized score assigned to each student that describes each students relationship to the mean of all students with a score. |
Category: Assessment Score | Variable: MTH_OVERALL_AGP |
Description: The adequate growth percentile (AGP) for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: MTH_PL_CHANGE |
Description: Performance level change is used to compare student performance from year to year for the mathematics portion of the assessment . Transition categories are: Significant Decline, Decline, Maintaining, Improvement, or Significant Improvement. Abbreviations are not used in this field, rather the actual descriptions are used. |
Category: Assessment Score | Variable: SCI_PL |
Description: The performance level for the science portion of the assessment. |
Category: Assessment Score | Variable: ELA_SS_SE |
Description: The scaled score standard error for the English language arts portion of the assessment. |
Category: Assessment Score | Variable: SCI_SGP |
Description: The student growth percentile (SGP) for the science portion of the assessment. |
Category: Assessment Score | Variable: MTH_SS |
Description: The scaled score for the mathematics portion of the assessment. |
Category: Assessment Score | Variable: RDG_VALID |
Description: Flag denoting whether the student's test was valid for the reading portion of the assessment. |
Category: Assessment Score | Variable: RDG_THETA_SE |
Description: The Theta standard error for the reading portion of the assessment. |
Category: Assessment Score | Variable: ELA_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the English language arts portion of the assessment. |
Category: Assessment Score | Variable: SCI_AGP_YRS_PROJ |
Description: The timeframe in which students are expected to reach proficiency. |
Category: Assessment Score | Variable: ELA_AGP_YRS_PROJ |
Description: The timeframe in which students are expected to reach proficiency. |
Category: Assessment Score | Variable: SOC_SGP |
Description: The student growth percentile (SGP) for the social studies portion of the assessment. |
Category: Assessment Score | Variable: SOC_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the social studies portion of the assessment. |
Category: Assessment Score | Variable: SOC_PL |
Description: The performance level for the social studies portion of the assessment. |
Category: Assessment Score | Variable: SCI_SS |
Description: The scaled score for the science portion of the assessment. |
Category: Assessment Score | Variable: SCI_VALID |
Description: Flag denoting whether the student's test was valid for the science portion of the assessment. |
Category: Assessment Score | Variable: RDG_PL |
Description: The performance level for the reading portion of the assessment. |
Category: Assessment Subscore | Variable: SUBSCORE_RPT_LEVEL_DESC |
Description: The description of the reporting level. |
Category: Assessment Subscore | Variable: SUBSCORE_PCT_CORRECT |
Description: The number of questions answered correctly divided by the total questions for this reporting level. |
Category: Assessment Subscore | Variable: SUBSCORE_RPT_LEVEL_TYPE |
Description: The reporting level type. Used as a means of organizing content standards and expectations. Varies by subject. |
Category: Assessment Subscore | Variable: SUBSCORE_SCALED_SCORE |
Description: The scaled score value for this reporting level. |
Category: Assessment Subscore | Variable: SUBSCORE_RPT_LEVEL_ID |
Description: The reporting level identifier value used by MDE. |
Category: Assignments | Variable: ASSIGNED_GRADE_06 |
Description: Flag designating that the staff member was assigned to teach sixth grade. |
Category: Assignments | Variable: IS_HIGHLY_QUALIFIED |
Description: This field reports whether or not a staff meets the requirements for being highly qualified. It is a required field only for teachers assigned to a core academic subject area and specific instructional paraprofessionals/aides as defined by NCLB and the MI Department of Education. |
Category: Assignments | Variable: ASSIGNED_GRADE_05 |
Description: Flag designating that the staff member was assigned to teach fifth grade. |
Category: Assignments | Variable: ASSIGNED_GRADE_09 |
Description: Flag designating that the staff member was assigned to teach ninth grade. |
Category: Assignments | Variable: ASSIGNMENT_CODE |
Description: The code that indicates the position held by the employee. |
Category: Assignments | Variable: ASSIGNED_GRADE_10 |
Description: Flag designating that the staff member was assigned to teach tenth grade. |
Category: Assignments | Variable: ASSIGNED_ISD_CODE |
Description: The state-assigned five-digit number, as recorded in the Educational Entity Master (EEM), that identifies the intermediate school district (ISD) or educational service agency (ESA) in which the district or program is located. This is the ISD that the educator is assigned to. |
Category: Assignments | Variable: ASSIGNED_GRADE_K |
Description: Flag designating that the staff member was assigned to teach Kindergarten. |
Category: Assignments | Variable: ASSIGNED_GRADE_11 |
Description: Flag designating that the staff member was assigned to teach eleventh grade. |
Category: Assignments | Variable: ASSIGNED_GRADE_02 |
Description: Flag designating that the staff member was assigned to teach second grade. |
Category: Assignments | Variable: EFFECTIVENESS_DESC |
Description: Description used to categorize Educator Effectiveness ranking. This is a locally determined label assigned as a result of annual educator evaluations. |
Category: Assignments | Variable: FTE |
Description: The amount of time required to perform an assignment stated as a proportion of a full-time position and computed by dividing the amount of time employed by the time normally required for a full-time position. |
Category: Assignments | Variable: FID_FUNCTION_CODE_DESC |
Description: The accounting/function description for the employee as determined for accounting purposes by the school district. |
Category: Assignments | Variable: SUMMARY_GROUP_NAME |
Description: The name for a grouping of assignment codes. The data from this grouping are similar to the data published on CEPI's website. |
Category: Assignments | Variable: ASSIGNED_GRADE_01 |
Description: Flag designating that the staff member was assigned to teach first grade. |
Category: Assignments | Variable: FEDERAL_GRANT_PARTICIPATION |
Description: This field identifies teachers funded by Title I or Title II Part A who teach core academic subjects in a targeted-assistance program. |
Category: Assignments | Variable: FID_FUNCTION_CODE |
Description: The accounting/function code for the employee as determined for accounting purposes by the school district. |
Category: Assignments | Variable: ASSIGNED_GRADE_RK |
Description: Flag designating that the staff member was assigned to teach Retentive Kindergarten. |
Category: Assignments | Variable: ASSIGNED_GRADE_04 |
Description: Flag designating that the staff member was assigned to teach fourth grade. |
Category: Assignments | Variable: ASSIGNED_GRADE_08 |
Description: Flag designating that the staff member was assigned to teach eighth grade. |
Category: Assignments | Variable: EDUCATIONAL_SETTING_DESC |
Description: The description for the educational setting (e.g., Bilingual Education/ELL or Special Education for various age groups, etc.) |
Category: Assignments | Variable: IS_MDE_TEACHER |
Description: Flag identifying teachers according to the MDE definition. |
Category: Assignments | Variable: ASSIGNMENT_DESCRIPTION |
Description: The description of the position held by the employee. |
Category: Assignments | Variable: ASSIGNED_GRADE_03 |
Description: Flag designating that the staff member was assigned to teach third grade. |
Category: Assignments | Variable: ASSIGNED_GRADE_07 |
Description: Flag designating that the staff member was assigned to teach seventh grade. |
Category: Assignments | Variable: ASSIGNED_GRADE_12 |
Description: Flag designating that the staff member was assigned to teach twelfth grade. |
Category: Assignments | Variable: IS_PRINCIPAL |
Description: Flag identifying principals according to the REP manual. |
Category: Awards | Variable: SCHOOL_START_YEAR_AWARDED |
Description: The numeric start year of the school year during which the award was conferred. Example: 2016 |
Category: Awards | Variable: AWARD_CIP_CATEGORY |
Description: The highest-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: Awards | Variable: IS_STARR_AWARD |
Description: Designates if the award record came from the STARR collection. |
Category: Awards | Variable: AWARD_CIP_CODE |
Description: The code indicating the discipline or field of study for which the award was conferred. 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: Awards | Variable: AWARD_LEVEL_CATEGORY |
Description: The reporting category of the level of achievement the student has received upon graduation/completion. |
Category: Awards | Variable: AWARD_DESCRIPTION |
Description: The descriptive title for the academic award, as submitted by the IHE. |
Category: Awards | Variable: AWARD_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: Awards | Variable: AWARD_DATE |
Description: The year, month and day in which the academic award was conferred. |
Category: Awards | Variable: SCHOOL_YEAR_AWARDED |
Description: The academic school year during which the award was conferred. Example: 2016-2017 |
Category: Awards | Variable: AWARD_LEVEL |
Description: The level of achievement the student has received upon graduation/completion. |
Category: Census Block | Variable: CENSUS_BLOCK |
Description: The state code, county code, census tract and census block numbers merged into one field as described in the Notes section on the previous tab. |
Category: Census Block | Variable: COLLECTION |
Description: General collection (Fall, Spring, Year) or SRM identifier. |
Category: Course Taking | Variable: COURSE_SECTION_NUMBER |
Description: The number assigned to differentiate among distinct occurrences ofcourses that have the same Course Subject Abbreviation and Course Number butare considered to be different courses. |
Category: Course Taking | Variable: IS_STARR_RECORD |
Description: Designates if the session record came from the STARR collection. |
Category: Course Taking | Variable: COURSE_TYPE_CODE |
Description: The two-digit code for the course type that represents the level and rigor of the instruction provided throughout the reported course. |
Category: Course Taking | Variable: LOCAL_COURSE_TITLE |
Description: The title assigned by the educating entity to identify a particular course. |
Category: Course Taking | Variable: RPIC_3 |
Description: The Research Personnel Identification Code (RPIC), as assigned in the Registry of Educational Personnel (REP) Application, for each teacher responsible for some or all of the instruction of the course being reported. Third of up to 3 possible. |
Category: Course Taking | Variable: ACADEMIC_SCHOOL_YEAR |
Description: The school year in which the data was reported by the district. |
Category: Course Taking | Variable: COURSE_FUNDING_CODE |
Description: The code for any programs that provide funding to the student course. |
Category: Course Taking | Variable: COMPLETION_STATUS_CODE |
Description: The standardized code representing a student's final status for the course being reported. |
Category: Course Taking | Variable: IS_VIRTUAL_DELIVERY |
Description: Flag that indicates whether the student is receiving instruction via a virtual delivery method. This could be virtual learning, online learning or computer courses; distance learning; or self-scheduled virtual learning. |
Category: Course Taking | Variable: COLLEGE_CREDIT |
Description: The number of college credit hours earned in a dual/concurrent enrollment course that is eligible for Section 64b Incentive funding. |
Category: Course Taking | Variable: NUMERIC_GRADE |
Description: The final numeric grade awarded for participation in the course. |
Category: Course Taking | Variable: IS_REMEDIAL |
Description: Y/N indicator of whether the course is a remedial course. |
Category: Course Taking | Variable: COURSE_TITLE |
Description: The name or title of the course, as defined by the IHE. |
Category: Course Taking | Variable: MOD_CREDITS_EARNED |
Description: Total of STARR Credits Earned for the course, or NSC FTE Days converted to Credits Earned for the session. |
Category: Course Taking | Variable: IS_REMEDIAL_SCIENCE |
Description: Y/N indicator of whether the course is a remedial science course. |
Category: Course Taking | Variable: IS_REMEDIAL_READING |
Description: Y/N indicator of whether the course is a remedial reading course. |
Category: Course Taking | Variable: LETTER_GRADE |
Description: The alphabetical grade earned in the course. |
Category: Course Taking | Variable: COURSE_SUBJECT |
Description: The alphabetic abbreviation of the academic department or discipline offering the course, as defined by the IHE. |
Category: Course Taking | Variable: IS_REMEDIAL_ESL |
Description: Y/N indicator of whether the course is a remedial English as a Second Language (ESL) course. |
Category: Course Taking | Variable: GRADE_SCALE_CODE |
Description: The grading scale used by the institution for the enrolled course, according to Postsecondary Electronic Standards Council (PESC) standards. |
Category: Course Taking | Variable: RPIC_2 |
Description: The Research Personnel Identification Code (RPIC), as assigned in the Registry of Educational Personnel (REP) Application, for each teacher responsible for some or all of the instruction of the course being reported. Second of up to 3 possible. |