Excel中利用VBA进行学院教务管理研究

College Educational Administration was Studied by Using VBA in Excel

Excel是办公自动化中一款非常实用、功能强大的电子表格处理软件,具有数据搜集、整理、分析和处理功能,再结合VBA,Excel发挥出更大作用。该文结合学院教务管理工作的特点,通过介绍VBA,在辅修专业学籍卡制作上的应用,说明自动化办公在学院教务管理中的重要性,并在此基础上提出一些学院教务管理自动化的对策建议。

Excel, a useful spreadsheet maker,which has varieties of functions like data collection and analyzing,will become moreeffective and exert more use by involving VBA. by illustrates the characteristics of teaching affair administration and the applica-tion of VBA in design registration record cord of minor courses, this paper shows that auto-working is of great importance in col-lege teaching affair administration. In this case, advances some countermeasures and Suggestions of school educational administra-tion management automation.