Analyzing and Mapping Census and Student Data . 2006 PNAIRP Conference Welches, OR. Acknowledgements.
2006 PNAIRP Conference
Students socioeconomic differences become even more magnified by colleges, raising the question, “How best can system support colleges so varied in student body and community make-up?”
DW – Student Data magnified by colleges, raising the question, “
Census – Population Data
Med HH Income / Ethnic
EmploymentDatabase – Example Contents
DW Address: 234 Main St,
BG # on Student Record
Student data is aggregated for each
block group and can be joined to the
block group data by block group number
2000 SVC Students whose HHIN was less than $20,000: 4.4%
* Based on Median Household Income Census data for the Hispanic population of the block group.
Familiar Problem: Conflicting methods of tracking ethnic vs. race codes. Future data sets should match.
Census Data 1990 & 2000
Separate ethnic and race code fields
Can choose “Hispanic” as well as a race codeSample Questions – Serving Our Minority Population
SBCTC Data 1993 & 2001