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 (Capitalized) ⑤ firstName (Capitalized) ⑥ sex: M / F / U.
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).
MoveOut Student
Tip: Options are current registered students (not yet moved out). Selecting a student records the Out date and notifies ClassOrgan.
Pending uploads
Tip: Upload one file per class (each file must contain exactly one classCode).
| schoolCode |
schoolYear |
classCode |
lastName |
firstName |
sex |
prepNum |
studentID |
Diagnostics (auto logs events)
Class Manager (Activity Control)
Each row represents a (Class, Activity). Click the Status to progress: INACTIVE → ACTIVE → ENDED. This writes to the classManager collection.
| teacherEmail |
classCode |
activity |
status |
startedAt |
endedAt |