运用电子表格实现体育测试项目成绩自动评分研究

为了满足高校信息化建设需要，方便体育教师快速、准确对学生体育测试项目成绩进行评分，文章通过查询知网文献资料，运用电子表格技术，采用INDEX与MATCH两函数组合查找，并采用单项分数成升序排列的评分表的办法，研发出了"体育成绩管理系统"，实现了对学生体育测试项目成绩自动评分功能。该系统可以满足体育教师个人对学生体育成绩管理的需求。但是，该系统安全性低，自动化程度低，处理数据量小，且尚未在实际中运用。

Research on using spreadsheet to realize the automatic scoring of physical testing

In order to meet the needs of the information construction of colleges and universities and facilitate PE teachers to quickly and accurately give marks to the students, the author inquired the CNKI literature and developed the Sports Performance Management System which uses the spreadsheet technology, INDEX-MATCH combination search and the individual scores sheet in ascending order, which achieves automatic scoring. The system can meet the needs of PE teachers for the management of students' physical performance. However, the system has low security, low degree of automation, small data processing size, and has not been used in practice.