CN112507683A - Method and device for rapidly exporting comprehensive quality evaluation files of students - Google Patents
Method and device for rapidly exporting comprehensive quality evaluation files of students Download PDFInfo
- Publication number
- CN112507683A CN112507683A CN202011592372.XA CN202011592372A CN112507683A CN 112507683 A CN112507683 A CN 112507683A CN 202011592372 A CN202011592372 A CN 202011592372A CN 112507683 A CN112507683 A CN 112507683A
- Authority
- CN
- China
- Prior art keywords
- student
- data
- comprehensive quality
- file
- exporting
- 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
- 238000013441 quality evaluation Methods 0.000 title claims abstract description 46
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000004140 cleaning Methods 0.000 claims abstract description 13
- 238000011156 evaluation Methods 0.000 claims abstract description 12
- 238000004519 manufacturing process Methods 0.000 claims abstract description 5
- 238000009472 formulation Methods 0.000 claims abstract description 4
- 239000000203 mixture Substances 0.000 claims abstract description 4
- 238000012216 screening Methods 0.000 claims description 23
- 238000001914 filtration Methods 0.000 claims description 11
- 238000009795 derivation Methods 0.000 claims description 5
- 230000010354 integration Effects 0.000 claims description 4
- 238000013506 data mapping Methods 0.000 claims description 3
- 230000008901 benefit Effects 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 230000001788 irregular Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- APTZNLHMIGJTEW-UHFFFAOYSA-N pyraflufen-ethyl Chemical compound C1=C(Cl)C(OCC(=O)OCC)=CC(C=2C(=C(OC(F)F)N(C)N=2)Cl)=C1F APTZNLHMIGJTEW-UHFFFAOYSA-N 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Abstract
The invention discloses a method and a device for realizing fast export of student comprehensive quality evaluation files, belonging to the technical field of file management, aiming at solving the technical problem that the export of the comprehensive quality evaluation files is difficult and nonstandard, and adopting the technical scheme that: the method comprises the following specific steps: generating a comprehensive quality evaluation file of students: summarizing the collected student evaluation data according to the index rule base, and extracting a final effective student file; exporting word documents of the student files; and generating a word document from the student archives generated in the gathering mode and exporting the word document. The system comprises a generating unit and a deriving unit; the production unit comprises a data acquisition module, a rule making module and a data cleaning module; the export unit comprises a template formulation module and a file generation module.
Description
Technical Field
The invention relates to the technical field of file management, in particular to a method and a device for rapidly exporting comprehensive quality evaluation files of students.
Background
Comprehensive quality evaluation of students is an important embodiment of quality education. The comprehensive quality evaluation is generally divided into seven dimensions (slightly different structures in different regions or schools), namely 'moral quality', 'citizen literacy', 'learning ability', 'communication cooperation and practice innovation', 'sports and health', 'aesthetic' and 'performance ability'. The seven dimensions are divided into a plurality of items to evaluate the students respectively.
Finally, the evaluation data of each student are screened and collected to generate a student comprehensive quality evaluation total file, but the export of the student files is difficult to export into a uniform and standard word document. The existing comprehensive quality evaluation data screening rule is too high in coupling degree with a program, and is inconvenient to maintain. The export of the comprehensive quality evaluation archive of the student is mainly realized by two ways at present, one way is that the word archive is generated by adopting a POI code generation way in the prior art, and the way has large workload, high error rate and difficult maintenance; another is to purchase a commercial version of the reporting service, which is too expensive and too dependent on third parties.
Data collected by student comprehensive quality evaluation comprise various indexes such as an arbitrary situation, a reward and punishment situation, artistic literacy, social practice, a statement report, daily physical exercise, research study and the like, the content is more, the complexity is high, and therefore, how to derive a standard and uniform word document is a problem to be solved urgently at present.
Disclosure of Invention
The invention provides a method and a device for rapidly exporting comprehensive quality evaluation files of students, and aims to solve the problem that the comprehensive quality evaluation files are difficult and irregular to export.
The technical task of the invention is realized in the following way, and the method for rapidly exporting the comprehensive quality evaluation file of the student specifically comprises the following steps:
generating a comprehensive quality evaluation file of students: summarizing the collected student evaluation data according to the index rule base, and extracting a final effective student file;
exporting word documents of the student files; and generating a word document from the student archives generated in the gathering mode and exporting the word document.
Preferably, the student comprehensive quality evaluation file is produced as follows:
acquiring archive data: collecting archive data from the comprehensive quality evaluation system or collecting archive data from the filled service data;
and (3) establishing rules of a rule engine: setting data screening rules of the student files according to different index rules;
rule screening data: and cleaning and filtering the data according to a set screening rule.
Preferably, the word document from which the student profile is derived is specifically as follows:
a Word module is formulated: according to the finally generated student file, compiling a student comprehensive quality file template in a command mode, namely formulating the student comprehensive quality file template through a template command;
exporting a Word document: and binding the cleaned data with the formulated student comprehensive quality file template to export a final student file.
Preferably, the rule engine is used for converting the business rules into an execution tree, and performing different screening, filtering and integration on the effective data of the comprehensive quality file to summarize the effective data into a finally required data set.
Preferably, the writing method adopted by the template instruction is that { } represents an expression, and the value is taken according to data in the expression.
Preferably, the pattern of the student comprehensive quality archive template comprises the following two forms:
firstly, fixing a table form: the original style of the label is not changed;
secondly, data list form: the template instructions are replicated according to the line of the student's integrated quality profile template.
A device for rapidly exporting comprehensive quality evaluation files of students, which comprises,
the generating unit is used for summarizing the collected student evaluation data according to the index rule base and extracting a final effective student file;
and the export unit is used for exporting the generated student archive generated word document.
Preferably, the production unit comprises, in combination,
the data acquisition module is used for acquiring archive data from the comprehensive quality evaluation system or acquiring archive data from the filled service data;
the rule making module is used for setting data screening rules of the student files according to different index rules;
and the data cleaning module is used for cleaning and filtering the data according to the set screening rule.
More preferably, the deriving unit comprises,
the template formulation module is used for compiling a student comprehensive quality file template in a command mode according to the finally generated student file, namely formulating the student comprehensive quality file template through a template command;
and the file generation module is used for exporting the cleaned data into a standard word document.
Preferably, the data cleaning module is used for formulating different index rules for different indexes of students in a rule engine mode, and screening and filtering are carried out;
the file generation module designates a corresponding student comprehensive quality file template in a template instruction mode, and finally data export is performed in a data mapping binding mode.
The method and the device for rapidly exporting the comprehensive quality evaluation files of the students have the following advantages:
the invention solves the problem that the comprehensive quality evaluation file is difficult and irregular to export, and the comprehensive quality evaluation file of students is more conveniently exported into a uniform and standard word document;
the invention can solve the problem that the student file is difficult to export, effectively filters and summarizes legal data and generates a word file template, and quickly and conveniently exports the student comprehensive quality file with a standard format;
the rule engine is adopted, the collected student data is filtered by configuring the screening rule of the comprehensive evaluation archive, the rule engine is adopted, the principle that the data and the business logic are packaged together in an object-oriented manner is fundamentally broken through, and the advantage that the business logic is put in the rule is that the maintenance can be more convenient when the business logic is changed; compiling corresponding rule files according to the evaluation rules for each evaluation index of the comprehensive quality evaluation, and screening out legal and effective evaluation data uniformly after the filling period is finished; the rule engine is an engine for solving the separation of business codes and business rules, and has the following main advantages:
simplifying system architecture and optimizing application;
secondly, the maintainability and the maintenance cost of the system are improved;
integration of the system is facilitated;
fourthly, the cost and the risk of writing the hard code business rule are reduced;
fourthly, the core of the invention lies in the creation of the archive template; the template instruction mode is adopted to replace the traditional complexity of compiling a large number of codes, meanwhile, the instruction support also improves the effectiveness of the template, the template is a simple method for processing complex word, the complex word pattern can be directly edited by the word, the code compiling pattern thunder area is perfectly avoided, and meanwhile, the instruction support also improves the effectiveness of the template.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method for rapidly exporting student comprehensive quality evaluation files;
FIG. 2 is a schematic diagram of a comprehensive quality file of students in the general high school.
Detailed Description
The method and the device for rapidly exporting the student comprehensive quality evaluation file are described in detail below with reference to the drawings and the specific embodiments of the specification.
Example 1:
the invention discloses a method for rapidly exporting comprehensive quality evaluation files of students, which comprises the following steps:
s1, generating a student comprehensive quality evaluation file: summarizing the collected student evaluation data according to the index rule base, and extracting a final effective student file;
s2, exporting word documents of the student archives; and generating a word document from the student archives generated in the gathering mode and exporting the word document.
As shown in fig. 1, the comprehensive quality evaluation file of the production student in step S1 in this embodiment is as follows:
s101, collecting archive data: collecting archive data from the comprehensive quality evaluation system or collecting archive data from the filled service data;
s102, establishing rules of a rule engine: setting data screening rules of the student files according to different index rules;
s103, rule screening data: and cleaning and filtering the data according to a set screening rule.
In this embodiment, the word document for exporting the student profile in step S2 is specifically as follows:
s201, establishing a Word module: according to the finally generated student file, compiling a student comprehensive quality file template in a command mode, namely formulating the student comprehensive quality file template through a template command;
s202, exporting a Word document: and (3) carrying out data binding on the cleaned data and the formulated student comprehensive quality file template, and exporting the final student file, as shown in the attached figure 2.
The rule engine in this embodiment is configured to convert the business rules into an execution tree, perform different filtering and integration on the effective data of the comprehensive quality archive, and summarize the effective data into a finally required data set.
The writing method adopted by the template instruction in the embodiment is that { } } represents an expression, and values are taken according to data in the expression.
Regarding the export function of the word archive, the main core of the export of the archive lies in the creation of an archive template; the template instruction mode is adopted to replace the complexity of traditional writing of a large number of codes, and meanwhile, the effectiveness of the template is improved due to the support of the instruction.
The template is a simple method for processing complex word, the complex word pattern can be directly edited by the word, the code writing pattern thunderbolt area is perfectly avoided, and meanwhile, the effectiveness of the template is improved by the support of the instruction
The following lists the instructions and roles supported below:
space segmentation;
trinocular operation { { testobj: obj2} };
n: indicating that this cell is of numerical type { { n: };
le: representative length { { le: () Use { { le: () >8obj 1: obj2} };
fd: formatting time { { fd: (obj; yyyy-MM-dd) });
fn: the formatted number { { fn: (obj; ###.00) } };
fe: traversing data and creating row;
a! fe: traversing data without creating row;
$ fe: downward shifting insertion, namely, downward shifting all the current line and the lower line;
# fe: traversing transversely;
v _ fe: traversing the values in the transverse direction;
a! if: delete current column {! if: (test) };
the apostrophe indicates that 1 is output as a constant value "such as 1";
balloon & space;
row change is carried out with multi-row traversal derivation;
sum: and (6) counting data.
The overall style is similar to that of an le expression, the adopted writing method is that { } } represents the expression, and then values are taken according to data in the expression.
The style of the student comprehensive quality archive template in the embodiment includes the following two forms:
firstly, fixing a table form: the original style of the label is not changed; as shown in the following table:
secondly, data list form: the template instructions are replicated from the line of the student's integrated quality profile template as shown in the following table:
job taking situation | |
Time | Description of the duties |
{{rz_date}} | {{rz_ms}} |
And combining the screened effective legal data of the comprehensive quality student archive of the rule engine, writing the effective legal data into the word document in a template instruction mode, and exporting and archiving the data. The method is simple, but still needs to write data screening rules and write word template documents according to self business requirements.
Example 2:
the invention relates to a device for rapidly exporting comprehensive quality evaluation files of students, which comprises,
the generating unit is used for summarizing the collected student evaluation data according to the index rule base and extracting a final effective student file;
and the export unit is used for exporting the generated student archive generated word document.
The production unit in this embodiment comprises,
the data acquisition module is used for acquiring archive data from the comprehensive quality evaluation system or acquiring archive data from the filled service data;
the rule making module is used for setting data screening rules of the student files according to different index rules;
and the data cleaning module is used for cleaning and filtering the data according to the set screening rule.
The derivation unit in the present embodiment includes,
the template formulation module is used for compiling a student comprehensive quality file template in a command mode according to the finally generated student file, namely formulating the student comprehensive quality file template through a template command;
and the file generation module is used for exporting the cleaned data into a standard word document.
The data cleaning module in the embodiment adopts a rule engine mode to make different index rules for different indexes of students, and the different index rules are screened and filtered;
the archive generation module in this embodiment designates a corresponding student comprehensive quality archive template in a template instruction manner, and finally performs data export in a data mapping binding manner.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for rapidly exporting comprehensive quality evaluation files of students is characterized by comprising the following steps:
generating a comprehensive quality evaluation file of students: summarizing the collected student evaluation data according to the index rule base, and extracting a final effective student file;
exporting word documents of the student files; and generating a word document from the student archives generated in the gathering mode and exporting the word document.
2. The method for rapidly exporting student comprehensive quality evaluation archives according to claim 1, wherein the student comprehensive quality evaluation archives are produced as follows:
acquiring archive data: collecting archive data from the comprehensive quality evaluation system or collecting archive data from the filled service data;
and (3) establishing rules of a rule engine: setting data screening rules of the student files according to different index rules;
rule screening data: and cleaning and filtering the data according to a set screening rule.
3. The method for rapidly exporting student comprehensive quality evaluation archives according to claim 1, wherein word documents exporting student archives are specifically as follows:
a Word module is formulated: according to the finally generated student file, compiling a student comprehensive quality file template in a command mode, namely formulating the student comprehensive quality file template through a template command;
exporting a Word document: and binding the cleaned data with the formulated student comprehensive quality file template to export a final student file.
4. The method for rapidly exporting comprehensive quality evaluation archives of students according to claim 1 or 2, wherein the rule engine is used for converting the business rules into an execution tree, and performing different screening, filtering and integration on the effective data of the comprehensive quality archives to summarize the effective data into a finally required data set.
5. The method for rapidly exporting the student comprehensive quality evaluation archive as claimed in claim 1 or 3, wherein the template instruction adopts a writing method of { } } for expression, and values are taken according to data in the expression.
6. The method for rapidly exporting student comprehensive quality evaluation archives according to claim 5, wherein the patterns of the student comprehensive quality archive templates include the following two forms:
firstly, fixing a table form: the original style of the label is not changed;
secondly, data list form: the template instructions are replicated according to the line of the student's integrated quality profile template.
7. A device for rapidly exporting comprehensive quality evaluation files of students, which is characterized by comprising,
the generating unit is used for summarizing the collected student evaluation data according to the index rule base and extracting a final effective student file;
and the export unit is used for exporting the generated student archive generated word document.
8. The student integrated quality evaluation archive rapid derivation apparatus as claimed in claim 7, wherein the production unit comprises,
the data acquisition module is used for acquiring archive data from the comprehensive quality evaluation system or acquiring archive data from the filled service data;
the rule making module is used for setting data screening rules of the student files according to different index rules;
and the data cleaning module is used for cleaning and filtering the data according to the set screening rule.
9. The student integrated quality evaluation archive rapid derivation apparatus according to claim 7 or 8, wherein the derivation unit comprises,
the template formulation module is used for compiling a student comprehensive quality file template in a command mode according to the finally generated student file, namely formulating the student comprehensive quality file template through a template command;
and the file generation module is used for exporting the cleaned data into a standard word document.
10. The device for rapidly exporting a student comprehensive quality evaluation archive according to claim 9, wherein the data cleaning module is used for formulating different index rules for different indexes of students based on a rule engine mode, and performing screening and filtering;
the file generation module designates a corresponding student comprehensive quality file template in a template instruction mode, and finally data export is performed in a data mapping binding mode.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011592372.XA CN112507683A (en) | 2020-12-29 | 2020-12-29 | Method and device for rapidly exporting comprehensive quality evaluation files of students |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011592372.XA CN112507683A (en) | 2020-12-29 | 2020-12-29 | Method and device for rapidly exporting comprehensive quality evaluation files of students |
Publications (1)
Publication Number | Publication Date |
---|---|
CN112507683A true CN112507683A (en) | 2021-03-16 |
Family
ID=74951939
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011592372.XA Pending CN112507683A (en) | 2020-12-29 | 2020-12-29 | Method and device for rapidly exporting comprehensive quality evaluation files of students |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112507683A (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107808356A (en) * | 2017-09-28 | 2018-03-16 | 浪潮软件集团有限公司 | Comprehensive quality evaluation system and method for evaluating comprehensive quality of students |
CN110674235A (en) * | 2019-08-13 | 2020-01-10 | 南方电网科学研究院有限责任公司 | Marketing and distribution topology file synchronous management system and method |
CN110688348A (en) * | 2019-10-09 | 2020-01-14 | 李智鹏 | File management system |
CN110955708A (en) * | 2018-09-27 | 2020-04-03 | 沈阳铝镁设计研究院有限公司 | Electrolytic aluminum plant equipment file acquisition system and method based on cloud |
CN112150119A (en) * | 2020-10-12 | 2020-12-29 | 浪潮云信息技术股份公司 | Comprehensive quality evaluation file generation and batch export system |
-
2020
- 2020-12-29 CN CN202011592372.XA patent/CN112507683A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107808356A (en) * | 2017-09-28 | 2018-03-16 | 浪潮软件集团有限公司 | Comprehensive quality evaluation system and method for evaluating comprehensive quality of students |
CN110955708A (en) * | 2018-09-27 | 2020-04-03 | 沈阳铝镁设计研究院有限公司 | Electrolytic aluminum plant equipment file acquisition system and method based on cloud |
CN110674235A (en) * | 2019-08-13 | 2020-01-10 | 南方电网科学研究院有限责任公司 | Marketing and distribution topology file synchronous management system and method |
CN110688348A (en) * | 2019-10-09 | 2020-01-14 | 李智鹏 | File management system |
CN112150119A (en) * | 2020-10-12 | 2020-12-29 | 浪潮云信息技术股份公司 | Comprehensive quality evaluation file generation and batch export system |
Non-Patent Citations (1)
Title |
---|
李东霖: "高新一种学生综合素质评价档案管理系统的设计与实现", 《硕士电子期刊 信息科技辑》 * |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106325969B (en) | The reversely tracing system of demand change | |
CN104077665A (en) | Power grid project manufacturing cost analysis data collecting system and method | |
CN112016287B (en) | Data management method, platform, storage medium and electronic equipment | |
CN102609520B (en) | Method for exporting model data of substation by filtering | |
CN106919612A (en) | A kind of processing method and processing device of SQL script of reaching the standard grade | |
CN112232047A (en) | Method, system, equipment and medium for multi-dimensional data acquisition and automatic summarization | |
CN105630986A (en) | Method for acquiring multidimensional data from database for grid display | |
CN116468010A (en) | Report generation method, device, terminal and storage medium | |
CN115840567A (en) | Application editing method and related equipment | |
CN111881579A (en) | Complex dynamic data model management method | |
CN106528566A (en) | Log file output method, server and client | |
CN111063444A (en) | Excel VBA-based death cause monitoring data analysis method | |
CN113282567A (en) | Method, system, medium and application for analyzing unsafe behavior database of operating personnel | |
CN112507683A (en) | Method and device for rapidly exporting comprehensive quality evaluation files of students | |
CN113255307A (en) | Intelligent reporting method and system for power system | |
CN111708814A (en) | Data statistical method, device, equipment and medium | |
CN116126443A (en) | Method and system for dynamically configuring electronic experiment record and report | |
CN108595593B (en) | Topic model-based conference research hotspot and development trend information analysis method | |
CN102866985A (en) | Data formatting device and method for on-line analytical processing system | |
CN107729305B (en) | Automatic conference material generation method based on database and front-end display technology | |
CN107945853B (en) | Medical quality reporting system based on metadata | |
CN104793372B (en) | The defects of different producing line liquid crystal modules grade decision method | |
CN107894940A (en) | A kind of log analysis device and method | |
CN107240150A (en) | A kind of three-dimensional tube numeral dissolves drawing method | |
CN102310950B (en) | Experiment intelligent interpretation system and method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210316 |