基于Excel电子表格的体育成绩统计软件设计

摘要

文中针对学生体育成绩统计中人工计算的弊端和操作不灵活的现象,运用设计出Excel电子表格中内嵌的各种类型的函数建立统计模型,提高学生体育成绩统计的计算效率和准确性,同时以图表的形式生成提高了体育成绩统计的直观性.在实际的应用中该系统为体育成绩的管理和查询提供了一个高效的平台,用时10分钟即可完成全部的输入和计算工作,大大提高了工作的效率,节约了工作的时间,同时提高了体育成绩统计的准确性.%Aiming at the students' sports scores in the drawbacks of manual calculation and operation is not flexible,using the design of embedded Excel electronic form in various types of function to establish a statistical model to improve students' sports scores of the computational efficiency and accuracy,but also improve the visual sports scores statistics to generate charts.In the actual application management and query the system for sports performance provides an efficient platform for 10 minutes to complete all the work input and calculation,greatly improved work efficiency,saves working time,and improve the accuracy of the sports scores statistics.