基于Word和Excel的通用题库管理系统

Universal test base management system based on Word and Excel

通过VBA重构Office,开发出题库管理系统。采用单Word文档保存某学科试题的方案,快速编辑题库和抽取试题,采用OLE技术与Excel通讯,实现了多次组卷的随机性与不重复性。给出了管理系统的功能模块设计,分析了在实现时使用的关键代码,同时提供下载供大家交流、使用。

A test base management system is developed through rebuilding Office with VBA. By using single Word document to save the test data, we can choose or edit the questions very fast. Under the OLE technology and Excel communication, both the random selection and non-repetition are realized. Here we share the individual function models and some key codes with the users.