Using Power Query in Excel 2016 To Ready CSV Files for Student Data Sync (SDS)

Student Data Sync, or SDS, is a core tool from Microsoft that helps schools prepare their student, teacher and class data ready for use in great platforms such as Teams for Education (formerly Microsoft Classroom) and Intune for Education.

In countries outside of the USA (where API exist), schools need to prepare six CSV files containing the relevant information from their Student Management System (SMS). Fortunately, Microsoft has provided some sample scripts and files (along with a toolkit to verify your data integrity) to help.

SDS

Student Data Sync is the starting point to creating a correlation or framework that connects your students, teachers and classes together in a meaningful way, allowing you to leverage cloud based tools more efficiently.

However, often the challenge lies in the format of the exported data from the school’s SMS. This is where Grant Saul, the Director of ICT from Westlake Boys High School has powerquerystepped in and provided a fantastic tutorial on how to use Power Query, a tool that comes in Excel 2016, to tidy up the format of your source data and prepare it for import with Student Data Sync.

In Grant’s example, he takes a standard export from Kamar (a very popular New Zealand SMS) and shows how it can be transformed using Power Query into the correct format for importing into SDS. You can read his original post here (and I encourage you to do so) whilst watching his screencast below:

The great feature of Power Query is it records each step in the data transformation, allowing you to easily replicate / replay the changes when the source data is refreshed, creating a super efficient method of managing your data.

For schools that want to use Microsoft SDS this is a very helpful guide.

Support Deploying Microsoft SDS

sds-support

If you’re a school that is needing some help deploying Microsoft Student Data Sync (SDS) then you can apply for one on one support for a limited time here:

http://concise.info/SDS-help

I posted some additional resources if you want to DIY that you can access here. SDS is being used increasingly across a range of Microsoft tool sets and will enable you to synchronise data with the recently announced Intune For Education.

Intune For Education Announced at BETT

This week Microsoft has released some major announcements at the annual BETT Show in London. You can read the full announcements on the official blog here, however the one that caught my attention the most was Intune For Education:

microsoft-tries-expelling-chromebooks-from-schools-with-intune-app-and-low-cost-pcsFor me, this is a key solution for schools to consider to simplify the management of Windows 10 devices, particularly for those schools that may not have dedicated ICT staff. The things that impressed me were:

  • It’s cloud based, there is no need to install locally as it is hosted in Azure and is scalable, making it suitable for schools of any size whilst remaining simple enough for part-time ICT admin staff to use.
  • There are a number of school-specific policies pre-configured to promote security for school devices (there are over 150 settings you can configure if you choose)
  • There is an express setup for schools that allow for quick deployment of new devices for different groups of users.
  • Your list of purchased applications in the Microsoft Windows Store For Business are automatically synchronised to Intune For Education allowing to easily choose which apps you wish to deploy e.g. Minecraft licensing in the Business Store.
  • There is an auto-enrollment feature meaning students or staff automatically receive the apps specified by the school when they first log in.
  • intune-for-education-set-up-pcs-100705444-largeFor super quick deployment there is free access to the “Schools Setup PC App” that creates a USB key to quickly configure common settings on a new device with a single key press – no need to get it on the wireless network first!
  • Intune for Education supports Student Data Sync to automatically create groups of students/teachers for customised group permissions allowing more granular control over policy.
    • Policy will “follow the user” so if you have different policies for different year levels, these will automatically apply as a student moves from year to year.
  • There is a test/assessment mode. Students can log in with a special account to be used when taking assessment which will lock the device down to pre-defined access levels.

These features represent a significant leap forward with technology offerings for managing Windows 10 devices in education. To learn more, check out Microsoft Education.

Update: A couple more videos showing how Intune for Education can be used, along with the benefits of Digital Inking:

Microsoft Classroom & SDS – Some Useful Resources

classroom

Microsoft Classroom

A number of schools are exploring how they can use the Microsoft Classroom platform to integrate with their teaching and assessment as they are already using Microsoft OneNote Classroom Notebooks.

UPDATE: I’ve found this dedicated blog on how teachers can use Microsoft Classroom – could be a good starting point:

http://microsoftclassroomguru.com/

To get a good understanding of what School Data Sync and Classroom actually are, then this is probably a good high level overview to start with. Thiis is a slightly more technical description in an Office Mix

I’ve pulled together some useful resources to assist teachers getting started:

Here is one example of a school using SDS and Office365 to support improved learning outcomes: