Guide for preparing the ‘Student List’ table in Excel
You need exactly these 6 columns: schoolCode, schoolYear, classCode, lastName, firstName, sex.
① schoolCode: 5 capital letters (e.g., 'SSMKR'). ② schoolYear: enter like '25 Fall' (space between year and semester).
③ classCode: one letter + two digits ('a01'). ④ lastName ⑤ firstName ⑥ sex: M / F / U.
Korean names are supported in lastName and firstName. Enter each student's roster name exactly as you want it to appear.
The system will auto-generate prepNum (temporary password) and studentID.
Note: Clicking Generate & Register Student List will also save the roster(s) to Firestore (no separate Register step).
| schoolCode | schoolYear | classCode | lastName | firstName | sex | prepNum | studentID |
|---|