CTC27_CodeMaps

This project was created over the CTC27 hack weekend (10-11 Sep 2022) to create a map to help visualise what, where and how Computing Science is provisioned and available to young persons in Scotland.

We created a map which plots the locations of secondary schools in Scotland, overlaid with supporting information such as: local authority boundaries, whether there were Computing Science teachers at those schools in 2016 and 2020, and if there were coding clubs in the area.

The data is obtained from several sources and the map is built in R and deployed in an R Shiny app viewable at https://codethecity.shinyapps.io/CodeMaps/

Data Sources

Local Authority Overlays

Scotland Local Authority geojson polygons used in map overlays github.com/martinjc

Scotland Secondary School Coordinates

This data was extracted from Open Street maps using an overpass query with output saved to Data/secondaryschoolsloc.geojson

[out:json][timeout:25];
{{geocodeArea:Scotland}}->.sco;
(
  nwr["amenity"="school"](area.sco);
);
out body;
>;
out skel qt;

Computing Science Teacher Counts

The counts of teachers providing Computing Science education in secondary schools 2016 and 2020 is extracted from this tableau dashboard created from FOI requests made by Education Scotland and their research into Computing Science provision in secondary schools. The extracted data is saved in Data/FTE by Local Authority_data.csv and Data/FTE by School_data.csv

The data for 'Secondary school teacher counts (with main subject of Computing), within each local authority area in Scotland in 2021' is extracted in file Data/Secondary_school_teachers_by_main_subject_local_authority_2021.csv. This data was extracted from Teacher census supplementary statistics, (file, table 8.9 ). This data hasn't been plugged into the map itself yet.

Code Clubs

Manually scraped from websites and social media at the CTC27 hack event. The outputs are saved in Data/Code_clubs.csv

Map

The source code for the map is app.R, a .html only version is available in schools.html and a published RShiny App which also includes supporting data tables.

Resources

The file resources_computer_science_education.csv contains additional useful information, links and articles organised in a timeline from 2006 - 2021.