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

Computer application is an important part of the Computer Culture Foundation Course。Computer Culture class is computer-oriented institutions of higher learning and non-computer science undergraduate opened a public computer courses。Taught mainly includes The computer's basic theory,The use of computer operating system,Office software use and computer networking applications。Key learning office productivity software including Word Chinese word processing, Excel spreadsheets and PowerPoint presentations。Usually,This class freshman year of college the first half of semester,The aim is to enable students to have a certain level of computer theory, while students use the computer's operating capacity are now paid special attention to the practical operation of the computer application ability。As the computer science and the rapid development of network technology。Current computer-assisted means of paperless examinations in the field of education and teaching a wide range of applications。Basic computer classes for the large number of new students every year to open their heavy teaching task。In particular, the number of students in college enrollment surge in the trend of teaching and examination work is facing greater pressure on。The examinations are to check the students grasp the extent of what they have learned an important link,Also the last link。It also to some extent to evaluate the teacher's teaching effectiveness and teaching ability。Because traditional methods of examination of the cultural foundation course examination of the computer there are certain problems。First,Scope of the study incomplete,In addition to theoretical knowledge of the discipline, its application is to examine some of the focus。This one is often very difficult to detect through traditional papers and the situation of the application;Second,The degree of difficulty grasping the paper well,Because a large number of candidates are using the same papers, the questions to ease the standards is not easy to measure, often do not meet the purpose of the examination。Their objectivity will be questioned;Third,Complex and heavy workload。From the papers printed, to organize examinations and papers the existence of such archives are also all kinds of problems;Fourth,Examination must be manually after the end of Marking,But also on the results and summary statistics。Such large numbers of continuous mechanical Ministry of Labor, but a huge waste of human and financial resources is also prone to errors。Another,Artificial Marking a large number of candidates of the respondents can not be carried out to analyze;Last,Computer-aided examination system and the community colleges and universities has become a development trend of examinations, but also to examine the various theoretical knowledge of the exam software have born, but the practical application of the test are still popular in the gradual;For these reasons, the development of a computer culture-based test system is necessary on the machine。The examination system can not only assess knowledge of basic theory of objective examination questions, such as choice, fill in the blank and other modes of examination questions, but also to assess practical ability of students to make examination to become a fair, scientific, comprehensive, efficient, and convenient。This is exactly the purpose of this thesis research and development is all about。This paper-based test system for the Computer Literacy proficiency exam in the computer portion of the design and development。Through in-depth analysis of the computer testing system and demonstration, combined with the university's physical facilities and the allocation of network environment, determine the use of client / server, C / S structure model for development。Use Visual Basic 6.0 or VB language as a program development platform, using OLE, and VBA programming technology to the Word text editor, Excel spreadsheets, PowerPoint presentations of the automatic scoring title three operations. The system from three sides which the test database management, answering operation, carry out an assignment score to achieve the whole process on the machine. Candidates have passed the authentication after the landing examination system, the system will automatically set of examination questions for the candidates randomly selected and, based on contents of examination papers to the candidates and to provide the necessary examinations Word, Excel, and PowerPoint operating environment, while describing examination questions will always appear on the screen, and can be adjusted according to the needs of the user display window size, to help candidates pop star。Candidates in this system to provide a simple, intuitive interface for the examination, and have automatic countdown function,The normal end of the exam, the candidate's operation resulted in the adoption process automatically uploaded to the server-side and complete the Marking score functions, statistics for all candidates take the exam scores。System analysis papers on the candidates, to enable teachers to further understand the candidates point of knowledge to grasp the situation。If the system is running during a sudden power failure, machine downtime, or unexpected situations such as power-down, candidates answer the question once again by the second landing, the system will not be a result of unforeseen disruptions caused by examination to determine the end of the examination。Examination system selected Microsoft SQL as the database。Based on the examination system functionality, performance, demand for power analysis, planning of the examination system of the database structure。Database contains Administrators table, Students tables, Operations table, OperScores the table, OperObjects the table and other relevant data tables used to store the administrator information, candidate information and questions of information。Test the connection between the system and the database connection using ADO,Candidates login identification, the system automatically from the test database randomly removing a set of sample questions, drawn to the questions to the candidates for the Student ID in order to DAT format, the file name is stored in the candidate client。Test system is divided into three modules, each item bank management, and test subsystems and scoring subsystems。Examination after completion of the operation results with the A Question of the DAT files uploaded to the server-side along with the specified folder。scoring subsystems adopts VBA programming techniques。In the VB, respectively, create a Word object, Excel, and PowerPoint object , and use the object properties and methods of reading the object's property values, such as operating results and are subject to the appropriate operation of the requirements of your scoring。Ratings given after the candidate's score and answer analysis,the answer to the candidates the results recorded in the Student ID as a file name text file。After the completion of the development of this test system can be normal operation, after a trial to prove the success of system development, greatly improve the fairness of the exam and work efficiency, but there are still insufficient and need to improve the place。Such as databases in the exam and answer the security of data backup and so on are the results of the need to improve and perfect the next direction。Exam in the course of the quantity, quality and scientific accuracy of the system and intelligent Marking is the next goal。Continuously updated through extensive use and testing will improve the quality of education that will deepen the reform of teaching play an important role, for my school education and teaching reform and make a bigger contribution。...