School Schedule Management System

A schedule planning and management tool for elementary schools. Pure front-end static application with data stored in browser LocalStorage.

Features

• General Settings — School info, automatic academic year calculation (ROC calendar), school day configuration
• Teacher Management — Bilingual names (Chinese/English), category tags (homeroom/subject/external with custom colors), subject assignment
• Subject Management — Bilingual names, subject abbreviations
• Class Management — Grade and class setup, homeroom teacher assignment, short names
• Period Configuration — Custom periods and time slot types (class time, lunch break, cleaning, etc.) with independent "show on schedule" and "count as period" toggles
• Schedule Editor — Grid-based scheduling, teachers auto-grouped by subject, real-time conflict detection, per-class fill count in sidebar
• Class Schedule View — Bilingual subject and teacher display, merged rows for non-class periods, HTML preview and Excel export
• Individual Teacher Schedule — Filter by category, view individual teacher timetable (class + subject per cell), print and Excel export
• Yearly Class Summary — All classes × periods overview with Excel export
• School-wide Teacher Summary — All teachers × periods overview with Excel export
• Data Import/Export — Full JSON export and import, one-click demo data loader

Tech Stack

Item	Description
Front-end	Vanilla HTML / CSS / JavaScript (no framework)
Data Storage	Browser LocalStorage
Excel Export	ExcelJS (CDN)
Deployment	Static files, deployable to any static hosting service

Project Structure

v2/
├── index.html        # Main page
├── css/
│   └── style.css     # Stylesheet
├── js/
│   └── app.js        # Application logic
└── vercel.json       # Vercel deployment config

Getting Started

1. Open index.html directly in a browser, or deploy to any static server
2. Click "Load Demo Data" to explore the full feature set
3. Or start from "General Settings" to manually set up school, teachers, subjects, and classes

Deployment

This project is purely static files, compatible with:

• Vercel — vercel.json included; push to GitHub and import
• GitHub Pages — Enable directly from repo settings
• Any static hosting — Upload all files and you're done

License

© 2025 Estella Chen. All rights reserved.