Photo by: Jeff Miller
Precollege Pipeline Data
To identify Student of Color (SOC) populations in the Wisconsin Precollege Pipeline by:
- Wisconsin school district
- gender showing percentages
- Identify districts and schools with high concentrations of SOC
- Identify next generation students in the precollege pipeline
- Track student demography as they progress from elementary school into middle school and high school
Identifying and tracking SOC in the Pipeline will better inform which districts/schools have substantial student populations in the UW System target area. There are many pockets of SOC in Wisconsin that may have been overlooked because no one would have imagined these populations exist in these numbers and in these areas of the state.
- Long-range planning:
The Precollege Pipeline Source Data informs better planning strategies for targeting SOC.
The ability to identify SOC in their sophomore and junior years will better inform
future recruitment efforts, possibly in areas not targeted before.
Following are the data sets developed from the DPI report "Public Enrollment by District by School by Ethnicity (PESE) 2006-07." All files are presented in an Excel spreadsheet format.
The files are protected on the EDI web site so you must download the files before data manipulation can occur.
Once you have downloaded the file, make a working copy and rename the file so the original data set is secure.
Precollege Pipeline Source Data 2006-07
Listed below are data sets developed from this effort which illustrate the types of reports that can be generated from the Precollege Pipeline Source Data file to fit your specific needs.
The Precollege Pipeline Source Data 2006-07 file was used to create all the examples presented below. For consistency this file should be used for all queries.
- Precollege Pipeline Data: District Totals SOC Percentages 2006-07
This data reflects the demography of Students of Color (SOC) enrolled in all Wisconsin DPI school districts. The data is sorted by Wisconsin county, school district, district totals SOC, district totals white, all districts total, all district percentages SOC.
- Precollege Pipeline Data: 15 to 100 Percent SOC 2006-07
To identify Wisconsin districts having SOC enrollment between 15% - 100% of the total district student population. This data is sorted by districts, showing schools within each district, sorted by grade with ethnicity and gender totals and percentages within each grade.
- Precollege Pipeline Data: 0 to 14 Percent SOC 2006-07
To identify Wisconsin districts having SOC enrollment from 0% to 14% of the total district student population. This data is sorted by district showing schools within each district, sorted by grade with ethnicity and gender totals and percentages within each grade.
Precollege Pipeline Data Field Descriptions
This document explains the field definitions and code definitions in the Precollege Pipeline Source Data file as provided by DPI. These definitions can be found at the bottom of the spreadsheet labeled:
- Data Changes
- Pem07 (Precollege Pipeline Source Data)
- Data Abbreviations
- Locale Code Definitions
WEASSP Pipeline Data Presentation 12-12-07
This data was presented at the WEASSP Conference MDC/PCD Joint meeting in Lake Geneva on Dec. 12, 2007. This presentation further illustrates the types of information which can be extracted from the Precollege Pipeline Source Data file.
Related Web Sites
Precollege Pipeline School District Data Mapping Project
along with these instructions:
Using the School District Data Mapping Site (pdf)
This data was developed using the Precollege Pipeline Source Data file and GPS technology by the Applied Population Lab (APL) UW Madison/Extension, providing a state view of Wisconsin school districts and giving district percentages of Student of Color populations in the Precollege Pipeline. Once a district of interest has been identified, the Precollege Pipeline Source Data file can be cross referenced to provide statistical information for the individual schools within the selected district, showing grade, ethnicity, and gender.
Applied Population Laboratory Fall 2007 Report:
Wisconsin’s Public School Enrollment: Past, Present, Future
Wisconsin High School Graduate Projections March 13, 2008
These reports, used in combination with the Precollege Pipeline Data and the Precollege Pipeline Data Mapping Project, will help inform future planning/recruitment decisions pertaining to SOC population growth in the state.
OADD will continually update the Precollege Pipeline Data web site as needed.
Questions or suggestions regarding any aspect of the Precollege Pipeline Data web site should be directed to Jerry Roberts (608-890-1894 or firstname.lastname@example.org).