June, 2011, Status
(All underlined links below download artifacts)
May 2011 State Core Slides
The State Core Model was chartered by Council of Chief State School Officers (CCSSO) in 2009 to bring a coherent state education agency (SEA) perspective to national standards movements. The State Core Model v1.0 was published March 3, 2010 as part of the National Education Data Model (NEDM). To produce this version:
· 34 state data handbooks were mapped: AR, CO, CT, DE, FL, GA, IA, IL, KS, LA, MA, MD, ME, MI, MN, MT, NC, NH, NJ, NM, NV, NY, OH, OK, PA, SC, TN, TX, UT, VT, WA, WI, WV, and WY.
· 20 states were met with: AR, CO, CT, DE, IA, KS, MD, ME, MT, NC, NJ, NM, NY, OK, PA, TX, UT, VT, WA, WY.
· 3 states were mapped more deeply: NJ, IL, and WA
In the first phase of work, as part of the National Education Data Model (NEDM), state mapping involved 4-5 hours of research per state with publicly published materials. The meetings were single, 1-hour WebEx sessions. Deep mapping involved development of comprehensive metadata workbooks. This phase also involved mapping to 79 EDFacts file specifications.
In May 2010, as part of the Common Education Data Standards (CEDS) adoption work, with funding from the Gates Foundation, CCSSO began expanding the State Core Model to serve a common technical reference model for SEAs and to help guide development of their P-20 State Longitudinal Data System (SLDS).
The State Core Model v2.0 was completed on December 1, 2010. v2o of the Model includes early childhood (EC), elementary and secondary (K12), post-secondary (PS), and workforce (WF) elements, known collectively as “P20,” and establishes comparability between sectors and between states. V2.0 of the Model includes maps to 625 Federal data collections and is designed to support dropout early warning intervention systems (DEWIS), positive behavior intervention systems (PBIS) and response to intervention (RTI). Future versions of the model are expected to include health and human services, justice, and substantially more depth in the areas of post-secondary education, interactive learning, performance metrics, and research. v2o of the Model consists of three principle artifacts:
(1) PDF and Word formats of a document entitled “State Core Model,” providing a narrative explanation of the context, conceptual model, and the logical model broken out by “data domains.”
(2) An Excel 2007 file entitled “State Core Workbook,” containing a complete data dictionary of all three schemas used in the model with maps to 625 federal collections and participating state dictionaries.
(3) The "ODS Entity Relationship Model," can be downloaded as a data definition language (DDL) scripts that will operate in over 30 major relational database platforms including Microsoft SQL 2008, MySQL, Oracle 10i.
ODS ERD in PDF
ODS ERD DDL in SQL’08
ODS ERD DDL in MySQL
ODS ERD DDL in Oracle
In February, 2011, the CEDS Management group approved a definition of consortium core artifacts that separated the State Core SLDS Reference Model (aka “the Model”) from the CEDS Data Mapping Workbook v2.1 (aka “the Workbook”) enabling the Model to continue to build out technical reference materials tightly focused on the needs of SEA SLDSs and freeing up the Workbook to create a Unified Data Map between the Model, CEDS Elements, NEDM, SIF, PESC, federal collections, and SLDSs. To guide this work, the CEDS Data Mapping Protocols documents a step-by-step process for states, specification bodies, and other data sets to be mapped in the Workbook and review the Model:
Data Mapping Steps
Step 1: Contact
Step 2: Discovery
Step 3: Mapping
Step 4: Mapping Review (Iterative)
Step 5: Map and Gap
Step 6: Final Presentation
State Core Model Review Steps
Step 7: Set-up Specific Instance in Sandbox
Step 8: Register for Friday technical reviews
Step 9: Customize State Core ODS
Step 10: Download DDL
So far, in the second phase of the work, as part of CEDS, 16 states have begun adoption through these ten steps: AZ, AR, CA, IA, IL, KS, MI, NC, ND, NJ, RI, OR, UT, WA, WY, VA.
No comments:
Post a Comment