ccc
ssm
K12
Strong Workforce Program
Download Document

Metric Definition Dictionary

 


 

Table of Contents

Updated 03.08.23. 1

Data Comparisons and Caveats. 4

Student Types. 4

Rounds of Funding. 4

Timeframes. 5

Snapshot View.. 5

Data Disaggregation. 5

Comparison Groups. 6

Data Limitations. 7

Data Sources. 8

Definition Descriptions. 8

Institutions, LEAs, Counties, Regions and Rounds. 8

CTE Pathways to Industry Sectors. 9

Student Type. 12

KS 122 K12 Students. 12

KS 123 K12 CTE Students. 13

Progress. 14

KS 101 K12 CTE Participants. 14

KS 102 K12 CTE Completers. 14

KS 117 K12 CTE Completers by Industry Sector 15

KS 105 K12 CTE Completers With Early College Credit, Work-Based Learning, or Third-Party Certification. 16

KS 118 K12 CTE Completers With Early College Credit, Work-Based Learning, or Third-Party Certification by Industry Sector 17

Disaggregation Type. 19

KS 119 Grade Levels. 19

KS 103 Gender 19

KS 104 Race/Ethnicity. 20

KS 107 Socioeconomically Disadvantaged. 21

KS 109 Homeless. 22

KS 113 Students with Disabilities. 23

KS 115 English Learners. 24

K12 Transition. 25

KS 300 K12 Students Who Graduated from High School 25

KS 301 K12 CTE Students Who Graduated from High School 25

KS 302 K12 CTE Participants Who Graduated from High School 26

KS 303 K12 CTE Completers Who Graduated from High School 26

KS 304 K12 CTE Completers Who Graduated from High School With Early College Credit, Work-Based Learning, or Third-Party Certification. 27

 

 


 

Data Comparisons and Caveats

Student Types

The tool documents graduation and CTE system engagement for K12 students in California for a subset of institutions and LEAs. Only data submitted through Cal-PASS Plus has been included for the K12 SWP dashboard in 2022-23 for Rounds 1, 2, 3 awardees of K12 Strong Workforce Program (SWP) funding. Only data at the institution level successfully submitted by LEAs, determined to have received K12 SWP funding as part of Rounds 1, 2, 3, will be included for the 2022-23 release of the K12 SWP dashboard for years 2018-19 through 2021-22. No prior year data to 2018-19 submitted to Cal-PASS Plus can be referenced.

Rounds of Funding

An “All Rounds” selection allows users to view data for all awardees in all rounds available for the years of data available in the current dashboard build including the following selections:

       All Rounds

       Round 1 (2018-19, 2019-20, 2020-21, 2021-22)

       Round 2 (2020-21, 2021-22, 2022-23)

       Round 3 (2021-22, 2022-23, 2023-24)

Note: The dates displayed for the Rounds correspond to the academic years of data available for the Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected. However, the following dates cover the period of funding for each Round:

Round 1 (July 1, 2019 through December 31, 2021)

Round 2 (July 1, 2019 through December 31, 2022.

Round 3 (January 1, 2021 to June 30, 2023)

For each round, the table below summarizes data submission into Cal-PASS Plus by awardees and the start of K12 SWP funding to the awardees by academic term.

Academic Yrs

2018-19

2019-20

2020-21

2021-22

2022-23

2023-24

2024-25

2025-26

 

Terms: Fall (F) and Spring (S)

F

S

F

S

F

S

F

S

F

S

F

S

F

S

F

S

 

Round 1

d

 

r

 

 

 

 

x

 

 

 

 

 

 

 

 

 

Round 2

 

 

 

 

d

 r

 

 

 

x

 

 

 

 

 

 

 

Round 3

 

 

 

 

 

 

d

 

 

 

x

 

 

 

 

 

Round 4

 

 

 

 

 

 

 

 

d

 r

 

 

 

x

 

 

 

Round 5

 

 

 

 

 

 

 

 

 

 

d

 

 

 

x

 

 

Legend:

d = start submission of data into CalPADS

r = started using funding

x = not required but included

 

Note: When more rounds of K12 SWP funding are included in future builds of the dashboard and when an institution or LEA is selected, then data will not be displayed for All Rounds. The rounds of funding are not relevant at that level and will default to the earlier round awarded to the institution or LEA selected. In future dashboard builds, institutions and LEAs can be flagged to note which ones received funding in each of the five rounds.

Timeframes

Information is provided for the following years:

  • 2021-2022 for awardees in Rounds 1, 2, 3
  • 2020-2021 for awardees in Rounds 1, 2
  • 2019-2020 for awardees in Round 1
  • 2018-2019 for awardees in Round 1

 

As additional rounds of K12 SWP funding are awarded to Local Education Agencies (LEAs), additional years for comparison will be included in the K12 SWP dashboard in future builds.

Snapshot View

Until there is sufficient data submitted by K12 SWP awardees into Cal-PASS Plus, a cohort view of awardees is not possible, and a snapshot view of the data will be shown. While a cohort view tracks the same defined group of students over time for attainment of metric outcomes, a snapshot view displays information based on students who met the outcome of each metric within the selected year. Therefore, the students who attained the metric outcome may not be the same from one metric to the next in a snapshot view.

Data Disaggregation

The standard display of disaggregations on LaunchBoard dashboards is to display the number of students in the subgroup who met the metric outcome as a percentage of all students in the subgroup included in the denominator. As an example, for the gender disaggregation, the percentage of female students who took a CTE course in the selected year at the selected locale for KS 123 or K12 CTE Students is calculated as [the number of female students who took a CTE course in the selected year at the selected locale] / [the number of female K12 Students in the selected year at the selected locale] as opposed to [the number of female students who took a CTE course in the selected year at the selected locale] / [the overall number of students who took a CTE course in the selected year at the selected locale]. This standard disaggregation calculation allows users to quickly compare the metric outcome rates across subgroups for a disaggregation.

However, there is an exception for the grade level disaggregation display in the K12 SWP dashboard. The grade level disaggregation display for metrics KS 123, KS 101, KS 102, KS 117, KS 107, and KS 118 will instead display [the number of students in each grade level (9th, 10th, 11th, 12th) who met the metric outcome in the selected year at the selected locale] / [the overall number of students who met the metric outcome in the selected year at the selected locale]. This display allows users to quickly see the percentage of students in each grade who met the metric outcome. For KS 122 or K12 Students, the counts of the number of students in each grade level in the selected year in the selected locale will be displayed as there is no denominator for this metric.

Disaggregated data will be provided by the following demographic variables in the Drill Down box in the upper righthand corner:

Value options: 9th, 10th, 11th, 12th
NOTE:
The grade level disaggregation display for metrics KS 122, KS 123, KS 101, KS 102, KS 117, KS 107, and KS 118 will not follow the standard disaggregation display for LaunchBoard dashboards as noted above.

  • Gender:

Value options: Female, Male, Non-Binary, Missing

Note: Missing refers to the students who do not have a Student Information (SINF)

  • Race/Ethnicity:

Value options: American Indian or Alaska Native, Asian, Black or African American, Filipino, Hispanic, Native Hawaiian or Other Pacific Islander, Two or More Races, White, Missing, Not Reported

Note: Missing refers to the students who do not have a Student Information (SINF) and Not Reported refers to data values for IsMissingRace in the SINF file.

  • Socioeconomically Disadvantaged:

Value Options: Socioeconomically Disadvantaged, Not Socioeconomically Disadvantaged

  • Homeless:

Value options: Homeless, Not Homeless

  • Foster Youth:

Value options: Foster Youth, Not Foster Youth

  • Students with Disabilities:

Value options: Students with Disabilities, Students without Disabilities

  • English Learners:

Value options: English Learner, Not an English Learner

Comparison Groups

Users can compare figures with information from the other years and statewide averages. Data used in the comparisons are based on the same data source(s) and use the same methodology to derive the data. The following provides a brief description on each of the data types available:

  • Time Trend: Track student outcomes as a trend over time.
  • Grade Level: for metrics KS 122, KS 123, KS 101, KS 102, KS 105
  • Statewide (All K12 SWP Grantees in Round 1,2,3): Counts and percentages across all students enrolled in LEAs who received K12 SWP funding in any round contained within the years of the dashboard.
  • Region: Counts and percentages across all grantee LEA enrolled students in the Macro-region.
  • County: Counts and percentages across all grantee LEA enrolled students in the county.
  • LEA: Counts and percentages across all grantee LEA enrolled students.
  • Institution: Counts and percentages within an individual K12 Institution for all grantee LEAs.
  • Industry Sector: CTE Pathways in K-12 are mapped to CDE Industry Sectors. For metrics tracking students into the community college system, CTE TOP codes are mapped to industry sectors or occupational cluster. Based on the crosswalk provided on the K12 Strong Workforce Program California Community College Chancellor’s Office website, the community college sectors have been mapped to the CDE sectors.
    • Note: Only available for KS 102 CTE Completers and KS 103 CTE Completers with Early College Credit or Work-Based Learning or Third-Party Certification.

The following selections will be included:

    • All Sectors
    • Agriculture & Natural Resources
    • Arts, Media and Entertainment
    • Building Trades and Construction
    • Education, Child Development, and Family Services
    • Energy, Environment, and Utilities Sector
    • Engineering and Design
    • Fashion and Interior Design
    • Finance and Business
    • Health Science and Medical Technology
    • Hospitality, Tourism, and Recreation
    • Information Communication Technology
    • Manufacturing and Product Development
    • Marketing, Sales, and Service Industry
    • Public Services
    • Transportation

Data Limitations

Missing and Suppressed Information

  • The Student Information File (SINF) includes student demographic and other information. Per CALPADS, “this file format is used to submit information about a student that is relatively static and not likely to change over time. It should be submitted when a student is assigned a new SSID. This file should only be submitted if there are any changes to data within the file.” If the SINF file was submitted prior to 2018-19, then it cannot be referenced for the build of the K12 SWP dashboard. Therefore, for earlier years, there will be missing gender and race/ethnicity information for students.
  • The Student English Language Acquisition (SELA) includes all of a student’s language acquisition records. Per CALPADS, “Update student English Language Acquisition Status (ELAS) data only:
    • Upon enrollment of a NEW student (brand new SSID)
    • When a student has a valid change in their ELAS (English Language Acquisition Status)
    • When any K–12 student with an ELAS of “TBD” has that status for more than 90 days from the ELAS Start Date.”

If the SELA file was submitted prior to 2018-19, then it cannot be referenced for the build of the K12 SWP dashboard. Due to missing Student English Language Acquisition (SELA) files prior to 2018-19 to determine if a student has ever been flagged as an English Learner and never been reclassified, the number of students included as English Learners in the dashboard may be underrepresented compared to other CDE sources.

  • The Special Programs Chart (SPRG) includes Program student records for three disaggregations displayed on the dashboard: Homeless, Socioeconomically Disadvantaged and Students with Disabilities. If the SPRG file was submitted prior to 2018-19, then it cannot be referenced for the build of the K12 SWP dashboard. Due to missing Special Programs Chart (SPRG) files prior to 2018-19 to determine if a student has ever been eligible for or participated in the Student with disabilities program, the number of students included as Students with Disabilities in the dashboard may be underrepresented compared to other CDE sources. In addition, for Socioeconomically Disadvantaged students, data to determine Foster Program Eligible, Direct Control and eligible as Tribal Foster Youth are not available.
  • Sector data is only available for KS 117 CTE Completers by Industry Sector and KS 118 CTE Completers with Early College Credit or Work-Based Learning or Third-Party Certification by Industry Sector
  • Link to FERPA and Complementary Suppression documentation for all LaunchBoard dashboards.
    • Masking is performed across the subgroups present (e.g., grade level, gender, race/ethnicity, English learner, socioeconomically disadvantaged, students with disabilities, and homeless), and over the primary attributes of data (year, metric, and locale).

Data Sources

  • K12 metrics are based on data submitted by Cal-PASS Plus members.  Only data uploaded to CalPASS Plus for the express purpose of K12 SWP grantee funding will be summarized in this dashboard.  Data submitted for years prior to the initial year of funding (2018-2019) will not be considered under this methodology. For the 2021-22 build of the dashboard, only Round 1 awardees will be included. For the 2022-23 build of the dashboard, Round 2 and Round 3 awardees have been added.

Definition Descriptions

       Description: Description of the metric

       Data Source: The source of the information

       Data Source Elements: Relevant data elements from the data source(s)

       Calculations: Specific calculations for the metric

       Denominator: The universe or cohort of students included

       Value Type: The type of data value populated for the metric

       Drilldowns: All selections possible for a given metric

       Alignment: How the metric definition conforms to other accountability frameworks

       Notes: General information or caveats about the data for the metric   

Institutions, LEAs, Counties, Regions and Rounds

Download this resource as a pdf or Excel file to see a mapping of institutions to LEAs, counties and regions as well as which Rounds of K12 SWP funding they are included in.

Note: “Noted as a grantee in: R1, R2, R3” means that the institution is mapped to a LEA that is on the California Community College’s list of K12 SWP grantees. It does not mean that data will appear for that institution in the dashboard for all rounds indicated.

CTE Pathways to Industry Sectors

The list of CTE industry sectors is from the CDE website for CTE Model Curriculum Standards. CTE Pathways from the CTE Course Code Definitions by Sector and Pathways 2021–22 Users Guide are mapped to the Industry Sectors in the following manner:

Industry Sector Name

CDE CTE Pathway Code

CDE CTE Pathway Title

Agriculture and Natural Resources

100

Agricultural Business

Agriculture and Natural Resources

101

Agricultural Mechanics

Agriculture and Natural Resources

102

Agriscience

Agriculture and Natural Resources

103

Animal Science

Agriculture and Natural Resources

104

Forestry and Natural Resources

Agriculture and Natural Resources

105

Ornamental Horticulture

Agriculture and Natural Resources

106

Plant and Soil Science

Arts, Media, and Entertainment

111

Design, Visual, and Media Arts

Arts, Media, and Entertainment

112

Performing Arts

Arts, Media, and Entertainment

113

Production and Managerial Arts

Arts, Media, and Entertainment

114

Game Design and Integration

Building and Construction Trades

120

Cabinetry, Millwork, and Woodworking

Building and Construction Trades

121

Engineering and Heavy Construction

Building and Construction Trades

122

Mechanical Systems Installation and Repair

Building and Construction Trades

123

Residential and Commercial Construction

Education, Child Development, and Family Services

130

Child Development

Education, Child Development, and Family Services

131

Consumer Services

Education, Child Development, and Family Services

132

Education

Education, Child Development, and Family Services

133

Family and Human Services

Energy, Environment, and Utilities

141

Environmental Resources

Energy, Environment, and Utilities

142

Telecommunications

Energy, Environment, and Utilities

143

Energy and Power Technology

Engineering and Architecture

150

Architectural Design

Engineering and Architecture

152

Engineering Design

Engineering and Architecture

153

Engineering Technology

Engineering and Architecture

154

Environmental Engineering

Fashion and Interior Design

160

Fashion Design and Merchandising

Fashion and Interior Design

161

Interior Design

Marketing, Sales, and Services

162

Personal Services

Information and Communication Technologies

170

Information Support and Services

Information and Communication Technologies

172

Networking

Information and Communication Technologies

174

Software and Systems Development

Arts, Media, and Entertainment

175

Games and Simulations

Business and Finance

180

Financial Services

Business and Finance

181

International Business

Business and Finance

182

Business Management

Health Science and Medical Technology

195

Mental and Behavioral Health

Health Science and Medical Technology

196

Biotechnology

Health Science and Medical Technology

197

Healthcare Operational Support Services

Health Science and Medical Technology

198

Patient Care

Health Science and Medical Technology

199

Public and Community Health

Hospitality, Tourism, and Recreation

200

Food Science, Dietetics, and Nutrition

Hospitality, Tourism, and Recreation

201

Food Service and Hospitality

Hospitality, Tourism, and Recreation

202

Hospitality, Tourism, and Recreation

Arts, Media, and Entertainment

210

Graphic Production Technologies

Manufacturing and Product Development

212

Machining and Forming Technologies

Manufacturing and Product Development

213

Welding and Materials Joining

Manufacturing and Product Development

214

Introductory/Core

Manufacturing and Product Development

216

Product Innovation and Design

Transportation

220

Structural Repair and Refinishing

Transportation

221

Systems Diagnostics, Service, and Repair

Transportation

222

Aviation and Aerospace Transportation Services

Transportation

223

Operations

Public Services

231

Legal Practices

Public Services

232

Public Safety

Public Services

233

Emergency Response

Marketing, Sales, and Services

241

Entrepreneurship/Self-Employment

Marketing, Sales, and Services

243

Professional Sales

Marketing, Sales, and Services

244

Marketing

Health Science and Medical Technology

250

Healthcare Administrative Services

                

    


 

Student Type

KS 122 K12 Students

Description

Students enrolled in 9th, 10th, 11th, or 12th grade at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

CALPADS SSID Student Enrollment:

       Field 1.23 – Enrollment Status Code

       Field 1.24 – Grade Level Code

CALPADS Course Section Completion (CRSC) File (Fields refer to current CFS):

       Field 9.04 – Reporting LEA

       Field 9.07 – CRS State Course Code

       Field 9.14 – Course Section ID

Calculations

Students who met the following criteria:

  • Has a SENR enrollment value in the selected year
  • Has at least one SCSC record in the selected year
  • AND 1.24 (Grade Code Level) in ('9', ‘09’, ‘10’, ‘11’, ‘12’)

Denominator

n/a

Value Type

Unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

 

Notes

Metric will be displayed in the Student Type section

 


KS 123 K12 CTE Students

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected, the percentage of students who enrolled in at least one CTE course

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Data Element(s)

CALPADS Course Section Completion (CRSC) File (Fields refer to current CFS):

       Field 9.04 – Reporting LEA

       Field 9.07 – CRS State Course Code

       Field 9.14 – Course Section ID

 

CALPADS Student Course Section Completion (SCSC) File (Fields refer to the current CFS):

       Field 10.14 – Course Section ID)

       Field 10.17 – Student Credits Earned

       Field 10.18 – Student Course Final Grade

 

Link to Cross Group Master Combos Group

Calculations

Student met all of the following criteria:

       Enrolled in a CTE course in the Cross Group Master Combo (CRSC) file

State Course Code IN (4000 – 5999) OR

State Course Code IN (7000 – 8999)

       in the selected year

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

 

Notes

Metric will be displayed as a rate in the Student Types section

 

                                                                                                                                                                    


Progress

KS 101 K12 CTE Participants

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected, the percentage of students who completed at least one course in a CTE pathway with a C- or better.

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Data Element(s)

CALPADS Course Section Completion (CRSC) File (Fields refer to current CFS):

       Field 9.04 – Reporting LEA

       Field 9.07 – CRS State Course Code

       Field 9.14 – Course Section ID

 

CALPADS Student Course Section Completion (SCSC) File (Fields refer to the current CFS):

       Field 10.14 – Course Section ID)

       Field 10.17 – Student Credits Earned

       Field 10.18 – Student Course Final Grade

 

Link to Cross Group Master Combos Group

Calculations

Student met all of the following criteria:

       Enrolled in a CTE course in the Cross Group Master Combo (CRSC) file

(State Course Code IN (4000 – 5999) OR

State Course Code IN (7000 – 8999))

       AND in the selected year

       AND with a final grade of C- or higher

AND Student Course Final Grade in ('A+','A','A-','B+','B','B-','C+','C','C-')

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

 

Notes

       All enrollments must be in the same K12 institution

       Metric will be displayed in a Learning Progress section

KS 102 K12 CTE Completers

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected, the percentage of students who completed 300 career education hours in an industry pathway and successfully completed the capstone course with a C- or better

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Student Career Technical Education File (SCTE)

Data Element(s)

Student Career Technical Education File (SCTE):

       Field 11.14 – CTE Pathway Completion Academic Year ID

       Field 11.13 – CTE Pathway Code

Calculations

Student met all of the following criteria:

       Completed 300 career education hours in an industry pathway AND successfully completed the capstone course (received a grade of C- or higher)

CTE Pathway Completion Academic Year ID is not NULL

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

Perkins V

Notes

       300 career education hours and capstone course completion behavior is summarized within the SCTE file upload.

       Metric will be displayed in a Learning Progress section

KS 117 K12 CTE Completers by Industry Sector

Description

Among students who completed 300 career education hours in an industry pathway and successfully completed the capstone course with a C- or better, the percentage of students who completed in each industry sector

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Student Career Technical Education File (SCTE)

Data Element(s)

Student Career Technical Education File (SCTE):

       Field 11.14 – CTE Pathway Completion Academic Year ID

       Field 11.13 – CTE Pathway Code

Calculations

Student met all of the following criteria:

       Completed 300 career education hours in an industry pathway AND successfully completed the capstone course (received a grade of C- or higher)

CTE Pathway Completion Academic Year ID is not NULL

Denominator

KS 102 K12 CTE Completers “All Sectors” Selection

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

Perkins V

Notes

§  Percentages will be represented as the percentage of students who completed in the specified sector over the total number of students who completed any sector.

§  Because students can complete multiple capstone courses, and some capstone courses apply towards multiple sectors, the sum of percentages are expected to total to greater than 100% in many cases.

KS 105 K12 CTE Completers With Early College Credit, Work-Based Learning, or Third-Party Certification

Description

Among K12 CTE Completers, the percentage of students who successfully completed at least one CTE course counting for early college credit, work-based learning, or third-party certification

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Student Career Technical Education File (SCTE)

Data Element(s)

Student Career Technical Education File (SCTE):

       Field 11.14 – CTE Pathway Completion Academic Year ID

       Field 11.13 – CTE Pathway Code

Course Section Completion (CRSC) File (Fields refer to current CFS):

       Field 9.04 – Reporting LEA

       Field 9.07 – CRS State Course Code

       Field 9.14 – Course Section ID

       Filed 9.19 – Course Section Instructional Level Code

CALPADS Student Course Section Completion (SCSC) File (Fields refer to the current CFS):

       Field 10.14 – Course Section ID

       Field 10.16 – Academic Year ID

       Field 10.17 – Student Credits Earned

       Field 10.18 – Student Course Final Grade

Calculations

Student met all of the following criteria:

       Completed 300 career education hours in an industry pathway AND successfully completed the capstone course (received a grade of C- or higher)

CTE Pathway Completion Academic Year ID is not NULL

       AND Enrolled in a CTE course in the Cross Group Master Combo

AND (State Course Code IN (4000 – 5999) OR

State Course Code IN (7000 – 8999))

       AND in the selected year

       AND took a course that counted for early college credit, work-based learning or third-party certification

AND Course Section Instructional Level Code IN (16, 23, 24)

       Up to and including the selected year (looking back no further than the  2018-2019 academic year)

AND SCSC Academic Year ID > ‘2018-2019’

AND SCSC Academic Year ID <= SENR Academic Year ID

       AND with a final grade of C- or higher

AND Student Course Final Grade in ('A+','A','A-','B+','B','B-','C+','C','C-')

Denominator

KS 102 K12 CTE Completers “All Sectors” Selection

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

 

Notes

Metric will be displayed in a Learning Progress section

KS 118 K12 CTE Completers With Early College Credit, Work-Based Learning, or Third-Party Certification by Industry Sector

Description

Among K12 CTE Completers with at least one CTE course counting for early college credit, work-based learning, or third-party certification, the percentage of students who completed in each industry sector

Data Source(s)

CALPADS:

Course Section Completion (CRSC) File

CALPADS Student Course Section Completion (SCSC) File

Student Career Technical Education File (SCTE)

Data Element(s)

Student Career Technical Education File (SCTE):

       Field 11.14 – CTE Pathway Completion Academic Year ID

       Field 11.13 – CTE Pathway Code

Course Section Completion (CRSC) File (Fields refer to current CFS):

       9.04 – Reporting LEA

       Field 9.07 – CRS State Course Code

       Field 9.14 – Course Section ID

CALPADS Student Course Section Completion (SCSC) File (Fields refer to the current CFS):

       Field 10.14 – Course Section ID

       Field 10.16 – Academic Year ID

       Field 10.17 – Student Credits Earned

       Field 10.18 – Student Course Final Grade

Calculations

Student met all of the following criteria:

       Completed 300 career education hours in an industry pathway AND successfully completed the capstone course (received a grade of C- or higher)

CTE Pathway Completion Academic Year ID is not NULL

       AND Enrolled in a CTE course in the Cross Group Master Combo

AND (State Course Code IN (4000 – 5999) OR

State Course Code IN (7000 – 8999))

       Up to and including the selected year (looking back no further than the  2018-2019 academic year)

AND SCSC Academic Year ID > ‘2018-2019’

AND SCSC Academic Year ID <= SENR Academic Year ID

       AND with a final grade of C- or higher

AND Student Course Final Grade in ('A+','A','A-','B+','B','B-','C+','C','C-')

       AND display by industry sector allowing for a student to be mapped to more than one sector when a CTE pathway is mapped to more than one sector

Denominator

KS 105 K12 CTE Completers With Early College Credit, Work-Based Learning, or Third-Party Certification “All Sectors” Selection

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All

Alignment

 

Notes

§  Percentages will be represented as the percentage of students who completed in the specified sector over the total number of students who completed any sector.

§  Because students can complete multiple capstone courses, and some capstone courses apply towards multiple sectors, the sum of percentages are expected to total to greater than 100% in many cases.

 


 

Disaggregation Type

KS 119 Grade Levels

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected enrolled in grades 9-12

Data Source(s)

CALPADS:

Student Information (SINF)

SSID Enrollment (SENR)

Data Element(s)

Grades 9, 10, 11, 12

Calculations

Student who met all of the following criteria:

       grouped by max Grade Level in the selected year at the selected locale

Max of Grade Level IN (09, 9, 10, 11, 12)

AND in the selected year at the selected locale

       for each metric where grade level will be displayed (KS 122, 123, 101, 102, 117, 105, 118) calculate differently from other standard disaggs as a percent of the overall metric value rather than as a percent of overall metric value for the disagg subgroup

AND [records in common for a numerator record and each grade level] / [records in common for a that same selection, including metric_id, overall students record]

Denominator

n/a

Value Type

Unduplicated count of students

Alignment

Perkins V

Notes

§  Use maximum reported grade in the year if multiple exist at the institution level

§  For K12 SWP 2.0, fix will be made to deduplicate students with different grade levels at different institutions for higher level locales (statewide, region, county, LEA) and assign that student to the maximum reported year

KS 103 Gender

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected with specific gender categories per CALPADS Code Sets.

Data Source(s)

CALPADS:

Student Information (SINF)

SSID Enrollment (SENR)

CALPADS Student Course Section Completion (SCSC) File

Data Element(s)

Gender Codes – F, M, X (started in 2019-20) pulled from the SINF file for students with at least one SENR record and one SCSC record.

Calculations

Student who met all of the following criteria:

       grouped by Gender as recorded in the last term of enrollment

Gender Code IN (‘F’, ‘M’, ‘X’)

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins V

Notes

Use latest category provided statewide.  If no SINF record has been submitted for a student since 2018-2019, the student will be assigned to the “Missing” category.

KS 104 Race/Ethnicity

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected with specific race/ethnicity categories per CALPADS Code Sets.

Data Source(s)

CALPADS:

Student Information (SINF)

Federal CALPADS Race/Ethnicity Categories

Data Element(s)

Refer to Race Category Code Set

Calculations

Student who met all of the following criteria:

       grouped by Race/Ethnicity as recorded in the last term of enrollment utilizing the Federal CALPADS Race/Ethnicity logic:

 

Ethnicity Roll up Business Rules

1) If the Student Hispanic Ethnicity Indicator (Field 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.31) = Y

2) If Student Hispanic Ethnicity Missing Indicator (Field 2.24) = N or null and the Student Ethnicity Missing Indicator (Field 2.25) = Y or null and Student Race 1 - 5 Codes (Fields 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below.

3) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing". 4) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing." 5) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = N or null, and Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows:

       If a single race = American Indian or Alaska Native (100), roll up to American Indian or Alaska Native

       If there is one or more of any of the Asian subgroups: ((201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category (100, 301, 302, 303, 304, 399, 400, 600, 700 302, 303, 304, 399, 400, 600, 700) then roll up to Asian

       If a single race = Filipino (400) roll up to Filipino (400)

       If race includes Filipino (400) AND one or more of any of the Asian subgroups, [(201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category roll up to Filipino (400)

       If there is one or more of any of the Native Hawaiian/Pacific Islander subgroups ((301) Hawaiian, (302) Guamanian, (303) Samoan, (304) Tahitian, (399) Other Pacific Islander) and no other race category (100, 201, 202, 203, 204, 205, 206, 207, 208, 299, 400, 600, 700) then roll up to Hawaiian/Pacific Islander.

o   If a single race = (600) Black or African American, roll up to Black or African American

o   If a single race = (700) White, roll up to White

       If more than one of the following races: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian/Pacific Islander, White, roll up to "Multiple"

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins V

Notes

Use latest category provided statewide.  If no SINF record has been submitted for a student since 2018-2019, the student will be assigned to the “Missing” category.

KS 107 Socioeconomically Disadvantaged

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who were ever flagged as socioeconomically disadvantaged.

Data Source(s)

CALPADS:

Student Information (SINF)

Special Programs Chart (SPRG)

Data Element(s)

CALPADS Student Profile export (33 – validate if they are in base ODS files)

DED for CALPADS

Field 2.50

Field 3.13

Education Program Code

Direct Certification Indicator

EdOpsCode

Calculations

Student who met any of the following criteria:

       Parent/Guardian not a K12 graduate

Field 2.50 = 14

       OR On free or reduced meal program

OR Field 3.13 IN (181, 182)

       OR Is a Title I Part C Migrant

OR Field 3.13 = 135

       OR Is Homeless

OR Field 3.13 = 191

       OR Is enrolled in a Juvenile Court school

OR EdOpsCode (Education Program Code) = JUV

       Up to and including the selected year (looking back no further than the 2018-2019 academic year)

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins V

Notes

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

     If a student is missing a SPRG file prior to 2018-19, then a student’s socioeconomically disadvantaged status cannot be determined and would be placed in the not socioeconomically disadvantaged subgroup leading to underrepresentation of socioeconomically students in the dashboard compared to other CDE sources.

     In addition, data to determine Foster Program Eligible, Direct Control and eligible as Tribal Foster Youth are not available to align with the CALPADS calculation.

 

KS 109 Homeless

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who were ever flagged as homeless.

Data Source(s)

CALPADS:

Student Information (SINF)

SSID Enrollment (SENR)

Special Programs Chart (SPRG)

Data Element(s)

Education Program Code

Calculations

Student who met all of the following criteria:

       Identified as Homeless

Education Program Code=191

       Up to and including the selected year (looking back no further than the 2018-2019 academic year)

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins

Notes

If a student is missing a SPRG file prior to 2018-19, then a student’s homeless status cannot be determined and would be placed in the not homeless subgroup leading to underrepresentation of homeless students in the dashboard compared to other CDE sources.

 

KS 113 Students with Disabilities

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who were ever flagged as eligible for or participating in the Students with disabilities program

Data Source(s)

CALPADS:

Special Programs Chart (SPRG)

Data Element(s)

Education Program Code

Calculations

Student who met all of the following criteria:

       Flagged as Special Education

Education Program Code (Student Program Field 3.13) = 144

       Up to and including the selected year (looking back no further than the 2018-2019 academic year)

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins V

Notes

If a student is missing a SPRG file prior to 2018-19, then a student’s disability status cannot be determined and would be placed in the not a student with disabilities subgroup leading to underrepresentation of students with disabilities in the dashboard compared to other CDE sources. In addition, data from the Student Special Education (SPED) file is not available.

 

KS 115 English Learners

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who were flagged as English Language Learners, and never reclassified as Fluent-English Proficient.

Data Source(s)

CALPADS:

Student English Language Acquisition (SELA)

Data Element(s)

English Language Acquisition Status Code

Calculations

Student who met all of the following criteria:

       Flagged as an English learner

English Language Acquisition Status Code = EL

       Up to and including the selected year (looking back no further than the 2018-2019 academic year)

       AND (never flagged as “Reclassified Fluent-English Proficient”

AND English Language Acquisition Status Code != RFEP

       Up to and including the selected year (looking back no further than the 2018-2019 academic year)

       More recently than being flagged as an English Language Learner)

Denominator

KS 122 K12 Students

Value Type

Percentage and unduplicated count of students

Alignment

Perkins V

Notes

If a student is missing a SELA file prior to 2018-19, then a student’s English Learner status cannot be determined and would be placed in the not an English Learner subgroup leading to underrepresentation of students who are included as English Learners in the dashboard compared to other CDE sources.

 


 

K12 Transition

KS 300 K12 Students Who Graduated from High School

Description

Students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who received a HS diploma in the selected year.

Data Source(s)

CALPADS:

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

School Completion Status Code

Calculations

Students who met the following criteria:

       Received a K12 diploma

School Completion Status Code = 100

       In the selected year

Denominator

n/a

Value Type

Unduplicated count of students

Drilldowns

Disaggregations: All except Grade Level

Alignment

Perkins V

Notes

Metric will be displayed as count in a section entitled K12 Transition

KS 301 K12 CTE Students Who Graduated from High School

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who received a HS diploma in the selected year, the percentage of students who enrolled in a CTE course in the selected year

Data Source(s)

CALPADS:

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

School Completion Status Code

Calculations

KS 123 K12 CTE Students who met the following criteria:

       Received a K12 diploma

School Completion Status Code = 100

       In the selected year

Denominator

KS 300 K12 Students Who Graduated from High School

Value Type

Percentage and unduplicated count of students

Drilldowns

Disaggregations: All except Grade Level

Alignment

Perkins V

Notes

Metric will be displayed as a percentage in a section entitled K12 Transition

KS 302 K12 CTE Participants Who Graduated from High School

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who received a HS diploma in the selected year, the percentage of students who completed at least one course in a CTE pathway with a C- or better.

Data Source(s)

CALPADS:

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

School Completion Status Code

Calculations

KS 101 K12 CTE Participants who met the following criteria:

       Received a K12 diploma

School Completion Status Code = 100

       In the selected year

Denominator

KS 300 K12 Students Who Graduated from High School

Value Type

Percentage and Unduplicated count of students

Drilldowns

Disaggregations: All except Grade Level

Alignment

Perkins V

Notes

Metric will be displayed as a percentage in a section entitled K12 Transition

KS 303 K12 CTE Completers Who Graduated from High School

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who received a HS diploma in the selected year, the percentage of students who completed 300 career education hours in an industry pathway and successfully completed the capstone course with a C- or better

Data Source(s)

CALPADS:

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

School Completion Status Code

Calculations

KS 102 K12 CTE Completers who met the following criteria:

       Received a K12 diploma

School Completion Status Code = 100

       In the selected year

Denominator

KS 300 K12 Students Who Graduated from High School

Value Type

Percentage and Unduplicated count of students

Drilldowns

Disaggregations: All except Grade Level

Alignment

Perkins V

Notes

Metric will be displayed as a percentage in a section entitled K12 Transition

KS 304 K12 CTE Completers Who Graduated from High School With Early College Credit, Work-Based Learning, or Third-Party Certification

Description

Among students at a Cal-PASS Plus participant K12 institution awarded K12 SWP funding as part of the round selected who received a HS diploma in the selected year, the percentage of students with at least one CTE course counting for early college credit, work-based learning, or third-party certification

Data Source(s)

CALPADS:

CALPADS Student Course Section Completion (SCSC) File

SSID Enrollment (SENR)

Data Element(s)

School Completion Status Code

Calculations

KS 105 K12 CTE Completers with Early College Credit, etc. who met the following criteria:

       Received a K12 diploma

School Completion Status Code = 100

       In the selected year

Denominator

KS 300 K12 Students Who Graduated from High School

Value Type

Percentage and Unduplicated count of students

Drilldowns

Disaggregations: All except Grade Level

Alignment

Perkins V

Notes

Metric will be displayed as a percentage in a section entitled K12 Transition