Intelligent evaluation method and system for WPS operation questions

Abstract

The invention relates to the technical field of software intelligent evaluation, in particular to an intelligent evaluation method and system for WPS operation questions. According to the scheme, firstly, the target document of the answering interface is obtained, the target document is the answering document of the examinee, then, the answering information of the examinee in the target document is extracted, each index point in the answering information is evaluated according to the preset scoring index point information, then, the corresponding evaluation results are output respectively, and finally, the evaluation results are output. According to the evaluation result, the corresponding index points are scored, a score corresponding to each index point is obtained, and the scores are displayed at the corresponding positions of the answer interface, so that intelligent evaluation of the WPS operation questions is completed. By the adoption of the scheme, answering and evaluation can be carried out synchronously, a WPS document submitted by an examinee does not need to be independently opened subsequently for analysis and evaluation, the scoring accuracy can be improved, the evaluation efficiency can be improved, and the investment of labor cost is effectively reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of software intelligent evaluation, and in particular to an intelligent evaluation method and system for WPS operation questions. Background Art

[0002] WPS operation questions are an important part of the basic computer application course examination. In the test paper, a series of scoring points are usually set according to the needs of the test knowledge points. The question setting and scoring methods play an important role in technical application.

[0003] At present, there are two main ways to achieve scoring. The first scoring method is to embed the scoring criteria into the scoring program in advance. This method has certain limitations, that is, the program needs to be adjusted accordingly for each exam, which makes it impossible for teachers to automatically set questions. In addition, since the program scoring mechanism is relatively simple, scoring errors may occur. The second scoring method is to set questions in a descriptive manner during the question setting process. The scoring points are set by the question setter according to the actual situation. During the scoring process, if the answer to a certain test point is exactly the same as the scoring conditions in the preset standard attribute information, the system will automatically score; when the test answer is not exactly the same as the preset answer and is not empty, manual scoring is required; when there are documents that are not in Word, PPT, or Excel format (such as various compressed documents), they cannot be opened for scoring. Such test papers can only be transferred to abnormal test papers and need to be manually processed, which reduces the efficiency of scoring to a certain extent.

[0004] Therefore, how to further improve the evaluation efficiency, reduce labor costs, and realize the full automation of the scoring process on the basis of ensuring the accuracy of scoring, and design a more flexible intelligent evaluation method for WPS operation questions is a problem that needs to be solved at present. Summary of the invention

[0005] The present invention provides an intelligent evaluation method and system for WPS operation questions, which effectively solves the problem of low efficiency of the existing evaluation method for WPS operation questions in computer application basic course examinations.

[0006] According to the first aspect, an embodiment provides an intelligent evaluation method for WPS operation questions, including: Get the target document in the answering interface; Extracting the examinee's answer information from the target document; the answer information includes a plurality of indicator points; According to the preset scoring indicator point information, each of the indicator points is evaluated in turn, and the evaluation results of each indicator point are output respectively; the preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameter, evaluation code and score; Scoring each of the indicator points according to the evaluation results of each indicator point to obtain the score corresponding to each indicator point; The score corresponding to each indicator point is transmitted to the question answering interface for display.

[0007] In an achievable implementation, the step of obtaining the target document in the question answering interface includes: Receive instruction information sent by the examinee for submitting answers, and in response to the instruction information, connect from the answer interface to the target document through a plug-in to achieve data transmission between the answer interface and the target document.

[0008] In an achievable implementation manner, the step of evaluating each of the indicator points in turn according to the preset scoring indicator point information includes: Initialize the index value to zero; the index value is used to mark the number of the indicator point evaluation; Compare the current index value with the number of indicator points. If the current index value is less than the number of indicator points, evaluate the current indicator point according to the preset scoring indicator point information, and increase the current index value by one. Then, continue to compare the updated index value with the number of indicator points. If the current index value is not less than the number of indicator points, the evaluation is terminated.

[0009] In an achievable implementation manner, the evaluating the current indicator point according to the preset scoring indicator point information includes: Obtaining indicator ID information, indicator point name information, question parameter information and operation data of the indicator point; Match the indicator ID information, indicator point name information and question parameter information of the current indicator point with the indicator ID, indicator point name and question parameter in the preset scoring indicator point information respectively; The operation data of the current indicator point is evaluated according to the evaluation code.

[0010] In an achievable implementation manner, the indicator point includes a simple indicator point and a complex indicator point; and the step of evaluating the current operation data of the indicator point according to the evaluation code includes: When the indicator point is a simple indicator point, the operation data of the indicator point is directly evaluated according to the evaluation code corresponding to the indicator point; When the indicator point is a complex indicator point, the operation position corresponding to the operation data is located according to the question parameter information; the format of the operation data at different operation positions is converted into a format recognizable by the evaluation code; and the operation data after format conversion is evaluated through the evaluation code.

[0011] In one feasible implementation, the preset scoring index point information is stored in a database; after receiving a question-setting instruction, a question-setting interface is displayed in response to the question-setting instruction, and the question-setting interface displays question-setting parameters and scores corresponding to the question-setting parameters for user editing, and the preset scoring index point information in the database is updated based on the question-setting parameters and scores edited by the user.

[0012] In an achievable implementation manner, scoring each corresponding indicator point according to the evaluation result of each indicator point includes: If the evaluation result of the current indicator point is "correct", the indicator point is scored according to the score corresponding to the current indicator point; If the evaluation result of the current indicator point is "error", the current indicator point will be scored as zero.

[0013] In an achievable implementation manner, after scoring each corresponding indicator point according to the evaluation result of each indicator point, the method further includes: The answer information and the evaluation results corresponding to all the indicator points are saved.

[0014] According to the second aspect, an embodiment provides an intelligent assessment system for WPS operation questions, including: The acquisition module is used to obtain the target document in the question answering interface; An extraction module, used to extract the examinee's answer information from the target document; the answer information includes multiple indicator points; An evaluation module is used to evaluate each of the indicator points in turn according to the preset scoring indicator point information, and output the evaluation results of each indicator point respectively; the preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameters, evaluation code and score; A scoring module is used to score each of the corresponding indicator points according to the evaluation results of each indicator point to obtain the score corresponding to each indicator point; The display module is used to transmit the score corresponding to each indicator point to the question answering interface for display.

[0015] According to a third aspect, an embodiment provides a computer-readable storage medium, on which a computer program is stored. The computer program can be executed by a processor to implement the method as described above.

[0016] According to the intelligent evaluation method / system of a WPS operation question of the above embodiment, first, obtain the target document of the answering interface, which is the answering document of the examinee, then extract the answering information of the examinee in the target document, evaluate each indicator point in the answering information according to the preset scoring indicator point information, and then output the corresponding evaluation results respectively, and then score the corresponding indicator points respectively according to the evaluation results to obtain the score corresponding to each indicator point, and display the score at the corresponding position of the answering interface to complete the intelligent evaluation of the WPS operation question. The above scheme of the present application can realize the simultaneous answering and evaluation, without the need to open the WPS document submitted by the examinee separately for analysis and evaluation, which can improve the accuracy of scoring, improve the evaluation efficiency and effectively reduce the investment of manpower costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 A flowchart of an intelligent evaluation method for WPS operation questions provided in this embodiment; Figure 2 A flow chart for evaluating each indicator point provided in this embodiment; Figure 3 A setting interface for setting preset scoring index point information provided in this embodiment; Figure 4 This is a structural block diagram of the intelligent evaluation system for WPS operation questions provided in this embodiment.

[0018] Attached figure numbers: 100, acquisition module; 200, extraction module; 300, evaluation module; 400, scoring module; 500, display module. DETAILED DESCRIPTION

[0019] The present invention is further described in detail below by specific embodiments in conjunction with the accompanying drawings. Wherein similar elements in different embodiments adopt associated similar element numbers. In the following embodiments, many detailed descriptions are for making the present application better understood. However, those skilled in the art can easily recognize that some features can be omitted in different situations, or can be replaced by other elements, materials, methods. In some cases, some operations related to the present application are not shown or described in the specification, this is to avoid the core part of the present application being overwhelmed by too much description, and for those skilled in the art, it is not necessary to describe these related operations in detail, and they can fully understand the related operations according to the description in the specification and the general technical knowledge in the art.

[0020] In addition, the features, operations or characteristics described in the specification can be combined in any appropriate manner to form various implementations. At the same time, the steps or actions in the method description can also be interchanged or adjusted in a manner that is obvious to those skilled in the art. Therefore, the various sequences in the specification and the drawings are only for the purpose of clearly describing a certain embodiment and are not meant to be a required sequence, unless otherwise specified that a certain sequence must be followed.

[0021] The serial numbers assigned to the components herein, such as "first", "second", etc., are only used to distinguish the objects described and do not have any order or technical meaning. The "connection" and "coupling" mentioned in this application, unless otherwise specified, include direct and indirect connections (couplings).

[0022] refer to Figure 1 The present embodiment provides an intelligent evaluation method for WPS operation questions, comprising the following steps: Step 100: Obtain the target document in the question answering interface through the acquisition module.

[0023] Specifically, the instruction information for submitting answers sent by the examinee is received, and in response to the instruction information, the plug-in is connected from the answer interface to the target document to realize the data transmission between the answer interface and the target document. That is to say, in the WPS operation questions, there will be several big questions, and each big question will include several small questions. When the examinee finishes answering the current big question or small question, there will be a "submit" mark at the end of each question. When the examinee clicks the "submit" mark, the intelligent evaluation mechanism can be triggered, so that the examinee can submit in real time in the WPS document interface and start the evaluation process, without reopening the document for evaluation in subsequent evaluations. Such a design not only effectively avoids the abnormal problems caused by opening the document during the evaluation process, but also eliminates the human cost of manual intervention in handling abnormal documents, and significantly improves the evaluation efficiency. After receiving the instruction information for submitting answers, in response to the instruction information, the system will use the websocket protocol to open the local service plug-in, connect from the examinee's answer interface to the WPS document operation interface, and realize data transmission between the WPS document operation interface and the examinee's answer interface.

[0024] Step 200: The extraction module extracts the examinee's answer information in the target document; the answer information includes multiple indicator points.

[0025] The indicator points represent the requirements of the answer items in the current question, such as paper size, page, title, paragraph, table, picture, etc. The answer information is evaluated with the indicator points as the smallest unit to ensure the accuracy of the evaluation.

[0026] Step 300: The evaluation module evaluates each indicator point in turn according to the preset scoring indicator point information, and outputs the evaluation results of each indicator point respectively; the preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameters, evaluation code and score.

[0027] Specifically, the preset scoring indicator point information is obtained from the database, including indicator ID, indicator point name, question parameters, evaluation code, score, etc. Among them, the evaluation code is a piece of code written according to the function of the indicator point, which can obtain relevant information of the WPS document object (i.e., the target document), and is used to extract the candidate's operation results from the WPS document and compare it with the preset answer to evaluate whether the candidate's answer is correct or not; the evaluation code is pre-set during development, and can also be dynamically added and adjusted later. The writing quality of the code can directly affect the correctness of the evaluation point, so it is very critical. The indicator point name is the name of the evaluation point, which is used to be displayed in the evaluation report. The question parameters refer to the parameters required to evaluate the point configured in the question interface. Generally, they are designed according to the ideas of dynamic forms and componentization, and try to be consistent with the operations in the WPS document. When conducting the evaluation, the evaluation code is run sequentially to obtain the corresponding answer information in the WPS document, and the corresponding answer data is judged according to the evaluation code whether it meets the preset scoring indicator point requirements, and returns "true" or "false". In addition, some preset scoring index point information also includes serial number, module, sub-module, etc.

[0028] Step 400: The scoring module scores each corresponding indicator point according to the evaluation result of each indicator point to obtain the score corresponding to each indicator point.

[0029] Specifically, if the evaluation result of the current indicator point is "correct", the indicator point is scored according to the score corresponding to the current indicator point; if the evaluation result of the current indicator point is "wrong", the current indicator point is scored as zero. When the result returned is "correct", the score is calculated according to the preset indicator point score value, and when the result returned is "wrong", the indicator point score is zero.

[0030] Step 500: The display module transmits the score corresponding to each indicator point to the question answering interface for display.

[0031] After completing the evaluation of the current indicator point, the score will be transmitted to the answering interface to display the score details.

[0032] By adopting the intelligent assessment method in this embodiment, answering questions and assessment can be carried out simultaneously. There is no need to open the WPS documents submitted by the candidates separately for analysis and assessment. This can improve the accuracy of scoring, improve the efficiency of assessment, effectively reduce the investment in manpower costs, and significantly reduce the workload of manual marking and handling of abnormal problems.

[0033] like Figure 2 As shown, in some implementations, each indicator point is evaluated in turn according to the preset scoring indicator point information, specifically including the following steps: Step 310: Initialize the index value to zero; the index value is used to mark the number of indicator point evaluations.

[0034] Step 320: compare the current index value with the number of indicator points. If the current index value is less than the number of indicator points, execute step 330: evaluate the current indicator point according to the preset scoring indicator point information, and increase the current index value by one. Then, return to step 320 and continue to compare the updated index value with the number of indicator points. If the current index value is not less than the number of indicator points, proceed to step 340: end the evaluation.

[0035] Specifically, the present solution introduces an index value, and the answer data corresponding to each indicator point is evaluated in turn through the index value. For example, if the answer information in the current target document contains 10 indicator points, then these indicator points can be accessed in turn through index values ​​0 to 9. At this time, 0 corresponds to the first indicator point, and 9 corresponds to the last indicator point. The execution starts from the first indicator point. Since 0 is less than 10, step 330 is executed to evaluate the first indicator point according to the preset scoring indicator point information. When the evaluation result is "true", a score is given, and when the evaluation result is "false", no score is given. At this time, whether it is scored or not, the current index value is increased by one, that is, 0+1=1. After the current index value becomes 1, since 1 is less than 10, step 330 is executed to evaluate the second indicator point according to the preset scoring indicator point information. When the evaluation result is "true", a score is given, and when the evaluation result is "false", no score is given. At this time, whether it is scored or not, the current index value is increased by one, that is, 1+1=2. After the current index value becomes 10, since 10 is not less than 10, that is, the evaluation of all indicator points has been completed, then the process can proceed to step 340: end the evaluation. In this way, the evaluation of all indicator points can be completed quickly and orderly.

[0036] In some implementations, the current indicator point is evaluated according to the preset scoring indicator point information, specifically including: Obtain indicator ID information, indicator name information, question parameter information and operation data of the indicator point; Match the indicator ID information, indicator point name information and question parameter information of the current indicator point with the indicator ID, indicator point name and question parameter in the preset scoring indicator point information respectively; Evaluate the operation data of the current indicator point according to the evaluation code.

[0037] Specifically, since the indicator points represent the answer information of the examinees, when setting questions, each indicator point also corresponds to an indicator ID, an indicator point name, question setting parameters, a preset score of the current indicator point, etc. For example, the specific question information is as follows: "Set the page to: A4 paper, 42 lines per page, 42 characters per line. (5 points)". Then, there are three indicator points in the question information, namely: paper size, number of pages per line, and number of characters per line. Specifically, the indicator IDs corresponding to the indicator points are: 3001000020, 3001000026, 3001000025; the corresponding indicator point names are: global settings-paper size, global settings-number of lines per page, global settings-number of characters per line; the corresponding question setting parameters are: paper size: A4, number of lines per page: 42, number of characters per line: 42; the corresponding preset scores are: 1 point, 2 points, 2 points. When conducting the assessment, the indicator ID information, indicator point name information, question parameter information and operation data of the indicator points answered by the examinee are obtained, wherein the operation data is the actual operation data of the examinee. After the obtained indicator ID information, indicator point name information and question parameter information of the indicator points answered by the examinee are respectively matched with the indicator ID, indicator point name and question parameter in the preset scoring indicator point information, the operation data is evaluated through the evaluation code according to the corresponding relationship to evaluate whether the examinee's answer is correct or not.

[0038] In some implementations, the indicator points include simple indicator points and complex indicator points; evaluating the operation data of the current indicator point according to the evaluation code includes: When the indicator point is a simple indicator point, the operation data of the indicator point is directly evaluated according to the evaluation code corresponding to the indicator point.

[0039] For simple indicator points, such as title content, paper orientation, paper size, number of lines per page, number of characters per line, etc., the test results of the examinees can be directly obtained by running the evaluation code, compared with the preset answers, and true or false can be returned. For the evaluation code of simple indicator points, the JavaScript (JS) macro language provided by WPS is used to write the evaluation code of the indicator points, which can accurately obtain the information of each object in the WPS document, including paper size, page, title, paragraph, table, picture and other information, to ensure the accuracy of the evaluation.

[0040] For example, taking Word document operation as an example, the specific title information for simple indicator points is as follows: "Set the page to: A4 paper, 42 lines per page, 42 characters per line. (5 points)".

[0041] Match the question information with the preset scoring indicator point information. The preset scoring indicator point information corresponding to the above question is as follows: [Module: WPS Document Submodule: Global settings Indicator ID: 3001000020 Point name: Global settings - paper size Question parameters: [Paper size: A4] Evaluation code: function __EVAL_MODEL__(paperSize){ return doc.PageSetup.PaperSize == paperSize;} Score: 1]; [Module: WPS Document Submodule: Global settings Indicator ID: 3001000026 Index point name: Global settings - Number of rows per page Question parameters: [Number of lines per page: 42] Evaluation code: function __EVAL_MODEL__(linesPage){ return doc.PageSetup.LinesPage == linesPage;} Score: 2]; [Module: WPS Document Submodule: Global settings Indicator ID: 3001000025 Indicator point name: Global settings - Number of characters per line Question parameters: [Number of characters per line: 42] Evaluation code: function __EVAL_MODEL__(charsLine){ return doc.PageSetup.CharsLine == charsLine;} Score: 2].

[0042] refer to Figure 3 When setting the preset scoring indicator information, the question information and each item in the corresponding scoring indicator information are set in advance. Take "paper size" as an example: Figure 3Set "Global Settings - Paper Size" under No. 1, set "WPS Document / Global Settings / Paper Size" under No. 2, set "Paper Size" under Parameter Name, set "A4" under Parameter Value, and set "1" under No. 3. After the settings are completed, click OK, and the scoring indicator point information corresponding to the indicator point of the question is set. It should be noted that because the evaluation point information is saved in the database, the evaluation point can be dynamically updated and adjusted during later use.

[0043] In the preset scoring indicator point information corresponding to the above questions, the evaluation code is used to obtain the answer results of the examinee's operation and compare them with the parameter values ​​set by the teacher. If the two results are consistent, true is returned and the score of the corresponding indicator point is recorded. If they are inconsistent, false is returned and the corresponding operation score is judged to be zero. The parameter value referred to here is the standard answer corresponding to the indicator point set by the teacher when setting the question. After the student clicks Submit in the Word document operation interface, the intelligent evaluation function is triggered. After the evaluation is completed, the answer results and corresponding score information are assembled and sent to the student answer interface. The assembled data is as follows: "[Indicator point name: Global settings - paper size Answer result: Wrong Index Points: 1 Score: 0]; [Indicator point name: Global settings-number of rows per page Answer: Correct Index Points: 2 Score: 2]; [Indicator point name: Global settings-Number of characters per line Answer result: Wrong Index Points: 2 Score: 0]; Total score: 2".

[0044] The score at this time refers to the score after each indicator point is evaluated, and the total score refers to the cumulative score of the entire Word operation question. If the first operation "paper size" is incorrect, 0 points will be awarded, the second operation "number of lines per page" is correct, 2 points will be awarded, and the third operation "number of characters per line" is incorrect, 0 points will be awarded, and the total score of this question is 2 points. Candidates can view their score details on the answering interface, and after clicking "Submit", the answer information and score will be saved in the database.

[0045] When the indicator point is a complex indicator point, the operation position corresponding to the operation data is located according to the question parameter information; the format of the operation data at different operation positions is converted into a format recognizable by the evaluation code; and the operation data after the format conversion is evaluated through the evaluation code.

[0046] For complex indicator points, such as: the operation position of the indicator point needs to be located through several parameters, the obtained candidate operation results do not match the preset answer format, and the right or wrong cannot be judged by directly comparing the candidate operation results with the preset question parameter values, the functions of the evaluation code include: locating the candidate's operation position according to the parameters, converting the candidate's operation result data to the same format as the preset answer data, setting a series of conditions to determine whether the obtained candidate's answer data meets the preset indicator point requirements, and then returning true or false.

[0047] For example, taking Word document operation as an example, the specific title information for complex indicator points is as follows: “1. Set the page paper type to custom size, width 540 pt, height 810 pt; (6 points); 2. Set the first line indent of all paragraphs in the text to 2 characters, and set all Chinese fonts in the text to Fangsong No. 5; (4 points); 3. Set the header of odd-numbered pages to "Yue Opera Costumes" and the header of even-numbered pages to "Chinese Yue Opera", and display them in the center. (6 points)".

[0048] Match the question information with the preset scoring indicator point information. The preset scoring indicator point information corresponding to the above question is as follows: [Module: WPS Document Submodule: Global settings Indicator ID: 3001000022 Indicator point name: Global settings-page width and height Question parameters: [page width: 540, page height: 810] Evaluation code: function __EVAL_MODEL__(pageWidth,pageHeight){ if(typeof(pageWidth) == "undefined"&&typeof(pageHeight) == "undefined"){ return false; } if(pageWidth&&doc.PageSetup.PageWidth.toFixed(2) !=pageWidth.toFixed(2)){ return false; } if(pageHeight&&doc.PageSetup.pageHeight.toFixed(2) !=pageHeight.toFixed(2)){ return false; } return true; } Score: 6]; [Module: WPS Document Submodule: Paragraph settings Indicator ID: 300030016 Point name: Paragraph settings - Paragraph indent Question parameters: [Select paragraphs: All paragraphs, Special format: First line indent, Measurement value: 2] Evaluation code: function __EVAL_MODEL__(paragraphSelectText,characterUnitLeftIndent,characterUnitRightIndent,specialFormat,characterUnitFirstLineIndent) { console.log("paragraphSelectText",paragraphSelectText) console.log("characterUnitLeftIndent",characterUnitLeftIndent) console.log("characterUnitRightIndent",characterUnitRightIndent) console.log("specialFormat",specialFormat) console.log("characterUnitFirstLineIndent",characterUnitFirstLineIndent) if(typeof(paragraphSelectText) == 'undefined'){ console.log("No text selected") return false;} if(typeof(characterUnitLeftIndent) == 'undefined' &&typeof(characterUnitRightIndent) == 'undefined' &&(typeof(specialFormat) == 'undefined' || (specialFormat !=0&&typeof(characterUnitFirstLineIndent) == 'undefined'))){ console.log("未正确设置指标点") return false;} if(specialFormat){ switch(specialFormat){ case "0": characterUnitFirstLineIndent = 0; break; case "1": case "-1": if(typeof(characterUnitFirstLineIndent) == 'undefined'){ return false;} characterUnitFirstLineIndent = specialFormat *characterUnitFirstLineIndent break;}} let flag = false; for(let i = 1; i<= doc.Paragraphs.Count; i++){ let text = doc.Paragraphs.Item(i).Range.Text.trim(); if(paragraphSelectText.map(obj =>obj.text.trim()).includes(text)){ if(characterUnitLeftIndent){ if(Math.abs(doc.Paragraphs.Item(i).CharacterUnitLeftIndent - characterUnitLeftIndent).toFixed(2) != 0.00){ console.log("文本之前",Math.abs(doc.Paragraphs.Item(i).CharacterUnitLeftIndent - characterUnitLeftIndent).toFixed(2)) return false;}} if(characterUnitRightIndent){ if(Math.abs(doc.Paragraphs.Item(i).CharacterUnitRightIndent - characterUnitRightIndent).toFixed(2) != 0.00){ console.log("文本之后",Math.abs(doc.Paragraphs.Item(i).CharacterUnitRightIndent - characterUnitRightIndent).toFixed(2)) return false;}} if(specialFormat == 0 ||(specialFormat&&characterUnitFirstLineIndent)){ if(Math.abs(doc.Paragraphs.Item(i).CharacterUnitFirstLineIndent - characterUnitFirstLineIndent).toFixed(2) !=0.00){ console.log("首行缩进",Math.abs(doc.Paragraphs.Item(i).CharacterUnitFirstLineIndent -characterUnitFirstLineIndent).toFixed(2)) return false;}} flag = true;}} if(flag){ return true;} return false;} Score: 2]; [Module: WPS Document Submodule: Paragraph settings Indicator ID: 300030022 Point name: Paragraph settings - font settings Question parameters: [Select paragraphs: All paragraphs, Chinese font: Fangsong, font size: 10.5 (size 5)] Evaluation code: function __EVAL_MODEL__(paragraphSelectText,fontNameFarEast,fontNameAscii,fontShape,fontSize,fontColor) { if(typeof(paragraphSelectText) == 'undefined'){ console.log("No paragraph selected"); return false; } if(typeof(fontNameFarEast) == 'undefined' &&typeof(fontNameAscii) == 'undefined' &&typeof(fontShape) == 'undefined' &&typeof(fontSize) == 'undefined' &&typeof(fontColor) == 'undefined'){ console.log("Indicator point setting is incorrect") return false; } let flag = false; for(let i = 1; i<= doc.Paragraphs.Count; i++){ let text = doc.Paragraphs.Item(i).Range.Text.trim(); if(paragraphSelectText.map(obj =>obj.text.trim()).includes(text)){ if(fontNameFarEast){ if(doc.Paragraphs.Item(i).Range.Font.NameFarEast !=fontNameFarEast&&doc.Paragraphs.Item(i).Range.Font.Name != fontNameFarEast){ console.log("Chinese font",doc.Paragraphs.Item(i).Range.Font.NameFarEast) / / Chinese font----NameFarEast console.log("Chinese font",doc.Paragraphs.Item(i).Range.Font.Name) / / Chinese font----NameFarEast return false; } } if (fontNameAscii) { if(doc.Paragraphs.Item(i).Range.Font.NameAscii !=fontNameAscii){ console.log("Western font",doc.Paragraphs.Item(i).Range.Font.NameAscii) / / Complex text type----NameBi return false; } } if(fontShape){ let bold = 0; let italic = 0; switch(fontShape){ case "0": break; case "1": italic = -1; break; case "2": bold = -1; break; case "3": bold = -1; italic = -1; break; } if(doc.Paragraphs.Item(i).Range.Font.Bold != bold ||doc.Paragraphs.Item(i).Range.Font.Italic != italic){ console.log("Font bold",doc.Paragraphs.Item(i).Range.Font.Bold) / / Complex text type----NameBi console.log("Font tilt",doc.Paragraphs.Item(i).Range.Font.Italic) / / Complex text type----NameBi return false; } } if(fontSize){ if(doc.Paragraphs.Item(i).Range.Font.Size !=fontSize){ console.log("font size",doc.Paragraphs.Item(i).Range.Font.Size) / / Chinese font----NameFarEast return false; } } if(fontColor){ if(doc.Paragraphs.Item(i).Range.Font.Color !=fontColor){ console.log("font color",doc.Paragraphs.Item(i).Range.Font.Color) / / Chinese font----NameFarEast return false; } } flag = true; }} if(flag){ return true; } return false; } Score: 2]; [Module: WPS Document Submodule: Global settings Indicator ID: 3001000003 Indicator point name: Global settings-Header settings Question parameters: [Odd and even pages are different: Yes, header of odd pages: Yue Opera Costumes, header of even pages: Chinese Yue Opera] Evaluation code: function __EVAL_MODEL__(differentFirstPageHeaderFooter,oddAndEvenPagesHeaderFooter,homePageHeader,evenPageHeader,oddPageHeader){ if(differentFirstPageHeaderFooter&&oddAndEvenPagesHeaderFooter){ / / Check both Different First Page and Different Odd and Even Pages if(typeof(homePageHeader) == 'undefined' || typeof(evenPageHeader) == 'undefined' || typeof(oddPageHeader) == 'undefined'){ / / All three values ​​need to be filled in return false; } } if(differentFirstPageHeaderFooter){ / / Check if the first page is different and only fill in the first page header and odd page header if(typeof(homePageHeader) == 'undefined' || typeof(evenPageHeader) == 'undefined'){ return false; } } if(oddAndEvenPagesHeaderFooter){ / / Check odd and even pages are different, just fill in the odd page header and even page header if(typeof(evenPageHeader) == 'undefined' || typeof(oddPageHeader) == 'undefined'){ return false; } } if(!differentFirstPageHeaderFooter&&!oddAndEvenPagesHeaderFooter){ if(typeof(evenPageHeader) == 'undefined'){ return false; } } if((doc.PageSetup.DifferentFirstPageHeaderFooter == -1) !=differentFirstPageHeaderFooter){ console.log("Different first page",doc.PageSetup.DifferentFirstPageHeaderFooter) return false; } if((doc.PageSetup.OddAndEvenPagesHeaderFooter == -1) !=oddAndEvenPagesHeaderFooter){ console.log("Odd and even pages are different",doc.PageSetup.OddAndEvenPagesHeaderFooter) return false; } / / let flag = false; / / console.log("Sections",doc.Sections.Count) for (let i = 1; i<= doc.Sections.Count; i++) { for (let j = 1; j<= doc.Sections.Item(i).Headers.Count; j++){ if(doc.Sections.Item(i).Headers.Count == 0){ return false; } let text = doc.Sections.Item(i).Headers.Item(j).Range.Text.trim(); / / if (text != "") { / / flag = true; let index = doc.Sections.Item(i).Headers.Item(j).Index; if (evenPageHeader&&index == 1&&text != evenPageHeader){ / / Return the header or footer on all pages except the first page in the document or section console.log("1------>" + text) return false; } if (differentFirstPageHeaderFooter&&index == 2&&text !=homePageHeader) { / / Return the header or footer on all pages except the first page in the document or section console.log("2------>" + text) return false; } if (oddAndEvenPagesHeaderFooter&&index == 3&&text !=oddPageHeader) { / / Even page header console.log("3------>" + text) return false; } / / } } } return true; } Score: 4]; [Module: WPS Document Submodule: Global settings Indicator ID: 3001000007 Indicator point name: Global settings - Header alignment Question parameters: [Odd page header: center alignment, even page header: center alignment] Evaluation code: function __EVAL_MODEL__(evenPageAlignType,homePageAlignType,oddPageAlignType){ if(typeof(evenPageAlignType) == 'undefined'&&typeof(homePageAlignType) == 'undefined'&&typeof(oddPageAlignType) == 'undefined'){ return false; } for (let i = 1; i<= doc.Sections.Count; i++) { for (let j = 1; j<= doc.Sections.Item(i).Headers.Count; j++){ if(doc.Sections.Item(i).Headers.Count == 0){ return false; } let text = doc.Sections.Item(i).Headers.Item(j).Range.Text.trim(); if (text != "") { let index = doc.Sections.Item(i).Headers.Item(j).Index; let alignType = doc.Sections.Item(i).Headers.Item(j).Range.ParagraphFormat.Alignment; if (evenPageAlignType&&index == 1&&alignType !=evenPageAlignType) { / / Return the header or footer on all pages except the first page in the document or section console.log("All headers except the first page------>" +alignType) return false; } if (homePageAlignType&&index == 2&&alignType !=homePageAlignType) { / / Home page header or footer console.log("Home page header------>" + alignType) return false; } if (oddPageAlignType&&index == 3&&alignType !=oddPageAlignType) { / / Even page header console.log("Even page header------>" + alignType) return false; } } } } return true; } Score: 2].

[0049] refer to Figure 3 In the setting interface, when setting the preset scoring indicator information, the question information and each item in the corresponding scoring indicator information are set in advance. Take "Set the page paper type to a custom size, width 540 pounds, height 810 pounds" as an example: Figure 3 Set "Global Settings - Page Width and Height" under No. 1 in the dialog box, set "WPS Document / Global Settings / Page Width and Height" under No. 2, set "Page Width" and "Page Height" under Parameter Name, set "540" and "810" under Parameter Value, and set "6" under No. 3. After the settings are completed, click OK to complete the setting of the scoring indicator point information corresponding to the indicator point of the question.

[0050] The evaluation process for complex indicator points is basically the same as the evaluation process for simple indicator points mentioned above. The biggest difference lies in the evaluation code. A series of conditions are set in the evaluation code to determine whether the obtained candidate's answer data meets the requirements of the preset scoring indicator point information. If it meets the requirements, true is returned and the score of the corresponding indicator point is recorded. If it does not meet the requirements, false is returned and the corresponding operation score is judged to be zero. After the candidate clicks Submit on the Word document operation interface, the intelligent evaluation function is triggered. After the evaluation is completed, the answer results and corresponding score information are assembled and sent to the candidate's answer interface. The assembled data is shown below: "[Indicator point name: Global settings-page width and height Answer: Correct Index Points: 6 Score: 6]; [Indicator point name: Paragraph settings-Paragraph indent Answer result: Wrong Index Points: 2 Score: 0]; [Indicator point name: Paragraph settings-font settings Answer: Correct Index Points: 2 Score: 2]; [Indicator point name: Global settings-header settings Answer: Correct Index Points: 4 Score: 4]; [Indicator point name: Global settings-header alignment Answer: Correct Index Points: 2 Score: 2]; Total score: 14".

[0051] In the evaluation of the above complex indicator points, the first operation "page width and height" will get 6 points if it is correct, the second operation "paragraph indent" will get 0 points if it is incorrect, the third operation "font setting" will get 2 points if it is correct, the fourth operation "header setting" will get 4 points if it is correct, and the fifth operation "header alignment" will get 2 points if it is correct. The total score for this question is 14 points.

[0052] In addition, taking Excel document operation as an example, the specific topic information is as follows: "Rename the worksheet "Sheet1" to "Commodity Sales Statistics Table", insert a blank row before the first row, and enter "2020-2021 Commodity Sales Statistics Table" in cell A1."

[0053] Match the question information with the preset scoring indicator point information. The scoring indicator point information corresponding to the above question is as follows: [Module: WPS table Submodule: Worksheet Operations Indicator ID: 4040400006 Indicator point name: Worksheet operation-modify table name Question parameters: [Original worksheet / workbook name: Sheet1, The renamed worksheet / workbook name: Commodity Sales Statistics Table] Evaluation code: function __EVAL_MODEL__(oldSheetName,newSheetName){ let sheet = excel.Worksheets.Item(oldSheetName); / / Original worksheetif(sheet){ return false; } let newSheet = excel.Worksheets.Item(newSheetName); / / renamed worksheet if (newSheet) { return true; } return false; } Score: 1]; [Module: WPS table Submodule: Cell Insertion Indicator ID: 4040100005 Point name: Cell Insertion - Row Insertion Question parameters: [Worksheet / workbook name: A1, Line content: 2020-2021 commodity sales statistics] Evaluation code: function __EVAL_MODEL__(sheetName,rowText){ return excel.Worksheets.Item(sheetName).Range("A1").Text ==rowText; } Score: 1].

[0054] When the examinee clicks Submit on the Excel spreadsheet interface, the intelligent assessment function is triggered. After the assessment is completed, the answer results and corresponding score information are assembled and sent to the student answer interface. The assembled data is as follows: "[Indicator point name: Worksheet operation-modify table name Answer: Correct Index Points: 1 Score: 1]; [Indicator point name: Cell Insert-Insert Row Answer: Correct Index Points: 1 Score: 1]; Total score: 2".

[0055] At this time, the first operation "modify table name" is scored correctly 1 point, the second operation "insert row" is scored correctly 1 point, and the total score of this question is 2 points.

[0056] Let’s take PPT document operation as an example to explain. The specific topic information is as follows: “1. Change the layout of the first slide to a title slide; 2. Add a note to slide 2: "The Metaverse itself is not a technology, but an idea and concept that requires the integration of different new technologies!"; 3. Set the transition effect of all slides to "Blinds".

[0057] Match the question information with the preset scoring indicator point information. The scoring indicator point information corresponding to the above question is as follows: “Question 1: [Module: WPS Demo Submodule: Board settings Indicator ID: 500505003 Indicator point name: Layout settings-Layout settings Question parameters: [Slide No.: 1, Layout: Title Slide] Evaluation code: function __EVAL_MODEL__(slideIndex, layout){ if(typeof(slideIndex) == "undefined" || typeof(layout) == "undefined"){ return false } slideIndex = parseInt(slideIndex); / / layout = parseInt(layout); if(ppt.Slides.Item(slideIndex).CustomLayout.Name.replace('\n','').replace('\r','').trim() == layout){ return true; } return false; } Score: 2]; Question 2: [Module: WPS Demo Submodule: Basic operations Indicator ID: 500501008 Point name: Basic operation - add notes to a slide Question parameters: [Slide No.: 2, Notes: The Metaverse itself is not a technology, but an idea and concept, which requires the integration of different new technologies!] Evaluation code: function __EVAL_MODEL__(slidesIndex,speakersNote){ slidesIndex = parseInt(slidesIndex); if(ppt.Slides.Item(slidesIndex).NotesPage.Shapes.Placeholders.Item(2).TextFrame.TextRange&&ppt.Slides.Item(slidesIndex).NotesPage.Shapes.Placeholders.Item(2).TextFrame.TextRange.Text == speakersNote){ return true; } return false; } Score: 3]; Question 3: [Module: WPS Demo Submodule: Switching Effects Indicator ID: 500502002 Point name: Transition effect-all transition effect settings Question parameters: [Effect: Venetian Blinds] Evaluation code: function __EVAL_MODEL__(EntryEffect){ if(PowerPoint.SlideMaster.SlideShowTransition.EntryEffect ==EntryEffect){ return true;} return false;} Score: 3]".

[0058] The "1" in the parameter value of question 1 refers to the first slide, and the "title slide" refers to the layout. The understanding of the parameter value of question 2 is the same as that of question 1. After the candidate clicks Submit on the PowerPoint operation interface, the intelligent assessment function is triggered. After the assessment is completed, the answer results and corresponding score information are assembled and sent to the answer interface. The assembled data is as follows: "[Indicator point name: Layout settings-Layout settings Answer: Correct Index Points: 2 Score: 2]; [Point name: Basic operation - add notes to a slide Answer result: Wrong Index Points: 3 Score: 0]; [Indicator point name: Transition effect-All transition effect settings Answer: Correct Index Points: 3 Score: 3]; Total score: 5".

[0059] Among them, if the operation of question 1 "layout setting" is correct, 2 points will be awarded; if the operation of question 2 "add note text to a slide" is incorrect, 0 points will be awarded; if the operation of question 3 "all transition effect settings" is correct, 3 points will be awarded. The total score of this question is 5 points.

[0060] In some embodiments, preset scoring indicator point information is stored in a database; after receiving a question-setting instruction, a question-setting interface is displayed in response to the question-setting instruction, and the question-setting interface displays question-setting parameters and scores corresponding to the question-setting parameters for user editing, and the preset scoring indicator point information in the database is updated based on the question-setting parameters and their scores edited by the user.

[0061] The focus of the evaluation method of this application is the design of the question parameters and evaluation code. During development, the developer develops and designs the question parameters and evaluation code and stores them in the database. When setting questions, the question parameter values ​​and scores are set on the question setting interface. After the candidates answer, the evaluation code is run on WPS for evaluation, and the result (true / false) returned by the evaluation code is used to determine whether the score is scored. Because the scoring indicator point information is stored in the database, the evaluation points can be dynamically updated and adjusted during later use.

[0062] In some implementations, after scoring each corresponding indicator point according to the evaluation result of each indicator point, the method further includes: Save the answer information and the evaluation results corresponding to all indicator points. After evaluating all indicator points, save the answer results and evaluation results in the candidate answer interface so that the results can be visualized when reading the information.

[0063] like Figure 4 As shown, the present embodiment provides an intelligent evaluation system for WPS operation questions, including an acquisition module 100, an extraction module 200, an evaluation module 300, a scoring module 400 and a display module 500. Among them, the acquisition module 100 is used to acquire the target document in the answering interface; the extraction module 200 is used to extract the answer information of the examinee in the target document; the answer information includes multiple indicator points; the evaluation module 300 is used to evaluate each indicator point in turn according to the preset scoring indicator point information, and output the evaluation results of each indicator point respectively; the preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameters, evaluation code and score; the scoring module 400 is used to score each corresponding indicator point according to the evaluation result of each indicator point, and obtain the score corresponding to each of the indicator points; the display module 500 is used to transmit the score corresponding to each of the indicator points to the answering interface for display.

[0064] The intelligent evaluation system of this embodiment first obtains the target document of the answering interface through the acquisition module 100, and the target document is the answering document of the examinee. Then, the answering information of the examinee in the target document is extracted through the extraction module 200, and then each indicator point in the answering information is evaluated according to the preset scoring indicator point information through the evaluation module 300, and the corresponding evaluation results are output respectively. After that, the corresponding indicator points are scored according to the evaluation results through the scoring module 400 to obtain the score corresponding to each indicator point. Finally, the display module 500 displays the score at the corresponding position of the answering interface to complete the intelligent evaluation of the WPS operation questions. The above system of the present application can realize the simultaneous answering and evaluation, without the need to open the WPS document submitted by the examinee separately for analysis and evaluation, which can improve the accuracy of scoring, improve the evaluation efficiency and effectively reduce the investment of manpower costs.

[0065] In view of the fact that the functions and effects of the acquisition module 100, the extraction module 200, the evaluation module 300, the scoring module 400 and the display module 500 have been described in detail in the above embodiment, the present embodiment will not be elaborated in detail here.

[0066] This embodiment provides a computer-readable storage medium, on which a computer program is stored, and the computer program can be executed by a processor to implement the above method. In view of the fact that the intelligent evaluation method for WPS operation questions has been described in detail in the above embodiment, this embodiment will not be repeated in detail here.

[0067] Those skilled in the art will appreciate that all or part of the functions of the various methods in the above-mentioned embodiments can be implemented by hardware or by computer programs. When all or part of the functions in the above-mentioned embodiments are implemented by computer programs, the program can be stored in a computer-readable storage medium, and the storage medium can include: read-only memory, random access memory, disk, optical disk, hard disk, etc., and the program is executed by a computer to implement the above-mentioned functions. For example, the program is stored in the memory of the device, and when the program in the memory is executed by the processor, all or part of the above-mentioned functions can be implemented. In addition, when all or part of the functions in the above-mentioned embodiments are implemented by computer programs, the program can also be stored in a storage medium such as a server, another computer, disk, optical disk, flash disk or mobile hard disk, and can be downloaded or copied and saved in the memory of the local device, or the system of the local device is updated, and when the program in the memory is executed by the processor, all or part of the functions in the above-mentioned embodiments can be implemented.

[0068] The above specific examples are used to illustrate the present invention, which is only used to help understand the present invention and is not intended to limit the present invention. For those skilled in the art, according to the concept of the present invention, some simple deductions, modifications or substitutions can be made.

Claims

1. An intelligent evaluation method for WPS operation questions, characterized in that: include: Get the target document in the answering interface; Extracting the examinee's answer information from the target document; the answer information includes a plurality of indicator points; the indicator points include simple indicator points and complex indicator points; According to the preset scoring index point information, each of the index points is evaluated in turn, and the evaluation results of each of the index points are output respectively; The preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameter, evaluation code and score; wherein, when the indicator point is a simple indicator point, the operation data of the indicator point is directly evaluated according to the evaluation code corresponding to the indicator point; when the indicator point is a complex indicator point, the operation position corresponding to the operation data is located according to the question parameter information corresponding to the indicator point; the format of the operation data at different operation positions is converted into a format recognizable by the evaluation code; and the operation data after the format conversion is evaluated by the evaluation code; Scoring each of the indicator points according to the evaluation results of each indicator point to obtain the score corresponding to each indicator point; The score corresponding to each indicator point is transmitted to the question answering interface for display.

2. The intelligent evaluation method according to claim 1, characterized in that: The step of obtaining the target document in the question answering interface includes: Receive instruction information sent by the examinee for submitting answers, and in response to the instruction information, connect from the answer interface to the target document through a plug-in to achieve data transmission between the answer interface and the target document.

3. The intelligent evaluation method according to claim 1, characterized in that: The step of evaluating each of the indicator points in turn according to the preset scoring indicator point information includes: Initialize the index value to zero; the index value is used to mark the number of the indicator point evaluation; Compare the current index value with the number of indicator points. If the current index value is less than the number of indicator points, evaluate the current indicator point according to the preset scoring indicator point information, and increase the current index value by one. Then, continue to compare the updated index value with the number of indicator points. If the current index value is not less than the number of indicator points, the evaluation is terminated.

4. The intelligent evaluation method according to claim 3, characterized in that: The step of evaluating the current indicator point according to the preset scoring indicator point information includes: Obtaining indicator ID information, indicator point name information, question parameter information and operation data of the indicator point; Match the indicator ID information, indicator point name information and question parameter information of the current indicator point with the indicator ID, indicator point name and question parameter in the preset scoring indicator point information respectively; The operation data of the current indicator point is evaluated according to the evaluation code.

5. The intelligent evaluation method according to claim 4, characterized in that: The preset scoring index point information is stored in a database; after receiving a question-setting instruction, a question-setting interface is displayed in response to the question-setting instruction, and the question-setting interface displays question-setting parameters and scores corresponding to the question-setting parameters for user editing, and the preset scoring index point information in the database is updated based on the question-setting parameters and scores edited by the user.

6. The intelligent evaluation method according to claim 1, characterized in that: Scoring each of the corresponding indicator points according to the evaluation results of each indicator point includes: If the evaluation result of the current indicator point is "correct", the indicator point is scored according to the score corresponding to the current indicator point; If the evaluation result of the current indicator point is "error", the current indicator point will be scored as zero.

7. The intelligent evaluation method according to claim 1, characterized in that: After scoring each of the corresponding indicator points according to the evaluation results of each of the indicator points, the method further includes: The answer information and the evaluation results corresponding to all the indicator points are saved.

8. An intelligent evaluation system for WPS operation questions, characterized in that: include: The acquisition module is used to obtain the target document in the question answering interface; An extraction module, used to extract the examinee's answer information from the target document; The answer information includes multiple indicator points; the indicator points include simple indicator points and complex indicator points; An evaluation module is used to evaluate each of the indicator points in turn according to the preset scoring indicator point information, and output the evaluation results of each of the indicator points respectively; The preset scoring indicator point information at least includes: indicator ID, indicator point name, question parameters, evaluation code and score; wherein, when the indicator point is a simple indicator point, the evaluation module directly evaluates the operation data of the indicator point according to the evaluation code corresponding to the indicator point; when the indicator point is a complex indicator point, the evaluation module locates the operation position corresponding to the operation data according to the question parameter information corresponding to the indicator point; converts the format of the operation data at different operation positions into a format recognizable by the evaluation code; and evaluates the operation data after the format conversion through the evaluation code; A scoring module is used to score each of the corresponding indicator points according to the evaluation results of each indicator point to obtain the score corresponding to each indicator point; The display module is used to transmit the score corresponding to each indicator point to the question answering interface for display.

9. A computer-readable storage medium, characterized in that: A computer program is stored on the medium, and the computer program can be executed by a processor to implement the method according to any one of claims 1 to 7.

Images