Excel VBA考试试题设计与评分方法研究

Research on Design of Examination Question and Method of Scoring in Excel VBA

在Excel VBA课程考试软件开发中,如何从Excel文件中获取考生操作的窗体对象和宏代码,是操作题评分中的一个关键性问题。到目前为止,有关Excel VBA课程的考试软件开发和评分方法研究方面的文献报道尚不多见。利用VBE及其子对象的属性和方法,可以测试Excel VBA工程中的窗体和控件对象的属性和事件代码,以及模块中的宏代码。给出了基本操作题、程序改错题和程序填空题这三种题型的试题和答案设计的示例。考试结果表明,使用VBE对象来获取考生操作的窗体对象和宏代码,很好地解决了Excel VBA考试系统中操作题的计算机评分问题。

In the software development process of Excel VBA examination,there is a key problem how to obtain the form object and macro code from the Excel file which examinee operates in the examination.So far,it is rarely for the literature on the development of software and the method of scoring in the examination of Excel VBA courses.In Excel VBA project,the properties and event code of form and controls,and the macro code in module can be tested by using the properties and methods of VBE object and its sub objects.In this article,three design examples of examination questions and answers,namely,basic operation question,modify the program and fill in the blanks in the program are given.The results show that it is a good solution to the computer scoring problem of exam questions in the Excel VBA by using the VBE object to obtain form object and macro code.