Skip Navigation LinksHome > Standard Output > Spreadsheets

Standard STHC Analysis Output - Excel Spreadsheets

The comprehensive range of spreadsheets supplied back to officers in client authorities include charts and graphs wherever possible. The spreadsheets fall into the following general categories:-

Note: We are currently beta testing an updated format for the Excel spreadsheet output. Please contact us for further information. In the meanwhile sample spreadsheets of the current format can be obtained from our Download page

Mode Of Travel Stats

The purpose of the "Mode of Travel Stats" is to show the School Census Mode of Travel Data as it is usually presented - summarised as a “number and percentage by mode” - along with key indicator fields calculated by our spatial analysis process. The key fields are the number and percentage of Pupils living within the Walk Threshold Traveling by Car as well as the overall travel carbon footprint per pupil, which is used to rate the school on a red, amber or green basis in the same way as the STHC reports.

Actual (& Nearest) Distance Stats

The "Distance Stats" translate the "numbers & percentages by mode" of the Mode of Travel stats into distances the ground - both the distance to the school the pupil actually attends ("Actual Distance") and that of the nearest eligible school defined by national curriculum year ("Nearest Distance").

Carbon & Calorie Stats

The "Carbon & Calorie Stats" translate the distances of the Distance Stats, which are only for a single journey between home and school, into total jpourney distances (home - school - home), and thence into either the calories burned by pupils during the walk or cycle or the CO2 emitted if travelling by vehicle. From these it is then possible to calculate the total school travel carbon footprint down to individual school level on a per pupil basis, which can then be turned into an overall sustainable travel rating for the school. It is these "carbon and calorie" figures that link the data to the "Sustainable Schools" and "Healthy Schools" agendas.

Cross Border Stats

As it sounds, the "Cross Border Stats" quantify the movement of pupils across the borders of the consortium authorities. All the LEAs in which the pupils home postcodes are situated are identified along with the actual numbers of pupils coming from each, for all the authorities that are part of the analysis dataset. The ability to calculate the pupil flows between LEAs will inform the creation of Travel to Learn Areas, an important feature of the emerging 14-19 agenda.

Distance Profile Stats

The "Distance Profile Stats" provide an immediate feel for how the different travel modes are distributed according to distance from the school. In particular they show the 85th & 95th percentile distance values for each subset of the data (the former is a standard indicator used by traffic engineers).

Key Analysis Results Table

This file is part of the standard Excel spreadsheet output, as well as a paper copy being included in the STHC School pack. The table presents the key analysis results for the authority at all the standard reporting levels in a user-friendly way. It enables schools to quickly see how they compare with other schools in the LEA, the average for their school type or the LEA as a whole.

Note: This sheet is designed to be printed at A1 width. In the case of large authorities like Dorset, the printed version becomes unfeasibly long and impossible to work with if all schools are included in the table (in a "Wallpapers-R-Us" sort of way ;-). To get round this we break down the schools by Local Authority District in the version included in the paper pack sent to schools. The digital version however includes all schools in the authority to enable full comparisons