Category Archives: School Data Sync

How to Download a Meeting Attendance Report in Microsoft Teams

As a teacher it’s important to measure engagement of students that are home learning. Microsoft Teams has given us a quick and easy tool to enable us to do this. 

In this post we look at how to download an attendance report of an online lesson. 



Once the participants of your Teams meeting have left and before you exit the meeting window you can view and download the meeting attendance report by following the steps below.

From the Meeting Control Panel select the Show Participants button.

Show participants panel

Click on the menu (three dots) in the people panel.

menu button

Select “Download attendance list” from the menu.

download attendance list

The CSV file will download.

CSV download

Once the spreadsheet has opened you will be able to view the names of the meeting participants. The “User Action” column displays when the participants have joined and left the meeting with the “Timestamp” column displaying the date and time the action occurred.

attendance report in Microsoft teams

Using this report can help to drive better attendance and engagement of remote lessons thus empowering teachers to achieve better results for their students.

Need help getting good user adoption in your school or MAT? Visit our website to see if we can help you!

Global Insights for Measuring Student Engagement with Microsoft Teams

During these difficult times, blended learning has been critical in providing students with uninterrupted learning. The blended learning approach can provide an effective way of reinforcing face-to-face learning with online resources and interaction.

However, it can be difficult especially with students working remotely and it is a challenge for the school to identify students who are not engaging well. Microsoft Teams Insights can help in providing detailed information on student engagement.

In these video guides, we take you through adding the insights tab to Class Teams and how to use it to track student usage, assessment trends, digital activity and much more.

In the first video, we look at new global insights app to measure student engagement across all class teams.



In the video below, we look at a more detailed view of the class breakdown and some custom analytics that we can also add into your tenancy.



You can find out more information on Cloud Design Box and how we can help your school get the most out of Microsoft Teams on our website.

Setting Team Policies for Safeguarding in Education

Before you start to use Teams in school, it is important to consider setting policies for safeguarding to promote the welfare of children and protect them from harm.

Each school must consider their own policies because one size does not fit all. For example, some schools might be comfortable with students direct messaging teachers for help while others will want this communication in a more open space. The school’s behaviour policy should also be taken into consideration. It is therefore important for IT to involve the safeguarding officer when planning out which policies to apply to users.

Microsoft have made it easier to assign policies to users (this was previously done through PowerShell and still is for some policies – see our previous PowerShell post).

Teams Admin Center

We recommend you create a custom policy for both staff and students. Staff will need changes to the policies too otherwise they won’t be able to do things like delete student messages in Teams (see our previous PowerShell post).



It is also important to remember that there isn’t a single policy to manage teams, it is broken up into:

  • Meeting Policies
  • Live Event Policies
  • Messaging Policies
  • Permission Policies (PowerShell applied only)
  • Emergency Policies (PowerShell applied only)
  • Voice Routing Policies
  • Call Park Policies
  • Calling Policies
  • Caller ID Policies (PowerShell applied only)

For each of these policy types, you will find a Global (Org-wide default) policy which will apply to everyone. Any changes to that policy will apply to everyone automatically.

Create a new policy

Create a new policy and give it a name using the “Add” button.

Create Policy

New messaging policy

Apply the policy to a group

Click on the “Group policy assignment” tab (if it’s not visible refer to our PowerShell post).

Group policy assignment tab

Click “Add group”.

Add Group Button

Search for a group and then select a policy before clicking “Apply”.

Apply Teams Policy to Group

This is much easier and quicker than running PowerShell scripts, we hope you find that useful!

Update 11/11/2020: We have been informed that if you set a user’s policy through PowerShell, this group method above may not work for you and you may need to use PowerShell to apply the policy.

Class Team Cheat Sheet for Teachers

Are you new to Teams or not quite sure about the right places to do things?

We have created a simple overview below for some of your key educator actions!

Class Teams Cheat Sheet

1. Posts

Have group discussions, video calls and praise students. Great for communicating with your class.

2. Files

Individual student work folders for any work that requires constant feedback between student and teacher throughout the academic year (e.g. class work or coursework).

3. Class Notebook

A student exercise book. Each student has their own section and can create pages with content (just like a real-life exercise book). The teacher can see all students section and can virtually stick their head over the student’s shoulder to see what they have written in their exercise book. There is also a content library for the teacher to add notes.

4. Assignments

Set assessed work, hand out work to students, collect submissions and mark.

5. Grades

This is a grade book linked to the assignments. See all the assignments set throughout an academic year or all the assignments set for an individual student throughout the academic year.

6. Long term resources

Access long term student facing resources in your centralised resource bank. Saves time by not having to upload your resources into each class that you teach and share resources with your department. Department heads can check on the quality of these centralised resources.

7. Insights (optional – add as tab)

Measure student engagement with statistics.

8. Breakout Groups (optional – add as channels)

Create breakout groups so students can work together on projects. These can be private channels on visible by the students added or open to the whole class.

Additional functionality

Please note that the student folders and long term resource tab is a feature provided by Cloud Design Box to help save teachers time and make it easier to work in Class Teams automated from MIS (SIS) data. You can contact us here.

Free Online Event for Educators from Microsoft Global Training Partners Cloud Design Box

Book Your Place on our Free Training Sessions for SharePoint and Microsoft Teams

Cloud Design Box Announced as Microsoft Global Training Partners

We’re thrilled to announce that Cloud Design Box is a Microsoft Global Training Partner and CPD Certified.

Microsoft Global Training PartnerCPD certified

To celebrate, we are offering three, free workshops for schools and multi-academy trusts on using SharePoint and Microsoft Teams to enrich learning.

Being named as a Microsoft Global Training Partner is a huge achievement for us – Microsoft chooses companies who share its mission in enabling educators to embrace the power of technology and empower every student to achieve more.

To attain this certification, the team has worked with Microsoft and undergone the official Microsoft Training Programme, learning how to further support schools and helping them to leverage technology.

Cloud Design Box now appears on the Education Training Providers area of the Microsoft website and can deliver services and training on Microsoft’s behalf.

CPD Certified Courses

Meanwhile, we’re equally pleased to be CPD certified. This certification helps us continue to deliver quality and trusted training resources to educators around the world.

Any teachers attending our training courses at school will get a CPD certificate afterwards.

Free Global Training Event 18th June 2020

On Thursday 18 June, we’re offering three free virtual workshops for schools, focusing on SharePoint and Microsoft Teams.

The first workshop takes place at 10am and centres around setting up assignments using Microsoft Teams. Lloyd and Darren will walk you through how to set assignments to your class members, use rubrics and mark work.

Free workshop setting assignments in Teams

After a short break for lunch, we’ll return at 1pm with a session on using SharePoint to organise long-term resources.

Our team will show you the power of centralising your long-term class resources that can be stored, shared, co-authored and added to every year.

Free workshop using sharepoint for centralising resources

Finally, at 4pm, we’ll round off the day with a workshop on getting started with Microsoft Class Teams.

Many teachers have been using Teams to connect with their classes over the past few months. We’ll be showing you how to extend this further and get the most out of the platform with conversations, assignments and online lessons.

Free workshop getting started with Microsoft Class Teams

All workshops will be hosted via Microsoft Teams because we’re passionate about using the products we work with and sell.
To register your interest for any of the workshops, please fill out this form.

Insights and Analytics in Class Teams

In this video guide, we take you through adding the insights tab to Class Teams and how to use it to track student usage, assessment trends, digital activity and much more.



You can find out more information on Cloud Design Box and how we can help your school get the most out of Microsoft Teams on our website.

Office 365 User Adoption Episode 11: Supporting Students with SEN and EAL with Office 365

In this podcast, we spoke with James Emmet, Network Manager at Engineering UTC North Lincolnshire about how they use features in Office 365 to support students with Special Education Needs (SEN) and English as an Additional Language (EAL).




Listen on Spotify

“We have a high number of students who are EAL, SEN, dyslexic and have low reading ages. I passionately believe that – when used in the right way – ICT is one of the most crucial tools to help these students with their learning,” James tells us.

“Our school’s main intake starts from Year 9, so it’s not long after they start before, we have to start prepping them for their GCSEs. Office 365 and key tools like Immersive Reader are essential for helping these students to learn.”

Immersive Reader is a free tool built into many of the Microsoft Products, including Microsoft Word.

“Using Immersive Reader, students can change the style and appearance of the text to help with reading comprehension,” James explains.

“For example, you can change the font, text size, text spacing and even create a virtual coloured overlay.”

Meanwhile, Picture Dictionary, the Translate tool and Read Aloud are particularly handy for supporting EAL students.

Picture Dictionary allows students to select a word they may not understand and view an explainer image, while Read Aloud turns the text on the page into speech for the student to listen to.

Both of these, combined with the Translate tool, are invaluable when it comes to improving reading comprehension in the classroom.

“We have found that Immersive Reader is being used by all of our students, not only those with EAL and SEN. In fact, one of our GCSE students who is predicted a level 7 in English regularly uses Immersive Reader to break down texts and closely analyse them,” James adds.

Immersive Reader also enables students to highlight word types, such as nouns and verbs, as well as break sentences down into syllables, which both students and their teachers have found useful for English and language-focused subjects.

“Because Immersive Reader is already built into many of the Microsoft products, we have not had to spend any extra time rolling it out into classrooms,” he tells us.

“It’s really taken off in our school. For example, we demonstrated the tool to one student and by the next lesson, the rest of their class were using it.”

The great thing about Office 365 and Immersive Reader is that it works on any connected device. Of course, this capability is more important than ever before as we see many children learning from home.

“We love the fact that Office 365 can be accessed via multiple devices and actively encourage our students to use their own devices or one from our bank of iPads. It gives their learning an extra boost.”

To find out more about Office 365 for Education, get in touch with a member of our team today.

Teacher Guide to Presenting Remote Lessons using Microsoft Teams

In this video and guide we show you the best way to start an online lesson in Microsoft Teams. Follow the tips below if you want to control presenters and have more control over the video conference.



Tip 1 – Create your lesson in the calendar view

Creating your lesson in the calendar rather than directly from your class team channel gives you a number of benefits including:

  • Sends out an email invitation to all students
  • If students accept the invitation it will add it to their own personal outlook calendar providing structure to their day.
  • You can stop students from being presenters (and some of the disruption they could cause)

When creating the calendar invite, there is no need to add the students individually, you just need to select the class as shown below.

Schedule Lesson

Tip 2 – Stop students presenting

By default, students are also presenters which means they can share their screens and kick others out of the meeting. This may disrupt the lesson, but you can change this setting!

Save the calendar meeting and wait for it to finish setting up (it becomes bold in the calendar view).

lesson entry

Once you go back into the calendar item, you will see there are additional menu items for controlling the meeting options.

Meeting options

Select “Meeting options” and then change the presenter to “Only Me” and press “Save”.

Presenter options

Tip 3 – Mute microphones

The first 4 students who join the meeting will have their mics unmuted, use the “Mute all” button at any point during the lesson.

Mute all

Tip 4 – Share screens

Use the share button to share your screen or present an application or file.

Share screen

Tip 5 – Mention that the lesson is about to start

Mentioning the class will send them an instant notification in teams. Use it to notify them that the lesson is about to start.

Mention

Tip 6 – Record the lesson

Some students may not be able to make it to your lesson in time. Ensure no one misses out and that they can use it for revision purposes by recording the meeting.

record lesson meeting

We hope you find these tips useful. Good luck with your online lessons!

Student and Parent Guide to Microsoft Teams

We have made a quick video guide for students and parents about using Microsoft Teams from home during this time of remote learning. We hope you find it useful!



Useful PowerShell Scripts for Managing Classes in Microsoft Teams

So, you have school data sync setup and all of your class teams have been generated in Microsoft Teams. Teachers are eager to start using it for extending the classroom or remote learning. Teachers then realise that students can do things that they were not aware of and request for some rights to be restricted.

Here is a list of useful PowerShell scripts to help you manage some of the most common issues that schools face.

  • – Allow teachers to delete student messages
  • – Stop students emailing the class group
  • – Disable chat for students
  • – Calling and Live Event Policies

Allow teachers to delete student messages

It’s surprising that this is not enabled as standard. Owners in class teams cannot delete member messages unless a custom message policy is set.

Create a messaging policy in the Teams Admin centre

Create a new messaging policy and select “Owners can delete sent messages”

Create custom message policy in Teams
Owners can delete messages
Apply Custom Message Policy using PowerShell
 

This needs to be run as a global admin. The variables at the top of the script should be changed to the AAD (or synced AD) group that you want to apply the messaging policy to and the message policy name.

#Variables to change - add the AAD group and custom message policy name here
$ADSecurityGroupNameToApplyPolicyTo="All Teachers"
$customMessagePolicyName="CustomTeacherMessagingPolicy1"

# Install AzureAD PowerShell if you don't already have it - commented out below
# install-module azuread

#Import modules if you haven't already
Import-Module SkypeOnlineConnector
Import-Module AzureAD

#Connect to Skype and Azure AD
$userCredential = Get-Credential
$sfbSession = New-CsOnlineSession -Credential $userCredential
Import-PSSession $sfbSession
Connect-AzureAD -Credential $userCredential

$GroupUsers = Get-AzureADGroup -ALL $true -Filter "DisplayName eq '$ADSecurityGroupNameToApplyPolicyTo'" | Get-AzureADGroupMember -ALL $true | select mail
 
foreach ($GroupUser in $GroupUsers)
{
	$userEmail=$GroupUser.Mail
	write-host "Processing $userEmail"
	Grant-CsTeamsMessagingPolicy -PolicyName "$customMessagePolicyName" -Identity "$userEmail"
}

Stop students emailing the class group

Once a student receives a welcome message into a group, they may reply back to it or find it in the address list and start a large group email.

In the script below connect to Microsoft Exchange PowerShell. You should update the variables with an AD security group for students to apply the policy to. To ensure you only apply this to the relevant teams, use the wildcard search to filter them. In this example we are assuming teams have been named in a format of SchoolCode-AcademicYear-ClassName so we can set the wildcard to only apply this setting to Teams starting with SCH-2019.

######Replace the following variables if necessary##########
$studentADSecurityGroup ="All Students"   #AD Group for all students
$wildcardsearch="SCH-2019*"                #Wildcard for Teams display name - Search for Teams beginning with ....  
###########################################################

$MyCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $MyCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session -AllowClobber
$groups = Get-UnifiedGroup -ResultSize 20000 -SortBy DisplayName -Identity "$wildcardsearch" | Select DisplayName,WhenCreated,Id
 
foreach ($group in $groups)
{
    $teamName = $group.DisplayName
    Write-Host "restricting group emails on $teamName for $studentADSecurityGroup"
    Set-UnifiedGroup -Identity "$teamName" -RejectMessagesFromSendersOrMembers "$studentADSecurityGroup"
}

Disable chat for students

Teams is a safe environment for students to chat, chats can be audited and monitored more closely than if they where to use WhatsApp or snapchat outside of the school systems. However, there are some situations where it might require turning off for safeguarding reasons.

Create message policy in Teams admin centre
Teams message policy

Click “Add” to create a new message policy and turn off the chat setting.

Turn off chat for students


Apply Custom Message Policy using PowerShell

This needs to be run as a global admin. The variables at the top of the script should be changed to the AAD (or synced AD) group that you want to apply the messaging policy to and the message policy name.

#Variables to change - add the AAD group and custom message policy name here
$ADSecurityGroupNameToApplyPolicyTo="All Students"
$customMessagePolicyName="CustomStudentMessagingPolicy1"

# Install AzureAD PowerShell if you don't already have it - commented out below
# install-module azuread

#Import modules if you haven't already
Import-Module SkypeOnlineConnector
Import-Module AzureAD

#Connect to Skype and Azure AD
$userCredential = Get-Credential
$sfbSession = New-CsOnlineSession -Credential $userCredential
Import-PSSession $sfbSession
Connect-AzureAD -Credential $userCredential

$GroupUsers = Get-AzureADGroup -ALL $true -Filter "DisplayName eq '$ADSecurityGroupNameToApplyPolicyTo'" | Get-AzureADGroupMember -ALL $true | select mail
 
foreach ($GroupUser in $GroupUsers)
{
	$userEmail=$GroupUser.Mail
	write-host "Processing $userEmail"
	Grant-CsTeamsMessagingPolicy -PolicyName "$customMessagePolicyName" -Identity "$userEmail"
}

Calling Policies

Calling policies can be used to configure what can and can’t be done by users when calling on Teams. An example of this might be for preventing students from calling on Teams.

Calling policies can be found under Voice as shown below:

Calling Policies

These are the settings that can be applied:

Teams Calling Policy for Students

This is how we apply a calling policy:

#Variables to change - add the AAD group and custom message policy name here
$ADSecurityGroupNameToApplyPolicyTo="All Students"
$customMessagePolicyName="CallingPolicyForStudents"

# Install AzureAD PowerShell if you don't already have it - commented out below
# install-module azuread

#Import modules if you haven't already
Import-Module SkypeOnlineConnector
Import-Module AzureAD

#Connect to Skype and Azure AD
$userCredential = Get-Credential
$sfbSession = New-CsOnlineSession -Credential $userCredential
Import-PSSession $sfbSession
Connect-AzureAD -Credential $userCredential

$GroupUsers = Get-AzureADGroup -ALL $true -Filter "DisplayName eq '$ADSecurityGroupNameToApplyPolicyTo'" | Get-AzureADGroupMember -ALL $true | select mail
 
foreach ($GroupUser in $GroupUsers)
{
	$userEmail=$GroupUser.Mail
	write-host "Processing $userEmail"
	Grant-CsTeamsCallingPolicy -Identity "$userEmail" -PolicyName "$customMessagePolicyName"
}

Live Event Policies

Live Event policies might be used restricting who can attend or record them live events.

Live event policies can be found under Meetings as shown below:

Live Event Policies

These are the options when setting up a Live Events policy.

Teams Live Event Policy for Teachers

This is how we apply a Live Event policy:

#Variables to change - add the AAD group and custom message policy name here
$ADSecurityGroupNameToApplyPolicyTo="All Students"
$customMessagePolicyName="LiveEventPolicyForStudents"

# Install AzureAD PowerShell if you don't already have it - commented out below
# install-module azuread

#Import modules if you haven't already
Import-Module SkypeOnlineConnector
Import-Module AzureAD

#Connect to Skype and Azure AD
$userCredential = Get-Credential
$sfbSession = New-CsOnlineSession -Credential $userCredential
Import-PSSession $sfbSession
Connect-AzureAD -Credential $userCredential

$GroupUsers = Get-AzureADGroup -ALL $true -Filter "DisplayName eq '$ADSecurityGroupNameToApplyPolicyTo'" | Get-AzureADGroupMember -ALL $true | select mail
 
foreach ($GroupUser in $GroupUsers)
{
	$userEmail=$GroupUser.Mail
	write-host "Processing $userEmail"
	Grant-CsTeamsMeetingBroadcastPolicy -Identity "$userEmail" -PolicyName "$customMessagePolicyName"
}

Update 11/11/2020: We have been informed that you may need to connect to Teams PowerShell to run these commands rather than Skype on some tenants (Connect-MicrosoftTeams).