Local Data Storage

Teacher Roster

This screen provides functionality for managing the teacher roster. You can view and manage basic information such as each teacher’s name, email ID (OneID), subject, and assigned class. The email ID (OneID) is used for Google Workspace and Microsoft 365 accounts. Additionally, class information is utilized for creating class groups in both platforms and is also used when generating student rosters in bulk based on class details and student counts. By using the Google ID Match and Microsoft ID Match features, you can retrieve user IDs from the cloud (Google Workspace, Microsoft 365) that match the names in the teacher roster and display them on this screen.

ClassSync Teacher Roster Management screen

Student Roster

This screen provides functionality for managing the student roster. You can view and manage information such as student ID, name, email ID (OneID), assigned class, and grade level. It includes the default input fields for School Data Sync (see: Default list of values – School Data Sync | Microsoft Learn). The student roster serves as key data for Google Workspace and Microsoft 365 accounts, class group creation, and Classroom/Teams synchronization. Additionally, by using the Google ID Match and Microsoft ID Match features, you can retrieve user IDs from the cloud (Google Workspace, Microsoft 365) that match the names in the student roster and display them on this screen.

ClassSync Student Roster Management screen

Class Roster : Manage rosters based on established classes and courses

This screen manages rosters based on the established classes and courses, with class information mapped from the teacher roster. It is utilized for subject-level data mapping when generating Microsoft SDS CSV files. Additionally, the roster is used for synchronizing Microsoft Teams class teams and Google Classroom classes.

ClassSync Class Roster Management screen

Enrollee Roster : Manage rosters based on established courses and enrolled students

This screen manages rosters based on the established courses and the students enrolled in them. The roster is utilized for subject-level data mapping when generating Microsoft SDS CSV files and is also used for synchronizing Microsoft Teams class teams and Google Classroom classes.

ClassSync Enrollee Roster Management screen

SDS V2.1 CSV File Format (Save to the folder selected by the user)

This screen provides functionality for generating CSV files in the Microsoft School Data Sync (SDS) v2.1 format. In the upper section, you can configure the school year, school name, school ID, domain, and academic session dates (start and end). There are options to add subject teachers directly to Teams class teams and to include class rosters or enrollee rosters. After completing the settings, clicking the Create SDS Files button generates CSV files compliant with SDS standards. The lower section displays the list of generated files, which include:
orgs.csv, users.csv, roles.csv, classes.csv, enrollments.csv, courses.csv, academicSessions.csv , relationships.csv, demographics.csv, and userflags.csv. A search bar on the right allows you to quickly locate specific files.

Microsoft School Data Sync V2.1 CSV generation screen

Unified Roster Management

ClassSync enables schools to manage teacher, student, and class rosters internally, automatically generating Microsoft SDS CSV v2.1 files.
These files can be uploaded to Microsoft School Data Sync to synchronize Teams class teams.
Additionally, the Google Classroom Sync feature connects to the SDS CSV v2.1 files as a data source to synchronize classes in Google Classroom.
Administrators can view class lists, archive or delete classes—all through an intuitive interface.

Unified Roster Management with School Data Sync

1. Support for Microsoft School Data Sync (SDS) CSV v2.1 File Format

1-1. Create School Data CSV v2.1 Format Files

Create School Data Sync CSV v2.1 files

School Data CSV v2.1 Format Files

1-2. Upload SDS CSV v2.1 files in Microsoft School Data Sync

Upload SDS CSV v2.1 files in Microsoft School Data Sync

Select SDS CSV v2.1 files

Upload SDS CSV v2.1 files

2. Create Google Classroom classes with SDS CSV v2.1 files

Google Classroom Sync is a feature that automatically creates and manages Google Classrooms based on your school’s class data. By loading SDS (School Data Sync) files, you can review class information and create or update Classrooms with just one click. It also allows you to archive or delete existing Classrooms and export data to CSV for efficient management.

Create Google Classroom classes with SDS CSV v2.1 files

Key Features:

  • Automatically create and sync Google Classrooms by class
  • Integrates with SDS (School Data Sync) for accurate data mapping
  • Archive or delete existing Classrooms easily
  • Export data to CSV for backup and reporting