Category Archives: OneDrive for business

The benefits of Office 365 and SharePoint in education

There’s no denying that Office 365 now provides a fantastic integrated suite of products. Why should schools and colleges look at moving to Office 365? Can it save time, money and improve student engagement? Let’s take a look in more detail.

Why is cloud storage important?

Office Integration
Office 365

One of the big benefits of using Office 365 (in general), is the close integration with Office Online. The days when students had to install Office on a PC or be restricted to an OS or desktop device are long gone. Office 365 brings Word, Excel, PowerPoint, OneNote and Sway to all devices. Office 365 licencing also means that students can download the full version too.

Access on any device

Can your students access all the lesson resources, shared drives and personal drives on their mobile and tablet devices at home? Only Google and Microsoft provide realistic solutions. Both are free for schools, but both require some setup and modification to make them suitable for each individual school.

Students are far more likely to access resources on mobile or tablet devices. In fact, many will never want to own a laptop or desktop computer. In addition to this, teachers are more reliant on using personal tablets and phones to access resources. The OneDrive for Business app allows students to search and navigate through all the shared resources from their phone and tablet.

Document management
Office 365

Remember accidentally losing a file? It would involve a call to the IT department who would then be searching through backups trying to locate the correct file. OneDrive and SharePoint both have a recycle bin, so you can restore documents for 93 days after the original deletion date. If you delete it from the end-user recycle bin, your IT admins can get it back from the site collection recycle bin (within the 93 days). Even after the 93 days, you can call Microsoft who can sometimes help you get older files back.

What if someone saves over a document or a mistake is made? Every document has version history by default, so you can easily go back to a previous version of the document.

Live collaboration and co-authoring

One of the most impressive features of SharePoint to demonstrate is the ability for multiple users to work on the same document at the same time. It could be a lesson plan in a Word Document, a marksheet in excel or a presentation in PowerPoint. These products provide co-authoring in a slick and easy-to-use way. The paragraph, cell or slide will lock and all users will see the editing live (see below).

Remember when marksheet spreadsheets were locked for editing when trying to open on the school servers? You don’t have that problem in SharePoint, you can work quicker and more efficiently saving precious time that teachers don’t have enough of.
co-authoring
Co-authoring in Office 365

What about homework and electronic assignments?

SharePoint is a great document management system but what about assignments and grading work? For homework and assignments, Office 365 has a range of built-in and third-party products to provide assignment functionality.

Microsoft Teams is also free for education and comes with some built-in assignment tools. These are great basic assignment tools ideal for keeping track of homework. Teams integrates with SharePoint, so you can access all your class and shared resources.

Microsoft Teams
Assignments in Microsoft Teams

Class Notebook is a powerful learning tool with individual student sections, an immersive reader, and tools to distribute and collect work.

OneNote Class Notebook
OneNote Class Notebook

If you want some more in-depth assignment tools, third-party products such as teacher dashboard, firefly, show my homework and many more come with Office 365 single sign-on. Store your resources in SharePoint and use any other application for assignments. Please note that not all these third-party products will allow students an easy way to create and submit office documents.

At Cloud Design Box, we can help you implement Teams with MIS data, create SharePoint resource areas, apply custom branding, training, support, workflows and much more! Contact us via the website for more details.

SharePoint by Cloud Design Box
SharePoint Design by Cloud Design Box

SharePoint Virtual Summit 2017

The 2017 SharePoint virtual summit took place last week. The previous year had seen a brave new bold redesign of SharePoint into a modern experience. This year we had exciting new announcements building on last year’s vision.

New OneDrive and SharePoint Sync Client

The new version of OneDrive sync client will map out the entire contents of SharePoint and OneDrive libraries without syncing them across. Documents will only be synced when requested on-demand or when a document is opened and edited.

OneDrive Files On Demand

This is great news and solves two problems faced by OneDrive users:

  • Large OneDrive/SharePoint libraries consumed large amounts of local storage syncing across
  • Possibility of errors when large numbers of files synced at once

A new unified sharing interface will be rolled out across OneDrive and SharePoint for a simpler experience. This feature will also be available in windows explorer.

SharePoint Virtual Summit

Communication portals

SharePoint released a new experience team site last year. It has now matured with developers creating third party web parts using the SharePoint Framework. Microsoft have now released a new type of site called a communication portal. This site replaces the older publishing sites used for company intranets. Although the new site is responsive out-of-the-box, we can now apply custom branding and functionality extending this into a true intranet experience.

SharePoint Communication Portal

Integration with Flow and PowerApps

These two new Office 365 apps are gaining momentum as modern replacements for SharePoint Designer Workflows and InfoPath Forms Designer.

Microsoft Flow creates workflows that can integrate with almost any product including Google Calendar, Twitter, Slack and a whole host of other services. Flow will have tighter integration with SharePoint and Flows can be created directly from list views.

PowerApps empowers users to create useful mobile friendly apps with no code for SharePoint and OneDrive. This has now been extended to integrate directly into a SharePoint page. PowerApps can now act as the custom form for SharePoint list data. This was a task previously done using InfoPath Designer or custom code.

SharePoint with PowerApps and Microsoft Flow

There was also news of a more powerful personalised search and much more. You can read the Microsoft review from Jeff Teper here.

So, it’s another exciting year ahead for the SharePoint and Office community!

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