学生体质健康测试数据的Excel统计处理研究

Research on the Statistics of Tested Datas of the National Student′s Physical Fitness and Health Standards with Excel

根据《国家学生体质健康标准》测试的有关要求,在Excel电子表格中建立了测试成绩统计表;介绍了测试数据的输入、核对及各测试项目得分和对应等级的输入方式;对总分的计算、总体评价等级的确定及各评价等级比例计算等方面的实现进行了详细说明.

Based on the testing requests of the National Student＇s Physical Fitness and Health Standards, this article had erected statistics for rhe testing datds, introduced the methods of how to input and check the tested datas, and how to input the scores and grades of deffrent test items. The anther explained calculatinggeneral scores, guaranteeing evaluation grades and computing percent of deffrent evaluation grades detailedly.