CN101593242A - A kind of appraisal system of Excel operation questions - Google Patents
A kind of appraisal system of Excel operation questions Download PDFInfo
- Publication number
- CN101593242A CN101593242A CNA2008101127911A CN200810112791A CN101593242A CN 101593242 A CN101593242 A CN 101593242A CN A2008101127911 A CNA2008101127911 A CN A2008101127911A CN 200810112791 A CN200810112791 A CN 200810112791A CN 101593242 A CN101593242 A CN 101593242A
- Authority
- CN
- China
- Prior art keywords
- appraising
- test answers
- module
- point
- test
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of appraisal system of Excel operation questions, it is characterized in that, this system comprises: memory module, position determination module, data acquisition module, matching module, external interface module and score module.Advantage of the present invention is: in the process of setting a question, the appraising standard of appraising point is revised easily (1), and the group topic is convenient; (2) in the process of appraising, adopt batch fashion to appraise for the appraising point test answers inequality with presetting the condition of appraising in the appraising standard, make the continuity of the person's of appraising thinking better, and efficient can be higher.
Description
Technical field
The present invention relates to computer technology, relate to a kind of appraisal system of Excel operation questions especially.
Background technology
Continuous development along with network technology, computer technology, the computer-assisted examination system not only obtains using at present in the school-based examinations of many schools, and is used more and more in such as public examinations of large-scale society such as TOFEL, GRE, common english grade examinations.So-called computer-assisted examination generally carries out on computers, computing machine can provide the paper that meets the pre-defined rule examination question to specific tester according to actual needs, the tester finishes the answer of corresponding examination question on computers, and the test answers of finishing submitted to by network, the person utilizes computer-assisted examination systems connection or off-grid to appraise by declaring the volume.
The Excel operation questions is one of employed main topic type in Basics of Computer Applications correlated curriculum or the training examination, its content of examination mainly comprise use Excel book, worksheet to Various types of data calculate, add up, screen, analysis, formatting and other various processing, also may require to generate list, form, chart, pivot chart, PivotTables, table or the like.In the examination of Excel operation questions, can the appraising point that several needs tester answers be set according to the needs of examination knowledge point usually.
In a kind of prior art, the method for setting a question and taking the description formula to set a question of Excel operation questions, wherein, it is that the person of setting a question records item content and the form of examination knowledge point with the language narration in the examination question that the description formula is set a question; After the group topic of people's complete operation topic of setting a question, it is issued in examination system, use in examination for the tester.
The tester finishes its answer to the Excel operation questions by terminal computer in the examination process, and the test answers after editor finished is submitted to by network or preserve in local computer and submit to.After this, the person is docile and obedient the Excel document that preface is manually opened every part of paper to declare the volume, and the appraising standard that requires in tester's test answers and the exercise question is compared, and manually provides corresponding answer mark.In this appraised process, the person that declares the volume, by part appraising manually that is, appraised to a paper and just to descend appraising of a paper after finishing all papers.
The process of setting a question of above-described Excel operation questions and the examinee submitted to the whole examination process that has constituted Excel operation questions in computer-assisted examination of the process of appraising of having answered paper, and there is following shortcoming in the examination scheme of Excel operation questions in the above-mentioned prior art:
When setting a question with the method for describing formula, the paper of its formation can not be appraised automatically, the person opens the Excel document that the tester submits to by volume need to declare the volume when declaring volume, thereby appraise manually, problems such as labour intensity is big, inefficiency can appear thus, and there is the inconsistent result that appraises in the different periods in the person that also occurs declaring the volume easily for different testers' same test answer, and this also obviously is inequitable for the tester.
In another kind of prior art, in the process of setting a question of Excel operation questions, the person of setting a question directly is programmed into appraising point in the program of appraising, and this moment can be by the program operation of simply appraising.But there is following significant deficiency in this prior art:
(1) each examination all needs to remodify program, and the person of setting a question can't independently set a question, and is very big to the dependence of program;
(2) the program mechanism of appraising is fairly simple, generally has only " correct give divide " and " the incorrect zero of giving " two kinds of mechanism of appraising, and makes partly and presets the test answers that answer not exclusively conforms to and be mistaken for mistake and non-score.
Summary of the invention
The technical problem to be solved in the present invention provides the appraisal system of Excel operation questions in a kind of computer-assisted examination system, make when computer-assisted examination the Excel operation questions set a question with the process of appraising in, the person's of setting a question dirigibility increases, and person's efficient improves, labour intensity reduces and accuracy rate improves to declare the volume.
In order to solve the problems of the technologies described above, the invention provides the appraisal system of Excel operation questions in a kind of computer-assisted examination system, this system comprises:
Memory module is used to store the appraising point and the corresponding appraising standard thereof of described Excel operation questions; Described appraising standard comprises: by described appraising point place worksheet and the position attribution that constitutes in the position of this worksheet, the condition of appraising and the score value of appraising;
Position determination module is used for according to default position attribution determine to wait the to appraise position of Excel operation questions appraising point;
Data acquisition module is used to gather the test answers of fixed appraising point position;
Matching module is used to judge whether the test answers of being gathered identical with the condition of appraising at this test answers institute correspondence position attribute place, when both are inequality, with this test answers with and the corresponding appraising dot information offer external interface module;
External interface module is used to show the test answers and the corresponding appraising dot information thereof that receive, and receives the outside score value of importing for test answers of appraising, and this appraise score value and corresponding appraising dot information thereof are offered the score module;
The score module is used for according to the score value of appraising the pairing test answers of this score value of appraising being scored, and writes down this test answers corresponding appraising dot information.
Further, described matching module also is used for the conditionally complete of appraising at the test answers of being gathered and this test answers institute correspondence position attribute place when identical, the index gauge sub-module with this test answers the score value of appraising of corresponding appraising point score.
Further, described matching module, be used for the test answers of judging appraising point and this appraising point during the incomplete same and non-NULL of corresponding appraising standard, just offer external interface module with this test answers and with its corresponding appraising dot information; When the test answers of judging appraising point was sky, the index gauge sub-module was scored with zero.
Further, this system that appraises also comprises: pretreatment module, be used for statistics gatherer to the various test answers of all appraising point and the quantity of various test answers, and the test answers of certain appraising point with preset appraising standard and inequality, but it is when proportion is higher than predetermined value in pairing all test answers of this appraising point, according to the appraising standard generation strategy that presets this test answers is increased to the pairing appraising standard that presets of this appraising point as the condition of appraising, perhaps with this test answers as the condition of appraising to be confirmed.
Further, described external interface module, also be used for described external interface module receive be the score value of appraising of test answers input after, shown identical appraising point place's test answers and this test answers are mated, and this pairing appraising point information of test answers that score value reaches with the match is successful of appraising is offered the score module.
Further, described external interface module also is used to receive the outside paper information of importing;
At this moment, the described system that appraises also comprises: test question extracting module, be used for the external information that receives according to described external interface module, and search the qualified Excel operation questions of waiting to appraise.
Compared with prior art, utilize the appraisal system of the Excel operation questions in the embodiment of the invention to have following remarkable advantage:
(1) in the process of setting a question, content of examination still offers the tester in the mode of describing, and appraising point can be determined arbitrarily according to actual needs by the person of setting a question.This revises the appraising standard of appraising point easily, and has made things convenient for the person's of setting a question group topic process;
(2) in the process of appraising, adopt batch fashion to appraise for the appraising point test answers inequality with presetting the condition of appraising in the appraising standard, the person needn't select paper repeatedly and consult appraising point to declare the volume, appraise continuously but concentrate, the continuity of person's thinking of like this not appraising is better, and efficient can be higher.In yet another aspect, there is the inconsistent phenomenon of appraising in the different periods in the person that also avoided occurring declaring the volume for different testers' same test answer.Certainly, the person that declares the volume also can independently appraise at certain or some testers' paper, the dirigibility that this has increased the person that declares the volume when declaring volume.
Description of drawings
Fig. 1 is the process flow diagram flow chart of setting a question of the Excel operation questions of the embodiment of the invention;
Fig. 2 is the process flow diagram flow chart of appraising of the Excel operation questions of the embodiment of the invention;
Fig. 3 is the appraisal system of the Excel operation questions of the embodiment of the invention;
Fig. 4 is the appraisal system of the Excel operation questions of further embodiment of this invention.
Specific embodiment
As shown in Figure 3, embodiments of the invention provide a kind of appraisal system of Excel operation questions, and this system comprises: memory module, position determination module, data acquisition module, matching module, external interface module and score module, wherein:
Memory module is used to store the appraising point and the corresponding appraising standard thereof of described Excel operation questions; Described appraising standard comprises: by described appraising point place worksheet and the position attribution that constitutes in the position of this worksheet, the condition of appraising and the score value of appraising;
Position determination module is used for according to default position attribution determine to wait the to appraise position of Excel operation questions appraising point;
Data acquisition module is used to gather the test answers of fixed appraising point position;
Matching module is used to judge whether the test answers of being gathered identical with the condition of appraising at this test answers institute correspondence position attribute place, when both are inequality, with this test answers with and the corresponding appraising dot information offer external interface module;
External interface module is used to show the test answers and the corresponding appraising dot information thereof that receive, and receives the outside score value of importing for test answers of appraising, and this appraise score value and corresponding appraising dot information thereof are offered the score module;
The score module is used for according to the score value of appraising the pairing test answers of this score value of appraising being scored, and writes down this test answers corresponding appraising dot information.
Further, described matching module also is used for the conditionally complete of appraising at the test answers of being gathered and this test answers institute correspondence position attribute place when identical, the index gauge sub-module with this test answers the score value of appraising of corresponding appraising point score.
Further, described matching module, be used for the test answers of judging appraising point and this appraising point during the incomplete same and non-NULL of corresponding appraising standard, just offer external interface module with this test answers and with its corresponding appraising dot information; When the test answers of judging appraising point was sky, the index gauge sub-module was scored with zero.
Further, this system also comprises: pretreatment module, be used for statistics gatherer to the various test answers of all appraising point and the quantity of various test answers, and the test answers of certain appraising point with preset appraising standard and inequality, but it is when proportion is higher than predetermined value in pairing all test answers of this appraising point, according to the appraising standard generation strategy that presets this test answers is increased to the pairing appraising standard that presets of this appraising point as the condition of appraising, perhaps with this test answers as the condition of appraising to be confirmed.
Further, described external interface module, also be used for described external interface module receive be the score value of appraising of test answers input after, shown identical appraising point place's test answers and this test answers are mated, and this pairing appraising point information of test answers that score value reaches with the match is successful of appraising is offered the score module.
Further, described external interface module also is used to receive the outside paper information of importing;
At this moment, described appraisal system also comprises: test question extracting module, be used for the external information that receives according to described external interface module, and search the qualified Excel operation questions of waiting to appraise.
The device of appraising of Excel operation questions in a kind of computer-assisted examination system that in another specific embodiment of the present invention, provides, as shown in Figure 4, comprising: test question extracting module, position determination module, data acquisition module, memory module, matching module, external interface module, pretreatment module and score module.
Below by detailed description scheme of the present invention is described better to Excel operation questions examination process.Process comprises: the appraising point and the corresponding appraising standard thereof that set in advance described Excel operation questions; Described appraising standard comprises: by described appraising point place worksheet and the position attribution that constitutes in the position of this worksheet, the condition of appraising and the score value of appraising; Carry out following step then:
According to described position attribution determine to wait the to appraise position of appraising point in the Excel operation questions;
Gather the test answers at described definite appraising point place;
When the test answers of being gathered and this test answers institute correspondence position attribute place appraise condition when inequality, show this test answers and appraising point information;
Receive the outside score value of appraising, and test answers is scored with this score value of appraising for shown test answers input.
From said process as seen, in the examination process of the Excel operation questions that the embodiment of the invention proposes, adopt batch fashion to appraise for the appraising point test answers inequality with presetting the condition of appraising in the appraising standard, the person needn't select paper repeatedly and consult appraising point to declare the volume, appraise continuously but concentrate, the continuity of person's thinking of like this not appraising is better, and efficient can be higher.Certainly, the person that declares the volume also can independently appraise at certain or some testers' paper, the dirigibility that this has increased the person that declares the volume when declaring volume.
Below in conjunction with the drawings and specific embodiments the present invention is done to introduce further, but not as a limitation of the invention.
In the computer-assisted examination system, by computing machine examination paper are presented in face of the tester usually, the tester is online to answer, and the paper that will finish answer is submitted to by network or preserve and submit at local computer.As the Excel operation questions that generally adopts in the examination, because it is more that it adopts branch, adopting the branch answer may not unique singularity, can correspondingly improve Excel operation questions examining method in the computer-assisted examination of prior art, each appraising point in the Excel operation questions is extracted, independently appraise so that realize.
Comprise the process of setting a question of examination question and the process of appraising of paper finished in test for the examination process of Excel operation questions, below employed method in these two processes is illustrated respectively:
In the process of setting a question of Excel operation questions, adopt following steps:
Table 1
| The appraising point numbering | The appraising point type | Position attribution | The condition of appraising | The score value of appraising |
| ... | ... | ... | ... | ... |
Wherein:
The appraising point numbering can be to preset special strategy according to certain to work out, and also can be the appraising point sequential organization according to the topic face;
The appraising point type, be to classify, can include but not limited to usually: cell (comprising numerical value, formula, formatting etc.), unit area (comprising that classification gathers, screening, record, PivotTables, table, formatting etc.), worksheet (comprise that chart, classification gather, screening, record, PivotTables, pivot chart, table etc.), workbook (comprise worksheet, document properties value are provided with etc.) or the like according to the characteristic of Excel document; The setting of appraising point type is for the person's of setting a question the purpose of setting a question clearly is shown;
Position attribution is the collection position of appraising point test answers, is directed to the singularity of Excel document, carries out different designs at different appraising point types, comprises this appraising point place worksheet and the position in this worksheet thereof.For example, at " cell " appraising point, position attribution generally is to be specified by (worksheet, cell coordinate), as " the C3 cell of Sheet1 worksheet "; Also can specify by " cell coordinate " separately,, be defaulted as the 1st Zhang Gong's tabulation this moment as " C3 cell "; At " unit area " appraising point, specify by (worksheet, unit area coordinate) or independent unit area coordinate (giving tacit consent to the 1st Zhang Gong's tabulation) similarly, as " the C3:D8 unit area of Sheet1 worksheet " or " C3:D8 unit area ".
The condition of appraising is for determining that tester's test answers is the standard of correct option;
The score value of appraising, the score value that should charge to when correct for this appraising point.
Step 103 will comprise that the paper of the Excel operation questions that forms with describing mode offers the tester, and preserve the appraising standard of this Excel operation questions that the identification informations such as numbering of this appraising standard and this Excel operation questions are set up corresponding relation.When carrying out the appraising standard preservation, can be stored in according to the situation of reality and declare volume with on the computing machine or on the computing machine of network side.
Below with a further example the above-mentioned method of setting a question is described, it is as follows to offer tester's test question information in the mode of describing in this example:
" in the A1 of Sheet1 worksheet cell value of filling out 3, in A2 cell value of filling out 4, in A3 cell value of filling out 5, the A4 cell with the SUM function obtain the said units regional value and and overstriking show.”
This test question information is included in the Excel operation questions that offers tester's use, finding test question information when taking an examination for the tester.
Determine that for above-mentioned content of examination the knowledge point that needs to investigate the tester is: cell editor, formula, function, formatting, above-mentioned knowledge point are the appraising point in the answer of tester's feedback test.Thus, can set up the appraising standard of this part Excel operation questions that is described in table 2 below.
Table 2
| The appraising point numbering | The type of appraising | Position attribution | The condition of appraising | The score value of appraising |
| 1 | Cell | A1 | Value=3 | 1 |
| 2 | Cell | A2 | Value=4 | 1 |
| 3 | Cell | A3 | Value=5 | 1 |
| 4 | Cell | A4 | Formula=SUM (A1:A3) or formula=SUM (A1, A2, A3) | 3 |
| 5 | Cell | A4 | Runic=true | 1 |
Above-mentioned appraising standard is preserved with certain predetermined format, and sets up corresponding relation with corresponding Excel operation questions identification information.For example: appraising standard can be stored with the form of set, and is as follows:
{23456，7，2，
1, cell, A1, { value, 3}, 1}
2, cell, A2, { value, 4}, 1}
3, cell, A3, { value, 5}, 1}
4, and cell, A4, OR, { formula, "=SUM (A1:A3) " }, { formula, "=SUM (A1, A2, A3) " }, 3}
5, cell, A4, { form, runic }, 1}
}
Illustrate: in above-mentioned set, the 1st the row " { 12345; 7; 1; " in 12345 for the supposition the numberings of this Excel operation questions in exam pool, 7 expression topic types are that machine is declared operation questions, what 2 expressions were submitted to is the Excel document, thus, above-mentioned three key elements have been formed the identification information of described Excel operation questions, have comprised the corresponding relation between appraising standard and the corresponding Excel operation questions in the above-mentioned set, and wherein, multiple correct option is arranged in the 4th appraising point, if test answers meet wherein a kind of promptly think correct.In other embodiments, also can adopt other mode to set up corresponding relation between appraising standard and the corresponding Excel operation questions identification information.
With reference to said method, promptly can finish setting a question of a Excel operation questions, and can this examination question be offered the tester by computing machine.
Finish the answer of above-mentioned Excel operation questions as the tester after, after the paper that will comprise test answers was submitted to, the person declared volume to all papers that receive according to batch fashion to declare the volume, and this is declared the volume method and comprises:
Step 201 receives the outside paper information of importing, and determines the paper that this need be appraised; Also promptly can determine the Excel operation questions that to appraise;
Described paper information can be selected that thus Excel operation questions in all papers with features such as same volume face or same test time, classes is carried out batch and appraise for: test duration, Test No., information such as paper number in batches.
Step 203 is gathered the test answers at each appraising point place in the above-mentioned instance objects; Described appraising point determines that according to the position attribution of appraising point in the declaring paper described appraising point is determined by the Excel operation questions identification information that collects is corresponding.
In this step, when gathering appraising point place test test answers, obtain this appraising point information and place paper information thereof, specifically can be the corresponding Excel operation questions identification information of this appraising point, appraising point numbering and test sheet numbers, for example: No. 23456 Excel operation questions in the above-mentioned example, appraising point 2 and No. 112001 paper;
Specifically, in above-mentioned example, the test answers of gathering the appraising point place successively is the test answers at the appraising point numbering 1-5 place described in the above-mentioned table 2.It can be realized with following step particularly:
According to the instance objects in the above-mentioned steps 202, to return a documents object, and utilize ExcelApp.Documents.Open (userans_fujian) to open the file that comprises test answers that the tester submits to, following situation may appear in this moment:
(1) do not have any document, this expression tester does not upload annex, then this Excel operation questions is directly counted zero, finishes appraising of this examination question;
(2) there is the document that to open in Excel document mode, what this expression tester submitted to may not be Excel format file (for example, may compress, submit the .RAR condensed document to), then change this part paper over to unusual paper, by follow-up artificial manual process;
(3) have the Excel document that can normally open, the expression tester has successfully submitted the Excel document to.At this moment, at all appraising point in this Excel document, the test answers that attribute or the method by the Excel instance objects reads the Excel of appraising point place example, this test answers is the result of each user of appraising point place editing operation.
(1) when test answers is empty (no value), directly this test answers is counted zero;
(2) when test answers is identical with the default conditionally complete of appraising, directly this test answers is scored according to the score value of appraising of this appraising point;
(3) during incomplete same and non-NULL, write down this appraising point information, test answers and paper information with the default condition of appraising when test answers, wait for that this appraising point is carried out craft appraises.This craft is appraised and can be carried out in mode in batches, also can carry out at certain or some testers.
For example, in the above-mentioned steps example, each appraising point place test answers and the result that appraises automatically of the actual extracting of certain test volume are as shown in table 3 below:
Table 3
| The appraising point numbering | The type of appraising | Position attribution | The appraising point test answers | The score value of appraising |
| 1 | Cell | A1 | Value=3 | 1 |
| 2 | Cell | A2 | Value=4 | 1 |
| 3 | Cell | A3 | Value=5 | 1 |
| 4 | Cell | A4 | Formula=SUM (A1+A2+A3) | Wait to declare |
| 5 | Cell | A4 | Runic=vacation | 0 |
As seen, the 1st, 2,3 appraising point test answers are identical with this appraising point corresponding appraising condition, and it is appraised according to presetting the score value of appraising; The 5th appraising point is not provided with runic (the runic parameter does not have value), the zero of awarding; The 4th appraising point and the condition of appraising are not inconsistent, and then the 4th appraising point are changed over to manually to appraise and wait to declare in the formation, wait to finish after the process of appraising automatically by the artificial batch or the processing of appraising separately.
By said method as can be seen, adopt batch fashion to appraise for the appraising point test answers inequality with presetting the condition of appraising in the appraising standard, the person needn't select paper repeatedly and consult appraising point to declare the volume, appraise continuously but concentrate, the continuity of person's thinking of like this not appraising is better, and efficient can be higher.
Further, in the step 205 of the foregoing description, the person declares volume work fast for the ease of declaring the volume, show that all comprise when not carrying out examination question that appraising point appraises, can show the examination question that comprises this appraising point according to presetting strategy ordering back, the described strategy that presets includes but not limited to: earlier by the appraising point ordering, sort (as pressing content ordering by test answers again, or by whether comprising key word ordering identical with the condition of appraising or that part is identical, or by the ordering of tester's number of the account), thus, the person that declares the volume can judge at a glance to identical or similar answer, and need not repeatedly to repeat to judge, and also can avoid occurring two kinds of evaluation results for same test answers; For example: examination request is formula "=SUM (A1:A3) " or "=SUM (A1; A2; A3) ", but user's answer but is "=SUM (A1+A2+A3) " formula that this end value is also correct, this situation when paper is corrected, can select certain score value be a standard (for example, the score value of appraising of this appraising point is 3 in the last example, and can select this kind test answers score value of appraising is 2), unified then correcting.
Again further, can also be judged to be in test answers when correct an appraising point, the corresponding test answers of identical appraising point of Excel operation questions is judged to correctly automatically in other papers that will be identical with it, and with the pairing score value of appraising of this appraising point the test answers of the identical appraising point in other paper is scored.Simultaneously, when the test answers with an appraising point was judged to certain score value, the identical appraising point test answers in other papers identical with it also can be judged to same score value, and with the value of being appraised appraising point is scored.Thus, further improve the person's that declares the volume work efficiency, also alleviated its labour intensity.
In another embodiment, can be in having gathered each part paper after each appraising point place test answers, the various test answers of all appraising point that statistics gatherer arrives and the quantity of various test answers, when the test answers of certain appraising point with preset appraising standard and inequality, but it is when proportion is higher than predetermined value in pairing all test answers of this appraising point, according to the appraising standard generation strategy that presets this test answers is increased to the pairing appraising standard that presets of this appraising point as the condition of appraising, perhaps with this test answers as the condition of appraising to be confirmed, increase to the pairing appraising standard that presets of this appraising point again after examining affirmation for the person that declares the volume.
Illustrate a bit: of the present invention and Excel operation questions appraisal system, not only can be used for the computer-assisted examination system of the network edition, also can be used in the computer-assisted examination system of standalone version.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.
Claims (6)
1. the appraisal system of an Excel operation questions is characterized in that, this system comprises:
Memory module is used to store the appraising point and the corresponding appraising standard thereof of described Excel operation questions; Described appraising standard comprises: by described appraising point place worksheet and the position attribution that constitutes in the position of this worksheet, the condition of appraising and the score value of appraising;
Position determination module is used for according to default position attribution determine to wait the to appraise position of Excel operation questions appraising point;
Data acquisition module is used to gather the test answers of fixed appraising point position;
Matching module is used to judge whether the test answers of being gathered identical with the condition of appraising at this test answers institute correspondence position attribute place, when both are inequality, with this test answers with and the corresponding appraising dot information offer external interface module;
External interface module is used to show the test answers and the corresponding appraising dot information thereof that receive, and receives the outside score value of importing for test answers of appraising, and this appraise score value and corresponding appraising dot information thereof are offered the score module;
The score module is used for according to the score value of appraising the pairing test answers of this score value of appraising being scored, and writes down this test answers corresponding appraising dot information.
2. the system as claimed in claim 1, it is characterized in that, described matching module also is used for the conditionally complete of appraising at the test answers of being gathered and this test answers institute correspondence position attribute place when identical, the index gauge sub-module with this test answers the score value of appraising of corresponding appraising point score.
3. the system as claimed in claim 1, it is characterized in that, described matching module, be used for further the test answers of judging appraising point and this appraising point during the incomplete same and non-NULL of corresponding appraising standard, just offer external interface module with this test answers and with its corresponding appraising dot information; When the test answers of judging appraising point was sky, the index gauge sub-module was scored with zero.
4. the system as claimed in claim 1, it is characterized in that, this system that appraises also comprises: pretreatment module, be used for statistics gatherer to the various test answers of all appraising point and the quantity of various test answers, and the test answers of certain appraising point with preset appraising standard and inequality, but it is when proportion is higher than predetermined value in pairing all test answers of this appraising point, according to the appraising standard generation strategy that presets this test answers is increased to the pairing appraising standard that presets of this appraising point as the condition of appraising, perhaps with this test answers as the condition of appraising to be confirmed.
5. the system as claimed in claim 1, it is characterized in that, described external interface module, also be used for described external interface module receive be the score value of appraising of test answers input after, shown identical appraising point place's test answers and this test answers are mated, and this pairing appraising point information of test answers that score value reaches with the match is successful of appraising is offered the score module.
6. the system as claimed in claim 1 is characterized in that, described external interface module also is used to receive the outside paper information of importing;
At this moment, the described system that appraises also comprises: test question extracting module, be used for the external information that receives according to described external interface module, and search the qualified Excel operation questions of waiting to appraise.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101127911A CN101593242A (en) | 2008-05-26 | 2008-05-26 | A kind of appraisal system of Excel operation questions |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101127911A CN101593242A (en) | 2008-05-26 | 2008-05-26 | A kind of appraisal system of Excel operation questions |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101593242A true CN101593242A (en) | 2009-12-02 |
Family
ID=41407895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008101127911A Pending CN101593242A (en) | 2008-05-26 | 2008-05-26 | A kind of appraisal system of Excel operation questions |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101593242A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109509512A (en) * | 2018-07-10 | 2019-03-22 | 北京大学 | A kind of automatic banking process of clinical business imported based on Excel |
-
2008
- 2008-05-26 CN CNA2008101127911A patent/CN101593242A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109509512A (en) * | 2018-07-10 | 2019-03-22 | 北京大学 | A kind of automatic banking process of clinical business imported based on Excel |
| CN109509512B (en) * | 2018-07-10 | 2021-04-30 | 北京大学 | Clinical business automatic library building method based on Excel import |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112631997B (en) | Data processing method, device, terminal and storage medium | |
| CN109697905A (en) | A kind of exam paper marking system | |
| CN110909035A (en) | Personalized review question set generation method and device, electronic equipment and storage medium | |
| CN106227773B (en) | Data processing method and system | |
| CN109800309A (en) | Classroom Discourse genre classification methods and device | |
| CN110930275A (en) | Reading training learning system based on mobile terminal | |
| CN102298583A (en) | Method and system for evaluating webpage quality of electronic bulletin board | |
| CN101593107A (en) | A kind of appraisal system of program design topic | |
| CN101593106A (en) | A kind of evaluation method of programming questions | |
| CN101593233A (en) | A kind of appraisal system of Word operation questions | |
| CN101587513A (en) | Appraising system for short answer questions in computer auxiliary test system | |
| CN201196783Y (en) | Examination device for Word operation test | |
| CN201196789Y (en) | Examination device for Excel operation test | |
| CN101593242A (en) | A kind of appraisal system of Excel operation questions | |
| CN111310428A (en) | Automatic input and transmission system and method for handwriting of paper form | |
| CN201196787Y (en) | Examination device for Word operation test | |
| CN115984054A (en) | Intelligent education method and system based on big data platform | |
| CN101593243A (en) | A kind of examining method of Word operation questions | |
| CN201196786Y (en) | Examination device for Access operation test | |
| CN101593244A (en) | A kind of examining method of Excel operation questions | |
| CN201196785Y (en) | Examination device for PowerPoint operation test | |
| CN101593235A (en) | A kind of appraisal system of Access operation questions | |
| CN111931480B (en) | Text main content determining method and device, storage medium and computer equipment | |
| CN101587514A (en) | Grading system for cloze test in computer aided examination system | |
| CN101593232A (en) | A kind of examining method of Word operation questions |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20091202 |