Tag Archives: Microsoft

Bett 2020

Cloud Design Box will be exhibiting at Bett 2020 from Wednesday 23rd January until Saturday 15th January 2020 on stand NQ21. Bett is the global meeting place for education buyers and it’s mission is to create a better future by transforming education and bringing together over 800 leading companies and over 34,000 visitors.

We will be opposite the N4 entrance in the North Hall (near the Tablet Academy escape room).

Tony, Darren, Joanne and Lloyd will be on the stand each weekday. Will, Lloyd and Tony will be around on Friday and Saturday.

We will be sharing a stand build with our partners SalamanderSoft. Speak to them to find out more about Active Directory automation from MIS data plus many more tools. You can find out more information on their website.

The team will be demonstrating our SharePoint and Teams solutions. For current customers, we will show you new features set to be released later this year including Teams assignment analytics and our new admin interface to create intranet sites.

If you don’t get chance to see us, feel free to get in touch for a chat and online meeting on our website.

Bett 2020 SharePoint Teams Education

End of Year Rollover Process in Microsoft School Data Sync

Lots of new and exciting features are coming to Microsoft Teams this summer, so get ready for the new academic year in advance and resolve any issues before the students are back.

I’m beginning the process of rolling over the academic year at many schools this month using Microsoft School Data Sync with the Cloud Design Box team. We have come across a few issues along the way. For the administrators out there trying to complete this process on their own, we thought it would be great to share our experience in the form of this video guide taking you through the process.



Before you begin the process, talk to SLT and teachers about the preferred clean-up options.

Expire All Classes

Adds a prefix to the start of the class name in this format: EXPMMYY. If you already prefix your classes with the academic year then there isn’t any reason to run this option.

Archive All Classes (recommended)

Archive makes the Team read-only. Teachers can restore a Team for a class and it will work as it did before. We recommend selecting this option so that teachers don’t have a long list of classes in the new academic year. If you have a course which lasts for two years, teachers can restore the class from the previous year and continue to use it; but it will no longer be updated with live MIS data.

Remove Students from All Classes

This removes students from class notebooks and all student data from assignments. This is non-reversible and therefore we do not recommend this choice.

A few issues to be aware of (which we cover in the video above):

  • Some classes will fail to clean-up – you will have to do these manually.
  • You may need to refresh the profile page if you get stuck on an error when starting the new term.
  • Occasionally a clean-up process may get stuck processing forever. If it lasts longer than 24 hours, log a support call with the Microsoft Education team.

We hope this video helps you out. Please feel free to share your comments, wins and frustrations with the process in the comments below!

Adding Announcements in Microsoft Teams for Education

In this video, I explore the new announcement feature in Microsoft Teams. It’s part of a big education release this summer, we will keep you posted on the latest developments!



Microsoft Teams for Education Released

Class teams are now available inside Microsoft Teams. These are created automatically using School Data Sync (SDS) or can be created manually in the Teams interface.

Microsoft Class Teams

Teams is a great collaboration interface that pulls together instant messaging, videos calls, SharePoint, OneNote and assignments into one place. It can also be extended with custom tabs.

I’ve created a quick video review below.



There are some similarities to Microsoft Classroom, however some functionality is different. A few issues with Class Notebooks in Teams:

  • Student sections menu not visible
  • Missing the Class Notebook tab to distribute pages and sections
  • Immersive reader option missing from view tab

You can get around these issues by opening the Team’s SharePoint site and clicking “Notebook” inside SharePoint. Hopefully Microsoft will be quick to resolve these issues.

Microsoft Classroom had a mobile app for Android and iOS which gave students notifications when new assignments were posted or graded. It also allowed students to set reminders for homework. The Teams mobile app does not include the assignment section at all so no notifications for students or teachers. The assignments are not visible on mobile devices. Again, this is early days and I expect Microsoft to release this functionality in the not too far future.

Microsoft Teams for education replacing Microsoft Classroom Preview

Over the last few months, we have received lots of positive feedback about the new Microsoft Classroom Preview product. Today Microsoft announced in the Office 365 message centre that this would be replaced at the end of July 2017 with Microsoft Teams for Education.

Microsoft Teams for Education

No need to panic, MS Classroom functionality will still exist but in the Microsoft Teams app (from what we can see from the screenshots). You can still set assignments, create class notebooks, discuss, share files and quizzes but it will all be accessed through the Microsoft Teams interface rather than through the MS Classroom App. There is no news on the Microsoft Classroom mobile app for iOS and Android but hopefully this will be replaced so that students can still get notifications for new assignments and grades.

More details can be found on Microsoft’s site here.



You may have seen the following message in the Office 365 message centre, notifying you of the change.

On July 31, 2017, we’ll discontinue support for the Microsoft Classroom Preview, as we work to unify our classroom experiences in Microsoft Teams in Office 365 for Education. Since the Microsoft Classroom Preview released, we’ve been very thankful for schools’ feedback from around the world; which has helped us improve benefits and features of the service. Ultimately, we learned to keep it simple and put classroom resources all in one place. We listened and we’re bringing the best of the classroom features (e.g., Assignments and OneNote Class Notebook) to Microsoft Teams in Office 365 for Education.

How does this affect me?

– Microsoft Classroom Preview will continue with current functionality until July 31, 2017. – Teachers will not be able to create new notebooks or assignments after the July 31, 2017. – Current classes and associated content will continue to be available as Office 365 Groups. Teachers can access assignment resources, files, calendars, and conversations, through tools such as Microsoft Outlook and SharePoint Online. If necessary, they can copy Class Notebook content to their personal workspace (e.g. OneDrive for Business). – When the new class experiences become available in Teams, School Data Sync will start creating the new classes for Microsoft Teams. SDS will continue to sync existing Microsoft Classroom Preview classes through July 31, 2017.

What do I need to do to prepare for this change?

We apologise for any inconvenience resulting from this transition. We encourage you to try out Microsoft Teams, and get yourself familiar with the Teams experience. Please click Additional Information to learn more.

Microsoft Classroom Webinar

I would like to thank everyone who took part in today’s webinar on Microsoft Classroom by Cloud Design Box.

In the session, we covered:

  • How to get Microsoft Classroom
  • How to create a new class
  • Using OneNote Class Notebook to enhance teaching and learning
  • Setting assignments
  • Marking and returning student work
  • Using the mobile apps
  • How to access School Data Sync (SDS)

The session was recorded for all those who missed the session.



I hope everyone found the session useful. We will be putting on additional webinars and live events later this year. Please follow us on Twitter for the latest updates.

Saving Tweets to Excel using Microsoft Flow

Microsoft Flow is the new tool integrated with Office 365 which allows different services to interact. Such as social media providers like Twitter and Facebook or file sharing platforms like Dropbox, OneDrive and Google Drive, and many more services.

I wrote a blog post earlier this year about integrating machine learning tools and another post about syncing Google calendar data into SharePoint using Flow processes, but I thought I would get back to basics and provide a clear easy tutorial for Microsoft Flow newcomers.

In this example, I’m going to setup a Flow to put all the tweets made from the company (my) twitter account into an excel spreadsheet. This is a simple process but might be useful for keeping track of marketing or even leaving an audit trail of marketing activity by the social media owners within an organisation. The excel spreadsheet will sit in OneDrive for business but you can determine where you would like it stored.

To start, we are going to create a new excel spreadsheet with a table. In OneDrive for business, create a new excel spreadsheet called “tweets”.

Microsoft Excel Online

Add the following column headers:

  • Tweet Text
  • Location
  • Time

Select the column headers and in the insert menu, select “table”. This will make a new table in Excel which Flow can access to add rows.

Open Microsoft Flow. The Flow icon should be available in your Office 365 App Launcher if you have the licence enabled (alternatively you can just go to the website).

Search the templates for “Twitter”, and select the “Save tweets to an Excel file” template.

Microsoft Flow Templates

You will then be required to login to Twitter and Excel. When logging into Excel, make sure that you sign into OneDrive for Business with the correct account (otherwise you will get unauthorised access when trying to add rows). When both services are signed in, press continue.

Twitter trigger

In the twitter trigger, add the twitter account name to the search text box. This will fire off the process when that account tweets.

Excel action

In the insert row action, find the tweets excel spreadsheet in your OneDrive for Business by using the folder icon. The table will appear automatically under the Table name drop down. You can then select each column and add the appropriate tweet field.

Save the Flow and check that it is enabled.

In twitter, send a tweet from your account.

Twitter tweet

The Flow will run every 60 seconds, you can check the runs by clicking on the “i” icon next to the Flow and then filtering by “Checks (no data)”. After a couple of minutes, your spreadsheet should be updated with the tweet data!

Excel populated with tweets from MS Flow