Providing expert timetable and space management consultancy services within the education sector
This is the fifth episode in the Teaching Space Utilisation Survey Data Video Tutorial Series this time looking at how to create frequency rate day and timeslot tables and graphs.
Unlike the previous episodes this data analysis technique breaks down the the institution data by timeslot in order to determine how many of the teaching spaces were used each hour and day. You can combine this technique with…….
This is the fourth episode in the Teaching Space Utilisation Survey Data Video Tutorial Series this time looking at how to create space type frequency, occupancy and utilisation results, tables and graphs.
As with the previous episode, this technique breaks the institution space utilisation data down into categories in order to highlight areas of weaknesses and strengths. This can be particularly useful when…
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 [Read more…]
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 [Read more…]
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
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.