基于数据字典的多参数约束随机组卷算法

Random Producing Test Paper Algorithm with Multi-parameters Constraint Based on Data Dictionary

研究Excel环境下,在题型、题量和难易度等参数约束下的随机组卷问题。提出需要解决的关键问题,设计基于数据字典的多参数约束随机组卷算法,并基于Excel VBA编程和数据字典技术实现该算法。最后给出主要程序。

This paper researches on random producing test paper in Excel environment, which is constrained by parameters, such as question type, question numbers and difficulty levels. Key problems are expounded, random producing test paper algorithm with muhi-parameters constraint, which is based on data dictionary, is designed. The algorithm is realized by Excel VBA and da- ta dictionary technique. Finally, main program is introduced.