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 WorkKeys (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. Data from the 2007-2008 school year forward are available. Future years’ data will be added on an annual basis as data become available. Note that prior to the 2015-2016 school year, the ACT was retired from testing by the MDE, and was replaced with the SAT. We have Career and College Readiness assessment records for over 1.7 million students in total.
SAT and PSAT
Highlights
Record Level: Student by Year by Assessment
Record Count: 220,000-320,000 PSAT records per year, 83,000-110,000 SAT records per year
Years Covered: 2016-Present, excluding 2020
Population Coverage: Data covers all students from private, home schooled and public schools who have participated in these assessments.
For the SAT, we have three main scores: Total, English Language Arts, and Math. For the English Language Arts and Math portions of the assessment, we have variables that denote whether the student's score met the college/career benchmark. In addition we have the student's Student Growth Percentile for SAT assessment if the student previously took the PSAT. Please note that beginning in the 2018-2019 Academic Year the State no longer assesses 8th graders with the MSTEP, instead they have begun to assess 8th graders with the PSAT. PSAT scores for 8th graders are stored under the SAT variables SAT_TOTAL_SCORE, SAT_ELA_SCORE, SAT_MATH_SCORE. Those PSAT scores can be found using the variable named 'assessment' that has a possible value of 'PSAT 8'.
ACT
Highlights
Record Level: Student by Year by Assessment
Record Count: 119,000 records per year
Years Covered: 2008-2015
Population Coverage: Data covers all students from private, home schooled and public schools who have participated in these assessments.
For the ACT assessment, we have 7 scores: Composite, Math, English, Writing, Combined English/Writing, Reading, and Science. Prior to 2014-2015, ACT was a component of the MME assessment. For 2014-2015, it was given as its own assessment.
ACT WorkKeys
Highlights
Record Level: Student by Year by Assessment
Record Count: 93,000-133,000 records per year
Years Covered: 2008-Present
Population Coverage: Data covers all students from private, home schooled and public schools who have participated in these assessments.
The ACT Workkeys is a job skills assessment administered to 11th graders. For the WorkKeys assessment, we have 3 scores: Applied Mathematics, Locating Information, and Reading. Each of the 3 portions of the assessment have a scaled score and a level score.
Advanced Placement
Highlights
Record Level: Student by Year by Assessment
Record Count: 50,000-70,000 records per year
Years Covered: 2010-Present
Population Coverage: Data covers all students from private, home schooled and public schools who have participated in these assessments.
The Advanced Placement (AP) data contain scores on all AP tests taken by Michigan public school students. Scores evaluate mastery of associated subject material. All tests are taken once a year in May. Scores are between 1 and 5. Scores are available for all subjects (e.g., Calc AB, English Language, US History…).For AP assessments, we have over 40 variables corresponding to the subjects a student could take a test for.
Codebook
Category Sort descending | Variable | Description |
---|---|---|
Category: Advanced Placement Exams | Variable: PHYS2GR | Description: Physics 2: Exam Score |
Category: Advanced Placement Exams | Variable: GERLAGR | Description: German Language and Culture: Exam Score |
Category: Advanced Placement Exams | Variable: GOVCOMGR | Description: Comparative Government and Politics: Exam Score |
Category: Advanced Placement Exams | Variable: GOVUSGR | Description: United States Government and Politics: Exam Score |
Category: Advanced Placement Exams | Variable: HUMGEOGR | Description: Human Geography: Exam Score |
Category: Advanced Placement Exams | Variable: ITALGR | Description: Italian Language and Culture: Exam Score |
Category: Advanced Placement Exams | Variable: JAPANGR | Description: Japanese Language and Culture: Exam Score |
Category: Advanced Placement Exams | Variable: LATINCGR | Description: Latin: Exam Score |
Category: Advanced Placement Exams | Variable: LATINVGR | Description: Latin Vergil: Exam Score |
Category: Advanced Placement Exams | Variable: MUSICTGR | Description: Music Theory: Exam Score |
Category: Advanced Placement Exams | Variable: PHYS1GR | Description: Physics 1: Exam Score |
Category: Advanced Placement Exams | Variable: ARTHISGR | Description: Art History: Exam Score |
Category: Advanced Placement Exams | Variable: PHYSBGR | Description: Physics B: Exam Score |
Category: Advanced Placement Exams | Variable: PHYSEMGR | Description: Physics C: Electricity and Magnetism: Exam Score |
Category: Advanced Placement Exams | Variable: PHYSMGR | Description: Physics C: Mechanics: Exam Score |
Category: Advanced Placement Exams | Variable: PSYCHGR | Description: Psychology: Exam Score |
Category: Advanced Placement Exams | Variable: SPANLAGR | Description: Spanish Language: Exam Score |
Category: Advanced Placement Exams | Variable: SPANLTGR | Description: Spanish Literature and Culture: Exam Score |
Category: Advanced Placement Exams | Variable: STATGR | Description: Statistics: Exam Score |
Category: Advanced Placement Exams | Variable: USHISTGR | Description: United States History: Exam Score |
Category: Advanced Placement Exams | Variable: WDHISTGR | Description: World History: Exam Score |
Category: Advanced Placement Exams | Variable: ART3DGR | Description: Studio Art: 3-D Design Portfolio: Exam Score |
Category: Advanced Placement Exams | Variable: FRENLTGR | Description: French Literature: Exam Score |
Category: Advanced Placement Exams | Variable: ARTST2GR | Description: Studio Art: 2-D Design Portfolio: Exam Score |
Category: Advanced Placement Exams | Variable: ARTSTDGR | Description: Studio Art: Drawing Portfolio: Exam Score |
Category: Advanced Placement Exams | Variable: BIOLGR | Description: Biology: Exam Score |
Category: Advanced Placement Exams | Variable: CALCABGR | Description: Calculus AB: Exam Score |
Category: Advanced Placement Exams | Variable: CALCBCGR | Description: Calculus BC: Exam Score |
Category: Advanced Placement Exams | Variable: CHEMGR | Description: Chemistry: Exam Score |
Category: Advanced Placement Exams | Variable: CHINESGR | Description: Chinese Language and Culture: Exam Score |
Category: Advanced Placement Exams | Variable: COMSCAGR | Description: Computer Science A: Exam Score |
Category: Advanced Placement Exams | Variable: COMSCBGR | Description: Computer Science B: Exam Score |
Category: Advanced Placement Exams | Variable: COMSCPGR | Description: Computer Science Principles: Exam Score |
Category: Advanced Placement Exams | Variable: CPSTNRGR | Description: AP Capstone Research: Exam Score |
Category: Advanced Placement Exams | Variable: CPSTNSGR | Description: AP Capstone Seminar: Exam Score |
Category: Advanced Placement Exams | Variable: ECONMAGR | Description: Macroeconomics: Exam Score |
Category: Advanced Placement Exams | Variable: ECONMIGR | Description: Microeconomics: Exam Score |
Category: Advanced Placement Exams | Variable: ENGLANGR | Description: English Language and Composition: Exam Score |
Category: Advanced Placement Exams | Variable: ENGLITGR | Description: English Literature and Composition: Exam Score |
Category: Advanced Placement Exams | Variable: ENVSCIGR | Description: Environmental Science: Exam Score |
Category: Advanced Placement Exams | Variable: EURHISGR | Description: European History: Exam Score |
Category: Advanced Placement Exams | Variable: FRNLANGR | Description: French Language and Culture: Exam Score |
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: RIC | Description: Student ID denoting a single student throughout educational career in MI |
Category: All | Variable: TEST_CYCLE_NAME | Description: The name that represents the test - year combination of the assessment. |
Category: All | Variable: SCHOOL_YEAR | Description: School Year of the data collection. |
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: ASSESSMENT | Description: The assessment the student participated in. |
Category: All | Variable: TEST_CYCLE_ID | Description: Number identifier for test, season, and year combination of assessment |
Category: Assessment Score | Variable: SAT_RSCH_Z_SCORE_ELA | Description: Score assigned to each student comparing students score to mean score |
Category: Assessment Score | Variable: SAT_RSCH_Z_SCORE_MATH | Description: Score assigned to each student comparing students score to mean score |
Category: Assessment Score | Variable: SAT_RDG_WRI_OVERALL_AGP | Description: Adequate growth percentile for the reading/writing portion of the assessment |
Category: Assessment Score | Variable: SAT_RDG_WRI_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
Category: Assessment Score | Variable: SAT_MATH_OVERALL_AGP | Description: The adequate growth percentile for the mathematics portion of the assessment |
Category: Assessment Score | Variable: SAT_MATH_AGP_YEARS_PROJECTED | Description: The timeframe in which students are expected to reach proficiency. |
Category: SAT and ACT | Variable: SAT_MATH_SCORE | Description: The official SAT score for the mathematics portion. |
Category: SAT and ACT | Variable: WKEY_RDG_VALID | Description: Denotes whether students test was valid for reading portion of assessment |
Category: SAT and ACT | Variable: SAT_MATH_SGP | Description: The student growth percentile for the mathematics portion of the assessment. |
Category: SAT and ACT | Variable: SAT_MATH_SGP_LEVEL | Description: Student Growth Percentile abbreviation for the MATH portion of the assessment |
Category: SAT and ACT | Variable: SAT_MATH_SGP_LEVEL_DESC | Description: Student growth percentile description for the math portion of the assessment |
Category: SAT and ACT | Variable: SAT_MATH_VALID | Description: Flag denotes whether student's test was valid for the MATH portion |
Category: SAT and ACT | Variable: SAT_TOTAL_SCORE | Description: The official overall SAT score. |
Category: SAT and ACT | Variable: WKEY_LOC_INFO_LEVEL_SCORE | Description: The level score for the locating information portion of the assessment |
Category: SAT and ACT | Variable: WKEY_LOC_INFO_SCALED_SCORE | Description: The scaled score for the locating information portion of the assessment |
Category: SAT and ACT | Variable: WKEY_LOC_INFO_VALID | Description: Denotes whether student's test was valid for locating info. in assessment |
Category: SAT and ACT | Variable: WKEY_MTH_LEVEL_SCORE | Description: The level score for the mathematics portion of the assessment |
Category: SAT and ACT | Variable: WKEY_MTH_SCALED_SCORE | Description: The scaled score for the mathematics portion of the assessment |
Category: SAT and ACT | Variable: WKEY_MTH_VALID | Description: Whether student's test was valid for mathematics portion of the assessment |
Category: SAT and ACT | Variable: WKEY_NCRC_DESC | Description: ACT WorkKeys NCRC certificate issues at Platinum, Gold, Silver, and Bronze |
Category: SAT and ACT | Variable: WKEY_RDG_LEVEL_SCORE | Description: The level score for the reading portion of the assessment |
Category: SAT and ACT | Variable: WKEY_RDG_SCALED_SCORE | Description: The scaled score for the reading portion of the assessment |
Category: SAT and ACT | Variable: SAT_MATH_COLLEGE_READY | Description: Indicates whether college/career ready benchmark was met on the MATH test |
Category: SAT and ACT | Variable: SAT_ELA_VALID | Description: Denotes whether student's test was valid for ELA portion of the assessment |
Category: SAT and ACT | Variable: SAT_ELA_SGP_LEVEL_DESC | Description: Student Growth Percentile description of the ELA portion of the assessment |
Category: SAT and ACT | Variable: SAT_ELA_SGP_LEVEL | Description: Student Growth Percentile for the ELA portion of the assesment |
Category: SAT and ACT | Variable: SAT_ELA_SGP | Description: Student Growth Percentile for the ELA portion of the assessment |
Category: SAT and ACT | Variable: SAT_ELA_SCORE | Description: The official SAT score for the English language arts portion. |
Category: SAT and ACT | Variable: SAT_ELA_COLLEGE_READY | Description: Indicates whether college/career ready benchmark was met on ELA test |
Category: SAT and ACT | Variable: SAT_COMBINED_VALID | Description: Flag denoting whether student's test was valid for ELA and MATH portion |
Category: SAT and ACT | Variable: IS_COLLEGE_REPORTABLE | Description: Flag denoting whether ACT scores for student are viable to report to college |
Category: SAT and ACT | Variable: ACT_WRITING_SCORE | Description: The ACT score for the writing portion of the assessment. |
Category: SAT and ACT | Variable: ACT_SCIENCE_SCORE | Description: The ACT score for the science portion of the assessment. |
Category: SAT and ACT | Variable: ACT_READING_SCORE | Description: The ACT score for the reading portion of the assessment. |
Category: SAT and ACT | Variable: ACT_MATH_SCORE | Description: The ACT score for the math portion of the assessment. |
Category: SAT and ACT | Variable: ACT_ENGLISH_WRITING_SCORE | Description: The ACT score for the English_writing portion of the assessment. |
Category: SAT and ACT | Variable: ACT_ENGLISH_SCORE | Description: The ACT score for the English portion of the assessment. |
Category: SAT and ACT | Variable: ACT_COMPOSITE_SCORE | Description: The composite average score of four test scores, ranging from 1 to 36 |