Integrated examination system of computer culture base based on database, OLE and VBA technology

Data | database
Integrated examination system of computer culture base based on database, OLE and VBA technology

Chen Cli

Content Summary: This paper introduces the integration examination system developed by using database technology, Object linking technology (OLE) and VBA programming in VB, so as to realize the paperless examination and automatic marking of theoretical knowledge and operation skill in the course of Computer Culture Foundation. Key words: Database OLE VBA paperless exam one. Questions raised

The basic of computer culture is a cultural basic course for non-computer majors, which mainly examines the students ' necessary theoretical knowledge and skillful operation skills. The traditional examination of the course is generally divided into two parts--written and operational, written answers on the paper and then by the Teacher for manual marking (large test also use machine reading card). Operation examination is divided into basic operation, Chinese and English input, operating system use, document typesetting (WORD), Data Processing (EXCEL) and so on, need to be under the teacher test students to complete the operation results on disk, and finally by the teacher to check the disk file and then manually scoring. This method of examination is not suitable for the current situation. Exposed the following drawbacks: from the title, roll, examination, marking, performance statistics, such as the examination process is cumbersome, involving links and numerous personnel, test papers confidentiality requirements high, especially the operation of the examination to be on the computer to check the results of the operation, time-consuming and laborious, so that teachers overwhelmed ; The examination paper analysis lacks the accuracy, generally only the results of the total number of general analysis, such as fractional statistics, average calculation, can not be more accurate analysis, such as mean variance, reliability, validity analysis and so difficult to effectively achieve; more importantly, the traditional test can not reflect the "computer is a modern High-tech crystallization,    Popularization of computer application is the basic idea of computer teaching. To sum up, the examination of the course urgently needs a set of fast, automatic and effective completion of the test link system-paperless examination system. The following introduction I developed with VB, the use of database technology, OLE technology to achieve the paperless examination system of the basic functions and implementation.

Two Demand analysis

After the examination of the course of the analysis, the system should be able to complete such as: 1. The integration of the written and operational examinations concentrates on the computer to complete the examination of the theoretical knowledge and the Operation skill, and uses the choice question (single choice, multiple choice) and the judgment question to use the computer automatic grading.    This reduces the written test link, saving the written test, roll, paper, printing and other costs. 2.    Test paper randomization using the question bank technology, the test from a large number of questions in the exam paper randomly generated, each candidate's questions are not the same, can effectively prevent the test paper leaks, candidates cheat and other situations appear. 3. Scoring automated candidates to submit the test papers on the machine, that is, the computer automatically completed the test paper score, the results can be immediately determined.    Save the teachers a lot of time, energy, to avoid the candidates for a long time, such as scores, marking the work of the black-box operation and so on. 4. The analysis of scientific examination papers after the completion of the whole examination, can automatically complete the registration of achievements, statistics, analysis and so on, and can be accurate analysis of the test in the variance, reliability, validity and other data, can be scientifically guided teaching work.

Three Functional module Design

1. Function Module Main control module is responsible for system security and interface setting. It is divided into three modules: 2. The management of the question Bank is mainly responsible for the increase, deletion, modification and statistics of various types of questions in the bank, and also completes the requirements of examination time, task type, problem quantity, difficulty and scope. The teacher operates in the background.    Access can also be used to help manage. 3. Test monitoring the module is examinee in front operation: 3. 1 log in and check the examinee ticket number, name and other information; 3. 2 Group of volumes from the test questions in accordance with the examination requirements of random sampling test paper generation; 3.      3 examinee Environment Initialization completes the examinee operation examination request the file environment, like the folder, the document. 3. 4 test examinee clicks to start the examination, completes the examination countdown, displays the examination question, examinee carries on the theoretical knowledge the answer, the hands-on operation; 3.   5 automatic scoring in the arrival of the specified time or the examinee, the system automatically completed the test paper score, and the results in storage, immediately give the test results. 4. Examination paper analysis mainly completes the overall analysis of the test results, each question score situation analysis. This module is operated by the teacher in the background.

Four Database design

Based on the above requirements, the database system provides the following database tables: 1.    Candidate Information table: including examinee ticket Number (c,8), name (c,8), theoretical results (n,3), on-machine results (n,3), whether qualified (F) and other fields. 2. The theory Bank list: In fact, it is a single choice, multiple-choice, judgment questions and so on three data tables.    Each table contains fields such as numbered (n,5), chapter number (n,4), difficulty (c,1), title (c,200), options A, B, C, D (c,50), Answer (c,4), and so on. 3. Operation of the table: according to the requirements of the operation requirements of the course, the following tables were designed: (1) Operating system table to check operating system operation use.    According to the basic aspects of the assessment, divided into numbers, the establishment of files, delete files, copy files, move files, set properties and other fields, each field in front of the action object, followed by the operating target, the middle with "," separated. (2) The Text entry table examines the text entry speed and the correct rate.    Design number and text (M) two fields. (3) The Document typesetting table examines the Word document typesetting use. In addition to numbering, a field is designed for each operation, such as font, glyph, font size, alignment, line spacing, left indent, right indent, face setting, margin, graphic source, graphic size, graphic wrapping, etc., according to the test requirements. Each field is also divided into operation objects and attributes, such as font (fourth, Arial), (4) Data processing table to test Excel for processing.    Design basic and document typesetting table. 4. The examination request table sets the examination time, the beginning section, the ending chapter, the difficulty, the radio, the multiple choice, the judgment, the operating system, the text entry, the document typesetting, the data processing and so on question number and the score.

Five The solution of the main problems in program design

    the main control module in this system, the implementation of the test Item Management module is as easy to realize as the general database management system. There are several main problems to be solved in this system:    1. The generation of test paper   Examinee after login in accordance with the requirements of the test randomly generated a set of questions, and formed a test paper. This system has adopted the paper table corresponding to each library table in the question bank. --Theoretical paper table, operating system paper table, typing paper table, document processing table. The following is an example of extracting a single topic to illustrate the following:    (1) Test request Library     (2) Remove single topic question Quantity     (3) from the single selection of the library to select the right to meet the requirements (range) of the topic     (4) to determine the number of questions < questions, if the display of error messages, Exit;    (5) Draw the number of questions =0;     (6) to determine the number of <= questions, or into the next major problem extraction;    (7) generated in the range of the 1--question number of random integers;    (8) to determine whether the question was smoked, If then return (7) to produce;    (9) To extract the question entry theory Bank;    (10) to increase the number of questions 1, return (6);    (11) to extract the next big question.     2. Examinee Environment Initialization     mainly completes the operating system question, the document typesetting question and so on Question request folder and the document. The system for each candidate to establish a number for the name of the folder, the examinee operating environment in this folder environment. After the group volume is completed, the corresponding field values are automatically removed from the test paper library, and the corresponding files and folders are established.       2. 1  operating system problem environment   in VB can be mkdir to establish a folder, the command to establish documents as follows:             open  filename for output as #文件号 (open file to write)           WRite file number, write content   (write)           close file number    (off)      OS questions only operate on file names, not content, so write content can be Ninding;      2. 2 Document typesetting environment   generate Word documents and corresponding picture files under the Examinee folder and write the corresponding text content; The system uses OLE technology in the program to invoke word generation, such as processing files:   Set wrdobj = CreateObject ("Word.Application")     ' establish Word Application object    wrdobj. Visible = false    ' does not display this object    Set Vardoc = wrdobj. Documents.Add ()    ' New document    CZTM1 = R3. Fields ("File content")    wrdobj. Selection.TypeText text:=cztm1   ' writes a file content field to the document    CZTM1 = R3. Fields ("filename")    Vardoc. SaveAs Filename:=curdir + "\" + cztm1  ' to refer to file name Save document    Wrdobj. Quit savechanges:=wdsavechanges  ' End of the application     3. Examination process monitoring     after the start of the test, candidates click on the corresponding button to enter the theoretical examination or operation test, and then can easily answer; for the choice of only the corresponding option to click on the selection, the operation of the same button can be clicked on the corresponding buttons to display Windows operating problems, word processing and other topics required, click "Start Word" can automatically start Word software. The countdown is displayed dynamically on the screen, and the system stops responding when the specified time arrives. Candidates can also be handed in early by clicking the handing out button. Enter the automatic scoring module after handing in the papers.     4. The theoretical score is easier to achieve in automatic scoring     scoring, and the score can be completed quickly by comparing the candidates ' answers (all selected results) with the standard answer. The following main description of the Operation test score:     4. 1 Operating system rating    checking candidates folder for required files or folders or file attributes. Here is a partial procedure for judging a copy of a file:

       st = R1. Fields ("Copy file")    ' get the Copy File Operation requirement field in the Test paper library;       Fdir1 = left (St, InStr (St, "\")-1)   ' Get source folder        FF = Mid (St, InStr (St, "\") + 1, InStr (St, ",")-InStr (St, "\")-1) &N bsp;  ' get source filename        fdir2 = Mid (St, InStr (St, ",") + 1)   ' Get destination folder   & nbsp;    if Dir (Fdir2 + "\" + ff) <> "Then Osfs = Osfs + fs  ' If the destination folder has the file corresponding to the source file name, add that part to the score &NBSP;&N bsp;   4. 2 text entry score   Compare examinee input text and standard text match character number.      4. 3 document typesetting and data processing scoring   This is the most difficult part of the system development. The basic idea is: in VB, call Word or Excel to open the corresponding document, and then use VBA programming to complete the selection of the Operation object, return the attribute value of the selected object, and compared with the corresponding requirements in the test paper, so as to determine whether the results of the examinee operation is correct. The following is a section of code that determines the alignment of paragraphs:       Set r1 = d1. OpenRecordset ("word title")           ' get action requirements for generating word questions '         Set wrdobj = CreateObject ("Word.Application")         Wrdobj. Visible = true       CZTM1 = R1. Fields ("filename") + ". Doc"        wrdobj. Documents.Open Filename:=curdir + "\" + cztm1       activedocument.select   ' Open the operation file        with Wrdobj. selection         activedocument.select          Select case R1. Fields ("glyph")    ' glyph setting requirements            case "bold":     If. Font.Bold = True Then Wordfs = Wordfs + 1           case "tilt":  & nbsp;     If. Font.Italic = True Then Wordfs = Wordfs + 1           case "bold Tilt": & nbsp;        If. Font.Bold and. Font.Italic then                           Wordfs = Wordfs + 1         End select       End With

Six System Application Effect

This system has been used in our school "computer culture basic" teaching semester examination, students and teachers reflect better. The basic realization of the examination of paperless, teachers from the cumbersome examination links liberated, saving a lot of personal belongings, so that teachers have more time and energy in the subject of scientific construction and teaching content, teaching methods of research. Students are also more interested in learning computers.                           Of course, the system also has a problem: such as theoretical problems only objective questions, the operation of the project is more fixed, the management of the database data entry has strict requirements, the operation of the interface is relatively monotonous, which will be in the future use of continuous improvement. Main references: (1). The Visual basic Chinese version of Learning shortcuts, Lin Yue, Peking University Press; (2). Microsoft Word for Visual Basic, Microsoft.

English information: title:the intensive Test System Based on Database and Ole and VBA technologe author:chen Keli Addr Ess:sichuan Pharmaceutical School Zip code:614201 abstract:this article introduces a Test System without PA Per, which are based on Database and OLE and VBA Technologe in the VB programme in order to realize the theoritcal Knowl      Edge and the operateing skill ' s test in the course of the Computer Culture basis. Keywords:database OLE VBA Test without paper e-mail: click_ckl@163.com