Analyzing and Mapping Census and Student Data

1
(No Transcript)
2
Analyzing and Mapping Census and Student Data

• 2006 PNAIRP Conference
• Welches, OR

3
Acknowledgements

• The State Board for Community Colleges wishes to
  thank the Ford Foundations Bridges to
  Opportunity Program and the Washington State
  College Spark Foundation for their support for
  this project.

4
Presenters

• David Prince, State Board for Community
  Technical Colleges
• Beth Hartsoch, Research Information Analyst,
  Skagit Valley College
• Maureen Pettitt, Director Institutional Research,
  Skagit Valley College

5
Workshop Topics

• Project Background
• Data Structure
• Applications
• Statewide
• College SVC Example
• Sample Questions
• Next Steps
• What will colleges get?
• How can you use the data?
• Q A

6
Project Background
7
A Census Based Proxy for Student Socioeconomic
Status and Income

• Based on census data for income, education (BA or
  higher) and occupation (professional/managerial)
• Student address matched to census
• Student assigned median household income and SES
  for area mapped

8
Washington State Socioeconomic Status Quintiles
1990 and 2000
Washington State SES 1990 Household Income (1999) Adults with BA degree or higher Persons employed professional Total State Population
Highest 61,615 45 44 20
Higher 46,581 26 31 23
Middle 39,865 18 24 22
Lower 34,088 12 18 19
Lowest 24,444 7 12 17

Washington State SES 2000 Household Income (1999) Adults with BA degree or higher Persons employed professional Total State Population
Highest 74,707 54 55 19
Higher 55,625 34 40 20
Middle 47,437 23 33 20
Lower 39,925 16 26 21
Lowest 29,515 10 18 20
9
Race still matters
10
State population- more than ever before our
future adults are being born and raised in low
SES households.
11
Participation rates measure how close the
resemblance is between state population and CTC
students

• Part Rate of students state population
• Part Rate less than 1 less than population
• Part Rate 1 Parity
• Part Rate greater than 1 more than population

12
Participation for Younger and Older Students by
SES Quintiles - 2000
Lowest Lower Middle Higher Highest
CTC Students (18-24 Yrs) .8 .85 1.03 1.14 1.35
CTC Students (25 ) 1.21 1.05 .99 .96 .75
13
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?
14
Additional information

• For the full research report Socioeconomic
  Well-Being of Washington State Who Attends
  Community and Technical Colleges (Sept 2006) link
  to
• http//www.sbctc.ctc.edu/data/rsrchrpts/resh_06-4
  .doc

15
(No Transcript)
16
Data Structure

• Relational Database (MS Access)
• SBCTC Data Warehouse Census Data tables
• Spatial Data
• GIS

17
GIS Quick Intro

• GIS Geographic Information System
• Useful for
• Visualizing distribution
• Spatial analysis
• Types of Data
• Point (students _at_ home addresses)
• Line (roads, rivers)
• Polygon (block groups, lakes, cities)
• Raster (hillshade, aerial photo)

18
GIS Quick Intro

• GIS Geographic Information System
• Useful for
• Visualizing distribution
• Spatial analysis
• Types of Data
• Point (students _at_ home addresses)
• Line (roads, rivers)
• Polygon (block groups, lakes, cities)
• Raster (hillshade, aerial photo)

19
(No Transcript)
20
GIS Quick Intro

• GIS Geographic Information System
• Useful for
• Visualizing distribution
• Spatial analysis
• Types of Data
• Point (students _at_ home addresses)
• Line (roads, rivers)
• Polygon (block groups, lakes, cities)
• Raster (hillshade, aerial photo)

21
(No Transcript)
22
GIS Quick Intro

• GIS Geographic Information System
• Useful for
• Visualizing distribution
• Spatial analysis
• Types of Data
• Point (students _at_ home addresses)
• Line (roads, rivers)
• Polygon (block groups, lakes, cities)
• Raster (hillshade, aerial photo)

23
(No Transcript)
24
GIS Quick Intro

• GIS Geographic Information System
• Useful for
• Visualizing distribution
• Spatial analysis
• Types of Data
• Point (students _at_ home addresses)
• Line (roads, rivers)
• Polygon (block groups, lakes, cities)
• Raster (hillshade, aerial photo)

25
Spatial Data Raster
26
Database Example Contents

• DW Student Data
• Family Status
• Fund Source
• Ed background
• Ethnic
• Program
• Intent

• Census Population Data
• Demographic
• Ed background
• Ethnic
• SES
• Med HH Income / Ethnic
• Employment

27
Database Placing Students in Block Groups
DW Address 234 Main St, Bellingham 98225
Student on Map
GIS
BG on Student Record
BG 530730009003
28
Database Adding Student Data to Block Groups
Student data is aggregated for each block group
and can be joined to the block group data by
block group number
BG 530730009003

• BG 530730009003
• Students 218
• Hispanic Students 5.4
• Transfer Students 59

BG 530730009003
BG 530730009003
29
Applications
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
Sample Questions Demographics of our Population

• What percent of our students household income is
  below 20,000 for a grant application?
• How has the SES of our district changed between
  census dates?
• What is the median household income of Hispanic
  students in our district?

35
Sample Questions Demographics of our Population

• 2000 SVC Students whose HHIN was less than
  20,000 4.4

36
Sample Questions Demographics of our Population

• What percent of our students household income is
  below 20,000 for a grant application?
• How has the SES of our district changed between
  census dates?
• What is the median household income of Hispanic
  students in our district?

37
(No Transcript)
38
Sample Questions Demographics of our Population

• What percent of our students household income is
  below 20,000 for a grant application?
• How has the SES of our district changed between
  census dates?
• What is the median household income of Hispanic
  students in our district?

39
(No Transcript)
40
Hispanic SVC Students' Household Income
Based on Median Household Income Census data
for the Hispanic population of the block group.
N 1,414
Mean 31,782
Median 31,500
Std. Deviation Std. Deviation 18,196
Quartiles 25 27,012
50 31,500
75 37,273
41
Sample Questions Serving Our Minority Population

• Where are minority groups concentrated within our
  district?
• Where are these groups underrepresented in the
  student population?
• Should we extend our ESL program to a remote
  location?

42
(No Transcript)
43
Sample Questions Serving Our Minority Population

• Where are minority groups concentrated within our
  district?
• Where are these groups underrepresented in the
  student population?
• Should we extend our ESL program to a remote
  location?

44
Sample Questions Serving Our Minority Population

• 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 code

• SBCTC Data 1993 2001
• One ethnic code field
• Choosing Hispanic precludes choosing another
  option

45
Sample Questions Serving Our Minority Population

• Where are minority groups concentrated within our
  district?
• Where are these groups underrepresented in the
  student population?
• Should we extend our ESL program to a remote
  location?

46
(No Transcript)
47
Sample Questions Improving our Marketing Efforts

• What percent of the population is between 18 and
  25 years of age?
• What is the geographic distribution of the
  population older than 25 years who have less than
  an Associates Degree?
• What percent of the population attends a
  community or technical college?

48
(No Transcript)
49
Sample Questions Improving our Marketing Efforts

• What percent of the population is between 18 and
  25 years of age?
• What is the geographic distribution of the
  population older than 25 years who have less than
  an Associates Degree?
• What percent of the population attends a
  community or technical college?

50
(No Transcript)
51
Sample Questions Improving our Marketing Efforts

• What percent of the population is between 18 and
  25 years of age?
• What is the geographic distribution of the
  population older than 25 years who have less than
  an Associates Degree?
• What percent of the population attends a
  community or technical college?

52
(No Transcript)
53
What will the colleges get?

• Access Database
• Statewide Map Images
• Maps that can be displayed on Google Earth

54
How can you use this data?

• Google Earth
• Free software (with upgrade options)
• http//earth.google.com
• View data provided by SBCTC
• GIS Software
• Data compatible with ESRI GIS ArcGIS
• SBCTC ArcGIS license

55
Google Earth

• Interactive mapping product of Google
• License levels
• Free view data
• 20 Upgrade speed, high res printing,
  annotation
• 400 Upgrade more speed, import spreadsheets,
  measurement tools
• View data from this project, provided as .kml
  files by SBCTC
• See handout Using Google Earth for more

56
(No Transcript)
57
Questions

• What questions do you have about the data?
• What limitations are there for proxy SES and
  income data?
• How do you think your college might use this
  information?