Data Gathering for Sustainable Student Transport




After receiving a list of possible questions around school transport from Dan,  I started the process of adding them into a Google Form, so that capturing the survey data would be far easier. I then added what I thought were pertinent questions and circulated the final result amongst our email group for feedback. After that feedback and some additional feedback from someone in Transport Modelling we generated the form below.

Transport Survey that went out to Learners at WBHS & WGHS


Getting Students & Staff to Fill in the Form

The next challenge was to actually get the learners and staff to fill out the form. The main issue was the GPS co-ordinates question as you needed to use an external web tool, which took time. The grades we were most successful with were GR8 & GR9. They have a weekly lesson in the computer room which allowed us a clearly defined time to do the survey. It was much harder to get the GR10-12’s to participate in the survey. All in all, we bugged people for about 4 weeks to get as much Data as we did.


The Results

In the end we managed to collect the following Raw Data. This then needed to be processed for input errors and refined into meaningful Data. The WWF paid for the services of an external firm to do this processing. The results can be seen in the PDF below.


Brett Cohen_Survey Results_Scholar Transport.pptx


Earlier Articles in the Series 

Part 1  Sustainable Transport Collaboration



Leave a Reply