Dropout prevention EARLY Warning reports

1. Dropout prevention EARLY Warning reports School Counseling/Guidance Fall Regional RESA Trainings Presenters: Debora Williams and Betsy Baugess

2. Graduation Rate = 82.5% http://www.newsobserver.com/2013/08/08/3092325/nc-graduation-rate-rises-above.html

3. Do You Know? Annual Number of Dropouts in U.S.

4. High School Dropout Statistics Annual number of high school dropouts in U.S. 3,000,000+ http://www.statisticbrain.com/high-school-dropout-statistics/

5. Do You Know? Number of dropouts in North Carolina (2012)

6. High School Dropout Statistics Number of students dropping out of school in North Carolina (2012) 13,488 Grades 9-12 http://www.ncpublicschools.org/docs/research/discipline/reports/consolidated/2011-12/consolidated-report.pdf

7. Do You Know? Number of NC students retained in 3rd Grade (2012)

8. Do You Know? 32,000 (2012)

9. PURPOSE To facilitate an early warning reporting system with research-based risk factors for identifying students who may be at risk of dropping out of school.

10. ResearchonEarly Warning Indicators On-track Credits An on-track student has accumulated the requisite number of credits to move to the next grade level and no more than one semester “F” in a core subject. (Allensworth, 2009) Attendance Eight times more predictive of failure than prior test scores. A student who has more than 5 absences in one semester of the 9th grade year has a 63% chance of graduating in four years. (Allensworth, 2009)In North Carolina, attendance issues were the most often noted for a reported dropout, accounting for 41.5% of all dropouts. GPA Students with a “B” (3.0) average or higher in the first year have better than a 93% chance of graduating; students with a D+/C- (1.0-2.5 GPA) average have a 53-92% chance of graduating; students with less than a “D” average (1.0) have less than a 6% chance of graduating. (Allensworth, 2009)

11. RELEVANT SIS DATA • Attendance data, both current and historical • State assessment achievement level data • Final marks for all middle school/high school courses • Most recently calculated GPA (calculated at year-end for grades 9-12) • Student name, pupil number, birth date, ninth-grade entry date

12. PowerSchool At Risk Report The At Risk Report provides a listing of courses, sections, and grades associated with students who are currently a risk of failing for the current term.

13. PowerSchool At Risk Report Allows administrators and teachers to take a proactive approach to address potential issues and ensure student accountability.

14. At Risk Report Fields • Attendance Mode • Daily • Meeting • Time • Students to Include • Selected students only • All students

15. At Risk Report FieldsAttendance Codes • ALL CODES • Illness or Injury • Medical/Dental Appt • Death in Family • Quarantine • Court/Admin Proc • Religious Observance • Educational Opportunity • Teacher-in-Treatment • Local School Bd Policy • Child Care • Excused Tardy • Medically Fragile • Deployment Activity • Unexcused Absence • Unex No Immunization • Unexcused Tardy • Suspensions

16. At Risk Report Fields • Reporting Segment or Begin Date and Ending Date • Reporting Segment • Chose from reporting segment from the pop-up menu • Begin Date and Ending Date • Specify a date range in using mm/dd/yyyy OR mm-dd-yyy • Failure to use this format issues an alert • Date must fall within the selected school year

17. At Risk Report – Data to be Filled ? Use Attendance Report Query • Enter minimum number of occurrences of selected attendance codes ? Use Grades Report Query • Uses three Grade fields to query students for the report • Select final grade type (Stored or Current) • Minimum number of classes with failing grades ? Use Discipline Report Query • Discipline/incident check inn PowerSchool does NOT consider the PowerSchool discipline/incident functionality that NC will be using. This section should not be used at this time.

18. \

20. At Risk Report

21. NCWISE ReportsGraduation Resiliency • Reporting Hub Accessible to NC WISE District/School Data Managers • Four reports available on NCWISE Reporting Hub • 9th Grade Dropout Early Warning Report • 10th Grade Dropout Early Warning Report • 11th Grade Dropout Early Warning Report • 12th Grade Dropout Early Warning Report

22. NCWISE REPORTS(continued) • Designed for availability just prior to the start of school allowing counselors to identify the “at risk” students. • Analyze the student’s historical data. • Executed at the beginning of school year for identification of individual student issues.

23. GR Risk Indicators • Attendance through middle/high school • Final course marks in key elementary/middle school courses • Successful completion of high school courses essential to graduation within an appropriate timeframe, as indicated by state assessments • Cumulative credits earned in each high school year • Continuous cumulative grade point average

24. Risk Criteria Ninth grade report • Final grade for standard required Math course (grades 6,7,8) < C • Final grade for standard required English course (grades 6,7,8) < C All reports • Total daily absences, in any one school year, exceed 5 daily absences

25. Tenth/Eleventh/Twelfth Grade Risk Criteria • GPA < 2.0 • Achievement Level I or II for EOCs • English I • Algebra I • Failure to achieve an expected level of course credits after each year in high school • At beginning of grade 10, less than 5 earned credits • At beginning of grade 11, less than 10 earned credits • At beginning of grade 12, less than 15 earned credits

26. Report Details • All reports are school level reports • Each report only contains students “at risk” for dropout • Each student has only one record in the report • Each column of the report represents a potential dropout risk factor

27. Report Details (continued) • If there is no data for a particular risk factor, the column for that factor indicates “no data” • Risk factor is calculated using only the available data points • There is no variable weighting factor. All risk factors carry the same weight. • Risk factor must be 25% or above for the student to be included in the report

28. Ninth Grade Sample Report

29. Example: Student #1 • Rising ninth grader • 2 absences in sixth grade • 8 absences in seventh grade - risk factor • 5 absences in eighth grade • Sixth grade English final mark is “C+” • Seventh grade English final mark is “D” - risk factor • Eighth grade English final mark is “F” - risk factor • Sixth grade math final mark is “D-” – risk factor • Seventh grade math final mark is “F” – risk factor • Eighth grade math final mark is “D” – risk factor • RISK FACTOR is 67% (6 of 9 factors qualify as risks)

30. Twelfth Grade Sample Report http://dpi.state.nc.us/docs/graduate/resiliency/sample-report.pdf

31. Once You Have the Report • Determine how best to use the data • Convene a team to review reporting data and analyze results • Determine preventative measures or interventions and how you will track the results

32. FAQs • At what grade can or should at risk reports be run? • When will all school data be available in PowerSchool?

33. Contacts • Debora Williams, Special Assistant Graduation Initiatives (919) 807-3912 debora.williams@dpi.nc.gov • Betsy Baugess, Manager Data/Software & Reporting (919) 807-3276 betsy.baugess@dpi.nc.gov