巧用IF和IFS函数统计高校教师教学工作量  

Clever Use of IF and IFS Functions to Count the Teaching Workload of College Teachers

作　　者：曹霞 彭红霞 刘群 CAO Xia;PENG Hongxia;LIU Qun(不详)

机构地区：[1]华中科技大学网络与计算中心,湖北武汉430074 [2]华中科技大学教务处,湖北武汉430074

出　　处：《科教文汇》2021年第6期13-14,28,共3页Journal of Science and Education

摘　　要：该文巧用Excel自带的IF和IFS函数,依据现行的普通高校教学工作量管理制度,针对几个常见的计算参数,实现了高校教师工作量标准化计算和统计,提高了教务管理相关工作效率,以供高校教务管理人员参考和借鉴。Through ingenious use of Excel IF and IFS functions,based on the current management policies for teaching workload in ordinary colleges and universities,and based on several common calculation parameters,standardized calculation and statistics of college teachers'workload is realized,and the efficiency of educational administration is improved.It can be used as a reference for academic management personnel in colleges and universities.

关 键 词：EXCEL IF函数 高校教务 教学工作量 

分 类 号：G647[文化科学—高等教育学]