摘要
在人才培养模式日趋完善的今天,将学生按专业大类进行专业班级的重组,需要进行比较复杂的条件筛选。Excel具有强大的数据统计和分析功能,同时利用内嵌的VBA套件可以实现更加复杂条件的判断和筛选。阐述了如何利用Excel和VBA套件实现北京联合大学管理学院专业分流系统的设计与实现。用户只需完成简单的基础数据录入工作,学生的专业分流结果便一目了然。
With the increasing improvement of talent training mode, the restructuring of students based on discipline classification requires complicated conditional screening. Thanks to its powerful data sorting and analyzing and the embedded VBA kit, Excel can process complex conditional judges and screening. This paper sets forth how to use Excel and the VBA kit to realize the design and deployment of the discipline classification system of Management College, Beijing Union University. Only with simple basic data input, users can obtain a clear discipline classification and students restructuring result of the students.
出处
《北京联合大学学报》
CAS
2014年第4期71-76,共6页
Journal of Beijing Union University
关键词
专业分流
Excel
VBA
Discipline classification and students restructuring
