MDD Background Information

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. Only data at the institution level successfully submitted by LEAs, determined to have received K12 SWP funding will be included in the data for the K12 SWP dashboard.

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 the DataVista 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 122KW 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 122KW, 122KP, 122KC, and 106K 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 122KT 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 right-hand corner:

• Grade Levels:

  • Value options: 9th, 10th, 11th, 12th

  • NOTE: The grade level disaggregation display for metrics 122KT, 122KW, 122KP, 122KC, and 106K will not follow the standard disaggregation display for DataVista 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

The standard display of disaggregations on the DataVista 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 122KW or K12 CTE Students is calculated as:

• Time Trend: Track Student outcomes as a trend over time.

• Grade Level: For metrics ____

• Statewide (All K12 SWP Grantees in Round 1, 2, 3, 4, 5, 6): 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 clusters. Based on the crosswalk (resource: URL) 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 122KC CTE Completers and 122KY 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.” 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 122KC CTE Completers by Industry Sector and 122KY 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 DataVista 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 LEAs or by Cal-PASS Plus members

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.