基于VBA的考生座位混排算法

The Method of Arranging Seats of Examinees Based on VBA

使用Office内嵌的VBA编程工具,介绍一种适合于有多组、少量考生考试的考号编排算法,实现同组考生的座位穿插排列,有效提高考试质量,可应用于吉林省高校教师岗前培训考务管理系统。

Using the programming tools VBA that embedded in Office,this paper introduces a more suitable catalog algorithm of multi-group but small number of exam candidates test to arrange the seating of same group candidates interspersed,to improve the quality of examinations effectively.This method can be applied in examination management system of Jilin Province colleges and for universities teachers' pre-work training.