This is the second episode in the Teaching Space Utilisation Survey Data Video Tutorial Series this time looking at how to create institution 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. Plus there is a downloadable one page sheet that includes the formulas used so you can quickly and easily refer back when creating your own frequency, occupancy and utilisation rates for your institution.
As with calculating room results, calculating your institution’s results is a fundamental part of understanding how your space is being being used and will provide you with a set of single overall figures that you can quickly and easily compare against previous years as well as other institutions to measure progress.
Please feel free to let meknow 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 the 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:
Click Here To Download The Episode 2 Spreadsheet
All subscribers to the Education Space Consultancy newsletter can freely access and download a simple one page sheet, including the different formulas used:
Click Here To Download The Episode 2 Formula Sheet
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:
What Are Space Frequency, Occupancy And Utilisation Rates And How Do I Calculate Them?
8 Tips For Getting The Most Out Of Your Teaching Space Utilisation Data
5 Reasons To Carry Out A Teaching Space Utilisation Survey In 15/16
All the best
Ben Moreland
Director