Course
Space Utilisation Survey Analysis and Interpretation

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.
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
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.
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 delivery
Live online cohort delivery
This course includes 7 x 2 hour live workshops delivered by the course facilitator Ben Moreland via Zoom. During each workshop Ben will guide you through the calculations step-by-step, with time dedicated during the live workshop for you to carry out the demonstrated calculations using your own organisation's data. As these are live workshops you will be able to ask questions, with Ben offering live support, helping to ensure you successfully achieve each workshop's outcomes.
Many of the workshops include group collaborative activities where you will work with other HE professionals and the course facilitator, to interpret the results and identify causes of low utilisation and/or timetable booking inaccuracies. All collaborative activities are predesigned within Mural (a digital-first visual collaboration tool), a tool you will gain free access to as part of this course.
Many of the workshops include group collaborative activities where you will work with other HE professionals and the course facilitator, to interpret the results and identify causes of low utilisation and/or timetable booking inaccuracies. All collaborative activities are predesigned within Mural (a digital-first visual collaboration tool), a tool you will gain free access to as part of this course.
Supported by recorded content
We recognise that you may want to revisit the data analysis calculations at a later date, therefore we have created recorded versions of all the calculations demonstrated during the live workshops. These have been broken up into modules, with each comprising of a series of 3-6 minute recorded video segments. Our aim being to provide you content that you can easily revisit, without having to spend time scrolling through long videos, so you can find the exact calculation you'd like to refresh your memory on, in a matter on seconds.
This course's recorded content is available for 12 months, following the completion of the live course.
This course's recorded content is available for 12 months, following the completion of the live course.
Analyse your own data and create your own results
By the end of this course you will have completed all the data analysis calculations and processes using your own space utilisation survey and timetable data. You will therefore finish the course with results and a presentation that you can use for informing and influencing your stakeholders, and bringing about positive changes at your organisation.
Workshop 1 - Organisation and room survey frequency, occupancy and utilisation
Section 1 - Importing fields from another dataset
Section 2 - Data formatting
Section 3 - Space frequency, occupancy and utilisation
Section 4 - Organisation frequency, occupancy and utilisation
Workshop 2 - Merging your survey and timetable datasets
Section 1 - Survey data setup
Section 2 - Timetable data setup
Section 3 - Importing timetable activity data onto your survey timeslot data
Workshop 3 - Hours booked and not attended, and class size differences
Section 1 - Identifying the hours booked and not attended
Section 2 - Identifying the differences between planned and surveyed class sizes, as well as space capacities.
Section 3 - Analysing the hours not booked but utilised
Section 4 - Timetable hours booked and not used per timeslot
Workshop 4 - Calculating survey and timetable results per space type
Section 1 - The calculations
Section 2 - Interpreting the results
Section 3 - Replicating the calculations for different fields
Workshop 5 - Timetable demand and frequency per timeslot
Section 1 - The calculations
Section 2 - Interpreting the results
Workshop 6 - Teaching room requirements per space type and capacity
Section 1 - The calculations
Section 2 - Interpreting the results
Workshop 7 - Influencing your stakeholders to bring about positive improvements
Section 1 - Presenting your results
Section 2 - Benchmarking and collaborating
Section 3 - Course conclusion
Course assessment
The data
Presentation to facilitator
COURSE Facilitator
Ben Moreland
—
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.