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 PDF

Info

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
Application number
CN202011592372.XA
Other languages
Chinese (zh)
Inventor
李曰超
左立峰
王宗超
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Cloud Information Technology Co Ltd
Original Assignee
Inspur Cloud Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur Cloud Information Technology Co Ltd filed Critical Inspur Cloud Information Technology Co Ltd
Priority to CN202011592372.XA priority Critical patent/CN112507683A/en
Publication of CN112507683A publication Critical patent/CN112507683A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/20Education
    • G06Q50/205Education 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

Method and device for rapidly exporting comprehensive quality evaluation files of students
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:
Figure BDA0002867261380000051
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.
CN202011592372.XA 2020-12-29 2020-12-29 Method and device for rapidly exporting comprehensive quality evaluation files of students Pending CN112507683A (en)

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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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