VLOOKUP函数在学生体质健康评价中的应用研究  

Research on the Application of Function VLOOKUP in Assessment of Students' Physical Health

作　　者：纪铭霞[1] 杨守民[2] 

机构地区：[1]河南师范大学体育学院,河南新乡453006 [2]河南科技学院新科学院,河南新乡453003

出　　处：《体育科技文献通报》2014年第6期17-17,27,共2页Bulletin of Sport Science & Technology

基　　金：2013年河南省科技厅软科学计划项目(课题编号:132400410325);2011年河南省社科联;经团联调研项目(课题编号:SKL-2011-2593)

摘　　要：通过对Excel中VLOOKUP函数进行剖析,以学生体质健康评价为例,对VLOOKU函数进行调用实验。研究发现VLOOKUP函数可以有效提高学生体质健康评价的准确性和工作效率。但在应用时务必正确设置函数参数,避免出现批量错误。另外,VLOOKUP函数灵活性较大,应用时人为误差和失误率会加大,专业、人性、智能的学生体质健康评价软件需进一步普及推广。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 .

关 键 词：VLOOKUP函数 学生体质 健康 评价 

分 类 号：G804.49[文化科学—运动人体科学]