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: Course Taking | Variable: LOCAL_COURSE_GRADE |
Description: The grade assigned by the educating entities to identify the level of achievement for a particular student course. |
Category: Course Taking | Variable: IS_REMEDIAL_WRITING |
Description: Y/N indicator of whether the course is a remedial writing course. |
Category: Course Taking | Variable: STARR_CREDITS_EARNED |
Description: The total value of credit hours successfully completed or earned for the course, as reported in STARR. |
Category: Course Taking | Variable: IS_STARR_RECORD |
Description: Designates if the session record came from the STARR collection. |
Category: Course Taking | Variable: STARR_CREDITS_ATTEMPTED |
Description: The total value of credit hours attempted for the course, as reported in STARR. |
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: COURSE_CIP_CODE |
Description: The Classification of Instructional Programs (CIP) code used by the US Department of Education's National Center for Education Statistics (NCES) to describe the area of study for the course. |
Category: Course Taking | Variable: COURSE_NUMBER |
Description: The official reference number/code portion of a course identifier, as defined by the IHE. |
Category: Course Taking | Variable: IS_REMEDIAL_MATH |
Description: Y/N indicator of whether the course is a remedial math course. |
Category: Course Taking | Variable: GRADE_STATUS |
Description: The student's disposition for the enrolled course. Examples: PassFailPass, Incomplete, HonorsGrade, Withdrew. |
Category: Course Taking | Variable: RPIC_1 |
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. First of up to 3 possible. |
Category: Course Taking | Variable: LOCAL_CREDITS_GRANTED |
Description: The Carnegie unit of credits granted to a student for completing the course or section of the course being reported. A course meeting every day for one period of the school day over the span of a school year offers one Carnegie unit. Thus, a Carnegie unit is a measure of seat time rather than a measure of attainment of the course objectives. Credit for a given course can vary from school district to school district. |
Category: Course Taking | Variable: LOCAL_COURSE_ID |
Description: The code assigned by the educating entity to identify a particular course. |
Category: Course Taking | Variable: VIRTUAL_METHOD_NAME |
Description: The type of virtual instruction the student is receiving. This could be virtual learning, online learning or computer courses; distance learning; or self-scheduled virtual learning. |
Category: Course Taking | Variable: LOCAL_COURSE_SECTION_ID |
Description: This characteristic is used by educating entities when the Local Course ID alone cannot uniquely identify a given course. |
Category: Course Taking | Variable: MOD_CREDITS_ATTEMPTED |
Description: Total of STARR Credits Attempted for the course, or NSC FTE Days converted to Credits Earned for the session. |
Category: Course Taking | Variable: CONTACT_HOURS |
Description: The seat time in front of the instructor. |
Category: Demographics | Variable: COHORT_YEAR |
Description: The cohort year the student is grouped into for tracking graduation outcomes. Assigned to a student upon being reported in 9th grade for the first time. Usually four years after student is seen in 9th grade unless the student is enrolled at an Early/Middle College. |
Category: Demographics | Variable: RACE_ETHNICITY |
Description: Reported ethnicity at the time the MTTC test(s) were taken. The options vary some relative to other data sets. |
Category: Demographics | Variable: GENDER_RAW |
Description: The student's gender as submitted by the IHE for the academic session. |
Category: Demographics | Variable: MONTH_YEAR_BIRTH_RAW |
Description: The student's date of birth as submitted by the IHE (month and year only for research data) for the academic session. |
Category: Demographics | Variable: RACE_ETHNICITY_RAW |
Description: The student's race/ethnicity as submitted by the IHE for the academic session. |
Category: Demographics | Variable: STABLE_GENDER |
Description: The latest reported gender for a student across all IHEs. Values are stabilized to one per student, favoring the most recently submitted data. CEPI does not receive gender data from NSC, so all values reflected here are sourced from STARR. |
Category: Demographics | Variable: STABLE_MONTH_YEAR_BIRTH |
Description: The latest reported date of birth (month and year only for research data) for the student for all time. Values are stabilized to one per student, favoring the most recently submitted data, then a present value over a missing value. |
Category: Demographics | Variable: RESIDENT_COUNTY_CODE |
Description: The two-digit code assigned to the Michigan county in which the student’s primary address is located. |
Category: Demographics | Variable: GRADE |
Description: The grade of the student. |
Category: Demographics | Variable: ECONOMICALLY_DISADVANTAGED |
Description: Indicates if the student is economically disadvantaged. |
Category: Demographics | Variable: IS_LEP |
Description: Indicator of whether or not a student has limited ability in speaking, reading, writing or understanding English. A Perkins IV Special Population. |
Category: Demographics | Variable: IS_DISPLACED_HOMEMAKER |
Description: Indicator of whether or not a student who has worked primarily in the home or for family, without compensation and has diminished marketable skills. A Perkins IV Special Population. |
Category: Demographics | Variable: LEP |
Description: Indicates if the student has limited English proficiency. |
Category: Demographics | Variable: IS_NON_TRADITIONAL |
Description: Indicator of whether or not a student's gender comprises fewer than 25 percent of individuals employed in the occupation or field of work the student is studying. A Perkins IV Special Population. |
Category: Demographics | Variable: IS_OUT_OF_WORKFORCE |
Description: A. An individual who is a displaced homemaker, as defined in section 3 of the Workforce Innovation and Opportunity Act (29 U.S.C. 3102)B. An individual who; (i)(I) has worked primarily without remuneration to care for a home and family, and for that reason has diminished marketable skills; or (II) is a parent whose youngest dependent child will become ineligible to receive assistance under part A of title IV of the Social Security Act (42 U.S.C. 601 et seq.) not later than 2 years after the date on which the parent applies for assistance under such title; and (ii) is unemployed or underemployed and is experiencing difficulty in obtaining or upgrading employment. |
Category: Demographics | Variable: IS_SPECIAL_POP_UNKNOWN |
Description: Indicator of whether or not the Perkins IV specific Special Population is unknown for the current session. |
Category: Demographics | Variable: IHE_AGE_AS_OF_SEP_30 |
Description: The student's age as of September 30th of the enrollment year. |
Category: Demographics | Variable: IS_INDIV_W_DISABILITY |
Description: Indicator of whether or not a student is an individual with a disability according to the Americans with Disabilities Act of 1990. A Perkins IV Special Population. |
Category: Demographics | Variable: IS_HOMELESS |
Description: Individuals who lack a fixed, regular and adequate nighttime residence (within the meaning of section 103(a)(1)) |
Category: Demographics | Variable: IS_FOSTER |
Description: “Age Out” - the time frame after which a foster care child is eligible for state services. Eligibility for state services varies depending on the state in which the child resides. Transitioning out of the child welfare system may occur as early as 18 or as late as age 23. |
Category: Demographics | Variable: IS_ECO_DIS |
Description: Indicator of whether or not a student has economic or academic disadvantages requiring special services or assistance. A Perkins IV Special Population. |
Category: Demographics | Variable: MONTH_YEAR_BIRTH_RAW |
Description: The date (month and year only) on which the student was born as it appears on a birth certificate or other legal document presented at the time of enrollment. |
Category: Demographics | Variable: GENDER |
Description: Reported gender |
Category: Demographics | Variable: RAW_RACIAL_ETHNIC_CODE |
Description: The ethnicity or race of the student. |
Category: Demographics | Variable: NATIVE_LANGUAGE_CODE |
Description: The code of the child's native or first language. The student's primary or native language indicated on the home language survey |
Category: Demographics | Variable: RESIDENT_COUNTY_NAME |
Description: The name of the Michigan county in which the student’s primary address is located. |
Category: Demographics | Variable: HOMELESS_STATUS |
Description: The status name for the primary nighttime residence of a student identified as homeless. |
Category: Demographics | Variable: COHORT_EXCLUSION |
Description: Indicator for those persons who may be removed (deleted) from a cohort (or subcohort). Allowed enumerations are:DeathTotal and Permanent DisabilityService in the Armed ForcesService with a foreign aid service of the federal governmentService on official church missions |
Category: Demographics | Variable: HOMELESS_CODE |
Description: The code for the primary nighttime residence of a student identified as homeless. |
Category: Demographics | Variable: NATIVE_LANGUAGE_NAME |
Description: The name of the child's native or first language. The student's primary or native language indicated on the home language survey |
Category: Demographics | Variable: IS_POVERTY |
Description: Flag indicating if the student is economically disadvantaged, based on Migrant, Homeless, Supplemental Nutrition Eligibility and Direct Certification status. |
Category: Demographics | Variable: FEDERAL_POVERTY_LEVEL_QUINTILE |
Description: The Federal Poverty Level (FPL) quintile to which a child belongs based on the records maintained by the program represented by a given record. |
Category: Demographics | Variable: BIRTH_YEAR |
Description: Reported year of birth |
Category: Demographics | Variable: RACE |
Description: The code representing the most recent reported racial and ethnicity group of the student. |
Category: Demographics | Variable: MULTIPLE_BIRTH_ORDER |
Description: Indicates that the student is part of a multiple birth where siblings share allunique identifying characteristics. Multiple Birth Order is not intended toidentify every case of twins, triplets, etc., in the state. It is only intended toprovide some distinguishing data element for cases where twins (triplets,etc.) of the same gender have the same or a similar first name. Each studentfrom such a multiple birth is to have a unique number. |
Category: Demographics | Variable: IS_FOSTER_CHILD |
Description: Flag indicating if the child has an active record in the recipient table from DHHS, then this field is set to Y. For Fall 2016 and Spring 2017, a flag set to “Y” may indicate either in-home or out-of-home placement of the child. |
Category: Demographics | Variable: IS_UNACCOMPANIED_YOUTH |
Description: Flag indicating if the student is an unaccompanied youth who is not in the physical custody of a parent or guardian and who fits the McKinney-Vento definition of homeless. |
Category: Demographics | Variable: STABLE_RACE_ETHNIC |
Description: The latest reported race/ethnicity for a student across all IHEs. Values are stabilized to one per student, favoring the most recently submitted data; then a known value over an unknown. In the event there is still a conflict, then the most likely of the reported values is chosen. CEPI does not receive race/ethnicity data from NSC, so all values reflected here are sourced from STARR. |
Category: Demographics | Variable: GENDER |
Description: The most recent reported gender of the student. |
Category: Demographics | Variable: RAW_GENDER |
Description: Indicates if the student is male or female. Code 'M' indicates the student is male. Code 'F' indicates the student is female. |
Category: Demographics | Variable: ZIP_CODE |
Description: The five- or nine-digit ZIP code of the location where the student lives at the time of reporting or the last known code of residence. |
Category: Demographics | Variable: IS_ECONOMICALLY_DISADVANTAGED |
Description: Flag to identify students who have been determined to be eligible for free or reduced-price meals via locally gathered and approved family applications under the National School Lunch program, are in households receiving food (SNAP) or cash (TANF) assistance, are homeless, are migrant, or are in foster care. When any of these conditions are present, a student is considered Economically Disadvantaged. |
Category: Demographics | Variable: GENDER_RAW |
Description: Indicates if the student is male or female. Code 'M' indicates the student is male. Code 'F' indicates the student is female. |
Category: Demographics | Variable: GRADUATION_COHORT_YEAR |
Description: The cohort year the student is grouped into for tracking graduation outcomes. Assigned to a student upon being reported in 9th grade for the first time. Usually four years after student is seen in 9th grade unless the student is enrolled at an Early/Middle College. Missing values are common and indicate a student is not advanced enough to be assigned a cohort year yet. |
Category: Demographics | Variable: RESIDENT_DISTRICT_NAME |
Description: The name for the Local Education Agency (LEA) district in which the student's custodial parent(s) or legal guardian resides. |
Category: Demographics | Variable: STABLE_GENDER |
Description: The latest MSDS-recorded gender for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset. |
Category: Demographics | Variable: RESIDENT_DISTRICT_CODE |
Description: The five-digit code for the Local Education Agency (LEA) geographic district in which the student's custodial parent(s) or legal guardian resides. |
Category: Demographics | Variable: GRADE_SY |
Description: The student's primary grade/setting as selected by CEPI reporting rules when multiple districts/schools report the student. (The grade level or the educational setting in which the student is enrolled.) |
Category: Demographics | Variable: STABLE_GRAD_YEAR |
Description: The latest recorded graduation year for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset. Missing values are common and indicate student is not due to graduate yet or did not graduate. |
Category: Demographics | Variable: READING_DEFICIENCY_CONTINUATION |
Description: Flag indicating the student had a reading deficiency continuing at end-of-year assessment. |
Category: Demographics | Variable: IS_COHORT_YEAR_CONFLICT |
Description: Indicates whether the student's graduation cohort year assignment has ever changed. Early Middle College participation or re-evaluation of a student's status may have resulted in the changes. Missing values are common and indicate the student is not advanced enough to be assigned a cohort year yet. |
Category: Demographics | Variable: IS_STABLE_RACE_ETHNIC_CONFLICT |
Description: Indicates whether conflicting racial/ethnic values have ever been reported for the student. |
Category: Demographics | Variable: IS_MILITARY_CONNECTED |
Description: Flag indicating a student has a parent who is a member of the Armed Forces on active duty or serves on fulltime National Guard duty. |
Category: Demographics | Variable: MONTH_YEAR_BIRTH_STABLE |
Description: The latest MSDS-recorded date of birth (month and year only for research data) for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset. |
Category: Demographics | Variable: RACIAL_ETHNIC_CODE_RAW |
Description: A unique six-position field using any combination of "0" through "6" in the proper position. Because this is a multipleoccurrence field, the indicator of the code is located by position in the format. The primary racial/ethnic choice is represented with a "1" and the second choice is a "2", etc. |
Category: Demographics | Variable: IS_GRADUATED_SY |
Description: Indicates student graduated in this school year (SCHOOL_YEAR). This value defaults to No and is set to Yes when there is a graduation record for a given school year. |
Category: Demographics | Variable: ETHNICITY_CODE_RAW |
Description: A unique six-position field using any combination of "0" through "6" in the proper position. Because this is a multipleoccurrence field, the indicator of the code is located by position in the format. The primary racial/ethnic choice is represented with a "1" and the second choice is a "2", etc. |
Category: Demographics | Variable: IS_STABLE_RACE_ETHNIC_CONFLICT |
Description: Indicates whether conflicting racial/ethnic category values have ever been reported for the student. |
Category: Demographics | Variable: RESIDENCY_STATUS_CODE |
Description: The code that indicates the student’s residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual. |
Category: Demographics | Variable: ZIP_CODE |
Description: Zip code associated with the street address of the individual submitted. |
Category: Demographics | Variable: IS_STABLE_GENDER_CONFLICT |
Description: Indicates whether conflicting gender values have ever been reported for the student. |
Category: Demographics | Variable: READING_DEFICIENCY_IDENTIFIED |
Description: Flag indicating the student had a reading deficiency identified at the beginning of year (or after enrollment). |
Category: Demographics | Variable: IS_SINGLE_PARENT |
Description: Indicator of whether or not a student is either an unmarried pregnant female, or a student of any gender who is unmarried or separated and has one or more minor children. A Perkins IV Special Population. |
Category: Demographics | Variable: IS_STABLE_GENDER_CONFLICT |
Description: Indicates whether conflicting gender values have ever been reported for the student. |
Category: Demographics | Variable: IS_STABLE_DATE_BIRTH_CONFLICT |
Description: Indicates whether conflicting date of birth values have ever been reported for the student. |
Category: Demographics | Variable: RESIDENT_DISTRICT_CODE |
Description: The five-digit code for the Local Education Agency (LEA) district in which the student's custodial parent(s) or legal guardian resides. |
Category: Demographics | Variable: RESIDENCY_NAME |
Description: The student's residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual. |
Category: Demographics | Variable: COHORT_STATUS_NAME |
Description: The name of the category assigned to a high school student based on grade and exit status. Used for grad/drop calculations. |
Category: Demographics | Variable: COHORT_STATUS_CODE |
Description: The code of the category assigned to a high school student based on grade and exit status. Used for grad/drop calculations. |
Category: Demographics | Variable: RESIDENCY_CODE |
Description: The code for the student's residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual. |
Category: Demographics | Variable: GENDER |
Description: The reported gender of the student. |
Category: Demographics | Variable: ETHNICITY_RACE |
Description: The ethnicity or race of the student. |
Category: Demographics | Variable: PRIMARY_ED_SETTING_SY |
Description: The student's primary educational setting for special education as selected by CEPI reporting rules when multiple districts/schools report the student. (The location or facility type where the student participates in special education programs or services.) |
Category: Demographics | Variable: MONTH_YEAR_BIRTH_RAW |
Description: The date (month and year only for research data) on which the student was born as it appears on a birth certificate or other legal document presented at the time of enrollment. |
Category: Demographics | Variable: PRIMARY_DISABILITY_CODE_RAW |
Description: The primary disability code identified on the student's Individual Education Plan (IEP) as defined by the Michigan Administrative Rules for Special Education (MARSE). |
Category: Demographics | Variable: IS_STABLE_DATE_BIRTH_CONFLICT |
Description: Indicates whether conflicting date of birth values have ever been reported for the student. |
Category: Demographics | Variable: STABLE_RACE_ETHNIC |
Description: The latest MSDS-recorded racial/ethnic category for the student for all time. Values are stabilized so there is only one value per student for all observations in this dataset. |
Category: Demographics | Variable: PRIMARY_ED_SETTING_CODE_RAW |
Description: The name of the location or facility type where the student participates in special education programs or services. Codes are categorized by student age. |
Category: Demographics | Variable: PRIMARY_DISABILITY_CODE_SY |
Description: The student's primary disability as selected by CEPI reporting rules when multiple districts/schools report the student. (Primary disability identified on the student's IEP as defined by the Michigan Administrative Rules for Special Education (MARSE). |
Category: Demographics | Variable: PRIMARY_LEP_LANGUAGE_SY |
Description: The student's native language selected by CEPI for federal reporting when multiple districts/schools report the student. See LEP_LANGUAGE_CODE_1, etc. for other languages. |
Category: Demographics | Variable: GRADE_RAW |
Description: The grade level or the educational setting in which the student is enrolled. |
Category: Developmental Assessment | Variable: DATA_SOURCE_CODE |
Description: The code for the comprehensive assessment tool used when completing the child's assessment. |
Category: Developmental Assessment | Variable: PARENT_INPUT_NAME |
Description: The name of the parent input about the child outcomes rating. |