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

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.

[Read more…]

This is Part 3 of the Space Utilisation Survey Data Calculations Video Tutorial Series looking at  how to calculate the frequency rate by timeslot as well as discussing how this data analysis technique can be used to further understand and improve space utilisation.

All of the worksheets used in this video tutorial series are available for free, to all those that subscribe to Education Space Consultancy so please remember to add your name and email address on the right hand side of the webpage and click subscribe to be sent the worksheets directly to your email account.

If you have missed Part 1 and Part 2 of the Space Utilisation Survey Data Calculations Video Tutorial Series, please follow the links below to find them as these go through the earlier stages of analysing space utilisation data:

Video Tutorial – Space Utilisation Survey Data Calculations – Part 1

Video Tutorial – Space Utilisation Survey Data Calculations – Part 2

If you are interested in teaching space utilisation data analysis and are [Read more…]