Design And Implementation Of Computer Test System Based On C/S Structure

Computer Application Foundation is a basic course of higher institutions for freshmen. It mainly covers computer's basic theory and how to use the Windows Operating System, the Office Software (including Microsoft Word, Microsoft Excel, and Microsoft PowerPoint) as well as computer network's application. Its goal is to enable students to acquire certain computer theoreys and develop their computer operation ability, the latter of which is the focus of the course.It is an arduous task for teaches to teach massive fresh students Computer Application Foundation every year. What's more, a test is the final and most important link of the whole teaching process, which not only inspects the degree that students grasp the knowledge but also appraises teachers' teaching effect and teaching faculty to a certain extent. But the traditional test of Computer Application Foundation has certain problems. First because the massive examinees use the identical examination paper, if the test question is too difficult and is too easy, the test cannot achieve its goals. Second, printing examination paper requires a lot of work and is also time-consuming. Its cost is high and it's a waste of paper, too. Simultaneously how to keep the examination paper file is another problem; Third, it is difficult to arrange the examination and monitor it since the massive examinees use identical examination paper in the same test. Fourth, Computer Application Foundation emphasizes the actual operation while the paper test can only focus on the theory. So it's very difficult to test examinees' actual ability of computer operation; Fifth, after the test, test papers have to be marked artificially, and teachers have to carry out the data statistics. It's easy for teachers to make a mistake because of the massive data. Finally, it will become more complicated to repeat the whole process if someone who, for some kind of reason, has not participated in the test has to take part in the test again. Based on the above reasons, it is necessary to develop hands-on test system of the computer application foundation, which can inspect not only the examinees knowledge but also their actual operation ability. It is just the goal of this paper to make the test more scientific, reasonable, effective, fair and quicker.After further analysis of hands-on test system of the computer application foundation, Visual Basic6.0 (VB) language is chosen as the platform to take the procedure, the VB object-oriented programming method is applied, combined with the VBA programming technology to carry on automatic grading about Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. In the process of the software development, the objects of FSO filing system in VB, Microsoft Word, Microsoft Excel and the Microsoft PowerPoint have been further researched and their structure and details have been grasped. The content of hands-on test have basically covered all the knowledge which the teaching program requests to grasp. This is also an important characteristics of this system.The function that the test system must fulfill includes basic theory inspection of Computer Application Foundation through the multiple choice questions and true or false questions as well as the inspection of actual hands-on computer operation ability by providing examinees the operating environment of the Windows, Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Examinee's answers are recorded and graded automatically. The examinee's score is demonstrated and uploaded to the examinee's information table. Besides, examinee's answers and their scores will be uploaded to the the folder that server assign to put files in for reference.The database the test system uses is ACCESS2003. For fulfilling the function of the test system and for future function expansion, the structure of the database is carefully designed, in which it contains the Ksxx table, the xz table, the pd table, the win table, the Word table, the Excel table, the ppt table and so on to store examinee's information and the test questions. The test system uses ADO connection and the database to carry on the examinee registers, choose test questions at random, and put the test questions in examinee's database.The test system adopts the modulation, including three modules—the question bank subsystem, the test subsystem and the grading subsystem. The test system uses VB. First examinees register. Then the examinee's valid identity is confirmed. After that the test system chooses test items at random and saves from server's database to examinee's client for the examinee, providing them test contact surface. This contact surface is simple and direct. Through this contact surface, the test is completed and examinee's information is demonstrated in the contact surface. Also the test's surplus time is given through countdown and the operation questions is shown at the top of the screen using the API to make it convenient for examinees to read and answer. When the test time is up or the examinee clicks "complete an assignment" button, the system will enter the grading subsystem.Multiple choice questions and true or false questions are graded by the grading subsystem through comparing examinees' answer with the right key in the database. If the answer is correct, it is scored; For Windows operation questions, the FSO filing system object must be established first in VB, and then are compared with examinee's operating result. If the operation is correct, it is scored; For Microsoft Word, Microsoft Excel and Microsoft PowerPoint, it uses the VBA programming technology to establish objects of Word, Excel and the PowerPoint separately through VB. Then it reads object attribute value by each object's attribute and method. If the operation is conformed by the request, it is scored. This grading request must be tolerant to some extent After grading had ended, examinee's score is demonstrated and uploaded.Although the test system has been used successfully for several years but it still needs to be improved such as examinee's identification authentication, the security and backup of the database, the quantity and quality of examination paper as well as the accuracy and the intellectualization that the system examined test papers. In addition it can be expanded in the fields of the inspection of the computer network operation, using the IIS technology, enlarging the B/S structure, making examinee's result inquiry more convenient and so on in order to obtaine more social and economic benefits and make a greater contribution to the school educational reform.