自建資訊應用系統在體育課成績評量之應用－以大一體育課程為例

The Application of the End-user Computing to the Assessment of Freshmen's Physical Education

詹美玲(Mei-Ling Chan)

《弘光人文社會學報》 5期 (2006/11) Pp. 127-146

https://doi.org/10.29933/SHSS.200611.0007

摘要

本研究目的是針對體育教師自行建立資訊應用系統的觀念，利用Microsoft Office Excel 2003軟體來進行體育成績評量系統的開發。本研究方法是利用函數連結原始測驗成績與相對分數成績間的函數路徑，大幅減少成績換算的步驟，同時建構教師在各項成績給分比例等機動調整功能。將「結果評量」與「過程評量」加以結合，提升教師給分上的客觀性與自主性。本研究結果：共包含7張工作表，並設計為提昇工作表的使用性與安全性。目前在教學應用上，使用多年，並同時有多位教師使用本系統於成績結算上的應用。在結論部份，本研究屬理論應用層次之研究架構的編排與設計，可迅速縮短成績對照的繁瑣過程，使用者僅輸入原始資料，即可自動顯示正確分數，並完成總成績的結算、排序、等第、平均數、標準差等各項結果，此有助於課程教學內容調整、教學狀況掌握，讓教學能在最短的時間了解各班學習效果，提供有建設性的參考。

關鍵字

函數 ； MATCH ； INDEX ； VLOOKUP ； SUM ； STDEV

並列摘要

This research purpose was to set up the concept of the application system of information by oneself to the P.E teacher, Utilized the software of Microsoft Office Excel 2003 to develop the P.E score estimate.This research method was approach route which to utilize function link primitive score and relative number of achievement, reduce the step that the score conversion, construct adjust the condition in every achievement at the same time for P.E teacher of divide proportion, etc. Combine result estimate and process estimate, improve P.E teacher estimate score of the objectivity and independence.This result of study: Include 7 worksheets altogether, and promote design for utilized and security the worksheet. In teaching was used at present, has used it for many years, and many teachers used this system to account application at the same time.In the conclusion part, This research belonged to lay out and design of the research structure of the application level of the theory, which tedious course that can shorten the score and contrast rapidly. The user only inputs the firsthand information can show the correct number, and finish several results, such as settlement, sequencing, grade in an imperial examination, average , standard deviation of the total result, etc., this helps adjustment of content of courses of course, teaching state to be mastered, enable teaching to find out about the results of learning of every class in the shortest time, offer constructive reference.

並列關鍵字

FUNCTION ； MATCH ； INDEX ； VLOOKUP ； SUM ； STDEV