Microsoft School Data Sync simplifies class management in Office 365. Using exports from Compass, you can populate your Office 365 tenant with Students, Staff, Subject and Class information for use in applications such as OneNote and Teams.
To be able to access the export in Compass, you will require the SubjectsAdmin permission.
For information on assigning permissions in Compass, please refer to the 'Permissions' article from our Knowledge Base.
Under the 'Teaching and Learning' menu (pencil icon), select 'Subjects and Classes'.
On the 'Subjects and Classes' page, click 'Exports'.
Select the 'Microsoft SDS' export.
Select the Fields and Parameters for the export.
Field Definitions
Import Identifier | Student ID |
SUSSI ID | Compass code/Network ID/LDAP username |
School email | |
GovCode1 | VSN/CEIDER/Field below DOB (based on your school's jurisdiction) |
Student CSV
Student Identifier = SIS ID within Office 365, this is typically their timetable code
Student Username = Students Office 365 username, this is typically their email or LDAP username
Teacher CSV
Teacher username = Staff Office 365 username, this is typically their email.
Section CSV
It is recommended to use Class code for both Section Identifier and Section Name.
If you do not see this export option in Subjects and Classes, please contact the Support team via support@compass.edu.au to have this feature enabled.
For instructions on uploading the Microsoft CSV files to your Office 365 environment, please click here.
School Data Sync will create classes as Office 365 groups. Teachers can then create Teams, click here for details on that process. If the School Technician wants to automate that on behalf of Teachers, click here for a sample script available on github they can use.