Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Geocomputation for Widening Participation in Higher Education

alexsingleton
December 02, 2009

Geocomputation for Widening Participation in Higher Education

Geocomputation 2009, UNSW - Sydney, 2nd Dec.

alexsingleton

December 02, 2009
Tweet

More Decks by alexsingleton

Other Decks in Education

Transcript

  1. GEOCOMPUTATION FOR WIDENING PARTICIPATION IN HIGHER EDUCATION Alex Singleton Paul

    Longley Oliver O'Brien Department of Geography and Centre for Advance Spatial Analysis , University College London
  2. 0 50000 100000 150000 200000 250000 300000 350000 400000 1962

    1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 THE HE PROBLEM: ACCEPTANCES 1962 - 2003
  3. 0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

    100% 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 Professional & Technical Administrators & Managers Clerical & Armed Forces Manual OCCUPATIONAL GROUP: 1968-1978
  4. 0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

    100% 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 V Unskilled IV Partly Skilled IIIN Skilled non- Manual IIIM Skilled Manual II Intermediate I Professional SOCIAL CLASS: 1980 - 2001
  5. 0% 10% 20% 30% 40% 50% 60% 70% 80% 90%

    100% 2002 2003 2004 2005 2006 2007 Higher managerial and professional occupations Lower managerial and professional occupations Intermediate occupations Small employers and own account workers Lower supervisory and technical occupations Semi-routine occupations Routine occupations SOCIO-ECONOMIC GROUP: 2002 - 2007
  6. WIDENING PARTICIPATION • Government have set 50% participation target •

    Standard fees - ~£1500 • Topup fees - Up to a cap of ~£3000 • Can only be charged if university signs “access agreement” - States how the money will be used to “widen participation” • University performance indicators (State School Students, NS-SEC, Neighbourhood) • WP Funding - POLAR
  7. PROBLEM • How to reach those students who are unlikely

    to attend HE? • University recruitment often un-systematic • lack spatial decision support tools • What data are available? • LOTS!
  8. SOLUTION • Give stakeholders of HE better access to data!

    • Simple to use • Simple to use • Simple to use • Simple to use • Simple to use! • Data • Record for every state school pupils in England • Spatial reference • Attainment / demographic attributes
  9. REVISED CARTOGRAPHY / DISPLAY Google Maps OpenStreetMap Google’s Terrain Layer

    Hillshading + Network London Profiler Schools Atlas
  10. CONTEXTUAL DATA • Spatial Location - profile of schools •

    Geodemographics • Deprivation classification • POLAR • Model school catchments
  11. OpenStreetMap (via Cloudmade) great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql

    NASA’s SRTM DEMs GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB PublicProfiler Schools Atlas DCSF.gov.uk EduBase and IDACI OpenLayers (.js) HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading AJAX Requests OSM Tiles PVCs (.kml) OAC R ArcGIS Google Chart API Tiles Chart Cache Architecture Diagram
  12. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql Mapnik OSM Tiling

    Script (.py) Stylesheets(.xml) OpenStreetMap (via Cloudmade) Shapefiles Tiles PublicProfiler Schools Atlas Network Layer
  13. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools Mapnik OSM Tiling Script (.py) Stylesheets(.xml) PerryGeo Hillshading Shapefiles Hillshading Layer PublicProfiler Schools Atlas Tiles OpenStreetMap (via Cloudmade)
  14. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading PublicProfiler Schools Atlas Choropleth Layers Tiles OpenStreetMap (via Cloudmade)
  15. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading OAC School Statistics PublicProfiler Schools Atlas Tiles OpenStreetMap (via Cloudmade)
  16. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading PVCs (.kml) OAC R ArcGIS School Catchment Areas PublicProfiler Schools Atlas Tiles OpenStreetMap (via Cloudmade)
  17. KDE / PVC Run: bandwidth 200 - 2000m Until: Single

    polygon Else: Reduce confidence 10% Run: bandwidth 200 - 2000m Until: Single polygon
  18. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading PVCs (.kml) OAC R ArcGIS Serving Tiles PublicProfiler Schools Atlas Tiles OpenLayers (.js) OpenStreetMap (via Cloudmade)
  19. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading PVCs (.kml) OAC R ArcGIS Other Tile Sources PublicProfiler Schools Atlas Tiles OSM Tiles OpenLayers (.js) OpenStreetMap (via Cloudmade)
  20. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading AJAX Requests PVCs (.kml) OAC R ArcGIS Google Chart API Chart Cache PublicProfiler Schools Atlas Tiles OSM Tiles OpenLayers (.js) Showing the Statistics OpenStreetMap (via Cloudmade)
  21. great_britain.osm (.xml) PostgreSQL DB with PostGIS osm2pgsql NASA’s SRTM DEMs

    GDAL Tools UKBorders English MSOAs and Postcodes DCSF. gov.uk National Pupil Database mySQL DB DCSF.gov.uk EduBase and IDACI HEFCE.ac.uk POLAR OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading AJAX Requests PVCs (.kml) OAC R ArcGIS Google Chart API Chart Cache OSM Tiles Tiles OpenLayers (.js) PublicProfiler Schools Atlas Showing Catchments OpenStreetMap (via Cloudmade)
  22. Individuals Individual level schools data Output Areas Output Area Classification

    CAS Wards POLAR HE Participation rates Surface Shuttle Radar Topography Mission Network Street network data LSOA Index multiple deprivation
  23. Map display and controls Tile processing areal and network data

    KDE / PVA automation for school catchment areas Processing SRTM data in terrain relief Charts API