Skip Navigation LinksHome > Downloads > Download Sample Output

10.2 Download Sample Data

In this section you can download sample contents of a School Travel Health Check School Pack - an example of an STHC report and covering letter, the local pupil travel map, the all pupil travel map and the summary spreadsheet. Click on the images below to download the file.

STHC Report (0.70MB) - Example of a report and covering letter sent to all schools in Dorset in October 2009 as part of a Knowledge Mappers produced STHC School Pack.

STHC Local Pupil Travel Map (5.5MB) - A1 sized map centred on the school and zoomed in to the walk threshold (800m for primary, 2km for secondary). It shows the school, the walk threshold as a coloured circle and icons for each of the pupils that live locally. This is usually on a colour, aerial photography back-ground. Thus it shows the spatial distribution of pupils within a reasonable walking distance of the school and how they it travel. These images are a product of the printing of the paper maps for STHC School Packs. They are a visual record of the maps sent to schools and are not intended to replace the paper output.

STHC All Pupil Travel Map (3.7MB) - A1 sized map showing the school, icons for all the pupils that attend the school, plus a coloured journey line connecting the icon with the school. The scale of the map, and hence the map background image, is entirely determined by the geographic distribution of the pupils – the further away that pupils are travelling from, the smaller the scale of the map. This map can be quite an eye opener (“they come from where???!!!!”) These images are a product of the printing of the paper maps for STHC School Packs. They are a visual record of the maps sent to schools and are not intended to replace the paper output.

STHC Summary Spreadsheet (0.29MB) - This is a more "print-friendly" version of the Individual Schools "Mode of Travel Stats" spreadsheet mentioned previously, printed at A1 width and showing the stats for the whole authority, generic school types (primary etc.), individual national curriculum years and all the schools in the authority. We highlight the line for the particular school the pack is for. (For large authorities the school list can be subdivided according to a defined area to cut down on the length of the print being sent to the school).

South West LEA Summaries An example of the output that allows easy comparison and benchmarking between authorities. With the new data warehouse now in place we will be moving to the production of a LEA level summary spreadsheet for all authorities engaged with the STHC.

South West STHC Summary Spreadsheet (6.44MB) – This spreadsheet shows summary data for all schools in the South West. Given the number of schools involved it is recommended that you use the filter and sort tools to ‘drill down’ or order the spreadsheet to suit your needs.

Thanks are extended both to the local authorities involved for the sharing of this data but also to the SW Public Health Observatory for their support and signposting of this work.
NOTE: When using filter tools, if the numbers don’t look right try closing and reopening the spreadsheet – sometimes Excel can get confused!