Data Quality The engine that drives the data warehouse

1
Data QualityThe engine that drives the data
warehouse

• Bill Flaherty
• Hanover County Public Schools
• Director of Technology Services
• Bill_at_hcps.us 804-365-4600
• http//hcps.us/presentations/DataQuality

2
NCLB has changed the educational landscape.
Student assessment is now the name of the game.
http//hcps.us/presentations/DataQuality
3
1999-2000School Board Goals

• Promote instructional programming in the
  following areas, among others.
• Professional development
• Curriculum development
• Implications of longitudinal assessment of
  student achievement
• Graduation requirements staffing needs
• Vocational / technical / alternative education
  study recommendations
• Standards of learning implementation /
  implications

4
Our Time Together

• Key elements to useful data
• Data entry
• Building a culture of data quality
• Components of quality data
• Roles of data entry personnel
• Roles of key players

http//hcps.us/presentations/DataQuality
5
When two or more people own a data elementno
one owns the data!
http//hcps.us/presentations/DataQuality
6
Key elements to useful data

• Accuracy
• Security
• Utility
• Timeliness

http//hcps.us/presentations/DataQuality
7
What do these things have in common?

• Develop an instructional plan
• Run a school
• Plan a budget
• Place a student in a class

http//hcps.us/presentations/DataQuality
8
How does data get entered into your system?
http//hcps.us/presentations/DataQuality
9
Teacher
Assistant Principal
Secretary
Principal
Central Office Administrator
Guidance Counselor
http//hcps.us/presentations/DataQuality
10
National Forum on Educational Statistics
Sponsored byNational Center for Educational
Statistics ( http//nces.ed.gov )
http//hcps.us/presentations/DataQuality
11
What Is a Culture of Quality Data?

• A belief that good data are an integral part of
  teaching and learning
• A belief that everyone in a school is responsible
  for quality data
• A belief that we can create orderly information
  from disorderly settings

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
12
The Components of Quality Data

• Policies and Regulations
• Standards and Guidelines
• Training and Professional Development
• Timelines and Calendars
• Technology (Hardware Software Network)
• Data Entry Environment

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
13
Quality Data Policies and Regulations

• Accurate data are necessary to meet the
  requirements of federal, state and district
  policies and regulations
• Policies developed collaboratively with those
  responsible for data entry and collection at
  school will foster a Culture of Quality Data     

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
14
Quality Data Standards and Guidelines

• When we talk about building a Culture of Quality
  Data, clear standards and guidelines for working
  with data are necessary
• Provide opportunities for those who enter data to
  give feedback about the work that they do and to
  be involved in establishing the guidelines for
  data entry

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
15
Quality Data Training and Professional
Development

• Professional development is more than a
  recitation of the keystrokes needed to complete a
  rote task
• It is critical that staff responsible for
  training and professional development emphasize
  their respect for the people responsible for data
  entry

•       

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
16
Quality Data Timelines and Calendars

• A calendar indicating when data entry must be
  complete and the dates that reports are due will
  assist schools in meeting deadlines
• It will help schools to meet deadlines if the
  district data calendar is distributed to all staff

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
17
Technology (Hardware Software Network)

• Technology exists to serve the needs of the
  district and school
• Involve the technology staff in planning for data
  collection and reporting
• System security is important when working with
  data.

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
18
Data Entry Environment
Data entry can be more efficient and accurate

• if there is a regular time set aside for data
  entry work
• if the place for data entry is away from high
  traffic areas     

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
19
What are some of the roadblocks to obtaining
quality data?

• School setting
• Office
• Classroom
• No process in place
• Lack of training
• Lack of understanding about the value of the work

http//hcps.us/presentations/DataQuality
20
You Cant Be Sure It Is Correct If You Dont
Check It!
http//hcps.us/presentations/DataQuality
21
http//hcps.us/presentations/DataQuality
22
http//hcps.us/presentations/DataQuality
23
http//hcps.us/presentations/DataQuality
24
Have you defined your roles?
http//hcps.us/presentations/DataQuality
25
http//hcps.us/presentations/DataQuality
26
Ref RPT.013 HANOVER COUNTY PUBLIC
SCHOOLS Page 1 Date 2/22/06
XXXXXX HIGH SCHOOL Time 142608
Statistics Summary as of 2006-02-22
14.25.57 -----------------------------------------
--------------------------------------- Advanced
Placement .......................................
........... 187 CTE Career Technical
Education ......................................
314 Diploma Type AD ADVANCED DIPLOMA
408 Diploma
Type GI GED WITH ISAEP
10 Diploma Type IB IB
DIPLOMA
9 Diploma Type MO MODIFIED DIPLOMA
49 Diploma
Type RG STANDARD DIPLOMA
1089 Diploma Type SP SPECIAL
DIPLOMA
31 Diploma Type 10 NO AWRD IEPgt12GD
5 Diploma Type
11 NO AWD- FRGN-XCG
5 Dual Enrollment
..................................................
... 60 Cafeteria Services Summary
..........................................
120 Cafeteria Services F FREE LUNCH
0 Cafeteria
Services P PRINCIPAL OPTION
43 Cafeteria Services R
REDUCE LUNCH
17 Cafeteria Services S FOOD STAMPS
51 Cafeteria
Services T TANF
9 Medicaid........................
...................................... 0
http//hcps.us/presentations/DataQuality
27
Ethnic Group Summary ............................
.................... 1606 Ethnic Group
00 UNSPECIFIED
0 Ethnic Group 01 AMERICAN
INDIAN
7 Ethnic Group 02 ASIAN
15 Ethnic
Group 03 AFRICAN AMERICAN
254 Ethnic Group 04
HISPANIC
20 Ethnic Group 05 WHITE
1310 Ethnic
Group 06 NATIVE HAWAIIAN
0 Foster Child
..................................................
...... 5 Foster Child YI IN-COUNTY
4
Foster Child YO OUT OF COUNTY
1 Foster Child YS
OUT OF STATE
0 GED Students (GD GI 09)
.............................................
10 Gifted ....................................
.......................... 190 Homeless
..................................................
.......... 4 IEP Summary
..................................................
....... 290 IEP Primary AUT (7805)
AUTISM
3 IEP Primary ED (7863) EMOTIONAL
DISTURBANCE 26 IEP
Primary MD (7810) MULTIPLE DISABILITIES
6 IEP Primary MR
(7822) MENTAL RETARDATION
21 IEP Primary OHI (7815) OTHER
HEALTH IMPAIRMENT 81
IEP Primary SD (7880) SEVERE DISABILITY
2 IEP Primary SLD
(7865) SPECIFIC LEARNING DISABILITY
147 IEP Primary SLI (7875) SPEECH OR
LANGUAGE IMPAIRMENT 2 IEP Primary
TBI (7874) TRAUMATIC BRAIN INJURY
1 IEP Primary VI (7850) VISUAL
IMPAIRMENT 1
28
Immigrant .......................................
.................... 4 Limited Prof
English .........................................
....... 30 LEP Status SN Screened,
Not LEP 17
LEP Status 1 LEP and Receiving Services
11 LEP Status 4
Identified as LEP, but not receiving services
1 LEP Status 5 First Year
Post_Monitor Status (FLEP1)
1 Migratory Child ..............................
....................... 1 Outside
Placement .......................................
............ 36 Refugee
..................................................
........... 1 NO Social Security Number
and NO waiver .............................
0 Suspension Bus .............................
......................... 10 Suspension
In-School ........................................
........ 142 Suspension Out of School
............................................
81 Title I ....................................
......................... 0 Truancy
Conference Scheduled ............................
............ 57 W8 Summary
..................................................
........ 12 Drop Reason Code 10
ACHIEVEMENT
7 Drop Reason Code 20 BEHAVIORAL
2 Drop
Reason Code 60 EMPLOYMENT
2 Drop Reason Code 70
MOVED
1 W9 Summary .................................
......................... 9 Principals
Signature _______________________________________
_________
29
02/27/06 073654
Gifted Codes
Verification
PAGE
1 Student Last First

Begin
End Tested Identified
Active ID Name Name
Code Description
Date Date Date
Date Y/N 37652 ALLAN
TIFFANY 1 Gen. Intellectual
Aptitude only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 21351 BEATON
JAMES 1 Gen. Intellectual
Aptitude only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 37756 BEAZLEY
JOSHUA 1 Gen. Intellectual Aptitude
only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 5963 BOSWELL
REBECCA 1 Gen. Intellectual
Aptitude only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 38368 BOWMAN
JESSICA 1 Gen. Intellectual
Aptitude only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 38366 BREWER
DERRICK 1 Gen. Intellectual
Aptitude only 09/06/2005 06/15/2006
01/01/1001 01/01/1001 Y 38668 BRUCE
ASHLEY 13 Gen.
Intel Apt Visual/Perf 09/06/2005
06/15/2006 01/01/1001 01/01/1001 Y 38372
CARROLL JOHN 1 Gen.
Intellectual Aptitude only 09/06/2005
06/15/2006 01/01/1001 01/01/1001 Y 37682
CAVANAUGH ADRIAN 1 Gen.
Intellectual Aptitude only 09/06/2005
06/15/2006 01/01/1001 01/01/1001 Y 37810
COLVILLE MOLLY 1 Gen.
Intellectual Aptitude only 09/06/2005
06/15/2006 01/01/1001 01/01/1001 Y 37617
COOK DAVID 1
Gen. Intellectual Aptitude only
09/06/2005 06/15/2006 01/01/1001 01/01/1001
Y 37452 DANIELSON JOSEPH 1
Gen. Intellectual Aptitude only
09/06/2005 06/15/2006 01/01/1001 01/01/1001
Y 38384 DIEHL JACOB
1 Gen. Intellectual Aptitude only
09/06/2005 06/15/2006 01/01/1001 01/01/1001
Y 40629 DODD MIRANDA 1
Gen. Intellectual Aptitude only
09/06/2005 06/15/2006 01/01/1001 01/01/1001
Y 11066 DONNA JOHN
2 Spec. Academic Aptitude only
09/06/2005 06/15/2006 01/01/1001 01/01/1001
Y
30
Key Players

• The Building Principal
• The Teacher
• The Data Entry Clerk
• The Districts Data Steward
• Technology Support Personnel
• The Superintendent

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
31
The Building Principal

• Check reports for accuracy
• Stay current on district requirements
• Make recommendations to district personnel
• Work with school staff to develop standard
  procedures
• Encourage the use of data in making instructional
  decisions
• Provide an environment conducive to accurate data
  entry.

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
32
The Teacher

• Attend training
• Dont be afraid to ask questions about your
  responsibilities
• Respect the privacy of student data
• Follow district policies and procedures
• Enter data accurately and in a timely manner.
• Ask for help, if you need it.

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
33
The Data Entry Clerk

• Enter data accurately and in a timely manner
• Ask for instructions and documentation
• Dont be afraid to ask questions
• Identify barriers to effective data entry
• Run edit reports
• Know reporting deadlines

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
34
The Districts Data Steward

• Develop a process
• Establish a calendar
• Coordinate the data collection process
• Provide professional development for staff
• Resolve discrepancies

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
35
Technology Support Personnel

• Ensure effective security measures
• Develop an efficient editing and verification
  system
• Provide technical assistance
• Provide a help desk
• Develop an electronic audit trail

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality
36
The Superintendent

• Set educational benchmarks that use data
• Support the development of a Culture of Quality
  Data
• Encourage principals to make data-driven
  decisions
• Support your information technology director
• Fund schools with adequate resources to enter data

National Forum on Education Statistics
http//hcps.us/presentations/DataQuality