Tag Archives: Schools

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.

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.

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.

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).

Office 365 User Adoption Episode 8: School Leadership with Microsoft Teams

We’ve spoken a lot on this blog and in our podcast about how Microsoft Teams and SharePoint transforms the classroom, from sharing class resources with pupils to improving student engagement with Digital Ink and Class Notebook.

However, there are also many opportunities to use these tools to drive School Leadership Teams.

We spoke with Gareth Rose, Assistant Headteacher of Notley High School & Braintree Sixth Form to see how their School Leadership Teams, Heads of Faculty and Subject Leaders use Microsoft Teams and SharePoint.



“SharePoint is a brilliant tool for sharing files. And, while it has a lot of collaboration tools within it, we find Microsoft Teams the easiest way to co-author documents used and created by the School Leadership Teams (SLT),” explains Gareth.

“We have five core Teams: one for SLT, one for the admins who support SLT, a data admin team and a pastoral middle leadership team that includes SLT and the Heads of Houses.”

A Team acts as a central hub for collaboration – a place where you can talk with Team members, share and co-author files and keep meeting minutes all in one place.

“To keep everything connected with our SharePoint site, Cloud Design Box has set it up so that users can access the relevant Teams from their SharePoint mega menu.”

School Leadership Teams Heads of Faculty and Subject Leaders use Microsoft Teams and SharePoint

Within each Team, Notley High School has private channels where only specific people can access files and conversations. Private channels in Teams can be controversial as many believe you should simply set up a new Team if a private channel is required.

But, as Gareth explains, it’s a structure that has really worked for them:

“If we set up a new Team every time we need a private channel, we’d have far too many Teams with them all linking off in different directions. With our structure, everyone can access, view and edit the files applicable to them.”

To further simplify processes, Gareth has maintained one rule: SharePoint is for sharing finalised documents and Teams is for collaborating on WIP files.

“All the work-in-progress documents are stored within their corresponding Teams, where they can be accessed and edited by the right people. It’s only when they’re finished that they can be released into SharePoint,” he tells us.

“We have a one version policy – if the file is being worked on, it’s in Teams, and if the file is finalised, it’s in SharePoint.”

It’s easy to see why Notley High has chosen this method of working. This is a great example of Office 365, SharePoint and Teams adoption that shows how the products can be used by the school leadership to work together more dynamically, keeping everyone on the same page and everything in one place, without having to waste time copied into unnecessary emails.


Watch the full Office 365 User Adoption podcast on School Leadership with Microsoft Teams on our YouTube Channel.

Meanwhile, if you would like to discuss adopting SharePoint, Office 365 or Microsoft Teams for your school or multi-academy trust, speak with a member of our team today.


Cloud Design Box

Class Teams Activation

All Class Teams provisioned by Microsoft School Data Sync are now deactivated for students. This means the students can only access the team once the teacher has pressed the activate button.

Activate Class Team

Monitored Conversations

One huge benefit is that students cannot have conversations in the team until it becomes activated. When hundreds of teams are created for each school every academic year, it’s hard to monitor all of them. With this new setting, teachers only have to monitor the conversations in teams that they have activated.

Prepare Class Teams in Advance

The activation step allows teachers to prepare content in the team before it goes live to students. Prepare your class notebook and assignments in advance before activating it at the start of term.

How to Activate the Team

It’s really simple, just click the “Activate” button shown below and confirm. Students will then have instant access to the team.

Activation

If you need help automating Microsoft Teams from MIS data and getting good user adoption in the classroom, contact us at Cloud Design Box.

Transform Student Engagement with Digital Ink

Guest post by Courtney Farrow with video by Tony Phillips

With 98% of classrooms now using computers, laptops and tablets, it’s safe to say that digital learning is here to stay.

However, many teachers still find themselves chained to their desktop computers, whiteboards and paper notebooks, unable to invest time and energy into making lessons more engaging, diverse and dynamic.

Does this sound familiar?

If so, Digital Ink in Microsoft’s Class Notebook could transform the way you teach.

Combining the traditional hand-written word with the power of digital technology, Digital Ink has improved the quality of the curriculum for 90% of teachers who have used it.

On top of this, schools say that Digital Ink saves time, increases engagement and class management, creates more personalised learning environments where students can get authentic, timely feedback from their teachers.

Today, we’re taking a closer look at some of the proven benefits of Digital Ink in the classroom.

Save time.

One of the main advantages of Digital Ink is that it saves time, which will probably be music to every teacher’s ears.

In fact, 67% of teachers who used the product said that it saved them precious time when preparing lessons, allowing them to access pre-prepared resources quickly, without having to redraw or re-write everything the class needs to see on a whiteboard.

One teacher explained:
“When I taught geometry and got to the question that nobody in the class understood, I had to stop the lesson and draw on the whiteboard. It took five minutes, and then I had to add labels. Only after all this, could I finally start talking about how to solve it.”

With Digital Ink, any lesson resources can be prepared in advance and reused over and over again, without having to erase and recreate it the next time you cover the topic.

Meanwhile, half of teachers have found that it saves time marking and grading pupils’ work. There will be more detail on student feedback with Digital Ink later in this blog post.

Improve the quality of lessons by unchaining the teacher from their desk

Most teachers who have used Digital Ink have said that it allows them to be anywhere in the classroom – without being tied to the front desk – enabling them to manage the class and engage the students in the work that’s appearing on the smartboard.

Thanks to the connectivity between student and teacher devices, children can be interacting with what is being displayed on the smartboard within seconds.

A more personalised learning environment.

Real-time collaboration between students and their teachers allows learning to continue outside of the classroom.

Around 50% of teachers have said that the technology increases the quality of communications with students.

Authentic and timely student feedback

Because of increased communication in and outside of the classroom, digital ink has transformed the way teachers give feedback to pupils.

You can quickly and easily annotate a piece of work, feeding back to students instantly and supporting them when they need it, rather than days after they need it.

As with all Microsoft Office 365 products, everything is saved automatically and in one place. One key benefit several teachers have pointed out is that Digital Ink lets teachers give feedback during the school day, or even during the actual lesson, rather than waiting until they get home.

In the video below, Cloud Design Box Founder Tony Phillips walks you through some critical uses of Digital Ink in the classroom, including student feedback and annotations, ink-to-text capability and solutions and steps for Math equations.



*All statistics and research mentioned in this blog post was taken from Digital Ink in the Classroom – Authentic, Efficient Student Engagement, an IDC InfoBrief, sponsored by Microsoft. IDC conducted a research study with 685 teachers who are using computers in the classroom to understand their classroom technology usage, and specifically how they are using Digital Inking devices.

Resources:

onenote.com/ink
digital ink in the classroom authentic efficient student engagement
White Paper: Power Digital Inking Classroom