ccc
lb
Guided
Pathways
Download Document

Metric Definition Dictionary

Contents

Metric Definition Dictionary. 1

DATA COMPARISONS AND CAVEATS. 4

STUDENT TYPE. 4

TIMEFRAMES. 4

COHORT VIEW.. 4

DATA DISAGGREGATION. 4

COMPARISON GROUPS. 5

DATA LIMITATIONS. 5

DATA SOURCE. 6

DEFINITION DESCRIPTIONS. 6

REGIONS. 6

STUDENTS. 11

GP 122F First Time Credit Students, Including Summer and Early College. 11

GP 333F First Time Credit Students, Including Summer and Early College, Who Did Not Transfer and Who Did Not Earn an Award. 11

DISAGGREGATIONS. 13

GP 103 Gender. 13

FP 104 Race/Ethnicity. 13

GP 105 Age Group. 14

GP 106 Perkins Economically Disadvantaged. 15

MILESTONES: COURSES. 17

GP 408 Course Success Rate for First Time Students. 17

MILESTONES: LEARNING PROGRESS. 18

GP 501 First Time Students Who Completed Both Transfer-Level Math and English in the District in the First Year18

GP 502 First Time Students Who Completed Transfer-Level Math in the District in the First Year. 19

GP 503 First Time Students Who Completed Transfer-Level English in the District in the First Year. 20

MILESTONES: CREDIT MOMENTUM.. 21

GP 406 First Time Students Retained Fall to Spring at the Same College. 21

GP 210 First Time Students Enrolled Full Time in the Fall Term.. 21

GP 404 First Time Students Who Successfully Completed Semester Unit Thresholds in Fall Term (GP 453 Wrapper Metric). 22

GP 444 First Time Students Who Successfully Completed Quarter Unit Thresholds in Fall Term (GP 453 Wrapper Metric). 23

GP 453 Wrapper Metric for First Time Students Who Successfully Completed Unit Thresholds in Fall Term��� 24

GP 214 First Time Students Enrolled Full Time in the Selected Year. 25

GP 405 First Time Students Who Successfully Completed Semester Unit Thresholds in the Selected Year (GP 454 Wrapper Metric). 26

GP 445 First Time Students Who Successfully Completed Quarter Unit Thresholds in the Selected Year (GP 454 Wrapper Metric). 27

GP 454 Wrapper Metric for First Time Students Who Successfully Completed Unit Thresholds in the Selected Year. 28

 


 

DATA COMPARISONS AND CAVEATS

STUDENT TYPE

The following provides the types of students who are included in the Guided Pathway dashboard on the LaunchBoard:

First-Time Students, Including Summer and Early College

First-time students include who enrolled in a community college for the first time in the summer or fall of the selected year, including those who had previously received concurrent enrollment credit.

TIMEFRAMES

Information is provided for the following years (unless noted otherwise):

  • 2018-2019
  • 2017-2018
  • 2016-2017
  • 2015-2016
  • 2014-2015
  • 2013-2014
  • 2012-2013
  • 2011-2012

 

Academic years include the leading summer plus fall, winter, and spring terms.

COHORT VIEW

Cohort views display information based on a cohort of students. Therefore, the specific students will be the same for all metrics displayed on the dashboard. The first-time student cohort is defined above in the Student Type section.

DATA DISAGGREGATION

Value options: Female, Male, Unknown/Non-Respondent, Multiple Values Reported

  • Race/Ethnicity (for all Views):

Value options: American Indian/Alaska Native, Asian, Black or African American, Filipino, Hispanic, Native Hawaiian or Other Pacific Islander, Two or More Races, White, Unknown/Non-Respondent, Multiple Values Reported

  • Age Group (for all Views):

Value options: 19 or less, 20 to 24, 25 to 29, 30 to 34, 35 to 39, 40 to 54, 55 and older, Unknown

  • Perkins Economically Disadvantaged (for all Views)

Value options: Economically Disadvantaged per Perkins definition (GP 106) and Not Economically Disadvantaged per Perkins definition

COMPARISON GROUPS

Comparison data is provided for the following:

  • Statewide: is based on the 114 colleges plus the three noncredit institutions. Counts, dollar values, and percentages are medians across all students in the state
  • Macro-region Median: is based on all the colleges and noncredit institutions within a specific macroregion. Counts, dollar values, and rates are medians across all students in the macroregion.
  • Micro-region Median: is based on all colleges and noncredit institutions within a specific microregion. Counts, dollar values, and rates are medians across all students in the microregion.
  • District Median: is based on all of the colleges and noncredit institutions within a specific district. Counts, dollar values, and rates are medians across all students in the district.
  • College Median: is based on the college selected. Counts, dollar values, and rates are medians across all students in the college.

DATA LIMITATIONS

Missing and Suppressed Information

 

Deduplication

In cases where students are enrolled at more than one college, and have provided conflicting information regarding goals or characteristics, assignment will be handled as described below. As a result, district, regional and statewide totals may not match the sum of college-level totals.

DATA SOURCE

  • Community college metrics are based on records submitted by community colleges to the California Community Colleges Chancellor's Office Management Information System (MIS)

DEFINITION DESCRIPTIONS

  • Description: Description of the metric
  • Student Type: n/a
  • Data Source: The entity providing data used in the calculation
  • Data Element: The specific data elements used from each data source
  • Calculation: The specific calculations used to derive the data value
  • Denominator: The universe of students included
  • Value Type: The type of data value populated for the metric
  • Drilldowns: The drilldown options (Age Group, Race/Ethnicity, Gender, Economically Disadvantaged) available for the metric. NOTE: All drilldowns will be the same for all metrics
  • SSM Alignment: Notes specific to how the metric aligns or does not align to a similar metric in the Student Success Metrics dashboard
  • Testing: Comparisons to similar or same metrics on other dashboards
  • Notes: General information or caveats about the data for the metric

REGIONS

Regions are assigned as follows.

Macroregion

Microregion

District

Community College

Bay Area

East Bay

Chabot-Las Positas

Chabot College

Bay Area

East Bay

Chabot-Las Positas

Las Positas College

Bay Area

East Bay

Contra Costa

Contra Costa College

Bay Area

East Bay

Contra Costa

Diablo Valley College

Bay Area

East Bay

Contra Costa

Los Medanos College

Bay Area

East Bay

Ohlone

Ohlone College

Bay Area

East Bay

Peralta

Berkeley City College

Bay Area

East Bay

Peralta

College of Alameda

Bay Area

East Bay

Peralta

Laney College

Bay Area

East Bay

Peralta

Merritt College

Bay Area

Mid-Peninsula

San Francisco

City College of San Francisco

Bay Area

Mid-Peninsula

San Francisco

San Francisco Centers

Bay Area

Mid-Peninsula

San Mateo

Ca�ada College

Bay Area

Mid-Peninsula

San Mateo

College of San Mateo

Bay Area

Mid-Peninsula

San Mateo

Skyline College

Bay Area

North Bay

Marin

College of Marin

Bay Area

North Bay

Napa Valley

Napa Valley College

Bay Area

North Bay

Solano

Solano Community College

Bay Area

North Bay

Sonoma

Santa Rosa Junior College

Bay Area

Santa Cruz-Monterey

Cabrillo

Cabrillo College

Bay Area

Santa Cruz-Monterey

Hartnell

Hartnell College

Bay Area

Santa Cruz-Monterey

Monterey

Monterey Peninsula College

Bay Area

Silicon Valley

Foothill-Deanza

De Anza College

Bay Area

Silicon Valley

Foothill-Deanza

Foothill College

Bay Area

Silicon Valley

Gavilan

Gavilan College

Bay Area

Silicon Valley

San Jose-Evergreen

Evergreen Valley College

Bay Area

Silicon Valley

San Jose-Evergreen

San Jose City College

Bay Area

Silicon Valley

West Valley-Mission

Mission College

Bay Area

Silicon Valley

West Valley-Mission

West Valley College

Central Valley-Mother Lode

Northern Central Valley-Mother Lode

Merced

Merced College

Central Valley-Mother Lode

Northern Central Valley-Mother Lode

San Joaquin Delta

San Joaquin Delta College

Central Valley-Mother Lode

Northern Central Valley-Mother Lode

Yosemite

Columbia College

Central Valley-Mother Lode

Northern Central Valley-Mother Lode

Yosemite

Modesto Junior College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

Kern

Bakersfield College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

Kern

Cerro Coso Community College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

Kern

Porterville College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

Sequoias

College of the Sequoias

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

State Center

Clovis Community College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

State Center

Fresno City College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

State Center

Reedley College

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

West Hills

West Hills College Coalinga

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

West Hills

West Hills College Lemoore

Central Valley-Mother Lode

Southern Central Valley-Mother Lode

West Kern

Taft College

Inland Empire

Inland Empire

Barstow

Barstow College

Inland Empire

Inland Empire

Chaffey

Chaffey College

Inland Empire

Inland Empire

Copper Mountain

Copper Mountain Community College

Inland Empire

Inland Empire

Desert

College of the Desert

Inland Empire

Inland Empire

Mt. San Jacinto

Mt. San Jacinto College

Inland Empire

Inland Empire

Palo Verde

Palo Verde College

Inland Empire

Inland Empire

Riverside

Moreno Valley College

Inland Empire

Inland Empire

Riverside

Norco College

Inland Empire

Inland Empire

Riverside

Riverside City College

Inland Empire

Inland Empire

San Bernardino

Crafton Hills College

Inland Empire

Inland Empire

San Bernardino

San Bernardino Valley College

Inland Empire

Inland Empire

Victor Valley

Victor Valley College

Los Angeles-Orange County

Los Angeles

Cerritos

Cerritos College

Los Angeles-Orange County

Los Angeles

Citrus

Citrus College

Los Angeles-Orange County

Los Angeles

Compton

Compton College

Los Angeles-Orange County

Los Angeles

El Camino

El Camino College

Los Angeles-Orange County

Los Angeles

Glendale

Glendale Community College

Los Angeles-Orange County

Los Angeles

Long Beach

Long Beach City College

Los Angeles-Orange County

Los Angeles

Los Angeles

East Los Angeles College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles City College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Harbor College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles ITV

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Mission College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Pierce College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Southwest College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Trade-Tech College

Los Angeles-Orange County

Los Angeles

Los Angeles

Los Angeles Valley College

Los Angeles-Orange County

Los Angeles

Los Angeles

West Los Angeles College

Los Angeles-Orange County

Los Angeles

Mt. San Antonio

Mt. San Antonio College

Los Angeles-Orange County

Los Angeles

Pasadena

Pasadena City College

Los Angeles-Orange County

Los Angeles

Rio Hondo

Rio Hondo College

Los Angeles-Orange County

Los Angeles

Santa Monica

Santa Monica College

Los Angeles-Orange County

Orange

Coast

Coastline Community College

Los Angeles-Orange County

Orange

Coast

Golden West College

Los Angeles-Orange County

Orange

Coast

Orange Coast College

Los Angeles-Orange County

Orange

North Orange

Cypress College

Los Angeles-Orange County

Orange

North Orange

Fullerton College

Los Angeles-Orange County

Orange

North Orange

North Orange Adult

Los Angeles-Orange County

Orange

Rancho Santiago

Santa Ana College

Los Angeles-Orange County

Orange

Rancho Santiago

Santiago Canyon College

Los Angeles-Orange County

Orange

South Orange

Irvine Valley College

Los Angeles-Orange County

Orange

South Orange

Saddleback College

North-Far North

Greater Sacramento

Lake Tahoe

Lake Tahoe Community College

North-Far North

Greater Sacramento

Los Rios

American River College

North-Far North

Greater Sacramento

Los Rios

Cosumnes River College

North-Far North

Greater Sacramento

Los Rios

Folsom Lake College

North-Far North

Greater Sacramento

Los Rios

Sacramento City College

North-Far North

Greater Sacramento

Sierra

Sierra College

North-Far North

Greater Sacramento

Yuba

Woodland Community College

North-Far North

Greater Sacramento

Yuba

Yuba College

North-Far North

Northern Coastal

Mendocino-Lake

Mendocino College

North-Far North

Northern Coastal

Redwoods

College of the Redwoods

North-Far North

Northern Inland

Butte

Butte College

North-Far North

Northern Inland

Feather River

Feather River College

North-Far North

Northern Inland

Lassen

Lassen College

North-Far North

Northern Inland

Shasta-Tehama-Trinity

Shasta College

North-Far North

Northern Inland

Siskiyous

College of the Siskiyous

San Diego-Imperial

San Diego-Imperial

Grossmont-Cuyamaca

Cuyamaca College

San Diego-Imperial

San Diego-Imperial

Grossmont-Cuyamaca

Grossmont College

San Diego-Imperial

San Diego-Imperial

Imperial

Imperial Valley College

San Diego-Imperial

San Diego-Imperial

Mira Costa

MiraCosta College

San Diego-Imperial

San Diego-Imperial

Palomar

Palomar College

San Diego-Imperial

San Diego-Imperial

San Diego

San Diego Adult

San Diego-Imperial

San Diego-Imperial

San Diego

San Diego City College

San Diego-Imperial

San Diego-Imperial

San Diego

San Diego Mesa College

San Diego-Imperial

San Diego-Imperial

San Diego

San Diego Miramar College

San Diego-Imperial

San Diego-Imperial

Southwestern

Southwestern College

South Central Coast

South Central Coast

Allan Hancock

Allan Hancock College

South Central Coast

South Central Coast

Antelope Valley

Antelope Valley College

South Central Coast

South Central Coast

San Luis Obispo

Cuesta College

South Central Coast

South Central Coast

Santa Barbara

Santa Barbara City College

South Central Coast

South Central Coast

Santa Clarita

College of the Canyons

South Central Coast

South Central Coast

Ventura

Moorpark College

South Central Coast

South Central Coast

Ventura

Oxnard College

South Central Coast

South Central Coast

Ventura

Ventura College

 


 

STUDENTS

GP 122F First Time Credit Students, Including Summer and Early College

Description

All students who enrolled in a credit course for the first time in the district in the fall of the selected year, including those who enrolled in the summer intersession immediately before or had previously earned concurrent enrollment credit

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SB11 Student-Education-Status

STD7 Student-Headcount-Status

SX Domain and Format

SXD2 Enrollment-Credit-Status

Calculations

Student who met all of the following criteria:

       With a record in the Student Enrollment Data Elements (SX) file

SX has a value

        AND where the student appears as a first-time NSA credit student

WHERE GI03 = Min(GI03) AND

SXD2 IN (T, D, S) AND

STD7 in (A, B, C, D, E) AND

SB11 not equal to 10000

        Flagged as a first-time NSA credit student overall in the fall term of the selected year, and the districts they were enrolled in during that year

WHERE [GI03 IS IN (YY7 or YY8)] is within the selected year and is in the district

Denominator

n/a

Value Type

Unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

This metric is not currently in the SSM dashboard which has a snapshot view only

Testing

GP 122F should be coded similar to SM 332SW except that students who enrolled in the preceding summer term as special admit are included in Guided Pathways

Notes

 

GP 333F First Time Credit Students, Including Summer and Early College, Who Did Not Transfer and Who Did Not Earn an Award

Description

All students who enrolled in a credit course for the first time in the district, in the fall of the selected year, including those who enrolled in the summer intersession immediately before or had previously earned concurrent enrollment credit, who did not transfer and who did not earn an award

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

SP02 Student-Program-Award

GI03 Term-Identifier

SB11 Student-Education-Status

STD7 Student-Headcount-Status

SX Domain and Format

SXD2 Enrollment-Credit-Status

Calculations

Student who met all of the following criteria:

       With a record in the Student Enrollment Data Elements (SX) file

SX has a value

        AND where the student appears as a first-time NSA credit student

WHERE GI03 = Min(GI03) AND

SXD2 IN (T, D, S) AND

STD7 in (A, B, C, D, E) AND

SB11 not equal to 10000

        Flagged as a first-time NSA credit student overall in the fall term of the selected year in the districts that they are enrolled in during the selected year

WHERE [GI03 IS IN (YY7 or YY8) is within the selected year and is in the district

         AND did not receive a Chancellor's Office approved degree or certificate in the selected year

AND [SP02 is NOT IN (A, S, B, L, T, F, L, H, I, J, K, L, M, N, P, Q, R, Y, Z)

WHERE GI03 is within the selected year]

         AND did not transfer to a four-year postsecondary institution in the selected year

AND No valid course enrollment reported by CSU, UC, and the National Student Clearinghouse for any four-year postsecondary institutions within the selected year

Denominator

n/a

Value Type

Unduplicated count of students

Drilldowns

Disaggregations: n/a

SSM Alignment

Metric will not be displayed on the dashboard but will be used as a denominator for GP 406 First Time Students Retained Fall to Spring at the Same College

Testing

SM 333SW should be coded similar to GP 333F

Notes

 

 

DISAGGREGATIONS

GP 103 Gender

Description

Students who were in specific gender categories

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SB04 Gender

Calculations

Student who met all of the following criteria:

        Enrolled in the selected year

WHERE GI03 is within the selected year

        Then Grouped by Gender as recorded in the last term of enrollment

AND SB04 IN (F, M, B, X)

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Unduplicated count of students

Drilldowns

n/a

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Testing

CP 103, SM 103 and AE 300 should be aligned

Notes

         Use latest category provided at the institutional level, or if a student has more than one gender or unreported anywhere in the system, assign the student to the "multiple values reported" category

         SB04 includes X which corresponds to unknown/non-respondent. This category is different than "multiple values reported" which is where students are placed if there is conflicting information at different colleges in the system

         "B" for Non-binary is a new value added for SB04 in the summer 2019

FP 104 Race/Ethnicity

Description

Students who were in specific race/ethnicity categories

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

STD10 Student-IPEDS-Ethnicity  

Calculations

Student who met all of the following criteria:

        Enrolled in the selected year

WHERE GI03 is within the selected year

        Then Grouped by Ethnicity as recorded in the last term of enrollment

AND STD10 IN (A, B, F, H, N, P, W, T, X)

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Unduplicated count of students

Drilldowns

n/a

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Testing

CP 104, SM 104 and AE 301 should be aligned

Notes

         Use latest category provided at the institutional level, or if there is more than one selection in the same term, assign the student to the "multiple values reported" category

         Race/ethnicity is based on IPEDS categories plus Filipino/a category

         STD10 includes X which corresponds to unknown/non-respondent. This category is different than "multiple values reported" which is where students are placed if there is conflicting information at different colleges in the system

GP 105 Age Group

Description

Students who were in specific age ranges

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SB03 Student-Birth-Date

Calculations

Student met all of the following criteria:

        Enrolled in the selected year

WHERE GI03 is within the selected year

        Age determined on Oct. 15th In the selected year anywhere in the community college system

AND (Oct 15th In the selected year - SB03)

        Then Grouped by the following age groups to determine percentages and distinct counts

AND Grouped together into:

19 or less

20 to 24

25 to 29

30 to 34

35 to 39

40 to 54

55 and older

Multiple Values Reported

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Unduplicated count of students

Drilldowns

n/a

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Testing

CP 105, SM 105 and AE 302 should be aligned

Notes

         Use age as of October 15th of the academic year at the institutional level

         SB03 does allow for an entry of YYYYMM99 or 99999999 to designate an unknown birthdate

GP 106 Perkins Economically Disadvantaged

Description

Students considered economically disadvantaged using the Perkins definition

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SB26 Student-WIA-Status

SC01 CalWORKs-Eligibility-Status

SF21 Student-Aid-Award-Type

SV03 Student-VTEA-Economically-Disadv-Status

Calculations

Student who met the following criteria in EITHER of these ways:

        Enrolled in the selected year

WHERE GI03 is within the selected year

        AND EITHER ever participated in the Workforce Investment Act (WIA) program at any college where enrolled

AND EITHER SB26 = J

        OR ever received a financial aid award at any college where enrolled

OR SF21 IN (BA, B1, B2, B3, BB, BC, BD, GC, GP, GS, WF)

        OR ever identified as a participant in a CalWORKs program at any college where enrolled

OR SC01 IN (1,2,3,4,6)

        OR ever identified as economically disadvantaged status at any college where enrolled

OR SV03 IN (1S, 1A, 1N, 2S, 2A, 2N, 3S, 3A, 3N, 4S, 4A, 4N)

        AND at any time up to and including the selected year

WHERE GI03 is any time up to and including the selected year

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Unduplicated count of students

Drilldowns

n/a

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Testing

CP 106 and SM 106 should be aligned with CP 106 on SWP dashboard

Notes

         This metric has been updated to align to the definition provided by MIS on 10/2/19 to denote Economically Disadvantaged status for Perkins. Based on guidance that these values are captured by one of the other included codes or that these are not uniquely related to indicators of socio-economic disadvantage, the following values were removed for SF21: F1, F2, F3, F4, F5, GB, GG, GW, GW, WF. For the same reasons, the following values were removed for SV03: 1N, 2N, 3N, 4N. SC01 data element has been added.

         If a student enrolls at more than one college and is considered economically disadvantaged at one college and not the other, the student is still considered economically disadvantaged.


 

MILESTONES: COURSES

GP 408 Course Success Rate for First Time Students

Description

Among all credit enrollments, the percentage of enrollments where students successfully completed the course

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Calculations

Enrollments counted to determine course success rate that met all of the following criteria:

         Count of enrollments with passing grades

SUM (SX03) for all SX04 WHERE

[First character of SX04 IN (A, B, C, P) OR

First two characters of SX04 IN (IA, IB, IC) OR

First three characters of SX04 in (IPP)]

        AND for credit courses only

AND CB04 IN (C, D)

         AND in the selected year

WHERE GI03 is within the selected year

 

Divide by enrollments that met all of the following criteria to determine rate:

        Count of enrollments with allowable grades for enrollment to be included in denominator for course success rate as displayed in Datamart

WHERE SX04 NOT IN (EW, MW, RD, SP, UD, UG)

        AND for credit courses only

AND CB04 IN (C, D)

        AND in the selected year

WHERE GI03 is within the selected year

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

The grades to be included in the calculation of all enrollments was given to us from MIS on 2/6/19


 

MILESTONES: LEARNING PROGRESS

GP 501 First Time Students Who Completed Both Transfer-Level Math and English in the District in the First Year

Description

Among all first-time credit students in the district, the proportion who completed both transfer-level math and English in their first academic year of credit enrollment within the district

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB03 Course-TOP-Code

GI03 Term-Identifier

SXD2 Enrollment-Credit-Status

SX04 Enrollment-Grade

Calculations

Students who met all of the following criteria:

        Had an enrollment in a math course in the district

CB03 = 1701.00

        AND that was a transfer level course

AND SXD2 = T

        AND earned a passing grade

AND [First character of SX04 IN (A, B, C, P) OR

First two characters of SX04 IN (IA, IB, IC) OR

First three characters of SX04 IN (IPP)]

        AND had an enrollment in an English course in the district

AND CB03 IN (1501.00, 1520.00)

        AND that was a transfer level course

AND SXD2 = T

        AND earned a passing grade

WHERE [First character of SX04 IN (A, B, C, P) OR

First two characters of SX04 IN (IA, IB, IC) OR

First three characters of SX04 IN (IPP)]

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         Incomplete grades are included in Course Success and Completed Transfer Level Math and English in the District in the First Year

         Courses outside of math and English Taxonomy of Program (TOP) codes are not currently included in this metric

         Includes completion of the courses in the same district only

         CB25 COURSE-GENERAL-EDUCATION-STATUS has been added in summer 2019 to account for courses that are not listed on the TOP codes indicated in the calculation above but that fulfill general education requirements for mathematics/quantitative reasoning or English composition in the context of transfer, degree, and certificate program.

GP 502 First Time Students Who Completed Transfer-Level Math in the District in the First Year

Description

Among all first-time credit students in the district, the proportion who completed transfer-level math in their first academic year of credit enrollment within the district

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB03 Course-TOP-Code

GI03 Term-Identifier

SXD2 Enrollment-Credit-Status

SX04 Enrollment-Grade

Calculations

Students who met all of the following criteria:

        Had an enrollment in a math course in the district

CB03 = 1701.00

        AND that was a transfer level course

AND SXD2 = T

        AND earned a passing grade

AND [First character of SX04 IN (A, B, C, P) OR

First two characters of SX04 IN (IA, IB, IC) OR

First three characters of SX04 IN (IPP)]

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         Incomplete grades are included in Course Success and Completed Transfer Level Math and English in the District in the First Year

         Courses outside of math Taxonomy of Program (TOP) codes are not currently included in this metric

         Includes completion of the courses in the same district only

         CB25 COURSE-GENERAL-EDUCATION-STATUS has been added in summer 2019 to account for courses that are not listed on the TOP codes indicated in the calculation above but that fulfill general education requirements for mathematics/quantitative reasoning or English composition in the context of transfer, degree, and certificate program.

GP 503 First Time Students Who Completed Transfer-Level English in the District in the First Year

Description

Among all first-time credit students in the district, the proportion who completed transfer-level English in their first academic year of credit enrollment within the district

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB03 Course-TOP-Code

GI03 Term-Identifier

SXD2 Enrollment-Credit-Status

SX04 Enrollment-Grade

Calculations

Students who met all of the following criteria:

        Had an enrollment in an English course in the district

CB03 IN (1501.00, 1520.00)

        AND that was a transfer level course

AND SXD2 = T

        AND earned a passing grade

WHERE [First character of SX04 IN (A, B, C, P) OR

First two characters of SX04 IN (IA, IB, IC) OR

First three characters of SX04 IN (IPP)]

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         Incomplete grades are included in Course Success and Completed Transfer Level Math and English in the District in the First Year

         Courses outside of the English Taxonomy of Program (TOP) codes are currently not included in this metric

         Includes completion of the courses in the same district only

         CB25 COURSE-GENERAL-EDUCATION-STATUS has been added in summer 2019 to account for courses that are not listed on the TOP codes indicated in the calculation above but that fulfill general education requirements for mathematics/quantitative reasoning or English composition in the context of transfer, degree, and certificate program.

 

MILESTONES: CREDIT MOMENTUM

GP 406 First Time Students Retained Fall to Spring at the Same College

Description

Among first-time students who enrolled in at least one credit course in the fall of the selected year who did not transfer or who did not earn an award in the selected year, the percentage who enrolled in at least one credit course in any TOP code in a subsequent primary term at the selected school

Data Source(s)

Chancellor's Office Management Information System

National Student Clearinghouse

CSU/UC Cohort Match

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

Calculations

GP 333F Students who met all of the following criteria:

        Either enrolled in Spring term for semester colleges

Student Enrollment file has a value in the spring term of the selected year AND

WHERE GI03=YY3 OR

        OR enrolled in Winter term for quarter colleges

OR Student Enrollment file has a value in the winter term of the selected year AND

WHERE GI03=YY2

        AND for credit courses only

AND CB04 IN (C, D)

Denominator

GP 333F First Time Students Who Did Not Transfer and Who Did Not Earn an Award

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included and except for the fact that Student Success Metrics course retention is not limited to credit only

Notes

         Calculated within a single academic year, excluding intersession and summer sessions.

         Primary terms only are included (Fall Semester, Spring Semester, Fall Quarter, Winter Quarter, Spring Quarter)

         Excludes any students who received a degree, certificate, or transfer at any time during the selected year.

GP 210 First Time Students Enrolled Full Time in the Fall Term

Description

Students who were enrolled full time in the Fall term at the selected institution

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SXD3 Enrollment-Units-Attempted

Calculations

Student met all of the following criteria:

        Attempted 12 or more units in the fall term at the selected college

SUM of SXD3 ≥ 12 for the fall term of the selected year at selected college

        AND in the selected year

WHERE GI03=YY7 for colleges on the semester system

OR WHERE GI03=YY8

         AND at the locale selected

AND at the district level WHERE 12 or more units can be earned in the fall term at any college in the district

AND at the regional level WHERE 12 or more units can be earned in the fall term at any college in the district

AND at the statewide level WHERE 12 or more units can be earned in the fall term at any college in the district

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and Unduplicated Count of Students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Metric is currently not in SSM 2.6

Notes

GP 404 First Time Students Who Successfully Completed Semester Unit Thresholds in Fall Term (GP 453 Wrapper Metric)

Description

Among first-time students enrolled in the Fall term, the proportion who successfully completed degree-applicable semester unit thresholds in the fall term of the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Calculations

Students who met all of the following criteria:

        Successfully completed degree-applicable credit courses at any college

[CB04 IN (D)

AND First character of SX04 IN (A, B, C, P)]

       In the Fall term of the selected year at any college

AND [WHERE GI03=YY7 for semester schools

OR WHERE GI03=YY8 for quarter schools]

        Convert quarter units to semester units for units earned at quarter schools

AND Multiply SUM (SX03) for quarter units by 0.667 to equate to semester units

        Eliminate 8888 and 9999 values at the course level

AND SX03 < 50

        Group into semester unit thresholds

AND SUM (SX03) by 0, 0.1-5.9, 6-8.9, 9-11.9, 12-14.9, or 15+

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

        For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either FP 404 for colleges and/or districts on semesters and GP 444 for colleges and/or districts on quarters.

        Only includes students who were enrolled in the fall term

        Includes enrollments at all community colleges for each student

        For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics

        For display on the dashboard each threshold has a unique ID associated with it:

o    GP_404_1��� 0 units

o    GP_404_2��� 0.1-5.9 units

o    GP_404_5��� 6-8.9 units

o    GP_404_6��� 9-11.9 units

o    GP_404_3��� 12-14.9 units

o    GP_404_4��� 15+ units

GP 444 First Time Students Who Successfully Completed Quarter Unit Thresholds in Fall Term (GP 453 Wrapper Metric)

Description

Among first-time students enrolled in the Fall term, the proportion who successfully completed degree-applicable quarter unit thresholds in the fall term of the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Numerator

Students who met all of the following criteria:

        Successfully completed degree-applicable credit courses at any college

[CB04 IN (D)

AND First character of SX04 IN (A, B, C, P)]

       AND in the Fall term of the selected year at any college

[WHERE GI03=YY7 for semester schools OR

WHERE GI03=YY8 for quarter schools]

        AND convert semester units to quarter units for units earned at semester schools

AND Divide SUM (SX03) for semester units by 0.667 to equate to quarter units

        AND eliminate 8888 and 9999 values at the course level

AND SX03 < 50

        AND group into quarter unit thresholds

AND SUM (SX03) by 0, 0.1-8.9, 9-13.4, 13.5-17.9, 18-22.4, or 22.5+

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

        For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either GP 404 for colleges and/or districts on semesters and GP 444 for colleges and/or districts on quarters.

        Only includes students who were enrolled in the fall term

        Includes enrollments at all community colleges for each student

        For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics

        For display on the dashboard each threshold has a unique ID associated with it:

o    GP_444_1��� 0 units

o    GP_444_2��� 0.1-8.9 units

o    GP_445_9��� 9-13.4 units

o    GP_444_3��� 13.5-17.9 units

o    GP_444_4��� 18-22.4 units

o    GP_444_5��� 22.5+ units

GP 453 Wrapper Metric for First Time Students Who Successfully Completed Unit Thresholds in Fall Term

Description

Among first-time students enrolled in the Fall term, the proportion who successfully completed degree-applicable unit thresholds in the fall term of the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Numerator

Wrapper Metric for GP 404 and GP 444

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

        Wrapper metrics are solely for the display of other metrics by grouping together those metrics to show overall rates or percentages for comparison

        For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either GP 404 for colleges and/or districts on semesters and GP 444 for colleges and/or districts on quarters.

        For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics

GP 214 First Time Students Enrolled Full Time in the Selected Year

Description

Students who were enrolled full time in each term in which they were enrolled during the selected year at the selected institution

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

GI03 Term-Identifier

SXD3 Enrollment-Units-Attempted

Calculations

Student met all of the following criteria:

        Attempted 12 or more units in each primary term of enrollment in the selected year at the selected college

SUM of SXD3 ≥ 12 for EACH primary term of enrollment in the selected year at selected college

        AND in the selected year

WHERE GI03=YY7 and GI03=YY3 for colleges on the semester system

OR WHERE GI03=YY8 and GI03=YY2 and GI03=YY4 for colleges on the quarter system

         AND at the locale selected

AND at the district level WHERE 12 or more units can be earned in each primary term at any college in the district

AND at the regional level WHERE 12 or more units can be earned in each primary term at any college in the region

AND at the statewide level WHERE 12 or more units can be earned in each primary term at any college

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and Unduplicated Count of Students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Metric is currently not in SSM 2.6

Notes

Primary terms only are included (Fall Semester, Spring Semester, Fall Quarter, Winter Quarter, Spring Quarter)

GP 405 First Time Students Who Successfully Completed Semester Unit Thresholds in the Selected Year (GP 454 Wrapper Metric)

Description

Among all first-time students, the proportion who successfully completed degree-applicable semester unit thresholds in the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Numerator

Students who met all of the following criteria:

        Successfully completed degree-applicable credit courses at any college

[CB04 IN (D)

AND First character of SX04 IN (A, B, C, P)]

       In the selected year at any college

AND WHERE GI03 is within the selected year

        Convert quarter units to semester units for units earned at quarter schools

AND Multiply SUM (SX03) for quarter units by 0.667 to equate to semester units

        Eliminate 8888 and 9999 values at the course level

AND SX03 < 50

        Group into semester unit thresholds

AND SUM (SX03) by 0, 0.1-5.9, 6-8.9, 9-11.9, 12-14.9, 15-19.9, 20-23.9, 24-29.9, 30+

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         Includes enrollments at all community colleges for each student

         For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either GP 405 for colleges and/or districts on semesters and GP 445 for colleges and/or districts on quarters.

         For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics

         For display on the dashboard, each threshold has a unique ID associated with it:

o   GP_405_1��� 0 units

o   GP_405_2��� 0.1-5.9 units

o   GP_405_8��� 6-8.9 units

o   GP_405_9��� 9-11.9 units

o   GP_405_3��� 12-14.9 units

o   GP_405_4��� 15-19.9 units

o   GP_405_5��� 20-23.9 units

o   GP_405_6��� 24-29.9 units

o   GP_405_7��� 30+ units

GP 445 First Time Students Who Successfully Completed Quarter Unit Thresholds in the Selected Year (GP 454 Wrapper Metric)

Description

Among all first-time students, the proportion who successfully completed degree-applicable quarter unit thresholds in the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Numerator

Students who met all of the following criteria:

        Successfully completed degree-applicable credit courses at any college

[CB04 IN (D)

AND First character of SX04 IN (A, B, C, P)]

       AND in the selected year at any college

WHERE GI03 is within the selected year

        AND convert semester units to quarter units for units earned at semester schools

AND divide SUM (SX03) for semester units by 0.667 to equate to quarter units

        AND eliminate 8888 and 9999 values at the course level

AND SX03 < 50

        AND group into quarter unit thresholds

AND SUM (SX03) by 0, 0.1-8.9, 9-13.4, 13.5-17.9, 18-22.4, 22.5-29.9, 30-35.9, 36-44.9, 45+

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either GP 405 for colleges and/or districts on semesters and GP 445 for colleges and/or districts on quarters.

         Includes enrollments at all community colleges for each student

         For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics

         For display on the dashboard each threshold has a unique ID associated with it:

o   GP_445_1��� 0 units

o   GP_445_2��� 0.1-8.9 units

o   GP_445_9��� 9-13.4 units

o   GP_445_3��� 13.5-17.9 units

o   GP_445_4��� 18-22.4 units

o   GP_445_5��� 22.5-29.9 units

o   GP_445_6��� 30-35.9 units

o   GP_445_7��� 36-44.9 units

o   GP_445_8��� 45+ units

GP 454 Wrapper Metric for First Time Students Who Successfully Completed Unit Thresholds in the Selected Year

Description

Among all first-time students, the proportion who successfully completed degree-applicable unit thresholds in the selected year

Data Source(s)

Chancellor's Office Management Information System

Data Element(s)

CB04 Course-Credit-Status

GI03 Term-Identifier

SX03 Enrollment-Units-Earned

SX04 Enrollment-Grade

Numerator

Wrapper metric for GP 405 and GP 445

Denominator

GP 122F First Time Students, Including Summer and Early College

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: Age Group, Race/Ethnicity, Gender, Economically Disadvantaged

SSM Alignment

Aligns to SSM 2.6 except for universe of students included

Notes

         Wrapper metrics are solely for the display of other metrics by grouping together those metrics to show overall rates or percentages for comparison

         For display on the dashboard, only semester unit buckets will be displayed at the Statewide, Macroregion, and Microregion levels. At the college district and the college level, data displayed will be either GP 405 for colleges and/or districts on semesters and GP 445 for colleges and/or districts on quarters.

         For display on the dashboard, Top-in-State will not be available for unit attainment buckets since those are displayed on one graph as a drilldown option to see each bucket allowing for disaggregations of the metrics