Highlights
Record Level: Student by award by institution
Record Count: 186,208 observations/year beginning in 2010
Years Covered: 2010-present*
Population Coverage: Students enrolled in or receiving an award from a Michigan public institution (see base file for details)
The awards dataset includes one record per student, for each award granted at all institutions. The dataset includes the reporting category of the award, such as Bachelor’s degree. Additionally, it includes award date, description, and CIP-code.
* Years covered includes any year for which there is data available in this file. However, researchers should note that these data encompass the academic histories of any student receiving an award beginning with the 2010 school year. As such, the base file “years covered” encompasses 2010, but all other files may include earlier records as well.
At the broadest level, student award levels are broken down into the following categories:
Award Level Category | Total observations/year |
---|---|
Associate Degree | 35,692 |
Bachelor's Degree | 80,380 |
Certificate | 11,552 |
Doctoral Degree | 6,936 |
Graduate Certificate | 556 |
Intermediate Graduate Degree | 91 |
Master's Degree | 25,845 |
Other | 17,328 |
Post-Master's Certificate | 228 |
Postbaccalaureate Certificate | 1,136 |
Postsecondary award, certificate | 5,352 |
Professional Degree | 1,002 |
Professional or Technical Credential | 110 |
Researchers should note the following about the datafile: During one or two of the earliest reporting years, the University of Michigan (Ann Arbor) reported an inordinate quantity of awards with the award date 01/01/2000. For many cases, there is an identical award in the file with a more legitimate date in a later academic year, but for some students the erroneous 01/01/2000 date remains. For this reason, the number of awards in 2000 can be inaccurate.
CEPI conducts some deduplication of award records, as follows:
- Award Levels of Bachelor's Degree and Baccalaureate Degree are treated the same, kept as Bachelor's Degree, and deduplicated if all other key fields are identical. From 2017-18 on, all Baccalaureate Award Levels are recoded to Bachelor's Degree in the source data for these files.
- For awards with an award level that is not equal to 'Other': Drop records with a null award CIP code if there is a corresponding record with matching IPEDS code, award date and award level, and an award CIP code value is present.
- For awards with an award level that is equal to 'Other': Drop records with a null award CIP code if there is a corresponding record with matching IPEDS code, award date, award level and award description, and an award CIP code value is present.
Codebook
Category Sort descending | Variable | Description |
---|---|---|
Category: Program Participation | Variable: IS_SPECIAL_EDUCATION |
Description: Flag indicating the student is eligible for Special Ed services. |
Category: Program Participation | Variable: IS_21ST_CENT_COMM_LC_PROG |
Description: Indicates this student participated in at least 30 sessions of an after-school or summer program funded through a 21st Century Community Learning Center (CCLC) grant.Program Code retired in 2017/2018 |
Category: Program Participation | Variable: IS_REDUCED_LUNCH_ELIGIBLE |
Description: Flag indicating if the student is eligible for reduced lunch based on Direct Certification through DHHS or Supplemental Nutrition Eligibility (SNE). If the student qualifies for Free Lunch, then the Reduced Lunch Eligible flag will be 'N' regardless of reduced lunch-specific eligibility factors. |
Category: Program Participation | Variable: IS_IMMIGRANT_PROGRAM |
Description: Flag indicating if the student participated in an Immigrant program. |
Category: Program Participation | Variable: IS_MIGRANT_ELIGIBLE |
Description: Flag indicating if the student was eligible for Migrant services. |
Category: Program Participation | Variable: IS_SUPPLEMENTAL_DIRECT_CERT |
Description: Flag indicating if the student has an active record in the Direct Certification database provided by DHHS. |
Category: Program Participation | Variable: IS_ELIGIBLE_FREE_LUNCH |
Description: Flag indicating if the student is eligible for free lunch based on being Migrant, Homeless, Direct Cert or Supplemental Nutrition Eligibility (SNE). |
Category: Program Participation | Variable: IS_HOMELESS_PROGRAM |
Description: Flag indicating if the homeless code field has a value greater than 0. |
Category: SAT and ACT | Variable: ACT_SCIENCE_SCORE |
Description: The ACT score for the science portion of the assessment. |
Category: SAT and ACT | Variable: WKEY_MTH_VALID |
Description: Flag denoting whether the student's test was valid for the mathematics portion of the assessment. (Y= Yes; N=No) |
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: IS_COLLEGE_REPORTABLE |
Description: A flag denoting whether the ACT scores for a student are considered viable to report to colleges. |
Category: SAT and ACT | Variable: SAT_MATH_SGP |
Description: The student growth percentile (SGP) for the mathematics portion of the assessment. |
Category: SAT and ACT | Variable: SAT_ELA_SGP_LEVEL |
Description: The student growth percentile (SGP) abbreviation for the English language arts portion of the assessment. |
Category: SAT and ACT | Variable: SAT_ELA_SGP |
Description: The student growth percentile (SGP) for the English language arts portion of the assessment. |
Category: SAT and ACT | Variable: SAT_MATH_COLLEGE_READY |
Description: Indicates whether college/career ready benchmark was met on the Mathematics test. |
Category: SAT and ACT | Variable: SAT_ELA_VALID |
Description: Flag denoting whether the student's test was valid for the English language arts portion of the assessment. |
Category: SAT and ACT | Variable: WKEY_LOC_INFO_LEVEL_SCORE |
Description: The level score for the locating information portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job. |
Category: SAT and ACT | Variable: SAT_MATH_SCORE |
Description: The official SAT score for the mathematics portion. |
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_MATH_VALID |
Description: Flag denoting whether the student's test was valid for the mathematics portion of the assessment. |
Category: SAT and ACT | Variable: SAT_TOTAL_SCORE |
Description: The official overall SAT score. |
Category: SAT and ACT | Variable: SAT_MATH_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the mathematics 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: SAT_ELA_SGP_LEVEL_DESC |
Description: The student growth percentile (SGP) description for the English language arts portion of the assessment. |
Category: SAT and ACT | Variable: WKEY_RDG_VALID |
Description: Flag denoting whether the student's test was valid for the reading portion of the assessment. (Y= Yes; N=No) |
Category: SAT and ACT | Variable: WKEY_RDG_SCALED_SCORE |
Description: The scaled score for the reading portion of the assessment. Scale Scores are used by educators to track growth in skills over time. |
Category: SAT and ACT | Variable: WKEY_LOC_INFO_SCALED_SCORE |
Description: The scaled score for the locating information portion of the assessment. Scale Scores are used by educators to track growth in skills over time. |
Category: SAT and ACT | Variable: WKEY_RDG_LEVEL_SCORE |
Description: The level score for the reading portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job. |
Category: SAT and ACT | Variable: ACT_READING_SCORE |
Description: The ACT score for the reading portion of the assessment. |
Category: SAT and ACT | Variable: SAT_MATH_SGP_LEVEL |
Description: The student growth percentile (SGP) abbreviation for the mathematics portion of the assessment. |
Category: SAT and ACT | Variable: SAT_COMBINED_VALID |
Description: Flag denoting whether the student's test was valid for the English language arts and mathematics portions of the assessment. |
Category: SAT and ACT | Variable: WKEY_MTH_SCALED_SCORE |
Description: The scaled score for the mathematics portion of the assessment. Scale Scores are used by educators to track growth in skills over time. |
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: WKEY_LOC_INFO_VALID |
Description: Flag denoting whether the student's test was valid for the locating information portion of the assessment. (Y= Yes; N=No) |
Category: SAT and ACT | Variable: ACT_COMPOSITE_SCORE |
Description: The composite score ranges from 1 (low) to 36 (high). The Composite score is the average of your four test scores, rounded to the nearest whole number. |
Category: SAT and ACT | Variable: ACT_ENGLISH_SCORE |
Description: The ACT score for the English portion of the assessment. |
Category: SAT and ACT | Variable: WKEY_NCRC_DESC |
Description: The ACT WorkKeys National Career Readiness Certificate (ACT WorkKeys NCRC®) is an assessment-based credential issued at four levels; Platinum, Gold, Silver, and Bronze. Other levels show information about the test, not necessarily credential levels. The NCRC measures and certifies the essential work skills needed for success in jobs across industries and occupations. |
Category: SAT and ACT | Variable: ACT_WRITING_SCORE |
Description: The ACT score for the writing portion of the assessment. |
Category: SAT and ACT | Variable: WKEY_MTH_LEVEL_SCORE |
Description: The level score for the mathematics portion of the assessment. Level Scores are often used in hiring and advancements decisions. They are based on ACT WorkKeys job profiles which are a snapshot of the skills needed for a particular job. |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_8 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: EO_SERVICE_NAME_7 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: SPECIAL_ED_PROGRAM_CODE_2 |
Description: The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. |
Category: Special Education | Variable: SPECIAL_ED_PROGRAM_CODE_3 |
Description: The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_10 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_PROGRAM_CODE_1 |
Description: The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_7 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_4 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_9 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_3 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: PARENTAL_CONSENT_DATE |
Description: The date on which the entity received the signed Parental Consent to Evaluate form. It is the beginning of the timeline for completion of the initial Individual Education Plan (IEP). |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_6 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_2 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_5 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: INITIAL_IEP_RESULT |
Description: The outcome code of the initial Individual Education Plan (IEP) determining if the student is eligible or ineligible for special education programs and services. |
Category: Special Education | Variable: INITIAL_IEP_COMPLETION_DATE |
Description: The completion of an Individual Education Program (IEP) is the date on the notice of the offer of a Free Appropriate Public Education (FAPE). |
Category: Special Education | Variable: SPECIAL_ED_SERVICE_CODE_1 |
Description: The code(s) representing any special education support service that provide developmental, corrective and other support as required to assist a child with a disability to benefit from special education (support services include related services) |
Category: Special Education | Variable: IEP_DATE |
Description: The date of the notice/offer of a Free Appropriate Public Education (FAPE) associated with the student's most recent Individual Education Program (IEP). |
Category: Special Education | Variable: INITIAL_IEP_TIMELIENESS |
Description: The timeliness status code for the evaluation of Individual Education Plan (IEP) eligibility. |
Category: Special Education | Variable: SECONDARY_DISABILITY_CODE_1 |
Description: Code used to describe additional disability characteristics as identified on the vision or audiological report. |
Category: Special Education | Variable: SPECIAL_ED_PROGRAM_CODE_4 |
Description: The code representing the IEP-designated program(s), or IFSP program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_1 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_10 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_4 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_6 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: EO_SERVICE_NAME_4 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: START_OF_SERVICE_TIMELINESS_NAME |
Description: The name of the Part C Indicator 1: Indicate the service start status for the services identified on the child's Individual Family Service Plan (IFSP). |
Category: Special Education | Variable: SEA_NOTIFICATION |
Description: Part C Indicator 8 B: Notification to the SEA must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services. |
Category: Special Education | Variable: START_OF_SERVICE_TIMELINESS_CODE |
Description: The code for the Part C Indicator 1: Indicate the service start status for the services identified on the child's Individual Family Service Plan (IFSP). |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_9 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: EO_SERVICE_CODE_1 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_7 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_10 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_8 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: RESULT_OF_INITIAL_IFSP_NAME |
Description: The name that indicates the results of the Individual Family Service Plan (IFSP) eligibility determination. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_7 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: LEA_NOTIFICATION |
Description: Part C Indicator 8 B: Notification to the LEA where the toddler resides must occur at least 90 days prior to the toddler's third birthday for toddlers potentially eligible for Part B preschool services. |
Category: Special Education | Variable: EO_SERVICE_CODE_4 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: TRANSITION_CONF_TIMELINESS_CODE |
Description: Part C Indicator 8 C code: Indicate if the transition IFSP conference was held within the required timeframe (at least 90 days but not more than nine months prior to the toddler's third birthday). |
Category: Special Education | Variable: PART_C_EXIT_REASON_NAME |
Description: The reason given for a child discontinuing services through Part C. |
Category: Special Education | Variable: TRANSITION_IFSP_TIMELINESS_CODE |
Description: Part C Indicator 8 A code: Indicate if the transition plan in the IFSP was completed within the required timeframe (at least 90 days but not more than nine months prior to the toddler's third birthday). |
Category: Special Education | Variable: SERVICE_COORDINATING_AGENCY |
Description: The name of the type of agency that is providing service coordination for this child through Part C. |
Category: Special Education | Variable: EO_SERVICE_NAME_3 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_CODE_2 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_NAME_5 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: RESULT_OF_INITIAL_IFSP_CODE |
Description: The code that indicates the results of the Individual Family Service Plan (IFSP) eligibility determination. |
Category: Special Education | Variable: EO_SERVICE_NAME_8 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_CODE_6 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_CODE_8 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_NAME_6 |
Description: The name of the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: EO_SERVICE_CODE_7 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_3 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: SECONDARY_DISABILITY_CODE_2 |
Description: Code used to describe additional disability characteristics as identified on the vision or audiological report. |
Category: Special Education | Variable: ELIGIBILITY_REASON_NAME_8 |
Description: The name/descriptor of the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_5 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_3 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |
Category: Special Education | Variable: INITIAL_IFSP_DATE |
Description: The date of the child's initial Individualized Family Service Plan (IFSP). |
Category: Special Education | Variable: EO_SERVICE_CODE_3 |
Description: The code for the Individual Education Plan (IEP)-designated program(s), or Individual Family Service Plan (IFSP) program(s), in which the student is participating. This is not to be confused with the student's type of disability. The student's program assignment is not required to match his/her impairment. (E.g., a student does not have to be diagnosed as early childhood developmentally delayed to participate in an early childhood special education program.) |
Category: Special Education | Variable: PRIM_SERVICE_SETTING_NAME |
Description: The name of the environment in which the majority of the services are being provided to the child. |
Category: Special Education | Variable: ELIGIBILITY_REASON_CODE_4 |
Description: The code used to identify the area of developmental delay or the established condition identified on the child's IFSP by which the child’s eligibility was determined. |