基于VBA设计的考试编排系统

Examination Seating Arrangement System Based on VBA

近年来随着学生人数的增多,考试周教学工作人员手动制作各科考试座位表已经成为一项艰巨而繁琐的工作。考试座位表编排的系统化是教学工作人员的迫切需求,作者通过VBA在Excel中制作一个应用程序的设计思路及操作流程,根据实际学生人数和教室规模的选择,实现了考生座位的自动编排、打印考试座位表等功能。经实际应用表明,它能有效的将教学工作者从编排座位工作中解救出来,减轻他们的工作负担,提高其工作效率。

In recent years with the increase of students,in exam week,Manully making examination seat table by teaching staff manually has become an arduous and tedious work.Exam seating arrangement of systematization are urgent needs for the teaching staff.This system based on the actual number of students and classroom size,enables candidates seat features such as automatic numbering,print examinations of the seating chart.In practical,it proved that it effectively reduce teaching staffs work burden and improve their efficiency.