Transcript Slide 1

Counselors Using Data
as a Tool
School Counselor Workshop
September 12, 2012
Counselors Using Data as a Tool
Overview – Participants will learn how to enter
data into a spreadsheet and prepare a
presentation which summarizes the results of
the lesson.
 Session 1 – Review of data terms, survey
design and excel worksheets
Counselors Using Data as a Tool
cont.
Session 2 – Visualizing data
 How to integrate data into a spreadsheet and
into a PowerPoint presentation.
 Elements of effective presentations.
Session 3 – Presentation of data over time
 PowerPoint presentation by class
 New data collection tools
 Next steps for school counselors
Objectives
To discuss- Review data terms used in ASCA National
Model.
 Review how data is used in the ASCA
National model results reports.
What Does A School Counselor Do?
Examples of Data to Examine
Test Scores
Achievement
State
National
Enrollment
Honors/AP Classes
 College Track
 Special Education

Attendance
 Absences
Tardies
 By Grade Level

Discipline
By Classroom
 Types of Problems
 Gender

Retention Rates
Special
Education

By Subject Area
 By Grade Level
 By Gender, Ethnicity
 By Gender

By Ethnicity
 By SES
Graduation Rate
By Gender
 By Ethnicity
 By SES

GPA/Class Rank
By Gender
 By Ethnicity
 By SES

Dropout Rate
Grade Levels
 Gender, Ethnicity…
 Reasons Why

Program evaluation data
It is critically important that school counselors
use data to show the school counseling
program’s impact through the evaluation of
process, perception, and results data.
1. Process data
2. Perception data
3. Results data
Process Data
“What did you do for whom?”
 1,350 6-8th grade students received the “Time
to Tell” guidance lesson.
 Four year plans were completed by 350
freshman students during English 9 classes.
 Held six five-session counseling groups with
eight students each on anger management.
Example of Process Data for
one high school
 Sixteen high school classroom guidance lessons





were taught for 2007-2008. (1 per quarter)
Eight student support groups (2 per counselor)
Forty-eight students participated in support groups
240 consultations regarding immediate student needs
with parents, teachers, etc.
150 documented incidents of immediate and critical
student interventions
75 documented referrals to outside agencies for
families and students.
Perception Data
“What others think, know or demonstrate” data.
 Measures competency achieved, knowledge gained or
attitudes beliefs of students




Pre-post
Competency achievement
Surveys
Evaluations
 Measures what students are perceived to have gained
in knowledge
Perception Data - Examples
 Competency Achievement
 Every student in grades 9-12 completed a 4 year plan
 Every 10th grade student completed an interest inventory
 Knowledge Gained
 89% of students demonstrate knowledge of high school
graduation requirements
 92% can identify Early Warning Signs of violence
 Attitudes or Beliefs
 74% of students believe fighting is wrong
 29% of students feel safe at school
 78% know the name of their school counselor
Results Data
“So WHAT” data
 Hard data
 Proof that your program has (or has not)
positively impacted students ability to utilize the
knowledge, attitudes and skills to effect behavior



Attendance
Behavior
Academic achievement
Results Report
How are students different
as a RESULT of what you do?
 What does the data tell you?
 Was the program successful?
 What worked?
 What did NOT work?
 What needs to be changed?
Results Data - Examples
 42 students on the retention list avoided
retention as a result of being in a group.
 Graduation rates improved 14% over three
years.
 Attendance improved among 9th grade
males by 49%.
Achievement and Related Data
School counselors should be proficient in the
collection, analysis and interpretation of
student achievement and related data.
School counselors should be proficient in
the collection, analysis and interpretation of
student achievement and related data
Student Achievement Data
 Standardized Test
 Passing all classes
Scores
 Grade point
averages
 SAT and AT scores
 Graduation rates
 Promotion and
retention rates
 Drop out rates
 Completion of
specific academic
programs (honors,
college prep.)
School Specific DataAchievement Related Data
Look at the date from the following three areas of
achievement related data for your school.
 Attendance data
 Tardy data
 Suspension rates
Discuss how you would use this data in selecting a
closing the gap lesson based on a ASCA standard &
a district performance objective.
Standards & Competency Related Data
 Competency Achievement



Every student in grades 9-12 completed a 4 year plan
Every 10th grade student completed an interest inventory
All 3rd grade students achieved competency PS:B1.5
Demonstrate who, where, and how to seek help for
solving problems and making decisions.
Disaggregated Data
Separating data by variables to see if there are
any groups of students who may not be doing
as well as others.
 Gender
 Ethnicity
 Socio-economic status (free and reduced lunch)
 Language spoken at home
 Grade level, etc.
Disaggregated Data
Jefferson County, KY
Advanced Placement Enrollment: Race and Gender
4000
3587
3500
2764
2621
3000
2500
2000
1500
2242
1772
1350
1311
1696
1530
1224
1000
427
282
220
45
500
0
Male
Female
Black
Total
1999-2000
2000-2001
2001-2002
2002-2003
Data Over Time
To get a true picture of the impact of the school
counseling program, it is important to look at
data over time.
 Immediate
 Intermediate
 Long Range
Immediate Data
Data that measures the immediate impact of
knowledge, skills and attitudes change as a
result of counseling activity or intervention.
Examples:
1. Pre-post test on student competencies addressed in
a classroom unit.
2. The number of students who completed a 4-year
plan.
Differences Pre- Post
(Immediate Data)
RESPECT Survey Pre to Post
40
35
30
25
20
15
10
5
0
Pretest Respect
PostTest Respect
Intermediate Data
Data collected to measure application of
knowledge, attitudes, and skills over a short
period of time.
Examples:
1. Improved test-taking ability
2. Improved classroom behavior after small-group
counseling
3. Improved grades this quarter after homework
lessons.
ACADEMIC
Career
Personal/ Social
Academic Results
Intermediate Data
Start of Group
Students on retention list:
• 6th - 81
• 7th - 73
• 8th - 103
End of Group
Students who came off
retention list:
• 6th - 27
• 7th - 22
• 8th - 23
72 students avoided retention
Attendance Data After Intervention
for Six Weeks
(goal + 5% increase)
100
80
60
baseline
6 weeks
difference
40
20
0
-20
m
l
s1
w
s2
c
m
j1
b
f
k
j2
Long Range
School wide year-to-year, longitudinal student
impact data collected for areas such as
student attendance, graduation rates, and
suspension rates.
African American and Latino 17 Year Olds Do
Math at Same Levels As White 13 Year Olds
100%
0%
200
250
White 8th Graders
Latino 12th Graders
Source: NAEP 1999 Long Term Trends Summary Tables (online)
300
350
African American 12th Graders
Percent
Comparison of Attendance Data
for Eight Year Span
Years
Percent Attendance
1996-1997
92.27%
2004-2005
93.33%
Stop
Percent
Percent of Students with Career Plan
24%
Without
WITH Career Plan
76%
ACADEMIC
Career
Personal/ Social
Academic Results
Intermediate Data
After Academic Counseling Groups,
Percentage of Students Demonstrating GPA
Improvement:
• 37% of 6th graders (64)
• 24% of 7th graders (47)
• 72% of 8th graders (46)
Differences Pre- Post
(Immediate Data)
RESPECT Survey Pre to Post
40
35
30
25
20
15
10
5
0
Pretest Respect
PostTest Respect
Total Number Of Parents Attending
Events/activities at Each Target Site
6000
5000
4000
2003-04
3000
2004-05
2000
1000
0
1
2
3
4
5
1-Bloom
2-Davidson
5-Lyons
6-Maldonado
6
7
8
3-Ford
4-Gale
7-Reynolds
8-Vesey
Individual Reading Scores
Of One Student
180
160
140
120
100
1st Reading
2nd Reading
80
60
40
20
0
1
2
3
4
5
6
7
8
9
10
11
12
13
Results Reports
 Ensure programs are implemented,
analyzed for effectiveness, and
changed/improved as needed
 Shared with stakeholders
 Immediate, intermediate, and longrange results
Guidance Curriculum Results
 Report documents results of the guidance
curriculum lessons delivered to ALL students.
 Provides process data, perception data &
results data.
 Provides implications and suggestions for
next lesson.
 Turned in to supervisor at end of the year.
Guidance Curriculum
Results Report
 Report documents results of the guidance
curriculum lessons delivered to ALL students.
 Provides process data, perception data &
results data.
 Provides implications and suggestions for
next lesson.
 Turned in to supervisor at end of the year.
Closing the Gap Results Report
 Shows the results of your action plan and
gives data –




Process – number of students affected
Perception – what do students think they know
Results – what happened
Implications for future lessons
Websites






ASCA: www.schoolcounselor.org
Russ Sabella: www.schoolcounselor.com
Education Trust: www.edtrust.org
LifeBound: www.lifebound.com
Real Game: http://www.realgame.com/
TUSD” www.tusd1.org
Department, “S” school counselors, elementary career, academic, &
personal/social lesson plans, and 9-12 curriculum books. Free to
download.
Thank you!!!!!
Judy Bowers, Ed.D.
School Counselor Consultant
ASCA President 2004-2005
[email protected]