This is the first in a 10 episode Teaching Space Utilisation Survey Data video tutorial series that I am making available to all for free, via the Education Space Consultancy website.
During each of these 10 episodes I build upon each skill learnt with the aim of creating a thorough set of data analysis results, tables and graphs within Microsoft Excel that you can use to investigate your institution’s or department’s teaching space utilisation survey data.
I always use each of these techniques as a starting point in pinpointing areas of weakness and strengths within an institution’s results when putting together a Teaching Space Utilisation Survey report, so I hope you find the techniques used in these videos helpful in helping you get the most out of your teaching space.
In addition to providing each video tutorial, all content used will be available for download plus I will also detail any formulae’s used within each post so you can refer back during or after the video.
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 let others know by sharing them via social media, you can do this simply by clicking the social media buttons below
Episode 1 – How to…Create Room Frequency, Occupancy and Utilisation Results
This first episode starts from the beginning and outlines how to create room frequency, occupancy and utilisation results using your Teaching Space Utilisation Survey results.
Understanding how each room is used throughout a set period of time is a fundamental starting point when looking at teaching space utilisation. By doing this you will be able to see which rooms are performing the best and worst, for frequency, occupancy and utilisation.
You can then investigate the reasons for these high/low rates further (such as against the timetable data and with those responsible for the use of this space) in order to understand why they are performing as they are. This information can then be used to begin to put together a strategy for improving how you use the teaching space at your institution.
During this video, I have used Microsoft Excel to create the room frequency, occupancy and utilisation results, the spreadsheet created including formulas is available for download below, plus the formulas used have also been detailed within a downloadable 1 page document that can also be downloaded below.
If you have any questions, please do let me know – 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 1 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 1 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:
Why Do Teaching Rooms Have Low Frequency Rates?
Why Do Teaching Rooms Have Low Occupancy Rates?
Why “Suggested Days And Times” Are Damaging Your Timetable Student Experience And Space Utilisation
All the best
Ben Moreland
Director
