學習扶助數學指標概念階層查詢系統
講者/Speaker： 吳國榮, kuo Jung Wu
本作品為「學習扶助數學指標概念階層查詢系統」，由更寮國小吳國榮老師設計，以 Google Apps Script 為核心，整合免費雲端工具打造而成。
設計背景
學扶篩選測驗結束後，教師雖能從報表得知學生的弱指標，卻難以快速釐清其前置知識脈絡。過去須人工翻查課綱、逐條對照，每學期耗費數小時，且易有盲點。
三大核心功能
知識階層圖譜：利用 AI 整理 361 條先備關聯，教師輸入弱指標後，系統即以互動式圖譜呈現完整的前置概念鏈，直接指出補救起點。
考古題整合查詢：整合 106～114 年共 46 份學扶評量考古題，支援依年級、年度、題號查詢，並提供考點頻率排行榜，可直接開啟原始試卷。
一鍵生成補救計畫：上傳班級報表後，數秒內自動完成全班弱點概覽、知識階層分組建議、先備知識檢核，以及每位學生的個人補救路徑排序。
具體成效
補救起點從憑感覺變為有根據，教師能依知識階層向前追溯真正的學習斷裂點
每學期數小時的人工整理壓縮為數秒自動完成
系統完全採用免費工具，任何學校的學扶教師均可自行使用
https://script.google.com/a/macros/apps.ntpc.edu.tw/s/AKfycby1XbfGkfnOy-mXHreGsRy9kmQ-gHX4ptsmNK0rR0ts-f-I9Hbb2bgvJGI6d8Qo9WdD/exec
System Title: Learning Support Mathematics Indicator Concept Hierarchy Query System
Designer: Wu Guo-Rong, Geng-Liao Elementary School
Background
After administering learning support screening tests, teachers can identify which ability indicators a student is weak in — but determining the prerequisite knowledge behind those indicators remains a major bottleneck. Previously, teachers had to manually cross-reference the Ministry of Education's curriculum documents, a process that consumed several hours each semester and was prone to oversight.
Three Core Features
Knowledge Hierarchy Graph: Using AI to organize 361 prerequisite relationships, teachers input a weak indicator and the system instantly renders an interactive concept map showing the full chain of prerequisite knowledge, pointing directly to the correct remedial starting point.
Historical Exam Integration: Integrates 46 learning support math assessments spanning 2017–2025, with indicator tagging for every item. Teachers can query by grade, year, or question number, view a frequency-ranked list of high-priority indicators, and open original exam papers directly.
One-Click Remedial Planning: After uploading a class report, the system automatically generates — within seconds — a class-wide weakness overview, knowledge-hierarchy-based grouping suggestions, prerequisite knowledge audits per student, and a personalized remedial sequence for each learner.
Impact
Remedial decisions shift from intuition to evidence, tracing learning gaps to their root causes via knowledge hierarchy
A semester's worth of manual data processing compressed from hours to seconds
Built entirely on free Google cloud tools (Google Apps Script + Sheets), requiring no additional budget or IT support — accessible to any learning support teacher
https://script.google.com/a/macros/apps.ntpc.edu.tw/s/AKfycby1XbfGkfnOy-mXHreGsRy9kmQ-gHX4ptsmNK0rR0ts-f-I9Hbb2bgvJGI6d8Qo9WdD/exec
- 論文全文：學習扶助數學指標概念階層查詢系統
- 影像： 相關影片