Excel函数在学生日常管理中的应用

Application of Excel Function in Students' daily Management

随着学生资料逐步电子化,班主任在整理资料中都会遇到很多头痛问题,填写学生信息表时经常出现错误,如身份证输入错误、出生日期与身份证不符、计算学生年龄不准确、户籍性质不规范等。该文重点介绍了vlookup、mid、countif、Indirect等4个Excel2013函数的使用方法,正确合理使用这些函数,对学生信息进行分析和提取,能大幅减轻学生管理工作中资料整理的压力。通过近三年的实践发现,开学初对班主任进行Excel2013函数培训,能极大提高工作效率。

With the gradual electronic data of students, the class teacher will have a lot of headaches in the sorting of information,when fill in student information representation often errors, such as identity card input error, date of birth and identity card does not match, calculate the age of the students is not accurate, the household registration is not standardized. This paper mainly introduces four Excel2013 functions: vlookup,mid,countif,indirect.Correct and rational use of these functions, the analysis and extraction of student information, can greatly reduce the pressure on the students' management work. Through nearly three years of practice found that the beginning of the class of the class teacher in charge of Excel2013 function training, can greatly improve the work efficiency.