基于VBA技术的工程制图试题库系统的研发

The System Development of the Engineering Drawings Test-system Based on VBA Technology

针对工程制图学科的试题中杂带着各种图形和公式,开发题库、组卷系统难度较大这一问题,应用Visual FoxPro 9.0构建题库数据库,以VBA技术实现随机组卷、图文混排,以OLE技术实现图形、公式的编辑与维护。在此基础上研发了一套工程制图试题库系统,提高了该学科命题效率和质量,保证了教考分离,使考试环节能够更好地评价教学效果,该题库系统还可扩展至工科全部课程使用。

Based on engineering drawings of the subject in the papers of miscellaneous with all kinds of graphics and formula,development of test questions library system,automatic test construction is a difficult question,the application of the Visual FoxPro 9.0 build question bank database to VBA technology to achieve the volume,mixed with pictures and draining with OLE（Object Linking and Embedding） technology to achieve graphics,formula editor and maintenance.Based on this research,a set of engineering drawing database system can improve the discipline proposition efficiency and quality,ensure the separation,make testing links to better evaluate the teaching effect,this test system can also be extended to all engineering course use.