| VLOOKUP函数在学生体质健康评价中的应用研究 |
| |
| 引用本文： | 纪铭霞,杨守民.VLOOKUP函数在学生体质健康评价中的应用研究[J].体育科技文献通报,2014(6):17-17,27. |
| |
| 作者姓名： | 纪铭霞 杨守民 |
| |
| 作者单位： | [1]河南师范大学体育学院,河南新乡453006 [2]河南科技学院新科学院,河南新乡453003 |
| |
| 基金项目： | 2013年河南省科技厅软科学计划项目（课题编号：132400410325）;2011年河南省社科联、经团联调研项目（课题编号：SKL-2011-2593） |
| |
| 摘 要： | 通过对Excel中VLOOKUP函数进行剖析,以学生体质健康评价为例,对VLOOKU函数进行调用实验。研究发现VLOOKUP函数可以有效提高学生体质健康评价的准确性和工作效率。但在应用时务必正确设置函数参数,避免出现批量错误。另外,VLOOKUP函数灵活性较大,应用时人为误差和失误率会加大,专业、人性、智能的学生体质健康评价软件需进一步普及推广。
|
| 关 键 词： | VLOOKUP函数 学生体质 健康 评价 |
Research on the Application of Function VLOOKUP in Assessment of Students’ Physical Health |
| |
| JI Ming-xia,YANG Shou-min.Research on the Application of Function VLOOKUP in Assessment of Students’ Physical Health[J].Bulletin of Sport Science & Technology,2014(6):17-17,27. |
| |
| Authors: | JI Ming-xia YANG Shou-min |
| |
| Institution: | ( School of Physical Education, Henan Normal University, Xinxiang 453006, China.) |
| |
| Abstract: | Through analyzing VLOOKUP in Excell, and taking students ’ physical health assessment as example , VLOOKUP is called and tested in the study .It is found that VLOOKUP can effectively promote the accuracy and work efficiency of students ’ physical assessment .However , it is necessary to set up the parameters when using VLOOKUP to avoid mass mistakes .Moreover, VLOOKUP is very flexible and the artificial mistakes and probability of mistakes will increase in application, therefore a more professional, humanized and intelligent students’ physical health assessment software should be further popularized . |
| |
| Keywords: | VLOOKUP student physical health assessment |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
