Evaluation and Reflection, Technologies, Uncategorized

Using Microsoft Power Platform to Support Staff Development

This blog post is a follow-up to the post Using Automation to Facilitate Flipped Learning. 

Due to the success of using Microsoft Power Automate to support flipped learning for an advanced KEATS training session, the Power Automate process was rolled out to all training sessions offered by Centre for Technology Enhanced Learning (CTEL) and other elements of the Microsoft Power Platform have been introduced. This blog post will outline the processes, successes, and challenges. 

Rollout of Power Automate Process 

Once the decision was made by the CTEL CPD Chair to roll out the Power Automate process to all CTEL training sessions, we needed to decide how this would work practically. The established process, or flow, used for the KEATS: Personalising the Learning Experience training session was built specifically for that session and was the only one that included pre-session work. We navigated around this by creating individual flows for each of the sessions run by CTEL and removing and adding steps as appropriate. The Assistant Learning Technologist for the team and I worked closely with the session leads, customising and creating the flows and encouraging personalisation of their flows to better reflect their sessions, such as adding attachments and editing email text.

Another risk was that the flows would reference the same Microsoft Excel spreadsheet hosted on a SharePoint site, and with multiple people accessing and changing the data, flows could be affected and send out emails at the wrong time. We navigated around this by creating individual spreadsheets and pointing the flows to the relevant spreadsheets for each session, which allowed for further customisation from session leads if desired. 

Flows are usually triggered 2 working days before the session is scheduled, but this can vary if the pre-session work required will take more time to complete. The core template automatically completes 5 core steps when triggered: 

  1. Creates a Microsoft Teams Meeting and invites all attendees to the meeting. 
  2. Sends an email containing further information about the session if needed. This is on a 5-minute delay to allow for any manual intervention should any mistakes be made in step 1. 
  3. Sends an email to participants as soon as the scheduled session is finished containing links to further resources and a request for feedback to be left via the Microsoft Form. 
  4. Sends an email 2 working days to participants after the session has been completed, asking for feedback if it hasn’t been left. 
  5. Sends an email 10 working days after the session to participants to ask if they have attempted any content that was covered in the session and if they have any success stories to share or need any further support. 

The above template is core and session leads can add further steps as relevant to their own flows. Working days are calculated within formulas in the Excel spreadsheet and are utilised to increase the response rate, rather than send emails out over a weekend or bank holiday which can be ignored. 

Displaying Feedback in Power BI 

The Power Automate process outlined above is fairly simple in terms of its structure and aims; it sends out emails at predetermined times based on the date and time of the relevant session, which is calculated in the Microsoft Excel spreadsheet. Each email sent to attendees once the session has been completed contains a link to CTELs feedback form. Once feedback is submitted, it is collected, anonymised, and stored. I designed a Power BI report to display the quantitative and qualitative data submitted to display the impact of the sessions and assist each session lead with making any changes using free text submissions.

An Overview of CTEL Feedback organised by session titles, calendar month and by faculty. The graph on the top-left presents which workshops in order of being given the highest feedback. The graph on the top-right presents volume of feedback given by different faculties. The graph on the bottom left presents the average and highs of how much feedback was given per calendar month. The bottom right graphs show when the drilldown date of workshops and the graph below shows overall feedback of 373 out of 746.
Figure 1: The Power BI report for feedback submitted for CTEL training sessions. Data is organised by session title, calendar month, and by faculty. 373 pieces of feedback were left for 2021/22.

After organising this data and gaining experience in Power BI, I was able to link this data to attendance data extracted from SkillsForge, to gain insights into our historical CPD attendance and how this relates to our feedback submissions. An advantage to this was to see if the flows had an impact on gathering feedback for our sessions.

Figure 2 presents the attendance of CTEL training sessions. Organised by calendar month, attendance type by sessions, and by faculty. The graphs on the top left present the overview of attendance of 2021/2022 Academic Year. With 1243 total sign ups out of 2486 and 166 number of sessions. The bottom left graph shows signups by workshop over time by index per month. The top-left graph shows signups by faculties ranging 0-200+. The bottom left graph shows attendance types by sessions of each workshop.
Figure 2: The Power BI report for attendance at CTEL training sessions. Data is organised by calendar month, attendance type by sessions, and by faculty.

Key findings revealed that attendance for 2020/21 was significantly high with 2209 members of King’s staff signing up for a session offered by CTEL, with feedback submissions at 324, so around 14.7% of attendees left feedback. Attendance dropped for the year 2021/22 with 1247 members of King’s staff signing up for a session. This is to be expected as we saw an increase in face-to-face teaching taking place and there were fewer modules delivering fully online teaching, but feedback submissions increased slightly with 373 submissions, around 30% of attendees submitting feedback. This is a positive revelation as although attendance figures fell by almost three quarters, the total amount of feedback submitted increased, and the percentage rate doubled. However, we need to be aware of several caveats with this data.

Figure 3 shows a stacked graph of bookings against feedback submissions for the academic years 2020/21 and 2021/22. With 3456 Bookings, 697 feedback submissions and 20.17% percentage.
Figure 3: Data displayed in a stacked bar graph of bookings against feedback submissions for the academic years 2020/21 and 2021/22.
  • As previously mentioned, the teaching in the academic year 2020/21 was delivered fully online. 2021/22 saw a gradual increase in face-to-face teaching from January onwards, so this data isn’t 100% comparable due to a significant change in circumstances.
  • CTEL ran a total of 29 ‘Breakout Rooms in Microsoft Teams Meetings’ training sessions in 2020/21 with 861 sign-ups, which massively increases attendance data for that academic year. 719 sign-ups occurred in September alone. Breakout rooms were a highly desirable feature of Microsoft Teams Meetings, but the functionality was not robust enough to be rolled out en masse, which may have impacted feedback submissions.
  • As digital capabilities in King’s staff increased throughout the months of the pandemic and demands on staff members’ time have reduced, this may have resulted in more time to engage with and submit feedback.

During the academic year 2020/21, CTEL joined other departments across King’s to offer a full suite of training opportunities in delivering teaching online. During that time, a generic feedback form was sent to attendees which were mainly concerned with joining instructions to Teams Meeting links, so we cannot see detailed responses to questions usually asked on the CTEL feedback form. Based on the 373 feedback responses submitted in 2021/22:

  • ~94% agreed or strongly agreed that they would recommend a CTEL training session to a colleague
  • ~95% agreed or strongly agreed that the session they attended will have a positive impact on their teaching.
  • ~95% agreed or strongly agreed that taking the session was worth their time.
Figure 4 shows feedback of workshops for 2021/22. The top left graph presents subject matter understanding before attending the course. With the factors measuring from novice, basic, proficient and advanced. The top right graph presents subject matter understanding after attending the course. With the factors measuring from novice, basic, proficient and advanced. The bottom graph presents agreement results from selecting different statements. Ranging from strongly disagree, disagree, neutral, agree and strongly agree.
Figure 4: Data displayed for 2021/22 quantitative questions.

The above is very positive as it demonstrates the impact that CTELs training sessions are having across the King’s community. The feedback form has not been changed for the academic year 2022/23 and so data can be easily compared in the future.

Based on an overview of the data, the Microsoft Power Automate process appears to be working well as the feedback response rate has remained steady as attendance figures have dropped, and Power BI has been a very useful tool to display and filter feedback data. Session leads have fed back that the Power BI report is beneficial and allows greater insight into the feedback for their sessions, and the CTEL CPD Chair has passed on positive feedback regarding the overall attendance data visualisations. I am currently working on an additional Power BI report that will utilise row level security to allow Technology Enhanced Learning Managers across the university to see attendance figures for their own faculties and tailor demand or promote courses that CTEL offer at strategic points in the year.

I am pleased that the automated process works and has helped free up time for CTEL staff and helped increase our feedback response rate, but I am dissatisfied that the session leads need to access two pieces of software (Microsoft Excel and Microsoft Power Automate) to get this to work. I am currently investigating whether I can achieve the same results with a Power App (another Microsoft Power Platform application) to improve usability and increase satisfaction.

Useful Links:


Written by Dave Busson-Crowe

Dave Busson-Crowe is a Learning Technologist at the Centre for Technology Enhanced Learning and has been involved with Learning Technology in some capacity for approximately 6 years.

He has a keen interest in the use of artificial intelligence in education.

Pedagogy, Technologies

Echo360: New Features

As the new academic year gets under way, we will be looking at some new features available in Echo360 which are now available to staff. Echo360 is one of King’s College’s core technologies (read more about our core technologies) and is used for Lecture Capture platform which is used to record live lectures.  
Echo360 can also be used to create video content on your desktop using your webcam and microphone and can also record your screen. For full guidance on using the features described here, please refer to the links at the bottom of this post. 

Browser Capture 

Until recently, the only way to create a desktop recording using Echo360 was to download and install Universal Capture to your computer. Browser Capture allows staff to create a desktop recording without the need for additional software, using their browser. Browser Capture allows you to record your screen, webcam video and audio.  

Echo360 browser capture

 

What are the Pros and Cons of Browser Capture?

The main advantage of using Browser Capture is that it doesn’t require installing additional software. Other pros include the ability to record just one application or window on your computer, or a specific browser tab, none of which are on option via Universal Capture. However, unlike Universal Capture, you cannot create recordings if you are offline, so you will need an active internet connection whilst recording.

Advanced Editing

Echo360 have introduced advanced editing options, including:

  • The ability to remove segments from your recording
  • The ability to insert other media in your recording
  • The ability to remove or add tracks from your recording

Removing Segments of a Recording

This new feature allows users to remove a segment of a recording, including one from the middle of a recording. This is useful if you have a break during your lecture, or if students undertake group discussion, which is not useful to have as part of your recording. Once you are in the video editor, you will see a new option to Split Clip via the play head menu.

Removing Segments of a Recording

Using this on both ends of the segment that you want to remove will allow you to delete it.

Insert Other Media in a Recording

It may be useful to insert other media into your recording, for instance if you want to record an introductory video for your lecture and have it be part of the recording, or if there are challenging parts of your lecture content that you want to expand on after it’s taken place. In the Echo360 video editor, click on Insert Clip as shown, you will then be prompted to add the clip via your Echo360 library.

Insert Other Media in a Recording

Remove or Add Tracks

A track is a particular element of your recording, such as the audio, a camera feed showing the Lecturer, or the screen recording. The ability to remove a track may be useful if the camera feed was part of your recording, but you later decide that you want to remove that element. You can remove a track by accessing the editor, clicking on the 3 dots next to the track you want to remove and clicking on Remove Track.

Remove or Add Tracks

 

 

 

 

 

 

Similarly, you can add tracks to your recording that will play alongside the existing tracks. To do this, access the editor, click on the Actions dropdown menu and select Add A Track. You will then be prompted to add the track from your Echo360 Library.

Add a track menu option

 

 

 

 

 

Note: You can only have a total of 3 tracks in one recording, so if you already have 3 then you won’t be able to add a new track until one is deleted.

Customising Video Thumbnails

A thumbnail is the preview image of your recording. You may choose to change this to something that better summarises the content of your recording. For instance, you can select a frame from your recording that shows a slide that shows a summary of what will be covered, or you can create an image to upload as your new thumbnail.

You can grab a new thumbnail from your recording by navigating to the part of the recording showing the slide/video that you want to use and selecting Set Thumbnail on the play head menu and following the remainder of the on-screen prompts.

Customising Video Thumbnails

 

 

 

 

 

 

 

For full guidance on using this feature, including how to upload a thumbnail from your computer, please refer to the link below under further guidance.

Further Guidance

Please note following links are accessible only for King’s staff:


Written by Fariha Choi

Fariha Choi is a Learning Technologist in the Centre for Technology Enhanced Learning and has been with CTEL since June 2021. She has a particular interest in educational multimedia and has worked as a Learning Technologist, eLearning Developer and Learning and Development Manager for the past 11 years.

Pedagogy, Technologies

Applying the Digital Education Accessibility Baseline: An Academic’s perspective

This recording by Dr. Manasi Nandi, Reader in Integrative Pharmacology, complements the blog post, Digital Education Accessibility Baseline: Raising our standards for digital accessibility. It focuses on how Manasi approached the implementation of the baseline, provides tips on where to start and how to overcome some of the challenges she encountered. The benefits of accessible KEATS courses and content are explained, and resources to support accessible design are signposted.

Please click on the image below to access the recording:

Applying the Digital Education Accessibility Baseline: An Academic’s perspective recording
Applying the Digital Education Accessibility Baseline: An Academic’s perspective – recording duration 13mins

 

 

 

 

 

 

 

 

Useful links:

MLC Accessibility 1
Evaluation and Reflection

King’s Language Centre Approach to Digital Education Accessibility

A holistic approach was adopted by the King’s Language Centre (LC) to comply with the legal requirements of accessibility. The Senior Leadership Team (SLT) has been instrumental in driving the change not only with the academics, but also with members of the Professional Service team (PSS). The approach combined top-down and bottom-up strategies that have been successful in improving all our digital resources, including KEATS pages, educational materials, and templates for essential documentation.  Continue reading “King’s Language Centre Approach to Digital Education Accessibility”

Accessibility Baseline 1
Technologies

Digital Education Accessibility Baseline: Raising our standards for digital accessibility

When the UK went into lockdown due to the Covid 19 pandemic, King’s College London was forced to close the university and move its courses online. As we were pivoting to learning and teaching online at an unprecedented scale the use of our Virtual Learning Environment, KEATS (Moodle), greatly increased. Continue reading “Digital Education Accessibility Baseline: Raising our standards for digital accessibility”

Captioning Transcription 3
Technologies

Introduction of Captioning and Transcription Service at King’s College London

In September 2020 King’s College decided to commit to further developing the Captioning and Transcription Service available via the King’s media platform (Kaltura). Academic staff were provided with access to request high quality human transcriptions for their lecture recordings. Continue reading “Introduction of Captioning and Transcription Service at King’s College London”

Evaluation and Reflection

Part 2: Embedding Digital Accessibility to the heart of everyday TEL work

This article has been divided in two parts. Part 1 discusses how the SSPP TEL team works to boost staff understanding of digital accessibility baseline. Part 2 provides an overview of the TEL training sessions available on the subject.


Part 2: TEL training sessions

The TEL Hub digital accessibility section is aimed at staff to access information in order to meet the basic requirements of digital accessibility baseline from a more administrative perspective. Continue reading “Part 2: Embedding Digital Accessibility to the heart of everyday TEL work”

Evaluation and Reflection

Part 1: Embedding Digital Accessibility to the heart of everyday TEL work

This article has been divided in two parts. Part 1 discusses how the SSPP TEL team works to boost staff understanding of digital accessibility baseline. Part 2 provides an overview of the TEL training sessions available on the subject.


Allyship:

“the state of being an ally (= a person who helps and supports somebody) to a particular group of people that you yourself do not belong to, in order to help ensure their basic rights and ability to be happy and successful in society”- Oxford learner’s dictionary

What does digital accessibility mean to me? It means being able to embrace a platform for its intended use, because the people building it know how to create a great user experience – anticipating, rather than reacting to the needs of our diverse learning community. Being an ally. Continue reading “Part 1: Embedding Digital Accessibility to the heart of everyday TEL work”