文献类型：期刊文献

中文题名：基于Excel-VBA的专业分流应用系统的设计与实现

英文题名：The Design and Deployment of an Excel-VBA-based Discipline Classification and Students Restructuring Application System

作者：李昕[1];杨冰[2]

第一作者：李昕

机构：[1]北京联合大学人事处;[2]北京联合大学管理学院

第一机构：北京联合大学人事处

年份：2014

卷号：28

期号：4

起止页码：71-76

中文期刊名：北京联合大学学报

外文期刊名：Journal of Beijing Union University

语种：中文

中文关键词：专业分流

外文关键词：Excel; VBA; Discipline classification and students restructuring

摘要：在人才培养模式日趋完善的今天,将学生按专业大类进行专业班级的重组,需要进行比较复杂的条件筛选。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.