The enrollment file is used to assign students to their respective classes. Below are the requirements and formatting details for creating a valid enrollment file.

Required Columns

  • StudentID - Identifies the student; must match the StudentID in the student file.
  • ClassID - Identifies the class; must match the ClassID in the class file.

Important: Ensure the column titles exactly match those listed above.

File Format

  • File Type: Tab-delimited text file (*.txt or *.tsv).
  • First Row: Must contain column headers.
  • Example Tools: Export from Excel or Google Sheets as Tab-delimited Text.

Import Options

Option 1: Multiple Rows per Student

Each row lists a single StudentID and one ClassID. If a student is enrolled in multiple classes, they will have multiple rows.

TEMPLATE:

StudentID

ClassID

123

Math

123

English

124

Science

Option 2: One Row per Student

Each student has one row, and their classes are listed in separate columns (ClassID1, ClassID2, etc.).

TEMPLATE:

StudentID

ClassID

ClassID

ClassID

123

Math

English

History

124

Science

Math


The Enrollment File assigns students to classes within a specific event. The students and classes referenced must already exist in the system from the Student and Class files.

Where to Check Imported Enrollment Data in the Admin UI

  • Open the event in the Admin UI.
  • Go to the Class Editor tab.
  • Select a class to view the enrolled students.
  • Ensure that all expected students are assigned to their correct classes.