Evaluation method of Excel operation questions
An excel and worksheet technology, applied in the computer field, can solve problems such as no scoring, the inability of the question maker to make questions independently, and large program dependence
Inactive Publication Date: 2009-12-02
乐标(北京)知识产权有限公司
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0009] (1) The program needs to be re-modified for each test, and the question maker cannot write the question independently, which is very dependent on the program;
[0010] (2) The scoring mechanism of the program is relatively simple. Generally, there are only two scoring mechanisms: "points for correctness" and "zero points for incorrectness". As a result, some test answers that do not completely match the preset answers are misjudged as errors and cannot be accepted. Minute
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0040] An evaluation method for an Excel operation question, comprising: setting in advance the scoring points of the Excel operation questions and their corresponding scoring standards; The location attribute, scoring condition and scoring value formed by the location of the worksheet; then perform the following steps:
[0041] Determine the position of the scoring point in the Excel operation question to be judged according to the position attribute;
[0042] collecting test answers at the determined scoring points;
[0043] When the collected test answer is not the same as the judgment condition of the location attribute corresponding to the test answer, the test answer and the judgment point information are displayed;
[0044] Receive the scoring value input from the outside for the displayed test answer, and use this scoring value to score the test answer.
[0045] As can be seen from the above method, in the evaluation method of the Excel operation question proposed in...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses an evaluation method of Excel operation questions, comprising: presetting the appraising points and the corresponding appraising standards; then implementing the following steps: determining the appraising points location in the Excel operation questions to be appraised according to the location attribute; collecting the test answers of the determined appraising points; displaying the test answers and the information of the appraising points when the collected test answers are not identical to the appraising condition of the location attribute to which the test answers correspond; receiving the appraising score input for the displayed test answers by the exterior. The invention has the following advantages: (1) in the process of setting questions, appraising standards for appraising points are easily modified and the setting of questions is convenient; (2) in the process of appraising, appraising is carried out by batch processing on answers of questions of appraising points with different appraising conditions from preset appraising standards, so that the appraisers have good thought continuity and work more efficiently.
Description
technical field [0001] The invention relates to computer technology, in particular to an evaluation method for Excel operation questions. Background technique [0002] With the continuous development of network technology and computer technology, computer-aided examination systems are not only used in many schools' internal examinations, but also in large-scale social public examinations such as TOFEL, GRE, and General English Tests. use. The so-called computer-assisted examination is generally carried out on a computer. The computer can provide specific testers with test papers that meet the predetermined rules according to actual needs. The tester completes the answers to the corresponding test questions on the computer and submits the completed test answers through the Internet. Markers use the computer-aided examination system to score on-line or off-line. [0003] Excel operation questions are one of the main question types used in courses related to basic computer ap...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F19/00G09B7/00G09B19/00
Inventor 尤晓东
Owner 乐标(北京)知识产权有限公司