Analyzing and Mapping Analyzing and Mapping

Census and Student DataCensus and Student Data

2007 Innovations Conference2007 Innovations Conference

New Orleans New Orleans

March 6, 2007March 6, 2007

AcknowledgementsAcknowledgements

The State Board for Community and Technical Colleges wishes to thank the Ford Foundation’s Bridges to Opportunity Initiative and the Washington State College Spark Foundation for their support for this project.

PresentersPresenters

Tina Bloomer, Director, Student Achievement Projects, Washington State Board for Community & Technical Colleges

Maureen Pettitt, Director of Institutional Research, Skagit Valley College

Essential contributions to this presentation by Beth Hartsoch (Skagit Valley College) and David Prince (Washington SBCTC)

Presentation TopicsPresentation Topics

Project Background Washington State Board for Community &

Technical Colleges Data Structure College-Level Applications

Student Demographics Minority Populations Marketing

Q & A

Project Project BackgroundBackground

A Census-Based Proxy for Student A Census-Based Proxy for Student Socioeconomic Status and IncomeSocioeconomic 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

Washington State Socioeconomic Status Washington State Socioeconomic Status Quintiles 1990 and 2000Quintiles 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%

Race still mattersRace still matters

S t a t e P o p u l a t i o n - R a c e a n d E t h n i c i t y b y S E S Q u i n t i l e s - 2 0 0 0

L a t / H i s p 4 7 % 2 1 % 1 4 % 1 1 % 7 %

N a A m 3 8 % 2 8 % 1 7 % 1 1 % 6 %

A f r A m 3 3 % 2 0 % 2 1 % 1 6 % 1 0 %

W h 1 7 % 2 1 % 2 1 % 2 1 % 2 0 %

A s / P a c 1 7 % 1 7 % 2 0 % 2 2 % 2 3 %

L o w e s t L o w e r M i d d l e H i g h e r H i g h e s t

State population- State population- more than ever before our more than ever before our future adults are being born and raised in future adults are being born and raised in low SES households.low SES households.

P o p u l a t i o n : C h i l d r e n 1 7 Y r s a n d Y o u n g e r b y S E S Q u i n t i l e s

1 9 9 0

H i g h e s t 1 8 % 1 9 % 1 9 % 2 0 %

H i g h e r 2 1 % 2 2 % 2 2 % 2 2 %

M i d d l e 2 1 % 2 2 % 2 2 % 2 2 %

L o w e r 2 0 % 1 9 % 2 0 % 1 9 %

L o w e s t 2 0 % 1 8 % 1 7 % 1 7 %

U n d e r 5 5 - 9 Y r s1 0 - 1 3

Y r s1 4 - 1 7

Y r s

P o p u l a t i o n : C h i l d r e n 1 7 Y r s a n d Y o u n g e r b y S E S Q u i n t i l e s

2 0 0 0

H i g h e s t 1 6 % 1 7 % 1 8 % 1 8 %

H i g h e r 1 8 % 1 9 % 1 9 % 2 0 %

M i d d l e 1 9 % 2 0 % 2 1 % 2 1 %

L o w e r 2 1 % 2 1 % 2 1 % 2 1 %

L o w e s t 2 6 % 2 3 % 2 1 % 2 0 %

U n d e r 5 5 - 9 Y r s1 0 - 1 3

Y r s1 4 - 1 7

Y r s

Participation rates measure how close the Participation rates measure how close the resemblance is between state population resemblance is between state population and CTC studentsand 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

Participation for Younger and Older Students Participation for Younger and Older Students by SES Quintiles - 2000by SES Quintiles - 2000

Lowest Lower Middle Higher Highest

CTC Students (18-24 Yrs)

.8 .86 1.05 1.14 1.35

CTC Students (25 +)

1.21 1.05 .99 .96 .75

Students socioeconomic differences become even Students socioeconomic differences become even more magnified by colleges, raising the question: more magnified by colleges, raising the question: ““How best can the system support colleges so How best can the system support colleges so varied in student body and community make-up?varied in student body and community make-up?””

L o w e s t L o w e r M i d d l e H i g h e r H i g h e s t

Additional InformationAdditional 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

Data Data StructureStructure

Data StructureData Structure

Relational Database (MS Access)SBCTC Data Warehouse

(student data)Census Data Tables

(population data) Spatial Data

GIS

GIS – Quick IntroGIS – Quick Intro

GIS = Geographic Information System Useful for:

Visualizing distribution Spatial analysis

Types of Data:1. Point (students @ home addresses)2. Line (roads, rivers)3. Polygon (block groups, lakes, cities)4. Raster (hillshade, aerial photo)

Spatial Data – RasterSpatial Data – Raster

Database – Database – Examples of VariablesExamples of Variables

DW – Student Data Family status Fund source Ed background Ethnicity Program Intent

Census – Population Data Demographic Ed background Ethnicity SES Median household

income/ethnicity Employment

Database – Database – Placing Students in Block Placing Students in Block GroupsGroups

GIS

BG# 530730009003

DW Address: 234 Main St, Bellingham 98225

Student on Map

BG # on Student Record

Database – Database – Adding Student Data to Adding Student Data to Block GroupsBlock Groups

BG# 530730009003

BG# 530730009003

BG# 530730009003

Student data is aggregated for each block group and can be joined to the block group data by block group number

BG# 530730009003•Students: 218•% Hispanic Students: 5.4%•# Transfer Students: 59

Applications: Applications: SES of Students SES of Students

attending Washington attending Washington State Community & State Community & Technical CollegesTechnical Colleges

Applications: Applications: Demographics of Demographics of

Students attending Students attending Skagit Valley CollegeSkagit Valley College

1. Where do our students come 1. Where do our students come from?from?

2. How has the SES of our district 2. How has the SES of our district changed between census dates? changed between census dates?

Applications: Applications: Serving our Minority Serving our Minority

PopulationPopulation

1. What is the median household income 1. What is the median household income of Hispanic students in our district?of Hispanic students in our district?

2. Where are minority groups 2. Where are minority groups concentrated within our district? concentrated within our district?

3. Should we extend our ESL program to 3. Should we extend our ESL program to a remote location?a remote location?

Hispanic SVC Students' Household Hispanic SVC Students' Household IncomeIncome

N 1,414

Mean $31,782

Median $31,500

Std. Deviation $18,196

Quartiles 25% $27,012

50% $31,500

75% $37,273

Based on Median Household Income Census data for the Hispanic population of the block group.

Applications: Applications: Improving our Improving our

Enrollment/Marketing Enrollment/Marketing EffortsEfforts

1.1. What percent of the population is between What percent of the population is between 18 and 25 years of age?18 and 25 years of age?

2. 2. What is the geographic distribution of the What is the geographic distribution of the population older than 25 years who have population older than 25 years who have less than an Associate’s Degree?less than an Associate’s Degree?

3. What percent of the district population 3. What percent of the district population attends a community or technical college? attends a community or technical college?

Available to WA Community CollegesAvailable to WA Community Colleges

Access Database Statewide Map Images

Provided as *.kml files by SBCTC Maps can be displayed on Google Earth

Free software (upgrade options for additional $$) at http://earth.google.com

SBCTC has ArcGIS software available

Thanks for joining us…Thanks for joining us…

Questions??