EDEN 101 Patrick Sherrill Barbara Timm Ross Santy

1
EDEN 101Patrick SherrillBarbara TimmRoss Santy
2
EDEN 101
EDEN 101 Presentation Objectives
Understand the Language of PBDMI/EDEN/EDFacts
Understand the Foundations of EDFacts
Understand What Steps Got Us Where We Are
Understand How to Replicate in Your State
Network with Other Coordinators
Ask and Answer Questions
3
EDEN 101
Language of PBDMI EDEN EDFacts
Performance Based Data Management Initiative
Education Date Exchange Network -- EDEN
EDEN Submission System ESS
EDEN Survey Tool EST
EDFacts
4
EDEN 101
Decision making
Intuition
Information
5
EDEN 101
Wisdom
Knowledge Management
Information Management
Data Management
6
EDEN 101
Government Performance and Results Act -- 1993
Data on Federal Program Outcomes
7
EDEN 101
Government Performance and Results Act - 1993
The Congress finds that Federal managers are
seriously disadvantaged in their efforts to
improve programs because of inadequate
information on program performance.
PL 103-62, Section 2
8
EDEN 101
Government Performance and Results Act - 1993
The purposes of this Act are to (4) help
Federal Managers improve service delivery by
providing them with information about program
results and service quality.
PL 103-62, Section 2
9
EDEN 101
Government Performance and Results Act - 1993
The purposes of this Act are to (6) improve
congressional decision making by providing more
objective information on achieving statutory
objectives, and on the relative effectiveness and
efficiency of Federal programs and spending..
PL 103-62, Section 2
10
EDEN 101
Paperwork Reduction Act -- 1995
Collect Data with Practical Utility
11
EDEN 101
Practical Utility
means the actual, not merely the theoretical or
potential usefulness of information to or for an
agency, taking into account its accuracy,
validity, adequacy, and reliability, and the
agencys ability to process the information it
collects in a useful and timely fashion.
5 CFR 1320.3(l)
12
EDEN 101
Clinger Cohen Act 1996
Creates Agency Chief Information Officer
13
EDEN 101
Bush Administration Education Initiatives
Legislation No Child Left Behind
OMB FY 2003 Budget Requirements (2001)
Developed a PBDMI Business Case (2001-2002)
Planning and Preliminary Activities (2002)
Established Team in Office of Deputy Secretary
FY 2003 Funding March 2003 (CR)
14
EDEN 101
Goals Performance Based Data Management
Initiative PBDMI
Consolidate Multiple Education Data Collections
Reduce Paperwork Burden on Education Partners
Improve Data Quality Completeness, Accuracy,
Timeliness, Validity
15
EDEN 101
AS IS
IDEAL
Business
Business
Bridging the Gap
Information
Information
Application
Application
Data
Data
Technology
Technology
16
EDEN 101
Enterprise Architecture
Business Architecture
Information Architecture
Application Architecture
Data Architecture
Technology Architecture
17
EDEN 101
Enterprise Architecture
Business What decisions do I make?
Information What information do I need?
Application What tools will produce that
information?
Data What data is needed to produce that
information?
Technology What information systems are needed
to produce that information?
18
EDEN 101
Federal Program Information Requirements
Interviewed Program Managers and Analysts
Derived Component Data Elements
Reviewed Data Elements With Program Experts
Established an Initial Set of Data Elements
19
Federal Program Data Requirements
20
EDEN 101
2003 Round One Initial Steps
Spring 2003 State Site Visits
JulOct 2003 Decide on data elements for pilot
Develop data model, system and file formats
Nov 17, 2003 Open portal to receive data
Dec 15, 2003 Close portal to data submission
Dec 2003Jan 2004 Evaluate 1st pilot submission
21
EDEN 101
2003 State Site Visits
Ask Every Data Provider About Every Data Element
Available? Where? When? What Quality?
Electronically Reportable? How? When?
22
EDEN 101
Results of the PBDMI Pilot Submission
50 States participated (including the DC PR)
Over 2,200 files were submitted
541 were submitted on the last day
43 States had at least one file process
successfully
18 States successfully submitted all 3 Directory
files
Of the 70 file types, 63 different types were
submitted
23
Communications Challenge
24
Education Data Models
25
EDEN 101
Barbara Timm
Elementary and Secondary Education Data Guru
26
Identifying Data Requirements
27
Sample Result IDEA Part B
IDEA Part B Data on Exiting
The number of children with disabilities, by
race, ethnicity, and disability category, who,
for each year of age from age 14 to 21, stopped
receiving special education and related services
because of program completion or other reasons
and the reasons why those children stopped
receiving special education and related
services. (From 20 USC 1418)
28
Sample Result Migrant
Migrant Education Data on Academic Achievement
STUDENT RECORDS- (1) ASSISTANCE- The Secretary
shall assist States in developing effective
methods for the electronic transfer of student
records and in determining the number of
migratory children in each State. (2)
INFORMATION SYSTEM- (A) IN GENERAL- The
Secretary, in consultation with the States,
shall ensure the linkage of migrant student
record systems for the purpose of electronically
exchanging, among the States, health and
educational information regarding all migratory
students. The Secretary shall ensure such linkage
occurs...Such elements may include (i)
immunization records and other health
information (ii) elementary and secondary
academic history (including partial credit),
credit accrual, and results from State
assessments required under section 1111(b)
(iii) other academic information essential to
ensuring that migratory children achieve to high
standards and (iv) eligibility for services
under the Individuals with Disabilities Education
Act. (From 22 U.S.C. 6398)
29
Pilot SY 2003-04 OMB Package Simple Data
30
Data Student Membership
Membership by race/ethnicity, by gender, and by
grade levels
31
Pilot SY 2003-04 OMB Package Complex Data
32
Pilot SY 2003-04 OMB Package Very Complex Data
33
Basic ComponentsData Group

• Names
• IDs
• Definitions
• Reporting periods
• Formats/code sets
• Reporting levels

34
Data Group Format Simple Data

• Name AYP Status
• ID - 32
• Definition - An indication of whether the state,
  district, or school met the Adequate Yearly
  Progress (AYP) requirements for the school year,
  as determined by the state-established criteria.
• Code Set or Format Yes, No, Not Applicable, and
  Missing
• Reporting period School Year
• Levels State, LEA, and School

35
Data Group Format Complex Data

• Name Membership Table
• ID 39
• Definition - The student enrollment, including
  students both present and absent, excluding
  duplicate counts of students within a specific
  school or LEA or students whose membership is
  reported by another school or LEA.
• Code Set or Format Number
• Reporting period October 1
• Levels State, LEA, and School
• Category Set Grade Level, Sex, Race/Ethnicity

36
All ComponentsData Groups

• Names
• IDs
• Definitions
• Reporting periods
• Formats/code sets
• Reporting levels
• Category Sets
• Subtotals
• Grand Totals

37
Category

• Grade Level (Membership)
• Definition The grade level or primary
  instructional level at which a student enters and
  receives services in a school during a given
  academic session.
• Code Set
• UG Ungraded
• PK Pre-kindergarten
• KG Kindergarten
• 01 - Grade 1
• 12 Grade 12

38
Logical Data Model
39
General Guidelines - ESS

• Mandated by law or serve a legitimate Department
  of Education business need
• Collected on a recurring basis
• Structured data
• Pre-formatted (telephone s)
• Predefined code sets (AYP Status)
• Numbers (student membership table)
• Generally available from SEAs

40
On-Line Collection

• LEP Accommodation Table
• LEP Program Terminated Table
• N or D Average Length of Stay in Funded
  Facilities Table (State Agencies)
• N or D Funded Facilities Table (State Agencies)
• RLIS Program Table
• Unsafe School Choice Offered
• Unsafe School Choice - Transferred

41
Metadata

• State Definitions
• General SEA Information
• Assessment
• AYP Reporting

42
K-12 Education Information Model
Communication Links,
43
Education Data ExchangeNetwork (EDEN)
44
Transmission of Data to EDEN
45
EDEN 101
MIS Conference 2/22-24
Jan Feb Mar Apr May Jun Jul Aug
Sep Oct Nov Dec Jan Feb Mar Apr
May Jun Jul Aug Sep Oct Nov Dec
Calendar Year 2006
Calendar Year 2007
Fiscal Year 2006
Fiscal Year 2008
Fiscal Year 2007
School Year 2005-06
School Year 2007-08
School Year 2006-07
2006-2007 Early Submission
2005-2006 Early Submission
2005-2006 Middle Submission
2006-2007 Middle Submission
2005-2006 End Submission
2006-2007 End Submission
2005-2006 Close-Out Submission
2006-2007 Close-Out Submission
2006-2007 OMB Submission
2007-2008 OMB Submission
Jan Feb Mar Apr May Jun Jul Aug
Sep Oct Nov Dec Jan Feb Mar Apr
May Jun Jul Aug Sep Oct Nov Dec
46
EDEN 101
Ross Santy
Deputy Assistant Secretary for Data and
Information
47
EDEN 101
Advocate
Data to Support a Previous Decision
Analyst
Data to Make a Future Decision
48
EDEN 101
Data Quality Continuum
Weather Reports
Bank Statements
49
EDEN 101
2 -7 8- 196
60 Complete
50
EDEN 101
202-708-9196
90 Accurate
51
EDEN 101
Data Importance
First Person Data My Job
Second Person Data Your Job
Third Person Data Their Job
52
EDEN 101
The data you have is not what you want
collection methodology
The data you want is not what you need
theory
The data you need is not available
reality
53
EDEN 101
Information Quality
Data Quality Management Program
54
EDEN 101
Multiple Efforts Working Together
Collaboration
Coordination
Cooperation
Communication
55
Workbook Scavenger HuntLily ClarkRebecca Kaye
EDEN 101