Enrollment File
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.