AI 讓幻想成真：全校調代課管理系統
講者/Speaker： 顏詩穎, Shih Ying Yen
本投稿文件以「AI 讓幻想成真：全校調代課管理系統」為主題，說明設計者基於 9 年教學組長行政經驗，運用 Google AI Studio、Google Apps Script、Google Sheets 與 Gmail 等工具，建立一套低成本、可快速部署的全校調代課管理系統。系統透過 Google SSO 自動辨識教師身分，呈現個人化週課表，並以 AI 輔助比對同科目、同班級與空堂條件，快速推薦適合的調代課人選。教師可在線上發起申請、預覽調整後課表，並透過 Email 完成一鍵確認，協議結果即時寫入試算表資料庫，後續可自動產出通知單並連動鐘點費核算。
此系統將傳統仰賴紙本、人工比對與行政端集中處理的調代課流程，轉化為教師可自主協作的數位流程。其成效包含單筆處理時間由約 20 分鐘縮短至 60 秒內、降低筆誤與衝堂風險、節省月底行政覆核工時約 80%、減少紙本使用約 50%，並提升資訊透明度與調代課決策品質。整體而言，本案例展現 AI 如何協助教育現場將長期行政痛點轉化為可運作、可擴散、零預算門檻的校園行政創新方案。
This submission, titled “Making Imagination Real with AI: A Schoolwide Class Substitution and Adjustment Management System,” presents an AI-assisted administrative system developed from the designer’s nine years of experience as an academic affairs coordinator. Built with Google AI Studio, Google Apps Script, Google Sheets, Gmail, and Google Workspace, the system provides a low-cost and easily deployable solution for managing class substitutions and schedule adjustments across the school. Through Google SSO, the system automatically identifies each teacher and displays a personalized weekly timetable. It also uses AI-supported matching logic to recommend suitable substitute teachers by comparing free periods, subject relevance, and class familiarity.
The system transforms a traditionally paper-based and administrator-centered workflow into a teacher-driven digital collaboration process. Teachers can initiate requests online, preview adjusted schedules, and complete mutual confirmation through one-click email approval. Once an agreement is reached, the result is automatically recorded in a Google Sheets database, used to generate official notices, and linked to payroll calculations for teaching-hour compensation. Reported outcomes include reducing each case from around 20 minutes to within 60 seconds, minimizing input errors and scheduling conflicts, saving approximately 80% of monthly administrative verification time, and reducing paper use by about 50%. Overall, this project demonstrates how AI can convert long-standing school administrative challenges into a practical, scalable, and zero-budget digital transformation model.
- 論文全文：AI 讓幻想成真：全校調代課管理系統
- 影像： 相關影片