Design And Realization Of Examination Paper Automatic Generation System

With the development of computer technology, the use of computer-aidedexam has become a trend. Examination paper automatic generation is animportant application mode of computer-aided examination. The so-calledexamination paper automatic generation is to build item bank with computerdatabase technology, and generate an examination paper based on userrequirements in a short test with the selection algorithm.In our school’s computer-aided examination, there are urgent requirementsfor constructing item bank and examination paper automatic generationaccording to user’s requirements. So, how to establish an effective item bankand generate examination paper base on it is a subject which needs studyurgently.The main work of the article is to design and implement an examinationpaper automatic generation system. The system not only must be able toorganize and create an item bank, but also can generate examination papersautomatically using items in the item bank according to requirements.In order to achieve the system, we focus on examination paper automaticgeneration system development status at home and abroad to understand andanalyze, so that we can grasp the current methods and implementation principlesof examination paper automatic generation system. Then, we have someresearches of the key technologies, choosing the right system architecture,development environment and the development of language. Finally, we cancomplete system analysis, design and implementation based on these keytechnologies and computer software development technology. The key technologies used by the system include the C/S architecturetechnology, JDBC technology and JACOB technology. C/S architecture is usedfor the system architecture design. JDBC is used for database connectivity andaccess. JACOB is used for embedding Office documents. The system usesMicrosoft SQL Server2008database server, Netbeans development tools andJava development language.The system analysis includes requirements analysis and data flow analysis.The requirements analysis describes functional requirements of class teachers,teaching units and Academic Affairs. Data flow analysis reflects not only theflow of data, but also reflects the process of business logic. The analysis of thesystem data flow diagram is conducive to system analysis and design.The system design includes architecture design, module design, data designand key methods designs. These designs depict the system’s overall structure andappearance. The system uses the C/S structure, and the system is divided intothree sub-systems and12modules. Database design describes data table names,fields and data types. Key methods design describes two key methods used bythe system: office document control and examination paper automaticgeneration algorithms.The system implementation includes system code organization, realizationof system functions and system interface implementation. Code organizationdescribes directory plan and naming convention in the process of system’sdeveloping. In the realization of system functions, we provide theimplementation way of database connection and the implementation process ofvarious functional modules. In the system interface implementation, wedemonstrate some main functional graphic interfaces to render the applying wayof the system.