SOUTHEAST EDUCATION DATA EXCHANGE (SEED) OVERVIEW & DEMO
58 Slides5.27 MB
SOUTHEAST EDUCATION DATA EXCHANGE (SEED) OVERVIEW & DEMO Wednesday, February 13, 2013 Bob Swiggum, Georgia Department of Education Deb Holdren, Georgia Department of Education 2013 Management Information Systems Conference 1
AGENDA SEED – The Project SEED – The Data SEED – The Architecture SEED – The Demo 2013 Management Information Systems Conference 2
SEED – THE PROJECT What is SEED? Why SEED? Who is SEED? SEED Rules SEED Timeline What Are We Doing? SEED Methodology SEED Concept Model 2013 Management Information Systems Conference 3
WHAT IS SEED? Georgia’s 2009 SLDS Grant Project to Share Data With Other SE States o o Longitudinal, Student Data K12 Only 2013 Management Information Systems Conference 4
WHY SEED? The Need for SEED GOALS and OBJECTIVES: Improve Continuity of Services to Students Enhance States’ Efforts to Ensure Graduation Validate Student Mobility Improve Accuracy and Reliability of Graduation Rates 2013 Management Information Systems Conference 5
WHO IS SEED? All SE States Invited to Participate Charter States: Georgia Kentucky OK North Carolina Alabama CO South Carolina Florida Colorado Oklahoma 2013 Management Information Systems Conference 6
SEED RULES 1. NO PII STORED IN HUB 2. Data is CEDS Compliant 3. Security is Paramount 4. Working Product Before Process 5. SEA Collaboration Required 2013 Management Information Systems Conference 7
SEED TIMELINE 2013 Management Information Systems Conference 8
SEED TIMELINE Milestones: 11/2011 – First Meeting at P20W Conference 01/2012 – Concept Paper Published 04/2012 – Kick-Off in Atlanta 01/2013 – MOUs Signed 02/2013 – Interactive SW Distributed to Pilots, Begin Piloting 04/2013 – End Piloting Interactive 04/2013 – Begin Piloting Batch 05/2013 – End Piloting Batch 05/2013 – GA, KY, NC Live 05/2013 – Begin Production Support and Maintenance 07/2013 – Complete Rollout to Charter SEAs 08/2013 – Begin Rollout to Other States 03/2014 – Close Project -- Continue Support and Maintenance 2013 Management Information Systems Conference 9
WHAT HAVE WE DONE? Face-to-Face Kick-Off Agreed on Scope and Requirements Agreed on Data Specifications Designed and Built Solution Architecture Built an Interactive Capability Designed Batch Capability 2013 Management Information Systems Conference 10
WHAT ARE WE DOING? Piloting Interactive Building Batch WHAT WILL WE DO? Finish Piloting Interactive Pilot Batch Go Live in GA, KY, NC Rollout to Charter States Open Up to Other States 2013 Management Information Systems Conference 11
SEED METHODOLOGY Collaboration via MS LIVE Scope and Requirements Interstate vs. Intrastate Conceptual Model (from Kick-Off) Process Model (New Student and Lost Student) Data Element Matrix o o o Mandatory Desired Optional 2013 Management Information Systems Conference 12
SEED METHODOLOGY Agile Development 1. Working Product 1. 2. Working Prototype Developed Functionality 1. 2. 3. 4. 3. Inspect Adapt Improve Repeat Repeat Step 2 2. Collaboration and Constructive Conflict 2013 Management Information Systems Conference 13
SEED METHODOLOGY Scrum Wall 2013 Management Information Systems Conference Photo by Georgia Department of Education. 14
SEED ARCHITECTURE 2013 Management Information Systems Conference 15
SEED – THE DATA Jump Right In CEDS Rule and CEDS Categories SEED Comprehensive Guide States Mapping to Comprehensive Guide SEED Physical Data Model SEED Graphic from dreamstime.com 2013 Management Information Systems Conference 16
SEED DATA – JUMP RIGHT IN! Last name Middle name/middle initial First name Suffix Gender Race (multiples) Ethnicity DOB SSN (Last 4 or 5) State Student Unique ID Other State Student Unique ID Local ID Other Local ID Address City of Birth State of Birth Country of Birth Parent Name Grade Level School Year Entry Date Exit Date **Assessment Data (ACT, MAP) **Incident Data **Course Data (with grades) School Data Program Data Student Data ** These data elements are optional for the pilot and the initial roll out. If a state chooses to bypass these elements during piloting and/or initial rollout, the state will implement them at a later date. 2013 Management Information Systems Conference 17
SEED DATA – RULE #2 Second SEED Rule: 2. Data is CEDS Compliant (version 2) CEDS Categories Chosen: 1. Demographics 2. Enrollment 3. Student Contact 4. Parent/Guardian ID 5. School Directory 6. LEA Directory 7. Discipline 8. Assessment 9. Assessment Performance Level 10. Academic Record 11. Program 12. Program ID 2013 Management Information Systems Conference 18
SEED COMPREHENSIVE GUIDE Comprehensive Guide – High Level 21 Screen Elements Search Initiation Screen Label State or States to Search Number of Years Desired State Student Unique ID Last 4 digits of SSN Former State Student Unique ID Last Name First Name Middle Name Name Suffix Gender Date of Birth Country of Birth State of Birth City of Birth Race/Ethnicity* Grade Level Former Street Address Former City Former State Former Zip Code Parent Name CEDS Entity N/A N/A Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Parent/Guardian Parent/Guardian Parent/Guardian Parent/Guardian 27 CEDS Elements CEDS Category N/A N/A Identity Identity Identity Identity Identity Identity Identity Demographic Demographic Demographic Demographic Demographic Demographic Demographic Demographic Demographic Demographic Demographic Enrollment Contact Contact Contact Contact Identity Identity Identity Identity CEDS Element Name N/A N/A Student Identifier Student Identifier Student Identifier Last or Surname First Name Middle Name Generation Code or Suffix Sex Birthdate Country of Birth Code State of Birth Abbreviation City of Birth American Indian or Alaska Native Asian Black or African American Native Hawaiian or Other Pacific Islander White Hispanic or Latino Ethnicity Entry Grade Level Address Street Number and Name Address City State Abbreviation Address Postal Code First Name Middle Name Last or Surname Generation Code or Suffix 2013 Management Information Systems Conference 19
Comprehensive Guide – Detail 2013 Management Information Systems Conference 20
SEED PHYSICAL DATA MODEL 2013 Management Information Systems Conference 21
SEED – THE ARCHITECTURE Quality Goals Security Model Federated Search Architecture Index Search Model Document Server Model Virtual Appliance Architecture Implementation Model Physical Data Models Hub Appliance 2013 Management Information Systems Conference 22
SEED QUALITY GOALS Scalability: Description: System’s reaction when user demands increase Solution: Microsoft.NET web farm modeled web servers support several workload management techniques Reliability, Availability: Description: Transparent failover mechanism, mean-time-between-failure Solution: Microsoft.NET web application supports load balancing through web farms Portability: Description: Ability to be reused in another environment Solution: The system is fully Microsoft.NET compliant and thus can be deployed onto any Windows application server Security: Description: Authentication and authorization mechanisms Solution: Federated Identity security mechanisms will be needed to be implemented for reuse 2013 Management Information Systems Conference 23
SEED ARCHITECTURE 2013 Management Information Systems Conference 24
SEED FEDERATED SEARCH ARCHITECTURE 2013 Management Information Systems Conference 25
SEED INDEX SEARCH MODEL 2013 Management Information Systems Conference 26
SEED DOCUMENT SERVER MODEL 2013 Management Information Systems Conference 27
SEED APPLIANCE ARCHITECTURE MODEL 2013 Management Information Systems Conference 28
SEED IMPLEMENTATION MODEL 2013 Management Information Systems Conference 29
SEED HUB PHYSICAL MODEL 2013 Management Information Systems Conference 30
SEED APPLIANCE PHYSICAL MODEL 2013 Management Information Systems Conference 31
SEED SIZE AND PERFORMANCE Volume Estimates: SEED Record Requests: 100 a day, with peaks in the morning SEED Georgia SEA and LEA Users: about 1,500 SEED Other SEA Users: about 100 Performance: Less than 10 seconds 2013 Management Information Systems Conference 32
SEED – THE DEMO SEED Interactive Capability SEED Hub Administration SEED Batch Prototype 2013 Management Information Systems Conference 33
SEED DEMO SEED Demo Simulated Appliances for NC and KY Georgia’s UAT Environment ALL Student Data are Obfuscated 2013 Management Information Systems Conference 34
SEED LOG IN Optional Log In 2013 Management Information Systems Conference 35
SEED FERPA ACKNOWLEDGMENT Optional FERPA Acknowledgement 2013 Management Information Systems Conference 36
SEED SEARCH INITIATION – SHORT FORM Optional Customized Banner for Each State 2013 Management Information Systems Conference 37
SEED SEARCH INITIATION – SHORT FORM Three Required Data Elements: 1. First and/or Last Name 2. Birthdate 3. State(s) to Search 2013 Management Information Systems Conference 38
SEED SEARCH INITIATION – LONG FORM 21 Search Elements Available 2013 Management Information Systems Conference 39
SEED SEARCH INITIATION – LONG FORM Online Validation 2013 Management Information Systems Conference ALL Student Data are Obfuscated 40
SEED SEARCH RESULTSALL Student Data are Obfuscated 2013 Management Information Systems Conference 41
SEED SEARCH RESULTS Select Icon View Student Record ALL Student Data are Obfuscated Three Pilot States Only 2013 Management Information Systems Conference 42
ALL Student Data are Obfuscated SEED STUDENT RECORD 999-999-9999 999-999-9999 2013 Management Information Systems Conference 43
ALL Student Data are Obfuscated SEED STUDENT RECORD CEDS Categories Available: 1. Demographics 2. Enrollment 3. Student Contact 4. Parent/Guardian ID 5. School Directory 6. LEA Directory 7. Discipline 8. Assessment 9. Assessment Performance Level 10.Academic Record 11.Program 12.Program ID 2013 Management Information Systems Conference 44
ALL Student Data are Obfuscated SEED STUDENT RECORD MyData Button 999-999-9999 999-999-9999 2013 Management Information Systems Conference 45
ALL Student Data are Obfuscated SEED STUDENT RECORD Export Student Record 2013 Management Information Systems Conference 46
SEED STUDENT RECORD EXPORT XML ALL Student Data are Obfuscated 2013 Management Information Systems Conference 47
SEED STUDENT RECORD EXPORT CSV Demographic Identification System For Student Student Identifier SSN4 Last Or Surname 1E 09 State 6712Saldana First Name Middle Name Aracely A Entry Grade Level Cohort Year Generation Code Or Suffix Sex Female Birth Date State Of Birth Country Of Birth Code Abbreviation ALL Student Data are Obfuscated City Of Birth Race ######## Address Street Number And Name Address City State Abbreviation White Enrollment SEED LEA Identifier SEED School Identifier Entry Date F2496CB2-CE19-47DB- 44143703-CEC7-4A529063-32D2C6781A07 9C24-2A01824CF0B8 ######## 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 ######## Exit Date Local Education Agency Identifier Organization Name School Year 1 KG Telephone Number School Identifier Name Of Institution 2012 660 Emory District 404-7636890 999-999-9999 398 Mc Sorley Elementary School 2011 660 Emory District 404-7636890 999-999-9999 398 Mc Sorley Elementary School Program SEED LEA Identifier SEED School Identifier Program Name Program Identifier Program Participation Start Date Program Participation Exit Date Program Exit Reason Program Exit Reason Description SEED School Identifier Marking Period Course Identifier Course Code System Course Title Grade Level Grade Level Description Grade Earned Academic Record SEED LEA Identifier Number Of Credits Earned Credit Type Earned Local Education Agency Identifier Organization Name School Year 999-999-9999 Telephone Number 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 17.001State Health/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 404-7636890 999-999-9999 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 23.001State Language Arts/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 404-7636890 School Identifier Name Of Institution Mc Sorley Elementary 398 School Mc Sorley Elementary 398 School 999-999-9999 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 27.011State Mathematics/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 404-7636890 Mc Sorley Elementary 398 School 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 36.001State Physical Education/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 404-7636890 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 41.011State Science/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 404-7636890 Mc Sorley Elementary 398 School 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 45.001State Social Studies/Grade K KG Kindergarten 0 00585Carnegie unit 2011 660 Emory District 999-999-9999 404-7636890 Mc Sorley Elementary 398 School 66F038E4-C12C-4762- 100F2B72-E243-4FCD9BAB-61AF5FBD5274 9D5A-42155F2908A9 2nd Nine-week Period 50.001State Visual Arts/Grade K Kindergarten 0 00585Carnegie unit 2011 660 Emory District 999-999-9999 Mc Sorley Elementary 398 School 999-999-9999 KG 2013 Management Information Systems Conference 404-7636890 999-999-9999 Mc Sorley Elementary 398 School 48
SEED HUB ADMIN Hub Admin 2013 Management Information Systems Conference 49
SEED HUB ADMIN – 1ST GENERATION Georgia Use Only 2013 Management Information Systems Conference 50
SEED HUB ADMIN – 1ST GENERATION View Details Edit Delete 2013 Management Information Systems Conference 51
SEED HUB ADMIN – 1ST GENERATION Add New SEA 2013 Management Information Systems Conference 52
SEED HUB ADMIN – 1ST GENERATION Add New SEA 2013 Management Information Systems Conference 53
SEED BATCH – WORKING PROTOTYPE Batch Prototype 2013 Management Information Systems Conference 54
SEED BATCH – WORKING PROTOTYPE Select and Submit Batch File 2013 Management Information Systems Conference 55
SEED BATCH – WORKING PROTOTYPE Summary Validation Results 2013 Management Information Systems Conference 56
SEED BATCH – WORKING PROTOTYPE Search Results 2013 Management Information Systems Conference 57
CONTACTS AND ADDITIONAL RESOURCES Contact Information: Bob Swiggum, [email protected] Debra Holdren, [email protected] [email protected] http://slds.doe.k21.ga.us 2013 Management Information Systems Conference 58
