基于VBA的辅助排课系统的实现  

Implementation of Aid Courses Arrangement Based on VBA

作　　者：郑杰[1] 周晓宏[1] 

机构地区：[1]深圳职业技术学院,深圳518055

出　　处：《现代计算机》2014年第24期67-70,共4页Modern Computer

摘　　要：介绍一个基于Excel的辅助排课系统的实现方法。在人人都熟悉的办公软件的基础上,用Excel的VBA作为开发工具,实现辅助排课功能。该系统可以实现授课班级数和授课教师人数众多的情况下,按照授课班级数和授课时间段两个条件,自动将授课班级安排给授课教师,同时完成班级冲突检查,给出已排出班级名称和剩余班级(未排出)班级名称,大提高排课效率。Presents an aid courses arrangement system base on VBA, based on the familiar Office software, uses VBA as a development tool, realizes the course arrangement. The system can solve the problems those are many classes and many teachers. According to every teacher＆#39;s classes number and teaching time, automatically arranges class for teacher, and completes conflict checks. The system lists the arranged classes and remained classes. Which is a useful, simple used system, greatly improves working efficiency.

关 键 词：EXCEL VBA 排课 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]