基于Excel的军事体育考核成绩统计表的设计与实现

The Design and Execution of Excel-Based Statistical Table of Military Sports Assessment Results

为解决人工统计军事体育考核成绩中存在的效率低下问题,本文基于Excel软件设计了一套军事体育考核成绩统计表。统计表以大纲为依据,利用函数和公式实现了所有类别军队人员的考核课目成绩统计。当输入人员信息和考核成绩后,统计表能自动更新课目及格标准并完成成绩评定,具有完全对标大纲、开发维护高效和推广使用方便等优点。部队试用结果表明,该表操作简单,评定准确,自动化程度高。基于该表进行成绩统计,能显著提高工作效率,消除人工失误,极大方便军事体育组训与考核。

A set of Excel-based statistical tables of military sports assessment results was designed and executed to solve the problem of inefficiency in manual counting.In accordance with the assessment outline,functions and formulas in the statistical tables are executed to produce the statistics of assessment subjects of all categories of military personnel.After personnel information and assessment results are input,the statistical tables can automatically update sports pass standards and produce final scores and grades.It has the advantages of efficient development and maintenance and convenience of promotion for extensive use in addition to full compliance with the assessment outline.Trial use by the armed forces demonstrate that the statistical tables are easy to operate,highly automatic and the results are accurate.Using the tables for score statistics can significantly improve work efficiency,eliminate manual errors and extremely facilitate military sports training and assessment.