Geocomputation for Widening Participation in Higher Education

9609e8b5ecb752618cbb0db56b5c0a46?s=47 alexsingleton
December 02, 2009

Geocomputation for Widening Participation in Higher Education

Geocomputation 2009, UNSW - Sydney, 2nd Dec.

9609e8b5ecb752618cbb0db56b5c0a46?s=128

alexsingleton

December 02, 2009
Tweet

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. STARTING POINT Very busy cartography Google API

  10. REVISED CARTOGRAPHY / DISPLAY Google Maps OpenStreetMap Google’s Terrain Layer

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

    Geodemographics • Deprivation classification • POLAR • Model school catchments
  12. None
  13. None
  14. Physical Geography Music

  15. None
  16. None
  17. 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
  18. 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
  19. 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)
  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 OAC Mapnik Shapefiles OSM Tiling Script (.py) Stylesheets(.xml) ArcGIS Color Brewer PerryGeo Hillshading PublicProfiler Schools Atlas Choropleth Layers Tiles 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 OAC School Statistics PublicProfiler Schools Atlas Tiles OpenStreetMap (via Cloudmade)
  22. 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)
  23. None
  24. None
  25. KDE / PVC Run: bandwidth 200 - 2000m Until: Single

    polygon Else: Reduce confidence 10% Run: bandwidth 200 - 2000m Until: Single polygon
  26. None
  27. 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)
  28. 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)
  29. 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)
  30. 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)
  31. Version One

  32. SCHOOL SELECTION

  33. SCHOOL PROFILES

  34. AREA PROFILES

  35. Version Two

  36. 3 WEBSITES • HE / Widening Participation • Choosing a

    school • Atlas website
  37. None
  38. None
  39. None
  40. None
  41. None
  42. None
  43. None
  44. None
  45. None
  46. None
  47. None
  48. None
  49. None
  50. 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
  51. 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
  52. None
  53. Thanks!