Graduation Rates Who Am I? Data Data Analyst at - - PowerPoint PPT Presentation
Graduation Rates Who Am I? Data Data Analyst at - - PowerPoint PPT Presentation
Graduation Rates Who Am I? Data Data Analyst at PED(Accountability Bureau) Jeanho.Rodriguez2@state.nm.us I like cauliflower bowls and the Rail Runner. 2 Map Intro Graduation Rates Data Pipeline Understanding
Who Am I?
2
Data- Data Analyst at PED(Accountability Bureau)
- Jeanho.Rodriguez2@state.nm.us
- I like cauliflower bowls and the Rail Runner.
Map
3
- Intro
- Graduation Rates
- Data Pipeline
- Understanding Graduation Rates
- Shared Accountability
- Webpage Files
- Questions
4
Trends in Statewide Rates
Graduation Rate 69.3% 68.6% 71.0% 71.1% 73.9% 70.4% 75.0% 75.9% 76.4% 78.9% 76.9% 77.9% 60.0% 65.0% 70.0% 75.0% 80.0% 2014 2015 2016 2017 2018 4 Year Rate 5 Year Rate 6 Year Rate
5
Historical Four-Year Graduation Rates Statewide By Race/Ethnicity
69.0% 71.0% 71.0% 73.9% 74.0% 76.0% 76.0% 79.3% 61.0% 61.0% 68.0% 69.2% 67.0% 71.0% 71.0% 73.1% 79.0% 81.0% 85.0% 86.0% 63.0% 63.0% 61.0% 65.8% 55.0% 60.0% 65.0% 70.0% 75.0% 80.0% 85.0% 90.0% Cohort 2015 Cohort 2016 Cohort 2017 Cohort 2018
All Students Caucasian African American Hispanic Asian American Indian
Graduation Rate
Historical Five-Year Graduation Rates Statewide By Race/Ethnicity
6
71.0% 71.0% 73.0% 76.4% 76.0% 75.0% 79.0% 80.6% 66.0% 62.0% 62.0% 73.2% 69.0% 70.0% 72.0% 75.5% 86.0% 81.0% 85.0% 89.9% 63.0% 59.0% 57.0% 70.9% 55.0% 60.0% 65.0% 70.0% 75.0% 80.0% 85.0% 90.0% Cohort 2014 Cohort 2015 Cohort 2016 Cohort 2017
All Students Caucasian African American Hispanic Asian American Indian
Graduation Rate
Difference between 4-year and 5-year Graduation Rates (Cohort 2017)
7
4.2 4.5 4.8 5.0 5.3 5.3 5.9 6.0 6.7 7.2 7.6 9.9
Caucasian Asian Female Hispanic African American All Students Non Hispanic Male Economically Disadvantaged English Learners Student w Disabilities Native American
Percent
Difference between 4-year, 5-year, and 6- year Graduation Rates (Cohort 2016)
8
1.7 1.8 1.8 2 2.3 2.2 2.4 2.5 3.5 3 3.1 6.1 6.4 6.5 6.9 7.6 7.7 8 8.2 9.6 9.9 11.1
Female Caucasian Hispanic All Students Male Asian Economically Disadvantaged English Language Learners Native American African American Students w Disabilities
Difference Between 4-6 Yr Cohort Difference 5-6 Yr Cohort
Historical Four-Year Graduation Rates New Mexico’s 10 Largest Cohorts
District 2014-2015 2015-2016 2016-2017 2017-2018
Albuquerque Public Schools
61.7% 66.2% 67.9% 69.6%
Las Cruces Public Schools
74.5% 79.6% 85.5% 86.2%
Rio Rancho Public Schools
82.7% 83.8% 82.0% 85.4%
Gallup McKinley County Schools
66.6% 65.3% 67.2% 73.1%
Gadsden Independent Schools
80.7% 86.1% 81.7% 81.8%
Santa Fe Public Schools
66.8% 71.3% 68.9% 73.0%
Farmington Municipal Schools
71.7% 70.5% 66.2% 74.7%
Roswell Independent Schools
68.3% 68.8% 65.8% 68.5%
Los Lunas Public Schools
75.7% 80.6% 76.3% 73.9%
Hobbs Municipal Schools
84.8% 86.6% 86.1% 88.9% Note: These 10 districts represent 61.2 percent of all students in the Cohort of 2018.
2017-2018 Four-Year Graduation Rates Highest and Lowest Rates by District
Large Districts Five Highest Rates District Rate
Los Alamos Public Schools 89.4% Hobbs Municipal Schools 88.9% Las Cruces Public Schools 86.2% Rio Rancho Public Schools 85.4% Clovis Municipal Schools 83.0%
Five Lowest Rates District Rate
Grants Cibola County Schools 62.4% Bernalillo Public Schools 63.2% Central Consolidated Schools 63.6% Portales Municipal Schools 65.2% Roswell Independent Schools 68.5% Note: Of the 78 districts with at least 10 students in the cohort, “large” districts are those in the highest third.
2017-2018 Four-Year Graduation Rates Highest and Lowest Rates by District
Medium Districts Five Highest Rates District Rate
Tatum Municipal Schools 93.0% Cloudcroft Municipal Schools 91.6% Mora Independent Schools 90.4% Santa Rosa Consolidated Schools 89.0% Cobre Consolidated Schools 87.7%
Five Lowest Rates District Rate
Raton Public Schools 67.5% Tularosa Municipal Schools 69.1% Cuba Independent Schools 70.4% Socorro Consolidated Schools 71.6% T or C Municipal Schools 72.3% Note: Of the 78 districts with at least 10 students in the cohort, “medium” districts are those in the middle third.
2017-2018 Four-Year Graduation Rates Highest and Lowest Rates by District
Small Districts Five Highest Rates
District Rate Melrose Public Schools 100.0% Springer Municipal Schools 100.0% Grady Municipal Schools 99.3% Animas Public Schools 98.5% Fort Sumner Municipal Schools 97.0%
Five Lowest Rates
District Rate Lordsburg Municipal Schools 56.8% Mesa Vista Consolidated Schools 67.1% Logan Municipal Schools 68.5% Peñasco Independent Schools 70.2% Clayton Municipal Schools 74.1%
Note 2: The following 11 districts were excluded from this analysis because they have fewer than 10 students in the cohort: Carrizozo, Corona, Des Moines, House, Lake Arthur, Maxwell, Mosquero, Roy, San Jon, Vaughn, and Wagon Mound. Note 1: Of the 78 districts with at least 10 students in the cohort, “small” districts are those in the lowest third.
Highest Increases in Graduation Rate Four-Year Rate by District
Large Districts 2017-to-2018 Change
District One-Year Percentage-Point Increase Bloomfield Schools 9.6% Aztec Municipal Schools 8.9% Farmington Municipal Schools 8.5% Bernalillo Public Schools 6.4% Gallup McKinley County Schools 5.9%
2015-to-2018 Change
District Three-Year Percentage-Point Increase Alamogordo Public Schools 11.7% Las Cruces Public Schools 11.7% Española Public Schools 9.3% Bloomfield Schools 9.3% Albuquerque Public Schools 7.9% Note: Of the 78 districts with at least 10 students in the cohort, “large” districts are those in the highest third.
Highest Increases in Graduation Rate Four-Year Rate by District
Medium Districts 2017-to-2018 Change
District One-Year Percentage-Point Increase Tatum Municipal Schools 19.9% Zuni Public Schools 18.2% Mora Independent Schools 17.3% Hatch Valley Public Schools 8.9% Cuba Independent Schools 8.1%
2015-to-2018 Change
District Three-Year Percentage-Point Increase Tucumcari Public Schools 23.8% Pecos Independent Schools 23.4% Dexter Consolidated Schools 15.0% Mora Independent Schools 13.9% Estancia Municipal Schools 13.6% Note: Of the 78 districts with at least 10 students in the cohort, “medium” districts are those in the middle third.
Highest Increases in Graduation Rate Four-Year Rate by District
Small Districts 2017-to-2018 Change
District One-Year Percentage-Point Increase Mountainair Public Schools 20.5% Melrose Public Schools 20.3% Hondo Valley Public Schools 15.3% Jemez Valley Public Schools 15.2% Reserve Public Schools 13.4%
2015-to-2018 Change
District Three-Year Percentage-Point Increase Reserve Public Schools 39.6% Taos Municipal Schools 21.6% Jal Public Schools 19.4% Melrose Public Schools 16.5% Hondo Valley Public Schools 16.1%
Note 1: Of the 78 districts with at least 10 students in the cohort, “small” districts are those in the lowest third. Note 2: The following 11 districts were excluded from this analysis because they have fewer than 10 students in the cohort: Carrizozo, Corona, Des Moines, House, Lake Arthur, Maxwell, Mosquero, Roy, San Jon, Vaughn, and Wagon Mound.
Data Pipeline
Schools & Districts STARS Snapshot Data Graduation Data Data Tools SOAP Grad Rates Web Files SPSS
National Adjusted Cohort Graduation Rate
- Comparable and meaningful across states
- Students who do not graduate within four years are
counted as non graduates in the four-year cohort rate
- Credit given for students who take longer than four years
to graduate
- Schools accountable for improving graduation rates for
all students and student subgroups
17
Understanding Graduation Rates
- How are graduation rates and points determined?
– Assigning students to the 4-year cohort – Applying shared accountability – Computing the cohort graduation rates
18
Creation of 4-Year Graduation Cohort
A student’s snapshot history (40D, 80D, 120D, EOY), grade level and school year information determine the student’s 4-year cohort membership.
1. Identify the first two consecutive snapshots pair in high school. 2. From the second snapshot of the snapshot pair, identify the grade level and the school year. 3. Determine the cohort year (expected graduation year).
a) If grade level is 9, add 3 to the snapshot school year. b) If grade level is 10, add 2 to the snapshot school year. c) If grade level is 11, add 1 to the snapshot school year. d) If grade level is 12, add 0 to the snapshot school year.
19
4-Year, 5-Year, and 6-Year Cohorts
20
4-Year Cohort of 2018 5-Year Cohort
- f 2018
6-Year Cohort
- f 2018
Grade 9 10 11 12 12 12 School Year 2015 2016 2017 2018 2019 2020
21
4- YR COHORT OF 2016
22
5-YR COHORT OF 2016
23
6-YR COHORT OF 2016
Outcomes Excusing Cohort Membership
- Deceased
- Transfer Students
- Foreign exchange students on “J” or “F” visa
- Students without two consecutive snapshots
24
Who is Considered a Transfer?
- Out-of-state schools
- Exchange programs in other countries
- Private schools
- Home schools
- Military schools overseas
- Other non-PED education settings
25
Student must exit to an educational setting that can potentially grant a diploma.
Can a Student Be Moved to Different Cohort?
- A student can be reassigned to a new cohort when he/she:
– Has at least a gap of 9 consecutive snapshots. – Shares a student ID with another student or has multiple student IDs.
26
Who is Considered a Graduate? Who Is Considered a Non-graduate?
- Graduates
– Standard high school diploma including ability and career pathways – Complete requirements by August 1 – Students who graduated early
- Nongraduates
– GED – Certificate of Completion – Dropped out – Still enrolled – Status unknown
27
Shared Accountability
- Shared Accountability Model
– The fraction of the snapshots each student obtained is applied to each attended school during the student’s high school career. – Total snapshots
- 16 for 4 years
- 20 for 5 years
- 24 for 6 years
– Graduates: Applied to numerator and denominators – Non-graduates: Applied to denominators only
28
Shared Accountability & Graduation Rate Computation
29
Student High School Count of Snapshots in School Count of Snapshots in State Fraction for that School Grad uated (Y/N) Graduation Numerator Graduation Denominator
Jade Pine 6 16 0.375 N 0.00 0.375 Jade Cactus 10 16 0.625 N 0.00 0.625 Paul Pine 10 10 1.00 Y 1.00 1.00 Sofia Pine 8 16 0.50 Y 0.50 0.50 Sofia Cactus 8 16 0.50 Y 0.50 0.50 Dylan Cactus 12 16 0.75 N 0.00 0.75 Dylan Pine 4 16 0.25 N 0.00 0.25
30
Navigating Graduation Web Files
Select School Data, Select Accountability
Navigating Graduation Web Files
31
Select Graduation Data
Navigating Graduation Web Files
32
Questions?
For additional information, please contact Yun Yao, Ph.D. yun.yao@state.nm.us Jeanho Rodriguez Jeanho.Rodriguez2@state.nm.us
33