The Design And Implementation Of Online Examination System Based On Computer Culture Basis For High Vocational College

Computer Culture Basis is a required course for all the students in domestic High Vocational Schools. The test of this curriculum needs to inspect students'mastery level of the elementary knowledge and the elementary theory, but also inspects students'basic operating skills. Especially, students should master office software, and hold higher operating level of MS Office. Computer paperless test can examine students'practice ability; moreover enhances the work efficiency of teachers greatly. It becomes popular and will be the developing direction in modern evaluation educating system. Thus, the research development which suits the paperless test curriculum based on the online examination system has become the practical significance topic.This system takes Web Server, database system and ASP.NET (Visual C#) as the software development technology, and uses the Browser/Server design pattern, and achieves multiple choice question exam, computer operation exam and automatic grading. Computer operation exam employs the COM technology as the key technologies to visit MS Office. System realization starts with establishing the good inspection each knowledge spot, then one kind of mark language saves the operating topic standard answers transformation into SQL Server 2005 databases. When examining test papers this system makes comparison between the examinee's Office operation topic answer and the database mark language by some kind of form, thus carries on the automated assessment. Like this when examining test papers may reduce the influence which comes from visiting the Office answer documents many times.Thus it enhances the system performance and enhances the efficiency of examining test papers. Moreover with times'development, the research and practice of online examination system will be innovated and improved continuously. Then its application will extend to more courses so as to meet the development of higher education.In order to accomplish this project successfully, we take Computer Culture Basis as an example. It is a compulsory course for all majors in high vocational college, as well as a basic course, so its paperless test holds special significance. Firstly, we analyze the curriculum standard in Computer Culture Basis, the hardware resources and the software resources, which are needed in the test; then we determine this system plan and the design Scheme by using the method of the software engineering. According to the demand, we divide the system into 4 function modules: the pre-exam preparation, the test process, the auto-check test paper and the auto-statistic of scores. In the pre-exam preparation the function module controls and maintains examinee's information and exam pool, meanwhile the examinee's registration, choosing the exams and answering the exams are realized by the test process function modules; the grading and storage of the examinee's achievement is done by grading function modules.Therefore we should develop one system based on the B/S structure, run in Windows'environment, updated ASP.NET dynamic homepage technology development platform. The system makes use of object-oriented programming language C#, and uses Computer Culture Basis edited by the HTML hypertext language to accomplish paperless test in compilation and examination. The online examination system has realized the system function. The online test system concludes question bank, quiz, automatic scoring of objective questions, automatic graders of operation questions, automatic random organization of test papers and test scores query. This article elaborates test system'design concept, the demand analysis , the system design, the detailed design, and the system implementation and the test process of examination system.Owing to this goal, before designing and analyzing the function of this examination system, I have consulted and studied some correlated materials, as well as some commercial companies'related assistance test software. Based on the analysis mentioned above, the specific request of online exams, the system which is needed to design and finish concludes application subsystem, proposition subsystem, test subsystem and marking subsystem. The application subsystem provides the examinees'the data file; the proposition subsystem produces question bank document; the test subsystem produces examination paper document, and marking subsystem produces result database.In view of advantages of Windows operating system such as versatility, easy operation, kindly interface and so on, it has become our preferred operating system. Because this examination system is based on the COM technology, we will meet some questions. It is slightly easy to develop the database part in this system. In other aspects, taking operating COM as example, the hands-on test contact surface production, the production of the examination paper stochastically will be able to encounter the difficulty resulting from its insufficient flexibility. Finally we will use the formidable Microsoft .NET platform to develop and use C# programming language.The .NET function is extremely powerful, so its platform includes founding and operating the new generation of service of the .NET foundation structure and the tool; it may use the massive clients'.NET User Experience; establishing one new generation high distribution in .NET millions of block system module service; as well as using the new generation of intelligent Internet equipment of the .NET equipment software.In the proposition subsystem, one tries the question bank, which is stored with MS SQL Server. The access to control mechanism of file database is too simple, which will easily lead to disclosure of examination questions; while maintaining and control of large-scale is complex which needs special DBA. MS SQL Server is typically small and medium databases, which is easily to use and maintain. Database design section contains student information table, teacher information table, test database information table. Test database information table concludes choice test database table and operation database table.The examination system is mainly employed online. As mentioned above, it is divided into application subsystem, proposition subsystem, test subsystem and marking subsystem. According to the later analysis of the system's functional, we have designed a functional block diagram. When student users log into the system, they first visit exam notes, and then have tests. In this paper, we take teacher module as an example, which includes teachers'proposition and teachers'judgment. Teachers'proposition module consists of two modules, one is a multiple-choice module, the other is Office operation questions module. The Office module also includes Word and Excel operating question proposition. When we have proposition, the teacher can manage all types of examination questions. Multiple-choice questions can be directly logged in, but the operation questions will have to be set by teachers according to different exam points. Then the correct answer is visited by the Office program, and the exam points are read out afterwards which has generated one kind of mark language, which is stored in a database. Proposition clients and other subsystems communicate with the data file.We have also conducted more thorough research to Microsoft Office. The basic idea of Office operation in this system is to list all the inspection pots of Office such as Word. Teachers set up the main elements in Word personally which will be examined in paperless test. After setting up their properties, the database produces a standard modus which can provide an answer for online marking. The test question comments the method basis standard answer description, each time it takes out one inspecting spot to visit the way with COM the Office documents which is submitted to the examinee to carry on comments reading.After completing development of the system, we carry on the module testing, the comprehensive test successively, as well as some specialized students take a practical test application. The effect is quite stable and we have also solved some problems rised in the test process. In the end of 2008, when finishing Vocational School Quality Computer Culture Foundation Course Textbook Research and Practice, which is the"Key Issue"in our Jilin Province Educational Science Eleventh Five-Year Plan, we chose three classes to the demonstrate and the apply this examination system, receiving praise from provincial leading group for science education experts. In 2008-2009 second semester, in some departments in Changchun Professional Technology Institute this system is used in the test of Computer Culture Basis. By using the online examination system, test efficiency is improved greatly. We are looking forward to refining the system, and is extended to be applied widely in the tests of other higher vocational colleges.