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

Showing 1 - 90 of 90 results
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