Download
1 / 57

Analyzing and Mapping Census and Student Data - PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on

Analyzing and Mapping Census and Student Data . 2006 PNAIRP Conference Welches, OR. Acknowledgements.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Analyzing and Mapping Census and Student Data ' - tania


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Analyzing and mapping census and student data

Analyzing and Mapping Census and Student Data

2006 PNAIRP Conference

Welches, OR


Acknowledgements
Acknowledgements

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


Presenters
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


Workshop topics
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



A census based proxy for student socioeconomic status and income
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




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


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



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?”


Additional information
Additional information magnified by colleges, raising the question, “

  • 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 structure
Data Structure magnified by colleges, raising the question, “

  • Relational Database (MS Access)

    • SBCTC Data Warehouse & Census Data tables

  • Spatial Data

    • GIS


Gis quick intro
GIS – Quick Intro magnified by colleges, raising the question, “

  • GIS = Geographic Information System

  • Useful for:

    • Visualizing distribution

    • Spatial analysis

  • Types of Data:

    • Point (students @ home addresses)

    • Line (roads, rivers)

    • Polygon (block groups, lakes, cities)

    • Raster (hillshade, aerial photo)


Gis quick intro1
GIS – Quick Intro magnified by colleges, raising the question, “

  • GIS = Geographic Information System

  • Useful for:

    • Visualizing distribution

    • Spatial analysis

  • Types of Data:

    • Point (students @ home addresses)

    • Line (roads, rivers)

    • Polygon (block groups, lakes, cities)

    • Raster (hillshade, aerial photo)


Gis quick intro2
GIS – Quick Intro magnified by colleges, raising the question, “

  • GIS = Geographic Information System

  • Useful for:

    • Visualizing distribution

    • Spatial analysis

  • Types of Data:

    • Point (students @ home addresses)

    • Line (roads, rivers)

    • Polygon (block groups, lakes, cities)

    • Raster (hillshade, aerial photo)


Gis quick intro3
GIS – Quick Intro magnified by colleges, raising the question, “

  • GIS = Geographic Information System

  • Useful for:

    • Visualizing distribution

    • Spatial analysis

  • Types of Data:

    • Point (students @ home addresses)

    • Line (roads, rivers)

    • Polygon (block groups, lakes, cities)

    • Raster (hillshade, aerial photo)


Gis quick intro4
GIS – Quick Intro magnified by colleges, raising the question, “

  • GIS = Geographic Information System

  • Useful for:

    • Visualizing distribution

    • Spatial analysis

  • Types of Data:

    • Point (students @ home addresses)

    • Line (roads, rivers)

    • Polygon (block groups, lakes, cities)

    • Raster (hillshade, aerial photo)


Spatial data raster
Spatial Data – Raster magnified by colleges, raising the question, “


Database example contents

DW – Student Data magnified by colleges, raising the question, “

Family Status

Fund Source

Ed background

Ethnic

Program

Intent

Census – Population Data

Demographic

Ed background

Ethnic

SES

Med HH Income / Ethnic

Employment

Database – Example Contents


Database placing students in block groups
Database – magnified by colleges, raising the question, “Placing Students in Block Groups

DW Address: 234 Main St,

Bellingham 98225

Student

on Map

GIS

BG # on Student Record

BG# 530730009003


Database adding student data to block groups
Database – magnified by colleges, raising the question, “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


Applications
Applications magnified by colleges, raising the question, “


Sample questions demographics of our population
Sample Questions – Demographics of our Population magnified by colleges, raising the question, “

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


Sample questions demographics of our population1
Sample Questions – Demographics of our Population magnified by colleges, raising the question, “

2000 SVC Students whose HHIN was less than $20,000: 4.4%


Sample questions demographics of our population2
Sample Questions – Demographics of our Population magnified by colleges, raising the question, “

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


Sample questions demographics of our population3
Sample Questions – Demographics of our Population magnified by colleges, raising the question, “

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


Hispanic svc students household income
Hispanic SVC Students' Household Income magnified by colleges, raising the question, “

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


Sample questions serving our minority population
Sample Questions – Serving Our Minority Population magnified by colleges, raising the question, “

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


Sample questions serving our minority population1
Sample Questions – Serving Our Minority Population magnified by colleges, raising the question, “

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


Sample questions serving our minority population2

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

Sample Questions – Serving Our Minority Population

SBCTC Data 1993 & 2001

  • One ethnic code field

  • Choosing “Hispanic” precludes choosing another option


Sample questions serving our minority population3
Sample Questions – Serving Our Minority Population race codes. Future data sets should match.

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


Sample questions improving our marketing efforts
Sample Questions – Improving our Marketing Efforts race codes. Future data sets should match.

  • 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 Associate’s Degree?

  • What percent of the population attends a community or technical college?


Sample questions improving our marketing efforts1
Sample Questions – Improving our Marketing Efforts race codes. Future data sets should match.

  • 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 Associate’s Degree?

  • What percent of the population attends a community or technical college?


Sample questions improving our marketing efforts2
Sample Questions – Improving our Marketing Efforts race codes. Future data sets should match.

  • 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 Associate’s Degree?

  • What percent of the population attends a community or technical college?


What will the colleges get
What will the colleges get? race codes. Future data sets should match.

  • Access Database

  • Statewide Map Images

  • Maps that can be displayed on Google Earth


How can you use this data
How can you use this data? race codes. Future data sets should match.

  • 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


Google earth
Google Earth race codes. Future data sets should match.

  • 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


Questions
Questions race codes. Future data sets should match.

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


ad