Empowering Educators with Microsoft 365

When Aristotle first said 'The whole is greater than the sum of the parts', he 'probably' wasn't talking about Microsoft 365... but the quote's still relevant.

Plan for today

introduction

Overview of lesson

Today we’re going to cover a range of automation with Microsoft 365, and our original plan was to take you through the Microsoft Learn materials on the Bookings App. (For those of you who haven’t as yet come across Microsoft Learn, there are a fantastic set of tutorials and learning paths on all Microsoft applications)

However, on investigation, the Bookings App has had a full makeover, and the materials haven’t as yet been updated.

We have therefore created a fresh set of materials for today, relevant to the updated Bookings App.

The Microsoft Learn tutorial is part of a Learning Path called  –

“Use assessment tools to conduct successful family-teacher conferences”

(click the above to take you to the full Learning Path)… much of the rest of which is also really useful.

We have also included an up to date video from Kevin Stratvert ( below) – one of my ‘go-tos’ for any 365 tutorials, so if any of you want to use these materials in a lesson you may find this useful too.

data education in colleges

Microsoft Teams

Microsoft Bookings

data education in colleges

Microsoft Forms

Microsoft Power Automate

integration of microsoft 365

The real ‘power’ of Microsoft 365 is the integration of apps, so today we’ll cover the advantages of the above applications and create a project using all 4.

TODAY'S SESSION

For each of the applications, we’ll give you an overview of how they work… then we have a short exercise which we’ll work through together

creative commons

All the materials for this session are released under a Creative Commons licence, and have been created with the idea that if any of you can use these within your lessons… please help yourself.

 

 

There are overviews, short pre-recorded videos and self-marking H5Ps.

For anyone wishing to make use of these materials, the easiest way is to create an iframe within Moodle or whichever VLE you use.

We have included instructions at the foot of the page as to how to add an iframe.

project overview

Objective: By the end of this session, you will be able to integrate Microsoft Teams, Microsoft Booking App, and Microsoft Forms into a seamless workflow to automate scheduling and managing Teams meetings. Additionally, you will gain a basic understanding of Power Automate for further automation possibilities.

data education in colleges

Helpful wee extra?

We sent this on email as part of your pre-course info, but am going to quickly demonstrate it to you so I can send you the image file you’ll need for the first tutorial

data education in colleges
data education in colleges

Microsoft Forms

Overview with instant future-proof data collection using Excel online

Overview of application

We’ll start with an overview of the application, then work through an exercise together.

 

It’s safe to say most of you have used or at least seen Forms previously…however, most of us have been creating our Form, sharing it, waiting for responses, then downloading the responses.

 

The main issue with the above, is that:
1) to gather the response data we need to go into the Form, navigate to the Excel spreadsheet and download

 

2) If we want to send a similar Form back out again, we tend to duplicate the original and resend.

 

 

Wouldn’t it be such a ‘time-saver’ if we could simply create one Form, and continue using the same one for months or years?

Student task #1

Student task #1: Setting Up a futureproof Microsoft Forms for student feedback

getting started with microsoft bookings

access microsoft bookings

  • Navigate to Microsoft Bookings and log in.
  • Click on “Get started” to create a new booking calendar if this is your first time using the app.

Creating a Booking Calendar:

Enter Business Information:

  • Fill in your details, such as the business name, address, and contact information.

Calendar Setup:

  • Define the available hours for booking.
  • Set up your time zone and business hours.
TOP TIP:
Double check your own time zone… I’ve noticed a couple of times in the past, that this can ‘update’ so that even if  you create an available time of eg 15:00, it ‘may’ appear on the recipient’s calendar for 03:00

Customising Appointment Types:

  • Go to the “Services” tab on the left panel.
  • Click “Add a service” to create a new appointment type (e.g., “Office Hours Meeting”).

customise the service

Service Name:

  • Enter a name like “Office Hours Meeting”.

Description:

  • Describe the service, e.g., “One-on-one meeting with students or staff”.

Duration:

  • Set the default meeting length (e.g., 30 minutes).

Availability:

  • Configure specific times or use business hours.

Additional Settings:

  • Enable “Online Meeting” to automatically create a Teams link.
  • Adjust booking lead time, maximum bookings per day, and other preferences.

Linking the Booking Responses:

  • Under “Staff”, ensure you are listed as available for bookings.
  • Set up notifications for when a booking is made.
  • Bookings will automatically appear in your Outlook and Teams calendars.

Testing Bookings:

  • Share the booking page link with yourself to simulate a student booking.
  • Verify that the booking appears correctly in your calendar with a Teams meeting link.

Student task #2

Student task #2: Configuring Microsoft Bookings to Automate Scheduling

Student task #3

Student task #3:Automating information requests using power automate

data education in colleges

iframes explained

This pdf will explain iframes, what they are, what they do, and how to use on Moodle. (click the link below to download the pdf)

iframe explained

Sqa Certified courses from scqf level 3 to scqf level 8

data education in colleges
data education in colleges

short courses from 2 hours to 8 hours in a range of microsoft applications