基于Excel VBA的航海学离线自适应考试系统的设计与实现

Excel VBA-based Navigation Offline Adaptive Test System Design and Realization

本文所提出的基于Excel VBA的航海学离线自适应考试系统,可对题目进行难度分级,并对学生水平进行分级,从而实现了系统自动为考生选择适合的题目,对其进行有选择性的测试。Excel在教师电脑中装机率很高,能够比较容易让用户接受。此系统成本低、对电脑要求低、维护方便、对使用者要求低、可作为教师日常课堂单元测验或期末上机考试之用,同时也可用作学生平时练习,及时让学生通过自测得到答案及评分,便于学生巩固、强化所学知识。

the proposed navigation offline adaptive testing system based on ExcellVBA ,topics can be difficult grading ,enables the system to automatically select the right topic for candidates ,to selec-tively test .Excellin a high rate of teacher computers installed in ,user is easier to accept .This system is low cost ,low demand for computer ,easy maintenance ,low requirements for users ,could serve as a day-to-day classroom teachers use in unit tests or final examination ,and can also be used for student practice regularly ,promptly make available to students through a self -test answers and scoring ,enab-ling consolidation ,intensifying what they have learned .