Course

Space Utilisation Survey Analysis and Interpretation

A live cohort course created by our space utilisation survey analysis expert Ben Moreland, who will guide you through how to clean, merge, analyse, interpret & present you space utilisation and timetabling booking data and achieve senior stakeholder buy-in for process improvements.
field
Space & timetabling
Format
7 x 2 hour live sessions
Skill level
Confident in Excel basics
Create results using your own data
Downloadable formula workbooks 
Live course supported by  recorded content

Course start date TBC

Objectives

Merge your datasets

  • Match up your timetable activities with your survey data, within 30 minutes.
  • No coding, simple Excel formulas that Ben explains, shares and will help you you to implement
  • All you require is Excel, a timetable data export and space utilisation survey data.

Timetable differences

  • Identify the timetable activities that have been booked and not attended.
  • Identify the differences between the planned and surveyed class size, and the room capacity for each activity.
  • Produce a report on booking inaccuracies per department.

Your organisation's results

  • Calculate your organisation's and each space's survey and timetable frequency, occupancy and utilisation.
  • Calculate the total number of hours booked and not attended per space.
  • Calculate the total number of hours used when not booked per space.

Space type utilisation

  • Learn how to analyse your room utilisation results per space type and identify potential causes.
  • Calculate survey, frequency, occupancy and timetable differences per space type, campus an building.

Demand by timeslot

  • Calculate your organisations survey and timetable demand  as well as hours booked and not attended, per timeslot.
  • Learn how to interpret this analysis and and identify potential causes for further investigation.

How many spaces?

  • Calculate the number, type and size teaching spaces you require given timetable and survey demand.
  • Compare this against your space supply and identify opportunities for improving the efficiency of your estate.

Course Information

Course requirements

Your skills and experience

To take part in this course, we expect you to already be comfortable using Microsoft Excel for carrying out calculations using formulas such as SUMIF and COUNTIF. We also expect you to be familiar with Excel functionality and operating a dataset that includes a large amount of data (>10,000 rows) and calculations.

If you have already completed the 'Calculating space demand using a timetable data export' course, this course is the ideal next step.

So as to ensure we can proceed efficiently throughout the course, we will not be explaining basic Microsoft Excel functionality. If you have limited experience using Microsoft Excel for data analysis purpose, we recommend you complete the 'Calculating space demand using a timetable data export' before enrolling onto this course, as this will be more suitable.

Tech requirements

During this course you will be creating and using formulas that require significant process power. Please ensure your device has the following minimum specifications;

Processor: Intel(R) Core(TM) i7-10510U CPU (or equivalent)
Installed RAM: 8GB

During the live workshop, please close all applications and remote desktop connections, apart for the Zoom meeting window and the Microsoft Excel files you will need to use during the live workshops

Your data

So as to ensure you can interpret our guidance and analyse your own organisation's data sets, we require you to send us your data at least 7 working days before the start of the live course. We will then review this data and provide guidance on how to manipulate this data (e.g. move columns) so that it mimics the setup of the data we will be using to demonstrate the analysis processes and calculations.

During the course we will not be analysing student or staff data, therefore please do not include this information within the data you send us. This will help to ensure we can comply with your organisation's staff and student privacy concerns.

COURSE Facilitator

Ben Moreland

Ben has worked within the HE space management and timetabling worlds for 14 years. This has included time as a timetabling and space manager for an HE organisation, a consultant providing space utilisation and timetabling services, and presently as the director of two businesses that aim to support both communities (Escentral and Education Space Consultancy).

Space utilisation and timetabling accuracy are two of Ben's passions and topics he has continually influenced throughout his career. Through the completion of 100+ of space utilisation projects, he has continually evolved calculations and processes for effectively analysing and interpreting these two datasets, using the widely accessible Microsoft Excel software. During this course Ben will share with you his methods of analysing, interpreting and presenting space utilisation and booking data, and offer guidance on how to gain senior stakeholder buy-in for process changes that will positively influence your estate and booking accuracy.

Ben has achieved many space utilisation and timetable analysis highlights, some of which include:

  • Successfully carried out 100+ space utilisation survey, analysis and reporting projects for HE and FE organisations throughout the UK, working with over 50 different organisations over the past 14 years.
  • Over a 3 month period helped a large UK University to reduce the number of hours booked and not attended from 1000 hours per teaching week to less than 200 hours, representing a 800 hour saving; the equivalent of 20 teaching rooms of availability being released back into the timetable. This enabled the University to accommodate a major increase in student numbers for the target academic year, without increasing the size of teaching estate.
  • Created Microsoft Excel based teaching space modelling calculations that determine the number, type and size teaching spaces required per teaching week, using primarily a timetable data export. These calculations also incorporate scenario modelling capabilities, enabling HE organisations to predict their space requirements given changing demand and supply parameters. Ben has worked with 20+ HE organisations to determine present and future teaching space requirements using these calculations, helping to shape their future estate so as to reflect their expected teaching delivery demands.
  • Developed timetabling strategies for 8 HE organisations, with each project identifying and addressing causes of timetabling inaccuracy and space utilisation, as well other issues effecting timetabling performance.
  • Provided adhoc analysis and timetabling support for HE organisations looking to semi automate processes, improve the accuracy of their data and better inform stakeholders.

This 'Space utilisation survey and interpretation’ course, encapsulates Ben’s passion and experience of using survey and timetabling data to inform estates planning. By joining this course, Ben will guide you through his proven framework for merging, analysing, interpreting and presenting your survey and timetable data sets.

Not quite what you're looking for?

Frequently asked questions

What if I am not happy with a course?

At Escentral, we work hard to give all our students the best possible learning experience. If at any time you are unhappy with the course, please contact us [email protected] so that we can resolve the issue.
Created with