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: 2008-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. The Michigan Education Assessment Program (MEAP) was administered in the Fall from 2007-2008 to 2013-2014. Michigan Merit Exam (MME) was administered in the Spring from 2007-2008 to 2013-2014. Michigan Student Test of Educational Progress (M-STEP) has been administered in the Spring from 2014-2015 to present, 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 2019-2020 academic year. In addition, Michigan state standardized assessments were voluntary in the 2020-2021 academic year. We have fewer records in 2020-2021 than we do in years where standardized assessments were mandatory - about 500,000 records, compared to over 680,000 in 2022 and 740,000 in 2019.
ELA Inconsistency
For MEAP assessments, ELA is not always reported. Reporting ELA can be calculated by combing a student's reading and writing score, with reading counting for 2/3 weight and writing for 1/3 weight. ELA is reported at the expense of reading and writing in M-STEP years. You can dive more deeply into a student's ELA score for M-STEP in the subscores dataset.
Number of Individuals with Records
We have assessment records for over 13.7 million student by year records in total from 2007-2008 to present. With regards to each specific assessment, we have records for 7 million student by year observations that were assessed using the M-STEP, 850,000 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 3.2 million total students, 2.2 million of whom ever took an MSTEP exam, 1.6 million of whom ever took a MEAP exam, and over 800,000 of whom ever took an MME exam.
Grades Assessments are Administered
The M-STEP is administered to students in the 3rd-7th grade,11th grade, and a few 12th graders. Before 2018-2019, 8th graders also took the M-STEP, but they are now administered the PSAT. 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, and 2021-present 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 2.1 million students in total.
Number of Test Takers by Grade
We have scores for over 1 million records for each grade from 3rd to 8th and 11th grade over the course of the file, roughly 100,000 per year. In addition, we have scores for 27,000 12th graders.
Subject Subscores by Academic Year and Grade
- For 2016-present (sans 2020 for COVID), 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 365,000 student by year observations, with over 125,000 total students. With regards to each specific assessment, we have records for 40,000 students that were assessed using the MEAP-Access and 95,000 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.
Individuals with Alternative and Standard Assesment Records
Approximately ~10-12% of students who sign up to take the alternative version of the state assessment also take the general version of the assessment. In these cases, the general version of the assessment is used in student reports and for accountability purposes.
Subjects Assessed by Academic Year and Grade
- For the 2015 to present (sans 2020 for COVID) Academic Years (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: All | Variable: BARCODE | Description: The barcode of the test given. |
| Category: All | Variable: ASSESSMENT | Description: The assessment the student participated in. |
| Category: All | Variable: TESTED_SCHOOL_CODE | Description: 5-digit code for building where student was tested |
| Category: All | Variable: TESTED_GRADE | Description: The grade level or the educational setting in which the student is enrolled. |
| Category: All | Variable: TESTED_DISTRICT_CODE | Description: State assigned 5 digit public school district where student was tested |
| Category: All | Variable: TEST_CYCLE_NAME | Description: The name that represents the test - year combination of the assessment. |
| Category: All | Variable: TEST_CYCLE_ID | Description: Number identifier for test, season, and year combination of assessment |
| Category: All | Variable: SUBJECT_IS_VALID | Description: Flag denoting if this portion of the assessment was valid. |
| Category: All | Variable: SUBJECT | Description: The subject of the assessment. |
| Category: All | Variable: SCHOOL_YEAR | Description: School Year of the data collection. |
| Category: All | Variable: RIC | Description: Student ID denoting a single student throughout educational career in MI |
| Category: All | Variable: IS_PRIVATE_SCHOOL | Description: Flag denoting whether student was attending private school at time of the test |
| Category: All | Variable: IS_HOME_SCHOOLED | Description: Flag denoting whether the student was homeschooled at the time of test. |
| Category: All | Variable: GRADE | Description: The grade level of the student enrolled. |
| Category: All | Variable: FEEDER_SCHOOL_CODE | Description: Stated assigned 5 digit number for building where student learned test material |
| Category: Alternative Assessments | Variable: SOC_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Alternative Assessments | Variable: WRI_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Alternative Assessments | Variable: SCI_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Alternative Assessments | Variable: RDG_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Alternative Assessments | Variable: IS_STATE_TESTED_FAY | Description: Y/N indicator for if student is considered a full academic year participant |
| Category: Alternative Assessments | Variable: IS_SCHOOL_TESTED_FAY | Description: Y/N indicator for if student is considered a full academic year participant |
| Category: Alternative Assessments | Variable: MTH_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Alternative Assessments | Variable: IS_DISTRICT_TESTED_FAY | Description: Y/N indicator for if student is considered a full academic year participant |
| Category: Alternative Assessments | Variable: ELA_MIACCESS_TEST_TYPE | Description: MI-Access Functional Independence for high, medium, and low range of complexity |
| Category: Assessment Score | Variable: SOC_OVERALL_SGP | Description: The student growth percentile for the social studies portion of the assessment |
| Category: Assessment Score | Variable: SOC_OVERALL_AGP | Description: Adequate Growth Percentile for social studies portion of assessment |
| Category: Assessment Score | Variable: SOC_AGP_YRS_PROJ | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: SOC_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: SCI_VALID | Description: Denotes whether student's test was valid for science portion of assessment |
| Category: Assessment Score | Variable: SCI_THETA_SE | Description: The Theta standard error for the science portion of the assessment. |
| Category: Assessment Score | Variable: SCI_SS_SE | Description: The scaled score standard error for the science 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_SGP_LEVEL_DESC | Description: Student Growth Percentile description for science portion of assessment |
| Category: Assessment Score | Variable: SCI_SGP | Description: The student growth percentile (SGP) for the science portion of the assessment. |
| Category: Assessment Score | Variable: SCI_RSCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: SCI_RESEARCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: SCI_PL_NAME | Description: The performance level name for the science portion of the assessment. |
| Category: Assessment Score | Variable: SCI_PL | Description: The performance level for the science portion of the assessment. |
| Category: Assessment Score | Variable: SCI_OVERALL_SGP | Description: The student growth percentile (SGP) for the science 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: SCI_AGP_YRS_PROJ | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: SCI_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: RDG_PL_NAME | Description: The performance level name for the reading portion of the assessment. |
| Category: Assessment Score | Variable: RDG_VALID | Description: Denotes whether students test was valid for reading portion of assessment |
| Category: Assessment Score | Variable: WRI_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: WRI_VALID | Description: Denotes whether students test was valid for writing portion of assessment |
| Category: Assessment Score | Variable: WRI_THETA_SE | Description: The Theta standard error 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: WRI_SS | Description: The scaled score for the writing portion of the assessment. |
| Category: Assessment Score | Variable: WRI_RESEARCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: WRI_PL_NAME | Description: The performance level name for the writing portion of the assessment. |
| Category: Assessment Score | Variable: WRI_PL | Description: The performance level for the writing portion of the assessment. |
| Category: Assessment Score | Variable: WRI_OVERALL_SGP | Description: The student growth percentile (SGP) for the writing portion of the assessment. |
| Category: Assessment Score | Variable: WRI_OVERALL_AGP | Description: The adequate growth percentile (AGP) for the writing 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: SOC_VALID | Description: Denotes validity of students test for social studies portion of assessment |
| Category: Assessment Score | Variable: SOC_THETA_SE | Description: The Theta standard error for the social studies portion of the assessment. |
| Category: Assessment Score | Variable: SOC_SS_SE | Description: Scaled score standard error for social studies portion of assessment |
| Category: Assessment Score | Variable: SOC_SS | Description: The scaled score for the social studies portion of the assessment. |
| Category: Assessment Score | Variable: SOC_SGP_LEVEL_DESC | Description: Student growth percentile description for social studies portion of assessment |
| Category: Assessment Score | Variable: SOC_SGP | Description: The student growth percentile for the social studies portion of the assessment |
| Category: Assessment Score | Variable: SOC_RSCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: SOC_RESEARCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: SOC_PL_NAME | Description: The performance level name for the social studies portion of the assessment. |
| Category: Assessment Score | Variable: ELA_SGP_LEVEL_DESC | Description: Student Growth Percentile description of the ELA portion of the assessment |
| Category: Assessment Score | Variable: MTH_PL | Description: The performance level for the mathematics portion of the assessment. |
| Category: Assessment Score | Variable: MTH_OVERALL_SGP | Description: The student growth percentile for the mathematics portion of the assessment. |
| Category: Assessment Score | Variable: MTH_OVERALL_AGP | Description: The adequate growth percentile for the mathematics portion of the assessment |
| Category: Assessment Score | Variable: MTH_AGP_YRS_PROJ | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: MTH_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: ELA_VALID | Description: Denotes whether student's test was valid for ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_THETA_SE | Description: Theta standard error for the ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_SS_SE | Description: Scaled score standard error for ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_SS | Description: The scaled score for the English language arts portion of the assessment. |
| Category: Assessment Score | Variable: RDG_SS_SE | Description: The scaled score standard error for the reading portion of the assessment. |
| Category: Assessment Score | Variable: ELA_SGP | Description: Student Growth Percentile for the ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_RSCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: ELA_RESEARCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: ELA_PL_NAME | Description: Performance level name for ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_PL | Description: The performance level for the English language arts portion of the assessment. |
| Category: Assessment Score | Variable: ELA_OVERALL_SGP | Description: Student Growth Percentile for the ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_OVERALL_AGP | Description: Adequate Growth Percentile for the ELA portion of the assessment |
| Category: Assessment Score | Variable: ELA_AGP_YRS_PROJ | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: ELA_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: MTH_PL_NAME | Description: The performance level name for the mathematics 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: RDG_SS | Description: The scaled score for the reading portion of the assessment. |
| Category: Assessment Score | Variable: RDG_RESEARCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |
| Category: Assessment Score | Variable: RDG_PL_RANGE | Description: Denotes student was low, mid, or high performance on the reading assessment |
| Category: Assessment Score | Variable: RDG_PL_CHANGE | Description: Compares yearly student performance level change in reading part of assessment |
| Category: Assessment Score | Variable: RDG_PL | Description: The performance level for the reading portion of the assessment. |
| Category: Assessment Score | Variable: RDG_OVERALL_SGP | Description: The student growth percentile (SGP) for the reading portion of the assessment. |
| Category: Assessment Score | Variable: RDG_OVERALL_AGP | Description: The adequate growth percentile (AGP) for the reading portion of the assessment. |
| Category: Assessment Score | Variable: RDG_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
| Category: Assessment Score | Variable: MTH_THETA_SE | Description: The Theta standard error for the mathematics portion of the assessment. |
| Category: Assessment Score | Variable: MTH_SS_SE | Description: The scaled score standard error for the mathematics 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: MTH_SGP_LEVEL_DESC | Description: Student growth percentile description for the math portion of the assessment |
| Category: Assessment Score | Variable: MTH_SGP | Description: The student growth percentile for the mathematics portion of the assessment. |
| Category: Assessment Score | Variable: MTH_RSCH_Z_SCORE | Description: Score assigned to each student comparing students score to mean score |