"Computer Culture Foundation" integrated test system based on database, OLE and VBA technology
Summary: This article introduces an integrated test system developed in VB to develop database technology, object link technology (OLE), and VBA programming system, thereby implementing paperless examinations on the theoretical knowledge and operation skills in the "Computer Culture Basic" class. Automatic reading. Keywords: database OLE VBA paperless test one. Questions raised
"Computer Culture Basis" is a cultural basis for non-computer majors, mainly examining students' necessary theoretical knowledge and skilled operational skills. The traditional exam of the course is generally divided into two parts - written test and operation, the written test answer answers on paper and then manually wrapped by teachers (large examinations). Operation exams are divided into basic operations, Chinese and English entry, operating system usage, document typography (Word), Data Processing (Excel), etc., students need to complete the operation results on disk under the teacher's inspection, and finally check the disk one by teacher. Document re-evaluation. This kind of examination method is very uncomfortable to expose the shortage of drawbacks: from the topic, rolling, examination, reading, and grade statistics, the test process is cumbersome; involving many people, the privilege requirements are high; In particular, the operation test should be checked one by one on the computer, and the time is expensive to make the teacher are overwhelmed; the test paper analyzes the lack of accuracy, generally only conducts substantially analysis of the total score, the average division, can not be done To a more accurate analysis, such as meantricle ergonomics, reliability, validity analysis, etc., more importantly, traditional exams cannot reflect "microcomputer is a modern high-tech crystal, popularizing microcomputer application is the purpose of microcomputer teaching" Basic idea. In summary, the course of the course urgently needs a set of fast, automatic, effectively completes the test link - paperless test system. The basic functions and implementation of the paperless test system implemented by myself using VB development, using database technology, OLE technology.
two. demand analysis
After analysis of the exam segments of the course, the system must be able to complete as to: 1. Written test and operation test integration on the theoretical knowledge and operational skills are completed on the computer, the theoretical questions are multi-choice (single selection, multiple options), and judgment questions to use computer automatic score. This reduces the written test, saving a written test, roll, paper, printing and other fees. 2. The test paper randomly adopts question bank technology. When the test is randomly generates a test paper in a question bank, each candidate is not the same, and the test can be effectively prevented from leaking the test paper, the appearance of candidates. 3. After the test automation, the candidates submit the test paper on the machine, that is, the computer automatically completes the score of the test paper, and the grades can be judged immediately. Saved a lot of time, energy, avoiding the scores of candidates, and the appearance of dark box operation in the warehouse. 4. After the test paper analysis scientific, after the completion of the whole exam, the registration, statistics, analysis, etc. of the performance can be automatically completed, and the data in the test is accurately analyzed, and the credibility, reliability, and effectiveness, etc. can be scientifically guided. Teaching.
three. Function module design
1. The function module master module is responsible for system security and interface settings. It is divided into three modules: 2. Question Bank Management is mainly responsible for the increase, deletion, modification, statistics of various types in question bank, and completes the requirements for test time, topics, topics, difficulty, and scope. Operation by teachers in the background. You can also use Access auxiliary management. 3. The examination monitoring this module is the candidate in the foreground operation: 3.1 Login entry and check the candidate admission ticket number, name and other information; 3.2 Group volumes from the question bank according to the examination requirements randomly extract the test paper; 3.3 Candidates Environment initialization Candidates Operate the documentation required by the exam, such as folders, files. 3.4 After the examination candidates click to start the exam, complete the countdown of the exam, show the test questions, candidates to conduct the theoretical knowledge of the theoretical knowledge, handle operation; 3.5 Automatic score After arriving in the provision time or candidate, the system automatically completes the score of the test paper, And put the results, and give the test results immediately. 4. The test panel analysis mainly completes the overall analysis of the test results, and the analysis of each question scores. This module is operated by teachers in the background. four. Database Design
Based on the above requirements, the database system provides the following database tables: 1. Candidates information form: including candidates pass certificates (C, 8), name (C, 8), theoretical scores (N, 3), on-machine grades (N, 3), whether or not to qualify (f) and other fields. 2. Theoretical question bank: actually three data sheets such as single-choice, multi-selection questions, judgment questions. Each table contains numbered (N, 5), chapter number (N, 4), difficulty (C, 1), title (C, 200), options A, B, C, D (C, 50), and Answers ( C, 4) and other fields. 3. Operation Question Book: According to the operation requirements required for this course, the following tables are designed: (1) Operating system table exams the operation of the operating system. According to the basic aspects of the assessment, the number, establish file, delete files, copy files, mobile files, set attributes, etc., in front of each field, the operation object, and later is the operation target, the intermediate "," separated. (2) Text entry table examine text entry speed and correct rate. Design number and text (m) two fields. (3) Document Titting Table Check the Word documentation. In addition to the number, according to the test requirements, a field is designed for each operation, such as font, glyph, font size, alignment, line spac, left indent, right indent, face setting, margin, graphics source, graphic size, Graphics are surrounded by graphics. Each field is also divided into operation objects and properties such as font (fourth paragraph, Song); (4) Data processing table exams Excel to perform data processing. Design Basic Top Title. 4. The exam requirements table set the test time, start chapter, end chapter, difficulty, radio, multi-selection, judgment, operating system, text entry, document typography, data processing, etc., the number and score.
Fives. Solution to the main problem in the programming, the main control module in this system, the implementation of the question bank management module is the same as the general database management system. The following major issues should be solved in this system: 1. After logging in, the test paper is logged in, and then the test is randomly generated in accordance with the exam, and form a test paper. This system uses a test paper corresponding to each library table in the question bank. - Theory test paper table, operating system test paper table, typing test paper table, document processing table. The following is taken as an example to illustrate the set roll of volume as follows: (1) Test Requirements Library (2) Remove the Single Select The question (3) Screen from the radio question bank (4) Judgment the number of questions 2.1 Operating System The environment is available in VB to create a folder with MKDIR. The command to create files is as follows: Open file name for output AS # file number (Open file to write) Write file number, write content (write) Close File Number (Off) Operation in Operation System Tops Only for file names, not involving content, so write content can be ruled; 2.2 Document Typography The environment is generated under the candidate folder and the corresponding picture file, and write Into the corresponding text content; the system uses OLE technology to use OLE technology to generate processing files: set wrdobj = creteObject ("word.application") 'Creating Word Applications WRDOBJ.Visible = false' does not display the object set vardoc = Wrdobj.Documents.add () 'New Document CZTM1 = R3.Fields ("File Content) WRDOBJ.SELECTION.TYPETEXT TEXT: = CZTM1' Write the file content field to the document CZTM1 = R3.fields (" File Name ") Vardoc.saveas filename: = curdir "/" CZTM1 'to refer to the file name Save Document WRDOBJ.QUIT SAVECHANGES: = WDSAVECHANGES' End the application 3. After the monitoring process of the test process begins the test, candidates can enter the corresponding button to enter the theoretical exam or the operation test, and then make it easy to answer; for the choice only on the corresponding option, click the corresponding button in the operation topic. Displaying the requirements of Windows operation questions, text processing, etc., click "Start Word" to automatically start Word software. Dynamically display countdown on the screen, the system will stop the system after the specified time arrives. Candidates can also click on the conversin button to pay ahead. Enter the automatic scoring module after the delivery volume. 4. Theoretical score in the automatic score ratings is more easy to implement, just compare the candidates' answers (all selected results) to compare the score. The following main description of the score of the operation test: 4.1 Operating system score Check if there is a file or folder or file attribute under the candidate folder. Here is a program that judges the copy file section: ST = r1.fields ("Replication File") 'acquires the copy file operation requirements in the test volume; fdir1 = left (st, instr (st, "/") - 1) get the source folder FF = MID (ST, INSTR (st, "/") 1, INSTR (ST, ",") - INSTR (st, "/") - 1) 'gets the source file name fdir2 = MID (ST, INSTR (ST, ",") 1) 'get the destination folder if Dir (fdir2 "/" ff) <> "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" " The text entry score is compared by the candidate to match the number of characters in the standard text. 4.3 Document Typing and Data Processing Rating This is a largest part of this system development. Basic thinking is: Turn Word or Excel in VB to open the corresponding document, then use the VBA program to complete the selection of the operation object, return to the selected object, and compare the corresponding requirements in the test paper, to determine if the candidate operation result is correct. Here is a code to judge the paragraph alignment: SET R1 = D1.OpenRecordset ("Word question") 'gets the generation of Word questions Requirements' Set Wrdobj = CreateObject ("Word.Application" WRDOBJ.Visible = true CZTM1 = R1. Fields ("File Name" ".doc" WRDOBJ.Documents.open filename: = curdir "/" CZTM1 ActiveDocument.select 'Open Operation File file with wrdobj.Selection ActiveDocument.select SELECT CASE R1.fields ("glylic ") 'Glyph setting requirements Case" bold ": if .font.bold = true life" = wordfs 1 case "tilt": if .font.italic = true dam = wordfs 1 case "Bold Tilting": If .font.bold and .font.italic The Wordfs = Wordfs 1 End Select End with 6. System application effect The system has now tried to the semester exams in the "computer culture foundation" teaching in our school, students and teachers are reflected in the reflection. Basically realize paperless paperless, liberate teachers from a cumbersome test session, saving a large number of people's property, making teachers more time and energy in topics scientific construction and teaching content, teaching methods Drilling. Students are also more interested in learning microcomputer. Of course, there is still a problem: such as the theoretical questions, the operation item is relatively fixed, and there is a strict requirement of data in question bank management, and the operation interface is relatively monotonous, which will continue to improve in future use. Main references: (1). "Visual Basic Chinese version self-study shortcut" Lin Yue, Peking University Press; (2). "Microsoft Word for Visual Basic" electronic version, Microsoft. English Information: Title: The intensive Test System Based on Database and Ole and VBA technologe Author: Chen keli Address: SiChuan Pharmaceutical School Zip code: 614201 Abstract: This article introduces a Test System without paper, which is based on Database and OLE and VBA technologe in the VB programme in order to realize the theoritcal knowledge and the operateing skill's test in the course of the Computer Culture Basis KeyWords:. Database OLE VBA Test without paper mail: click_ckl@163.com
