skip to main content

P20 WIN

Improving Education & Employment Opportunities for Connecticut's Students

The Preschool through 20 and Workforce Information Network (P20 WIN), through secure sharing of data, ensures individuals successfully navigate educational pathways into the workforce.

The dashboards below shed light on the relationship between CSCU credentials and the Connecticut labor market. They help answer critical question such as: Are students who complete degrees from Connecticut State Colleges and Universities (CSCU) working in Connecticut? Are there differences in average wages earned by students who complete credentials in different education programs? Are students working after completing a specific education program?

Clearly, the value of education extends far beyond placement into a job, yet these questions and others are important for students and education leaders alike. With information about recent outcomes of their peers, students can make informed decisions about their own education pathways. Similarly, educators can use this information to evaluate and improve local education programs. Yet there are limits to these data. Users must not draw conclusions about the quality of any specific education program or institution based upon these short term views. For a complete summary of the underlying limitations of the data and high level findings, please read the Summary Report (pdf)

Instructions

There are two sets of interactive dashboards below. The first set includes 7 distinct dashboards with wage and employment data by institution, degree type and academic program. The second set contains 5 separate dashboards with demographic data. Within each set, use the tabs at the top to navigate between dashboards. Focus your view by selecting options from the drop down menus at the top for: academic year, institution, degree level, education program, and/or demographic category.

Important Notes

  • Data are aggregated so that information for any group of students smaller than 6 as well as the next larger group size have been suppressed. The total counts of credentials earned includes everyone, but when data are viewed at a lower level of granularity (e.g. by education program), data for some groups of students are not available. This has been done to preserve student privacy.
  • Credentials not graduates: Some individuals represented in these data have completed multiple credentials, therefore the count of graduates will be slightly different from the count of credentials earned.
  • Employment data are only for individuals who worked in Connecticut. Data about employment and earnings come from the Connecticut Department of Labor (DOL) Unemployment Insurance (UI) database, and only include individuals who are employed by organizations in Connecticut.
  • Employment data do not include everyone who is working. Employment and earnings data available in the UI database come from organizations that are required to report under unemployment insurance law. These data exclude individuals who are self-employed, all members of the Armed Forces, elected officials in most states, agricultural workers on small farms, most employees of railroads, some domestic workers, most student workers at school and employees of some types of non-profit organizations. According to DOL, UI covered jobs generally include approximately 95% of wage and salary positions in the labor market.
  • Data do not provide unemployment rates: It is not possible to calculate the number of individuals who are unemployed by subtracting the number of employed from the number of graduates. Individuals who are actively working may not be captured in this data because they are working out of state because their job is not covered by UI law, and some individuals who are not working may do so by choice in which case they would not be counted as unemployed.
  • Average Wages underestimate annual salaries: Employers give UI data to DOL by quarter without occupation, hours worked or hourly wage information; therefore, there is no way to know or estimate whether individuals worked part-time or full-time during the 3 months in any given quarter, nor can we know whether individuals worked for the full quarter or only a portion of it. The inclusion of wages for individuals who worked part-time or for only a portion of a given quarter likely lowers the overall average. For this reason and others, attempts to calculate an average annual salary based on the data as it is provided will be inaccurate.

Data Sources

Data about credentials earned were obtained from the Connecticut State Colleges and Universities System and matched to unemployment insurance data from the Connecticut Department of Labor utilizing the processes and agreements of the Connecticut Preschool through Twenty and Workforce Information Network (P20 WIN).

Overview

Opportunities for Students

To improve education and employment opportunities for students, Connecticut needs a system that links data between agencies as students progress from early childhood into jobs and careers.

Connecticut's Preschool through Twenty and Workforce Information Network (P20 WIN) provides a way for agencies to share and match data securely while protecting student, worker and employer privacy. Education and workforce leaders can then have information to make decisions for improving our students and the state.

Process FAQs Requests & Reports


How Data Are Linked (video)

How P20 Win Works

P20 WIN securely links data between education and workforce agencies in the state for the purpose of conducting audits and evaluations of publicly funded education programs.

Information available through P20 WIN, can facilitate the long term economic development of Connecticut through the improvement of education programs and workforce alignment. Moreover, P20 WIN enables responses to state and federal reporting requirements.
VIDEO: How Data Are Linked


Why Connecticut needs P20 WIN

P20 WIN provides a competitive edge in improving the utilization of public resources, and assists economic development initiatives by highlighting areas where improvements can be made. P20 WIN can link the education and workforce data to provide answers that can facilitate long term economic development through the improvement of education programs and workforce alignment.


Answering Key Questions

P20 WIN will enable Connecticut to address critical questions that can only be answered by linking data between agencies such as: What high school academic experiences are the best predictors of student's success in college or the workplace? Which indicators can be used to support students to be college and career ready? Which teacher preparation programs produce graduates who are teaching in Connecticut? Are there differences in student academic growth that suggest best practices in teacher preparation programs? Which certificates and degrees enable students to work in Connecticut? Are there significant differences in earnings? Do patterns change over time?


The Legal Framework

The Participating Agencies established a legal framework for the operation of P20 WIN that satisfies state and federal law including FERPA. With approval from the Office of the Attorney General, they developed a data governance policy that defines a multi-tier inter-agency committee structure, with roles and responsibilities for continued collaboration and decision making about data access and data use for the benefit of the State. In addition, the Participating Agencies have memoranda of agreement (MOA) that enable the linkage and matching of data while preserving individual privacy and data security. Supporting documents are at www.ct.edu/initiatives/p20win#process, and a Legislative Research Report is available at http://www.cga.ct.gov/2014/rpt/pdf/2014-R-0216.pdf.


P20 WIN is Not

P20 WIN is not a data warehouse that stores data centrally. Each Participating Agency has its own repository for its own data, and each retains management control of that data. This structure provides greater data security and lower operational cost, while the network provides the legal framework for linking and matching data repeatedly to satisfy approved data requests across agencies. By managing their own source data, Participating Agencies provide greater data security and leverage internal resources to improve data quality without the massive expense of designing, developing, maintaining an external warehouse to be managed in perpetuity by others.


Collaboration

P20 WIN is a network for the State of Connecticut supported by the voluntary collaboration and engagement of the Participating Agencies: The State Department of Education (SDE), The Board of Regents for Higher Education (BOR), the University of Connecticut (UConn), the Department of Labor (DOL) and the Connecticut Conference of Independent Colleges (CCIC). Leadership from each agency has been meeting regularly to establish this network in order to increase data interoperability for the benefit of the state.

Process

To establish P20 WIN, participating agencies executed legal agreements, developed a data governance framework to guide data sharing, and selected a technical model for implementation. With support from the Office of the Attorney General, agencies developed Memoranda of Agreement (MOA) and a data management process that enables and provides for the legal and secure linkage of education and employment data. In addition to completing the MOA, executives of the participating agencies approved a Data Governance Policy that establishes working groups and provides a mechanism for ongoing cross-agency collaboration and decision making.

The MOAs define a process for data management. Authorized representatives from participating agencies may submit an application for data to conduct an audit or evaluation of publically funded education programs. If the request is approved by the members of the P20 WIN Data Governing Board, an MOA specific to that data request will be executed, and the approved authorized representative will be able to receive matched data in order to conduct the approved audit or evaluation. The authorized representative and other designated individuals from the authorized representative's agency, who have signed Personal Statements of Non-Disclosure, will be able to work with the data to produce a report that is sufficiently aggregated for public disclosure. Once a final report has been approved by the Data Governing Board as being sufficiently aggregated to comply with privacy statutes, the aggregated results and accompanying reports may be made public.

The technical model being implemented for P20 WIN has a federated architecture. Federated data systems have a decentralized structure which allows each agency to retain administrative authority over their data. The P20 WIN federated model provides a high degree of data security for data because the system is exclusive to the participating agencies and because the data matching and data analysis processes are completed separately. The federated structure also allows for future expansion of P20 WIN possible at a significantly lower cost than is typical with a centralized warehouse model.

Data Sharing Agreements

National Resources

Historical Resources

Frequently Asked Questions

What is P20 WIN?
P20 WIN stands for the Preschool through Twenty and Workforce Information Network; where, the word 'twenty' means 'Advanced and Life-long learning'. P20 WIN is Connecticut's inter-agency network that securely links unit record data so that state agencies can audit and evaluate the effectiveness of education programs and make improvements in policies and programming to enhance student success. The participating agencies include: the Connecticut State Department of Education (CSDE), the Connecticut Board of Regents for Higher Education (BOR), the University of Connecticut (UConn), the Connecticut Department of Labor (DOL) and the Connecticut Conference of Independent Colleges (CCIC). Data are never evaluated to look at individuals; rather, patterns of aggregated data are studied to identify areas where education and workforce training may be improved in a way that uses limited fiscal resources judiciously and to maximum effect.

Why was P20 WIN created?
P20 WIN is a necessity for Connecticut for several reasons. The network is needed to enable the audit and evaluation of publically funded education programs and provide a mechanism for satisfying federal reporting requirements. P20 WIN provides information to education and workforce training leaders that can assist in improving education and workforce outcomes for Connecticut students. By analyzing the collective outcomes of students as they progress through the education system and into the workforce, it is possible to identify areas in need of improvement.

How are data linked?
P20 WIN does not utilize a central data warehouse or database. There is no inter-agency data repository that retains individual data. Rather, the inputs to the network are decentralized, stored and maintained by the source agencies themselves. Data are only linked when there is a specific audit or evaluation of publically funded education programs that has been approved and all necessary documentation and data sharing agreements have been completed in accordance with the P20 WIN Data Request Management Procedure as well as state and federal law.After an audit or evaluation has been approved and all documentation completed, data are linked through a two-step process. These two steps require separation of information needed to match records (e.g. name, date of birth) from the information needed to conduct the audit or evaluation (e.g. data from an education record or demographic data). These two types of data files are never combined and the files used to match data are destroyed once the linkage has occurred and generic group numbers and fake record numbers are in place. The process protects individual privacy by separating the data at all stages of the process, by using meaningless fake record numbers, and by destroying the data used to create the links.
Data Matching Details VIDEO: How Data Are Linked

What data elements are used to match data?
Since the state must link data to satisfy state and federal reporting requirements and to conduct audits and evaluations of education programs, some identifying data must be shared; however the specific data elements used to match data sets depend on the data sets being linked. For example, a linkage between Board of Regents and Department of Labor data is different than a linkage between the Board of Regents and the Connecticut State Department of Education (CSDE) because CSDE does not collect Social Security Numbers for K-12 students. The following elements may be used to link data between CSDE, BOR and DOL.
  • First Name
  • Last Name
  • Middle Name
  • Date of Birth
  • SSN
  • High School Code
  • State Assigned Student Identifier (SASID)


Will reports or findings developed from data linked through P20 WIN reveal information about individual students?
No. Reports generated from data linked through P20 WIN will never reveal any information about the experiences or outcomes of an individual student. No conclusions or findings or programmatic changes will ever be made based upon the information of an individual. Before any data are made public from an audit or evaluation, the P20 WIN Data Governing Board members whose data are included review and verify that the data are aggregated sufficiently so that individual identities cannot be determined from the data set. Data are modified by rounding, use of ranges, aggregation of groups and/or elimination of small cell sizes for maximum security as recommended by the U.S. Department of Education in their Technical Brief: Statistical Methods for Protecting Personally Identifiable Information in Aggregate Reporting http://nces.ed.gov/pubs2011/2011603.pdf.

Where are final aggregated P20 WIN reports located?
After specific audits and evaluations are completed and data are sufficiently aggregated so that no individuals can be identified, publically releasable reports will be located at P20 WIN site and may also be at the CT Open Data Portal managed by the Governor's office.

What data fields are in P20 WIN?
P20 WIN is not a data warehouse; therefore, no data about any individuals are retained anywhere outside of Participating Agencies source data systems. However, a downloadable list of data elements that could be used in an audit or evaluation of publically funded education programs may be found at the P20 WIN Data Dictionary - Searchable Online Version.

Can state agencies share data without the consent of the parent or individual?
Yes; however, the Family Education Rights and Privacy Act (FERPA) allows State and Local Education Authorities or Agencies to disclose student records without consent only under specific conditions. (34 CFR 99.31). One of these conditions allows for data to be disclosed to Authorized Representatives for the purpose of conducting an audit or evaluation of education programs that receive state or federal funding. P20 WIN was designed to enable the state to conduct audits and evaluations of publically funded education programs; therefore, this exception enables the disclosure of education records for that purpose.

Systems like P20 WIN enable Connecticut to evaluate effectiveness of education programs in preparing students for current and future success. It is incumbent upon the state agencies to ensure that state tax dollars are used effectively, so being able to audit and evaluate publically funded education programs is an essential state function.

In 2011, United States Department of Education revised the regulations for the Family Education Rights Privacy Act (FERPA) to both clarify and strengthen the implementation of this law. While data may be shared without consent for the purpose of conducting an audit or evaluation, the law also requires that a written agreement be established between the Local or State Education Authority and the Authorized Representative. This agreement must include specific terms, and there are penalties if these terms are not upheld. The requirements for the written agreement include protections such as: a) identification of the purpose for which the data are to be shared, b) restriction against using the data for any other purpose or re-disclosing the data to someone else, c) destruction of data when no longer needed for the designated purpose and d) designation of date by which the data destruction will occur.

How long are student records kept on individuals?
Information identifying individuals such as name or date of birth (DOB) are not retained beyond the time that it takes to conduct a match between data sets. Before analysis, student records are stripped of the same identifying information (e.g. name, DOB). The redacted student record containing education information is retained only for the duration of the analysis as approved and specified in the Data Sharing Agreement that governs the specific audit or evaluation. The standard time period for an evaluation is typically one year.

With whom are data shared?
Data are only disclosed to Authorized Representatives of state and local education agencies as limited by the Family Education Rights and Privacy Act (FERPA), 45 CRF 99.35(a)(1). A data sharing agreement called a Memorandum of Agreement (MOA) is established to designate the Authorized Representative and defines the duties and responsibilities of the Authorized Representative to protect the data from further disclosure.

A rigid procedure has been developed for P20 WIN which provides a process for the creation of a data request and the designation of an Authorized Representative. This procedure includes review and approval by members of the P20 WIN Data Governing Board so that only audits and evaluations that are of benefit to the Local or State Education Authority may be approved.

How will families know when student data is a part of a data request?
When a data request is approved for an audit or evaluation and the data is to be linked through P20 WIN, the information about that data request will be posted at: http://www.ct.edu/initiatives/p20win#process under the section titled Data Request Documents. Given that identifying information about individuals in these data requests is not available to anyone working on the combined data, it is not feasible to notify individuals or families directly.

Who developed the data sharing agreements and policies that support P20 WIN?
The process of developing each policy, procedure and data sharing agreement that supports P20 WIN has been deliberate and careful to ensure that student privacy is maintained and all state and federal laws are upheld. Initial drafts were developed by the P20 WIN Data Governing Board with significant input and oversight from agency attorneys as well as the Connecticut Attorney General's Office, and final versions were approved by all attorneys and the P20 WIN Executive Board. In addition, the Directors from two US Department of Education departments, the Family Policy Compliance Office (FPCO) and the Privacy Technical Assistance Center (PTAC) were engaged to ensure that P20 WIN processes and required data sharing agreements are fully compliant with the Family Educational Rights and Privacy Act (FERPA).

Who is the contact person for further information?
If you have questions or concerns about the P20 WIN system, you may contact the P20 WIN Manager. The BOR has been designated as the Administrative Lead Agency for the P20 WIN Participating Agencies to facilitate administration and operation of the network.
    Jan Kiehne, P20 WIN Program Manager
    Institutional Research Specialist
    Office of Policy, Research & Strategic Planning
    Connecticut Board of Regents for Higher Education
    39 Woodland BOR
    Hartford, CT 06105-2326
    860-723-0236
    kiehnej@ct.edu

Requests & Reports

Data Request Documents

Each data request requires substantial documentation and the execution of a data sharing agreement before any personally identifiable data can be shared or linked. Refer to the P20 WIN Data Request Management Procedure (pdf) for a description of the process for requesting data and descriptions of the required documentation. Links in this section provide the official data sharing documents that support data requests approved by the P20 WIN Data Governing Board.

Data Request 0003

Employment & Average Wage Data by Institution and Program - Community Colleges, State Universities & Charter Oak State College

Required Forms & Data Sharing Agreement
Public Report
Interpretation of the Employment and Average Wage data in these reports requires a solid understanding about the data points counted and averaged at the different points of time. It is strongly recommended, that anyone interested in these data read the Summary Report carefully before using these data for additional analysis or to draw conclusions that go beyond those articulated in the Summary Report itself.

Data Request 0004

Employment and Wage Metrics Requested for Legislative Review of Certificates

Required Forms & Data Sharing Agreement
Public Report
The metrics provided by P20 WIN to the Connecticut Legislative Program and Investigation (PRI) Committee were requested by the Legislative Program Review and Investigation Committee to evaluate the production of certificates by post-secondary institutions in Connecticut. This study included certificates produced by public, private, non-profit and for-profit higher education institutions.
Learn More

Data Request 0006

Postsecondary Employment & Wage Outcomes for Legislative Report Card

Required Forms & Data Sharing Agreement
Public Report
It is strongly recommended that anyone interested in these data read the Summary Report carefully before using the data points in the Employment and Wage reports. The Summary Report contains important definitions and context for the data that are critical for accurate usage. Note, that the data within each table are provided by system (Connecticut State Colleges and Universities), by sector (Connecticut State Universities, Connecticut Community Colleges, and Charter Oak State Colleges) as well as by every individual institution for each of the cohort years 2009-2010 through 2013-2014. If you have questions, contact Jan Kiehne, P20 WIN Program Manager, at kiehnej@ct.edu.

Data Request 0007

College Enrollment, Remediation & Credit Attainment for Public High School Graduation Cohort of 2011

Data Request 0008

Postsecondary Employment & Wage Outcomes for CCIC

P20 WIN Data Dictionary

The Data Dictionary contains elements that are a part of P20 WIN as of the pilot phase of system implementation. It is expected that the Participating Agencies will add additional elements as they become available.

Contact

If you have questions or concerns about the P20 WIN system, you may contact the P20 WIN Manager. The BOR has been designated as the Administrative Lead Agency for the P20 WIN Participating Agencies to facilitate administration and operation of the network.

Jan Kiehne
P20 WIN Program Manager
860-723-0236
kiehnej@ct.edu

Connecticut Board of Regents for Higher Education
39 Woodland BOR
Hartford, CT 06105-2326

Continue Exploring P20 WIN