Research And Implementation Of General Item Bank System Based On COM Component Technology

With the rapid development of information technology,a university informationization level also become an important index to measure the comprehensive strength of the University.CAI(Computer Aided Instruction)penetrated into every link of teaching,has gradually become the main focus of attention.Item bank system is the core subsystem of the CAI,design of item bank system mainly includes the construction of test database and making test paper.Based on the actual demand of Hunan Vocational Institute of Safety Technology,the project team developed a set of general item bank system.The goal lies in the realization of separation of teaching and examination,to achieve better educational measurement;but also to help the teachers from the heavy teaching work out,so as to have more time for self—improvement.This paper analyzes the application and research status of item bank system at home and abroad,points out the problems existing in some of the item bank system.The key technologies involved in the development of the item bank system are described and analyzed in detail,especially for Algorithm of generating test papers and the automatic generation technology of Word documents based on COM component were studied.According to the actual needs of institute,the general item bank system mainly includes four function module,courses management,tests management,make test paper,test papers management.The system has good universality,adapt the courses examination.At present,the item bank system of all kinds have more common,universal,operation convenience,and the quality of generated test as the main basis for the measure of the quality of the item bank system.For the realization of several key technology design of item bank system,this paper carried out innovative research:1.To simplify the question editing links.In order to facilitate the operation of teacher,the development team designed the Excel template files and template related documentation,teachers can organize the questions directly in Excel software,then the Excel file to the system administrator,by the system administrator to test bulk upload;2.To optimize database storage structures.In designing test question database structure,fully taking into account the item bank system versatility,expandability,operability and minimize data redundancy,in order to improve efficiency,most of the features are implemented through stored procedures.3.Improvement on algorithm of randomly.By placing the test question in accordance with the NEWID()to sort,and then directly fetch first n rows of distinct n-random questions,avoids the question of conventional randomized algorithm repeatedly checking operation,greatly improve the generating efficiency of randomized algorithms.4.Uses the COM component technology to automatically generate Word format papers.Through research test papers output technology,using COM components,database papers will be output to the Word software,and automatic format processing(including paper header information,the question number,score display,picture size format control,blank answer area),auto save,and supports batch of generating Word examination paper,greatly reducing the user's workload.