Overview of School Data Sync and Classroom

Note: This topic is pre-release documentation and is subject to change in future releases.

Microsoft has several tools you can deploy to help you import and use Student Information System (SIS) data in classrooms:

  • School Data Sync helps you import Student Information System (SIS) data into Office 365.

  • Microsoft Classroom is a customized website that lets you organize effective use of Office 365 services in your classroom.

School Data Sync

School Data Sync helps to automate the process of importing and integrating school Student Information System (SIS) data to use with Office 365 education aids, like Microsoft Classroom and OneNote Class Notebooks.

The tool also gives application developers a single cloud API to use for creating applications that integrate with multiple SIS providers, along with single sign-on (SSO) capabilities. For example, app developers can use the API to access class roster information to personalize experiences for teachers and students who use their apps.

Microsoft Classroom

Microsoft Classroom is a single experience for managing all classes and assignment workflow for teachers and students. Teachers can use the Office documents and class materials they already have, or create new ones using familiar Office applications like Word and PowerPoint. Classroom lets teachers create a Class Notebook for all the students in their class quickly. Assignments in Classroom can reference materials from the Class Notebook, Office documents, and links to Internet content. Teachers can create assignments for multiple classes at the same time, easily grade submissions, and give private feedback.

For more support documents about Microsoft Classroom, please visit https://aka.ms/classroomsupport. To learn more about Microsoft Classroom, please visit http://classroom.microsoft.com.

Choose a deployment method

There are several methods available for syncing SIS information with Office 365: Using CSV (comma separated value) files, using PowerSchool API, using Clever API, or using OneRoster. Regardless of the method you choose, the same requirements apply.

Requirements

  • Your Office 365 tenant must be an Office 365 Education tenant.

  • Synced identities must be licensed for SharePoint Online and Exchange Online. Skype for Business licenses aren't required. Note that OneDrive for Business is provided through the SharePoint Online license.

    If a student or teacher doesn't have the required licenses in Office 365, School Data Sync will still create their profile, but Classroom will not finish provisioning properly for them for any apps they aren't licensed to use.

  • If you're not setting up an Office 365 tenant that will use synced identities, you can just create new cloud identities for teachers and students and license them for services when you set up their profiles.

Deployment methods

  • Deploy School Data Sync by using CSV files

    You can use CSV (comma separated value) files with School Data Sync (SDS) to synchronize your School Information System (SIS) users with Office 365. If you use this method, you'll need six separate CSV files based on your SIS data, to set up the synchronization profile. You'll create the files, and then upload them into School Data Sync for processing.

    Follow these steps to deploy School Data Sync by using CSV files.

  • Deploy School Data Sync by using PowerSchool Sync

    PowerSchool Sync is an SIS provider that works with School Data Sync to help import student and teacher information into Office 365. SDS connects by using the REST-based APIs provided by the PowerSchool SIS system, and then creates the Office 365 profiles. There's a set of required attributes that you must map to Office 365. With this method, you can avoid creating CSV files and manually extracting data from the SIS databases.

    Follow these steps to deploy School Data Sync by using PowerSchool Sync.

  • Deploy School Data Sync by using Clever Sync

    Clever Sync is an identity management and rostering solution that works with School Data Sync to help import student and teacher information into Office 365. SDS connects by using the REST-based APIs provided by the Clever system, and then creates the Office 365 sync profiles. With this method, you can avoid creating CSV files and manually extracting data from the SIS database or Clever system.

    Follow these steps to deploy School Data Sync by using Clever Sync.

  • Deploy School Data Sync by using OneRoster

    You can use OneRoster CSV (comma separated value) files with School Data Sync to synchronize your Student Information System with Office 365. If you use this method, you'll need to generate the full set of OneRoster CSVs, run them through a conversion process, and then upload them into SDS to enable synchronization into Office 365.

    Follow these steps to deploy School Data Sync by using OneRoster.

See Also

Overview of School Data Sync and Classroom

CSV files for School Data Sync

School Data Sync required attributes for PowerSchool Sync

School Data Sync errors and troubleshooting

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×