This is the third episode in the Teaching Space Utilisation Survey Data Video Tutorial Series this time looking at how to create site and building frequency, occupancy and utilisation results, tables and graphs.
I have used Microsoft Excel to put together these results, tables and graphs, therefore in addition to providing a video a downloadable version of the spreadsheet used is also available below. For this episode although new techniques have been used, there are not any formulas that haven’t been used in previous episodes therefore a additional formula sheet hasn’t been provided.
These data analysis techniques start to break the overall space utilisation down into categories, that can highlight areas of weaknesses and strengths. For example, a site may have a significantly lower utilisation rate than the other sites. You can then investigate this site further; are there specific buildings, space types, days/times or rooms with low utilisation rates – what is the cause? Once you found the cause or causes within the data, you can then begin to investigate this further with those responsible for the management/booking/use of the space(s) effected.
Please feel free to let me know if you have any questions either by getting in contact with me directly, or by commenting below. Finally, if you find these tutorials helpful please do let others know by sharing them via social media, you can do this simply by clicking the social media buttons below
I hope you find this video helpful!
All subscribers to the Education Space Consultancy newsletter can freely access and download the the completed spreadsheet used in this video tutorial, including all formulas used:
If you are not yet a Education Space Consultancy newsletter subscriber and would like to have access to this and other resources available – for free – simply sign up to the newsletter by adding your details above, or to the right and you will receive a password to access all resources available for free as well as receive a fortnightly newsletter including more resources, news and info.
If you have already subscribed to the Education Space Consultancy newsletter, but can’t find your password please feel free to contact me and I will send you another password ASAP.
Finally, if you are interested in Teaching Space Utilisation Surveys and Data Analysis, why not take a look at the Teaching Space Utilisation Survey & Consultancy service Education Space Consultancy provides or if you have any questions or would like to discuss anything further, please feel free to contact me direct.
Other Related Articles:
All the best