CN108710602A

CN108710602A - Processing method, device, computer equipment and the storage medium of achievement data

Info

Publication number: CN108710602A
Application number: CN201810460823.0A
Authority: CN
Inventors: 唐亮
Original assignee: Shenzhen Ji Yao Information Technology Co Ltd
Current assignee: Shenzhen Ji Yao Information Technology Co Ltd
Priority date: 2018-05-15
Filing date: 2018-05-15
Publication date: 2018-10-26

Abstract

The present invention provides a kind of processing method of achievement data, device, computer equipment and storage medium, this method：Judge whether the table in the first file that marking system generates has update according to the attribute information of table；When determining that the table in first file has update, newer table is obtained, and judges whether the newer table is achievement data table；If so, according to the mapping relations and the newer table that prestore, achievement analytical table is generated.In this method, the range that computer equipment obtains table can be reduced, expense is handled to reduce computer equipment.Further, low in the analysis efficiency for the Record Analysis System that traditional technology can be improved, the excessive problem of processing expense.

Description

Processing method, device, computer equipment and the storage medium of achievement data

Technical field

This application involves field of computer technology, more particularly to a kind of processing method of achievement data, device, computer Equipment and storage medium.

Background technology

With the development of information technology, more and more schools unite to the total marks of the examination of student using marking system Meter, to generate Students' Score List.Later, the student performance in Students' Score List is carried out by Record Analysis System personalized Analysis, to generate towards school leaders, form master or the teaching quality analysis of student report.

In Record Analysis System carries out personalized analytic process to the student performance in Students' Score List, need to learn The form of raw list of results is converted to the form that Record Analysis System can identify, then carries out subsequent personalization again Analysis.And carry out in above-mentioned form transfer process, the method for generally use keyword match analysis is converted, to The achievement data is filled in achievement analytical table.

But the analysis efficiency of the Record Analysis System of traditional technology is low, processing expense is excessive.

Invention content

Based on this, it is necessary in view of the above technical problems, provide a kind of place for the achievement data that can improve analysis efficiency Manage method, apparatus, computer equipment and storage medium.

In a first aspect, a kind of processing method of achievement data is provided, method, the method includes：

Judge whether the table in the first file that marking system generates has update according to the attribute information of table；Its In, the attribute information include the title of table, the modification time of table, the size of table, table content it is at least one；

When determining that the table in the file has update, newer table is obtained, and judges the newer table Whether it is achievement data table；

If so, according to the mapping relations and the newer table that prestore, achievement analytical table is generated；Wherein, described Mapping relations include the correspondence between achievement data tableau format and achievement analysis tableau format.

The processing method of achievement data provided in this embodiment, computer equipment are goed over examination papers according to the judgement of the attribute information of table Whether the table in the first file that system generates has update；When determining that the table in the file has update, obtain Newer table, and judge whether the newer table is achievement data table；If so, according to the mapping relations to prestore and The newer table generates achievement analytical table.Compared to traditional technology, during generating achievement analysis table, first Whether there is update to judge the table in the first file, further, when the table in the first file has update When, judge whether the newer table is achievement data table, and when newer table is achievement data table, it can just generate update The corresponding achievement analytical table of achievement data table.In this way, may make computer equipment only to the generation pair of newer achievement data table The achievement analytical table answered, without generating corresponding achievement analytical table to newer non-achievement data table, to which traditional skill can be improved The analysis efficiency of the Record Analysis System of art is low, the excessive problem of processing expense.

Second aspect, provides a kind of processing unit of achievement data, and described device includes：

First judgment module, the table in the first file for judging marking system generation according to the attribute information of table Whether lattice have update；Wherein, the attribute information include the title of table, the modification time of table, the size of table, in table That holds is at least one；

Acquisition module, for when determining that the table in the file has update, obtaining newer table；

Second judgment module, for judging whether the newer table is achievement data table；

Generation module, if being achievement data table for the newer table, according to the mapping relations and institute to prestore Newer table is stated, achievement analytical table is generated；Wherein, the mapping relations include achievement data tableau format and achievement analytical table Format between correspondence.

The third aspect, provides a kind of computer equipment, including memory and processor, and the memory is stored with computer Program, which is characterized in that the processor realizes that first aspect provides the processing of achievement data when executing the computer program Method.

Fourth aspect provides a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that Realize that first aspect provides the processing method of achievement data when the computer program is executed by processor.

The processing method of achievement data provided in this embodiment can make computer equipment according to the attribute information of table Judge whether the table in the first file that marking system generates has update；When determining that the table in the file has update When, newer table is obtained, and judge whether the newer table is achievement data table；If so, according to the mapping to prestore Relationship and the newer table generate achievement analytical table.Compared to traditional technology, in the process for generating achievement analysis table In, whether there is update to judge the table in the first file first, further, the table in the first file When having update, judge whether the newer table is achievement data table, and when newer table is achievement data table, it can just give birth to At the corresponding achievement analytical table of newer achievement data table.In this way, may make computer equipment only to newer achievement data table Corresponding achievement analytical table is generated, without generating corresponding achievement analytical table to newer non-achievement data table, to can be improved The analysis efficiency of the Record Analysis System of traditional technology is low, the excessive problem of processing expense.

Description of the drawings

Fig. 1 is the structural schematic diagram of the processing system for the achievement data that one embodiment provides；

Fig. 2 is the flow diagram of the processing method for the achievement data that one embodiment provides；

Fig. 3 is the flow diagram of the processing method for the achievement data that another embodiment provides；

Fig. 4 is the flow diagram of the processing method for the achievement data that another embodiment provides；

Fig. 5 is the flow diagram of the processing method for the achievement data that another embodiment provides；

Fig. 6 is the flow diagram of the processing method for the achievement data that another embodiment provides；

Fig. 7 is the flow diagram of the processing method for the achievement data that another embodiment provides；

Fig. 8 is the structural schematic diagram of the processing unit for the achievement data that one embodiment provides；

Fig. 9 is the structural schematic diagram of the processing unit for the achievement data that another embodiment provides；

Figure 10 is the structural schematic diagram of the processing unit for the achievement data that another embodiment provides；

Figure 11 is the structural schematic diagram of the processing unit for the achievement data that another embodiment provides；

Figure 12 is the internal structure chart for the computer equipment that one embodiment provides.

Specific implementation mode

Based on the above, the processing method of achievement data provided by the embodiments of the present application be applicable to it is shown in FIG. 1 at The processing system of achievement data.The system may include scanner, marking system and Record Analysis System, scanner and marking system Between the paper of scanning can be transferred to go over examination papers by electronic form and be by wired or wirelessly connect Obtained achievement result after marking system corrects the electronic test paper of scanner scanning, is sent to achievement analysis by system System, so that Record Analysis System can analyze achievement result.Optionally, marking system can be analyzed with achievement System is independently arranged, i.e., marking system and Record Analysis System can be independent computer equipment respectively, alternatively, marking system It can also be integrated in Record Analysis System in a computer equipment, the present embodiment does not limit this.It needs to illustrate It is that Fig. 1 is only a kind of exemplary illustration.

In the conventional technology, lattice usually are carried out to the Students' Score List that marking system generates in the processing system of achievement data When formula is converted, it is low that there are analysis efficiencies, the big problem of processing expense.The processing method of achievement data provided by the present application, device, Computer equipment and storage medium aim to solve the problem that traditional technology technical problem as above.

It should be noted that the executive agent of following methods embodiment can be various computer equipments, such as personal meter Calculation machine, notebook and tablet computer etc., the application do not limit herein, and the executive agent of following methods embodiment is to calculate It is illustrated for machine equipment.

It is with reference to the accompanying drawings and embodiments, right in order to make the object, technical solution and advantage of the application be more clearly understood The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not For limiting the application.

Fig. 2 is the flow diagram of the processing method for the achievement data that one embodiment provides, and the present embodiment refers to Computer equipment has newer table in the first file that marking system generates, and newer table is achievement data table When, according to the mapping relations and newer table to prestore, generate the process of achievement analytical table.This method includes：

S101, judged according to the attribute information of table marking system generate the first file in table whether have more Newly；Wherein, the attribute information include the title of table, the modification time of table, the size of table, table content at least one It is a.

Specifically, above-mentioned marking system after the electronic test paper to scanner scanning is corrected, can will obtain Table is stored in the first file.It should be noted that above-mentioned marking system can also generate other according to the instruction of user Table, and be stored in the first file, such as generate according to questionnaire input by user the table of investigation result and also can It is stored in the first file.Again alternatively, list data in the other equipment that can be communicated with marking system, specific at some In the case of, it can also be stored in the first file.Again alternatively, user may carry out maloperation, such as non-marking system is given birth to At table be put into the first file, or due to computer equipment disorder, by non-marking system generation table be put into first In file.Can also include other tables that is, may include achievement data table in the first file of this implementation Lattice.

Optionally, above-mentioned first file can be named in a manner of adding examination title term, for example, 2017.09- 2018.01 grade eight midterm examination.Optionally, the achievement data table in the first file can in such a way that class adds subject into Row name, for example, five classes of Chinese Achievement Test tables.It should be noted that the above-mentioned name to the first file and achievement data table Mode can express out the exam information of examinee's examination, but above-mentioned naming method is only a kind of example, specifically how right First file and achievement data table are named, and are determined by marking system.In addition, achievement data table is an electronic watch Lattice, such as Excel tables or WPS tables etc., the format that the format of the table can be as described in Table 1.

The number of examining	00001	0002	0003	……
					Single choice 1	3	0	3
……
					Multiselect 1	5	3	5
……
					Letter answers 1	10	8	5
……
					Total score	90	85	90

Table 1

Specifically, when whether the table in judging the first file has update, can be carried out according to the attribute information of table Judge.Wherein, attribute information include the title of table, the modification time of table, table size (memory size) at least One.Optionally, computer equipment judges whether the table in the first file has update, can be by following several possible Embodiment is realized：

The first possible realization method：If the title and previous moment of the table in the first file described in current time Table title it is different, it is determined that the table in first file has update.

Specifically, the table in the first file of computer equipment pair carries out the scanning of fixed cycle, or scanning in real time, Or it is scanned under the scan instruction that user sends.In scanning process, the title in the first file is recorded Come, compares the title that the adjacent twice sweep moment records.If the title and previous moment of current time record The title of table is different, then illustrates that the table in the first file has and increase new table, i.e. table in the first file There are update, newer table to be different from the title pair of the table of previous moment record in the title for the table of current time record The table answered.

For example, the title for the table that computer equipment is recorded in previous moment is respectively：One class of Chinese Achievement Test table, class Three's language Literary list of results, Fourth Shift's Chinese Achievement Test table and five classes of Chinese Achievement Test tables.The current time title of table of record is respectively：One class Chinese Achievement Test table, two classes of Chinese Achievement Test tables, class Three's Chinese Achievement Test table, Fourth Shift's Chinese Achievement Test table and five classes of Chinese Achievement Test tables.By Different with the title of the table of previous moment record in the title of the table of current time record, different titles correspond to Table be two classes of Chinese Achievement Test tables, at this point, computer equipment judges that the table in the first file has update, newer table For two classes of Chinese Achievement Test tables.Wherein, before the table in the first file of computer equipment pair is scanned, computer is set Standby scan path is set as the path of the first file, i.e. computer equipment only scans the table in the first file, in this way, The scanning range that computer equipment can be reduced, to reduce the operation load of computer equipment.

Second of possible realization method be：If table described in the modification time and previous moment of the table at current time Modification time is different, it is determined that the table in first file has update.

Specifically, in the realization method, computer is in scanning process, by the modification time of the table in the first file It records, than the modification time for the same table that the adjacent twice sweep moment is recorded.If the table of current time record Modification time is different from the modification time of the table of same names in previous moment, then illustrate the table in the first file have by The table of modification, that is, have the update, newer table to be：The table of modification time variation.For example, computer equipment is in previous moment The modification time of one class of Chinese Achievement Test table of record is 20,18/,5/5 11：09, in one class of Chinese Achievement Test table of current time record Modification time be 20,18/,5/5 11：30.Since the corresponding modification time of identical table is different, it is determined that the first file In one class of Chinese language table have update.

The third possible realization method is：If the size of table described in the size and previous moment of the table at current time It is different, it is determined that the table in first file has update.

Specifically, in the realization method, computer is in scanning process, by the big small records of the table in the first file Get off, than the size for the table that the adjacent twice sweep moment is recorded.If current time record table size with it is previous when The table of same names is of different sizes in quarter, then illustrates that the table in the first file has the table changed, that is, have update, Newer table is：The changed table of memory size.For example, one class of Chinese language in previous moment record of computer equipment The memory size 325K of list of results is 400K in the memory size of one class of Chinese Achievement Test table of current time record.Due to identical The memory size of table is different, it is determined that one class of Chinese Achievement Test table in the first file has update.

4th kind of possible realization method be：If the content of table described in the content and previous moment of the table at current time It is different, it is determined that the table in first file has update.

Specifically, in the realization method, computer is in scanning process, by the content record of the table in the first file Get off, than the content for the table that the adjacent twice sweep moment is recorded.If current time record table size with it is previous when The content of the table of same names is different in quarter, then illustrates that the table in the first file has the table changed, that is, have update, Newer table is：The changed table of table content.For example, one class of Chinese language recording in previous moment of computer equipment at The table content of achievement table is the corresponding achievement data of 50 numbers of examining, in the table of one class of Chinese Achievement Test table of current time record It is the corresponding achievement data of 55 numbers of examining to hold.Since the corresponding table content of the table of the title of identical table is different, then really One class of Chinese language table in fixed first file has update.

Optionally, computer equipment can also be simultaneously according to the size, the content of table, table of the table in above-mentioned attribute information At least two in the modification time of lattice, judge whether the table in the first file has update.Specific judgment mode is for example above-mentioned Possibility realization method.It is of course also possible to according to above-mentioned attribute information, the table in the first file is otherwise judged Whether update is had.In this regard, the present embodiment does not limit.

Corresponding above-mentioned several possible realization methods, if the table in the first file does not update, computer equipment etc. It waits for next scanning moment, whether the table carried out in the first file next time has newer judgement.

S102, when determining that the table in first file has update, obtain newer table, and described in judging more Whether new table is achievement data table.

Specifically, when computer equipment judges that the table in the first file has update, newer table is obtained, and sentence Whether the newer table that breaks is achievement data table；When computer equipment judge the table in the first file without update when, then without It need to judge whether the table is achievement data table, to save the processing expense of computer equipment.It wherein, can based on above-mentioned S101 Know, the form of expression of newer table can be：The title of table have newly increase, the modification time of the table of same name Change, the content of the table of same name changes, the size of the table of same name changes.

It wherein, can be according in the table in newer table when whether judge newer table is achievement data table Appearance is judged.Optionally, computer equipment prestores the table format of the achievement data table of marking system generation, is denoted as the One table format.That is, computer equipment can know in advance marking system generate achievement data table cell in deposit Which information storage is, for example, the cell storage of which row is the information such as examination score value.Based on this, computer equipment can Judge whether the newer table is achievement data table according to the content in the examination score value region in table.For example, at Score value in achievement tables of data is that a numerical value rather than a character or one are more than a certain range of numerical value (for example, 200), Also, computer equipment can also judge whether the newer table is achievement according to the corresponding examination paper type of score value of taking an examination in table The corresponding examination paper type of examination score value is the character of a preset length in tables of data, such as table, for example, single choice 1, multiselect 2 etc., And not one be more than preset characters length, for example, whether you like the styles of teaching of Mr. Zhang.

Based on this, the score value region that computer equipment can on merit in tables of data, and/or according to the corresponding examination paper of score value The character length of type is judged.Specifically, when score value be no more than the numerical value of a preset value when and/or score value it is corresponding When the character length of examination paper type is not more than a preset characters length, then judge the table for achievement data table, otherwise for it is non-at Achievement tables of data.It is of course also possible to judge whether the table in the first file is achievement data table according to other modes, specifically such as Embodiment shown in lower.It should be noted that how the present embodiment is to according to the content in table to judge whether the table is into The concrete mode of achievement tables of data does not limit, as long as judging whether the table is achievement data table according to the content in table Method, all within the protection domain of the present embodiment.

S103, if so, according to the mapping relations and the newer table to prestore, generate achievement analytical table；Wherein, The mapping relations include the correspondence between achievement data tableau format and achievement analysis tableau format.

Specifically, the processing method of achievement data provided in this embodiment can in the first file newer table be at When achievement tables of data, achievement analytical table corresponding with achievement data table is generated.And in the first file newer table be it is non-at When achievement tables of data, the achievement analytical table with non-achievement data table is not generated.In this way, can avoid the generation institute of computer equipment blindness There is the corresponding achievement analytical table of newer table, to reduce the processing expense of computer equipment.

When newer table is achievement data table, the realization method of above-mentioned S103 can be：

Achievement analytical table is generated by crucial word analysis according to the table and preset mapping relations.Wherein, it calculates Achievement analysis tableau format is prestored in machine equipment, i.e., fills in examination basic information in the gauge outfit of achievement analytical table in advance, For example, the first row of the first row fills in the number of examining of all examinees, the secondary series of the first row fills in name, and the third row of the first row are filled out It is written as examinee's gender, the Nth column of the 4th row to the first row of the first row fills in examination paper type etc. respectively.It should be noted that this Embodiment does not limit the specific format of achievement analytical table.In addition, in achievement analytical table in addition to Table Header information, other cells For sky.Based on this, in a kind of example, it can be table shown in following table 2 to prestore achievement analysis tableau format：

The number of examining

Name

Gender

Single choice 1

……

Multiselect 1

……

Letter answers 1

……

00001

00002

……

Table 2

Specifically, according to the table and preset mapping relations, by crucial word analysis, the tool of achievement analytical table is generated Body mode is：Tableau format is analyzed based on achievement, according to certain sequence, extraction needs the corresponding row of the cell of typing score value to close Key word and row keyword；According to row keyword and row keyword, searches in achievement data table and closed with row keyword and row respectively Numerical value in the corresponding cell of the identical keyword of key word；By the numerical value typing found to the cell for needing typing score value In.For example, the table format based on achievement data table shown in achievement analysis sheet format shown in above-mentioned table 2 and table 1, and surname Name and gender are computer equipment or user's typing, in typing when the cell of other non-typing score values, according to from top to bottom, from Left-to-right sequential search first needs the cell (" 0001 " and " single choice 1 " corresponding cell) of typing score value, and carries Take the corresponding row keyword " 0001 " of the cell and row keyword " single choice 1 "；In table 1 above, search " 0001 " with Content in " single choice 1 " corresponding cell, i.e., " 3 "；It is " 0001 ", and row key that " 3 ", which are entered into row keyword in table 2, Word is in " single choice 1 " corresponding cell.Repeat the above steps, until by table 2 institute typing score value in need cell record Until entering score value, to generate achievement analytical table.

If in addition, in above-mentioned achievement analytical table be logged score value in the cell of typing score value in need after, and When still having the score value of non-typing in above-mentioned table 1, then illustrate there is the corresponding total marks of the examination number of the number of examining newly increased in table 1 According to.At this point, computer equipment reads the corresponding number of examining of score value of non-typing, and it is stored in the last one in first row in table 2 and examines In the next unit lattice of number corresponding cell, and according to the method described above, the corresponding score value of the typing number of examining newly increased.

It should be noted that above-mentioned table 2 is only a kind of exemplary illustration, above-mentioned achievement data tableau format may be used also Think the table of other forms.Optionally, can be typing have a name and gender, the table of the corresponding score value of non-typing examination paper type Sound of laughing formula.Optionally, in order to reduce operation complexity, all numbers of examining and examination basis letter can be prestored in computer equipment The mapping relations of breath, for example, identification card number corresponding with the number of examining, name, gender, class etc..Achievement analytical table is generated afterwards When, it is thus only necessary to user fills in the number of examining, other examination basic informations by computer equipment according to above-mentioned mapping relations, into Row keyword match, to generate complete achievement analytical table.

Corresponding to above-mentioned S103, if the table increased newly in the first file is non-achievement data table, computer equipment Wait for whether next scanning moment, progress have newer judgement to the table in the first file next time.

The processing method of achievement data provided in this embodiment, computer equipment are goed over examination papers according to the judgement of the attribute information of table Whether the table in the first file that system generates has update；When determining that the table in file has update, update is obtained Table, and judge whether newer table is achievement data table；If so, according to the mapping relations and newer table that prestore Lattice generate achievement analytical table.Compared to traditional technology, during generating achievement analysis table, first to the first file In table whether there is update to be judged, further, when the table in the first file has update, judge the update Table whether be achievement data table, and when newer table be achievement data table when, can just generate newer achievement data table Corresponding achievement analytical table.In this way, computer equipment may make only to generate corresponding achievement to newer achievement data table and analyze Table, without generating corresponding achievement analytical table to newer non-achievement data table, to which the achievement analysis of traditional technology can be improved The analysis efficiency of system is low, the excessive problem of processing expense.

Based on above-mentioned embodiment as shown in Figure 1, in a kind of optional embodiment, computer equipment can also be according to such as Under type judges whether newer table is achievement data table：

It whether there is preset examination information parameter according to the content in the newer table, determine the update Table whether be achievement data table；Wherein, the examination information parameter includes examination paper type identification, each examination paper type Under examination paper mark, at least one of the examination paper quantity under each examination paper type.

Specifically, prestoring examination information parameter in computer equipment, wherein exam information parameter is examination paper class At least one of the examination paper quantity under examination paper mark, each examination paper type under type mark, each examination paper type.For example, this Examination paper type identification in secondary exam information parameter is：Single choice, multiple choice, simple answer, additional topic；It is corresponding, each examination paper Type identification is respectively：Single choice 1, single choice 3, multiple choice 1, multiple choice 2, simple answer 1, adds topic 1 and adds single choice 2 Topic 2；Corresponding, the examination paper quantity under each examination paper type is respectively：Single choice 3, multiselect be 2 entitled, simple answer be 1 with And it is entitled 2 additional.

Based on the above, realize judge shown in above-described embodiment newer table whether be achievement data table side Formula is specially：Computer equipment traverses the content in newer table, the result traversed；It searches in traversing result With the presence or absence of the examination paper mark of examination；If in the presence of illustrating that newer table is otherwise achievement data table illustrates to update Table be non-achievement data table.Based on above-mentioned example, if in the result of traversal there are single choice, multiple choice, simple answer with And additional topic and/or single choice are 3 entitled, multiselect is 2 entitled, simple answer is 1 and add entitled 2 and/or single choice Including：Single choice 1, single choice 2, single choice 3, multiple choice include multiple choice 1, multiple choice 2, and multiple choice includes：It is multiple choice 1, more The selected topic 2, additional topic include：Additional topic 1 and additional topic 2 then illustrate that newer table is achievement data table.

On the basis of the above embodiments, optionally, the application also provides a kind of true according to the content in newer table Whether the fixed newer table is achievement data table mode, and which is：

According to the first table format of preset marking system, judge the content in the newer table with the presence or absence of pre- If examination information parameter, and determine whether the newer table is achievement data table according to judging result.

Specifically, computer equipment prestores the first table format of the achievement data table of marking system generation, wherein First table format is used to indicate the storage location of examination parameter information in achievement tables of data.That is, computer equipment exists After getting the first table format, the target area that examination information parameter stores in achievement data table will be known, such as Single choice, multiple choice, simple answer and the additional topic that computer equipment is known in advance in examination parameter information are stored in The first row in achievement data table is based on this, and computer equipment can be according to the first table format, the table in the first file Target area in searched, if examination parameter information can be found, if in the presence of illustrate newer table be achievement Otherwise data form is non-achievement data table.Judge whether newer table is achievement data based on provided in this embodiment The mode of table can reduce the seeking scope in newer table of computer equipment, to reduce computer equipment Handle expense.

On the basis of the above embodiments, as shown in figure 3, optionally, the application also provides a kind of to go over examination papers according to preset The first table format that system generates, determine newer table whether be achievement data table mode, which is：

S201, the ranks mark for obtaining storage exam information parameter in first table format.

Specifically, the ranks mark of examination information parameter can be stored in the present embodiment in the first table format, wherein The row and column of cell where ranks mark refers to examination parameter information.For example, when parameter information of taking an examination is single choice 1, base In above-mentioned table 1, the ranks mark of above-mentioned exam information parameter refers to the mark of 1 corresponding cell row and column of single choice, That is the second row and secondary series.Based on this, computer equipment can be known in advance all examination informations parameter in the first table Ranks mark in format.

S202, judge to examine with the presence or absence of described this in ranks corresponding with ranks mark in the newer table Try information parameter.

S203, if so, determining that the newer table is achievement data table.

Based on the above-mentioned explanation to S201, computer equipment is in the ranks mark for learning all examination parameter informations Afterwards, it is identified according to ranks, identical ranks is searched in newer table and identify corresponding cell, and judge that the cell corresponds to Content whether be examination information parameter, if so, show newer table be achievement data table.It is corresponding, if it is not, then Show that newer table is non-achievement data table.Based in above-mentioned S201 for example, if the second row and secondary series are determined Cell in content be " single choice 1 " when, determine newer table be achievement data table.It optionally, can also be according to first The ranks mark of part examination information parameter, judges to whether there is in corresponding ranks in newer table in table format Above-mentioned part exam information parameter.When it is present, determine that newer table is achievement data table.

In the present embodiment, computer equipment obtains the ranks mark of storage exam information parameter in the first table format； Judge to whether there is examination information parameter in newer table in ranks corresponding with ranks mark；If so, determining more New table is achievement data table.In the present embodiment, computer equipment is according to the ranks mark with storage in newer table Know the exam information parameter in corresponding ranks, judges newer table for achievement data table, the present embodiment further reduces The processing expense of computer equipment.

Fig. 4 is the flow diagram of the processing method for the achievement data that another embodiment provides, what the present embodiment was related to It is computer equipment after determining that newer table is achievement data table, judges whether the score value in newer table is correct Process, this method include：

S301, determine the newer table be achievement data table after, judge each to examine in the newer table Whether the score value under topic mark is located in preset numberical range.

S302, if it is not, then by the award indicators be abnormal score.

Specifically, in the present embodiment, computer equipment can prestore each examination paper in examination parameter information Corresponding maximum score value (i.e. full marks value) under each examination paper mark under type, above-mentioned preset numberical range is for 0 to each examining The corresponding maximum score value of topic mark.For example, computer equipment can store the corresponding maximum score value of single choice 1, i.e. single choice 1 is corresponding full Divide score value, such as 5.Computer equipment judges after determining that newer table is achievement data table under each examination type Each examination paper identify corresponding score value whether in preset numberical range.

Based on the above it is found that when the score value under each examination paper mark is not in preset numberical range, then say Score value under bright examination paper mark is an abnormal score, at this point, being abnormal score by the award indicators.Generating achievement analytical table When, it will be highlighted labeled as the data of abnormal score, such as overstriking, underline or show in different colors etc. Reason, to prompt user's score value for an abnormal score.Based on this, in the present embodiment, computer equipment can to abnormal score into Line flag, when exporting achievement analytical table, user can be based on the label and distinguish abnormal score and normal such computer equipment Score value improves the intelligent of human-computer interaction.

Fig. 5 is the flow diagram of the processing method for the achievement data that another embodiment provides, what the present embodiment was related to It is computer equipment after generating achievement analytical table, process achievement analytical table being stored in file.Any of the above-described On the basis of embodiment, this method may include：

S104, judge under current path with the presence or absence of the second file with the name-matches of the first file, wherein institute It is the file for storing the achievement analytical table to state the second file.

S105, if it is not, then create the second file of same names according to the title of the first file, and by the achievement Analytical table is stored into second file.

Specifically, above-mentioned current path can be set by user, or a default path.Computer equipment After generating achievement analytical table, judge under current path with the presence or absence of the second file to match with the first file, example Such as, file identical with the first folder name, alternatively, with the relevant file of the first folder name (for example, first Preset suffix title of nominally increase of file etc.).

If there is the second file to match with the first file under current path, computer equipment analyzes achievement Table is stored in the second file.It is corresponding, if the second file to match with the first file is not present under current path, Computer equipment creates the second file under current path, second file it is entitled identical as the first folder name File, or after the title of the first file plus the title as the second file such as preset suffix.In addition, needing It is noted that the present embodiment does not limit the specific naming method of the second file.

Optionally, in order to ensure achievement analytical table by it is permanent and stablize reservation, the second above-mentioned file can be stored In the database.Based on this, on the basis of above-mentioned embodiment as shown in Figure 5, the processing of achievement data provided in this embodiment Method further includes：Second file is stored in into database.

In the present embodiment, computer equipment is after generating achievement analytical table, judge under current path with the presence or absence of with Second file of the name-matches of the first file；If it is not, then creating the of same names according to the title of the first file Two files, and the achievement data table is stored into second file.I.e. the present embodiment can be to the achievement of generation point It analyses table and carries out classification storage, may make that achievement analytical table is accurately found in this way, and then improve computer equipment and executing this reality Apply example offer achievement data processing method when it is intelligent.

In one embodiment, content there is a possibility that by modification in the achievement data table generated due to marking system, For example, user find marking system generate achievement data table in there are a certain score value be by marking system misregistration, at this point, The mistake score value is revised as correct score value by user.Since the processing method of achievement data provided in this embodiment can be to update Achievement data table handled, to generate achievement analytical table, therefore, user to wrong score value change before, computer equipment The corresponding achievement analytical table of the achievement data table changed is generated.Based on such situation, the embodiment of the present application also provides A kind of processing method of achievement data, as shown in fig. 6, based on any of the above embodiments, this method can also include：

If S401, subsequent time, stores to the achievement analytical table in the database and correspond in first file The content of table there is update, then obtain the achievement analytical table and correspond in the update of the table in first file Hold.

More new content described in S402, extraction, and will be in the update content update to the achievement analytical table.

Specifically, based on the content described in above-mentioned S101 it is found that computer equipment can be to the table in the first file It is scanned, and records the attribute information of the first file in scanning process, wherein attribute information may include table Lattice content.Therefore, the subsequent time at current time (i.e. corresponding next scanning moment at Current Scan moment) is recorded respectively The table content of same table is compared, if table content is identical, without any processing.If conversely, lower a period of time It carves corresponding table content and is not entirely identical to corresponding table content of above-mentioned current time, at this point, according to subsequent time pair The table content answered traverses corresponding table content of above-mentioned current time, the content being updated in lookup table, and extracts this The corresponding ranks mark of content being updated.It is identified according to the ranks, in the corresponding achievement analytical table of the table being updated Corresponding cell is found, and the content in the cell is replaced with to the content being updated.

In the present embodiment, if subsequent time, the achievement analytical table stored into database corresponds in the first file The content of table there is update, then obtain the more new content that achievement analytical table corresponds to table in the first file；Extraction More new content, and will update in content update to achievement analytical table.In this way, when the achievement in the first file of computer equipment pair After tables of data has generated achievement analytical table, the table content quilt of the table in corresponding first file of the achievement analytical table When update, no longer need to generate corresponding achievement analytical table to the table, it is thus only necessary to change the content being updated, can drop in this way The processing expense of low computer equipment, and reduce the memory size of computer equipment.

It is following by a simply example, come introduce achievement data of the embodiment of the present invention processing method process.Tool Body may refer to shown in Fig. 7：

The paper of scanning is transferred to marking system by S501, scanner by electronic form.

After S502, marking system correct the electronic test paper of scanner scanning, obtained table is stored in In one file.

S503, Record Analysis System scan the table in the first file, and being goed over examination papers according to the judgement of the attribute information of table is Whether the table in the first file that system generates has update.

The detailed process of the S503 may refer to above-described embodiment, and details are not described herein.

S504, when the table during Record Analysis System determines the first file has update, obtain newer table.

The row of exam information parameter is stored in first table format of the achievement data table that S505, acquisition marking system generate Row mark.

S506, judge to believe with the presence or absence of the examination in ranks corresponding with ranks mark in newer table Cease parameter.

S507, if so, determining that newer table is achievement data table.

The mapping relations and the newer table that S508, basis prestore, generate achievement analytical table；Wherein, described to reflect The relationship of penetrating includes the correspondence between achievement data tableau format and achievement analysis tableau format.

Optionally, which can also include the following steps：

S509, judge under current path with the presence or absence of the second file with the name-matches of the first file.

If the second file with the name-matches of the first file is not present under S510, current path, according to first The title of file creates the second file of same names, and the achievement analytical table is stored to second file In.

S511, second file is stored into database.

If S512, subsequent time, stores to the achievement analytical table in the database and correspond in first file The content of table there is update, then obtain the achievement analytical table and correspond in the update of the table in first file Hold.

More new content described in S513, extraction, and will be in the update content update to the achievement analytical table.

The operation principle and technique effect of the processing method of achievement data provided in this embodiment as described in above-described embodiment, Details are not described herein.

It should be understood that although each step in the flow chart of Fig. 2-7 is shown successively according to the instruction of arrow, These steps are not that the inevitable sequence indicated according to arrow executes successively.Unless expressly stating otherwise herein, these steps Execution there is no stringent sequences to limit, these steps can execute in other order.Moreover, at least one in Fig. 2-7 Part steps may include that either these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps Completion is executed, but can be executed at different times, the execution sequence in these sub-steps or stage is also not necessarily successively It carries out, but can either the sub-step of other steps or at least part in stage be in turn or alternately with other steps It executes.

In one embodiment, as shown in figure 8, providing a kind of processing unit of achievement data, including：First judges mould Block 11, acquisition module 12, the second judgment module 13 and generation module 14, wherein：

First judgment module 11 is used to be judged according to the attribute information of table in the first file that marking system generates Whether table has update；Wherein, the attribute information includes the title of table, the modification time of table, the size of table, table Content it is at least one；

Acquisition module 12, for when determining that the table in the file has update, obtaining newer table；

Second judgment module 13, for judging whether the newer table is achievement data table；

Generation module 14, if being achievement data table for the newer table, according to the mapping relations that prestore and The newer table generates achievement analytical table；Wherein, the mapping relations include that achievement data tableau format is analyzed with achievement Correspondence between tableau format.

The processing unit of achievement data provided in this embodiment can execute the embodiment of the above method, realization principle Similar with technique effect, details are not described herein.

In one embodiment, above-mentioned second judgment module 13 is specifically used for according to the content in the newer table With the presence or absence of preset examination information parameter, determine whether the newer table is achievement data table；Wherein, described Secondary exam information parameter includes the examination paper mark under examination paper type identification, each examination paper type, the examination paper under each examination paper type At least one of quantity.

In one embodiment, above-mentioned second judgment module 13 is specifically used for the first table according to preset marking system Sound of laughing formula judges that the content in the newer table whether there is preset examination information parameter, and is tied according to judgement Fruit determines whether the newer table is achievement data table.

In one embodiment, above-mentioned second judgment module 13 is stored specifically for obtaining in first table format The ranks of exam information parameter identify, and judge whether deposited in ranks corresponding with ranks mark in the newer table In the examination information parameter；If so, determining that the newer table is achievement data table.

In one embodiment, on the basis of above-mentioned embodiment illustrated in fig. 8, as shown in figure 9, above-mentioned achievement data Processing unit further includes：Third judgment module 15.Wherein：

Third judgment module 15, for after determining that the newer table is achievement data table, judging the update Table in the lower score value of each examination paper mark whether in preset numberical range；And it is each in the newer table It is abnormal score by the award indicators when score value under examination paper mark is not located in preset numberical range.

In one embodiment, the first above-mentioned judgment module 11, if specifically for the first file described in current time In table title it is different from the title of the table of previous moment, it is determined that the table in first file has update； Alternatively, if the modification time of the table at current time is different from the modification time of table described in previous moment, it is determined that described Table in one file has update；Alternatively, if the size of table described in the size and previous moment of the table at current time is not Together, it is determined that the table in first file has update；If alternatively, the content of the table at current time and previous moment institute The content for stating table is different, it is determined that the table in first file has update.

In one embodiment, on the basis of above-mentioned Fig. 8 or embodiment illustrated in fig. 9, as shown in Figure 10, above-mentioned achievement The processing unit of data further includes：4th judgment module 16 and creation module 17.Wherein：

4th judgment module 16, for judging under current path with the presence or absence of second with the name-matches of the first file File, wherein second file is the file for storing the achievement analytical table.

Creation module 17, when for there is the second file with the name-matches of the first file under current path, The second file of same names is created according to the title of the first file, and the achievement analytical table is stored to described second In file.

In one embodiment, above-mentioned creation module 17 is additionally operable to store second file into database.

In one embodiment, on the basis of above-mentioned embodiment illustrated in fig. 10, as shown in figure 11, above-mentioned achievement data Processing unit further include：Update module 18.Wherein：

Update module 18 is stored to the achievement analytical table in the database and is corresponded to described the if being used for subsequent time There is update in the content of the table in one file, then obtain the achievement analytical table and correspond to the table in first file The more new content of lattice；More new content described in extraction, and will be in the update content update to the achievement analytical table.

The processing unit for the achievement data that above-described embodiment provides, can execute the implementation of above-mentioned method as seen in figures 3-6 Example, implementing principle and technical effect are similar, and details are not described herein.

The specific of processing unit about achievement data limits the processing method that may refer to above for achievement data Restriction, details are not described herein.Modules in the processing unit of above-mentioned achievement data can be fully or partially through software, hard Part and combinations thereof is realized.Above-mentioned each module can be embedded in or in the form of hardware independently of in the processor in computer equipment, It can also in a software form be stored in the memory in computer equipment, the above modules are executed in order to which processor calls Corresponding operation.

In one embodiment, a kind of computer equipment is provided, internal structure chart is shown in Fig.12.The calculating Machine equipment includes processor, memory, network interface, display screen and the input unit connected by system bus.Wherein, the meter The processor of machine equipment is calculated for providing calculating and control ability.The memory of the computer equipment includes that non-volatile memories are situated between Matter, built-in storage.The non-volatile memory medium is stored with operating system and computer program.The built-in storage is non-volatile The operation of operating system and computer program in storage medium provides environment.The network interface of the computer equipment be used for it is outer The terminal in portion is communicated by network connection.To realize a kind of processing side of achievement data when the computer program is executed by processor Method.The display screen of the computer equipment can be liquid crystal display or electric ink display screen, the input of the computer equipment Device can be the touch layer covered on display screen, can also be the button being arranged on computer equipment shell, trace ball or tactile Plate is controlled, can also be external keyboard, Trackpad or mouse etc..

It will be understood by those skilled in the art that structure shown in Figure 12, only with the relevant part of application scheme The block diagram of structure, does not constitute the restriction for the computer equipment being applied thereon to application scheme, and specific computer is set Standby may include either combining certain components than more or fewer components as shown in the figure or being arranged with different components.

In one embodiment, a kind of computer equipment, including memory and processor are provided, is stored in memory Computer program, the processor realize following steps when executing computer program：

When determining that the table in first file has update, newer table is obtained, and is judged described newer Whether table is achievement data table；

In one embodiment, following steps are also realized when processor executes computer program：

Obtain the ranks mark that exam information parameter is stored in first table format；Judge in the newer table It whether there is the examination information parameter in ranks corresponding with ranks mark；If so, determination is described newer Table is achievement data table.

After determining that the newer table is achievement data table, each examination paper mark in the newer table is judged Under score value whether be located at preset numberical range in；If it is not, being then abnormal score by the award indicators.

If the title of the table in the first file described in current time is different from the title of the table of previous moment, really Table in fixed first file has update；If alternatively, described in the modification time and previous moment of the table at current time The modification time of table is different, it is determined that the table in first file has update；If alternatively, the table at current time Size is of different sizes with table described in previous moment, it is determined that the table in first file has update；If alternatively, working as The content of the table at preceding moment is different from the content of table described in previous moment, it is determined that the table in first file has Update.

Judge under current path with the presence or absence of the second file with the name-matches of the first file, wherein described the Two files are the file for storing the achievement analytical table；If it is not, then being created according to the title of the first file identical Second file of title, and the achievement analytical table is stored into second file.

Second file is stored into database.

If subsequent time, stores to the achievement analytical table in the database and correspond to the table in first file Content there is update, then obtain the more new content for the table that the achievement analytical table corresponds in first file；It carries The more new content is taken, and will be in the update content update to the achievement analytical table.

In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated Machine program realizes following steps when being executed by processor：

If so, according to the mapping relations and the newer table that prestore, achievement analytical table is generated；Wherein, described Mapping relations include the correspondence between achievement data tableau format and achievement analysis tableau format.In one embodiment, Following steps are also realized when computer program is executed by processor：

In one embodiment, following steps are also realized when computer program is executed by processor：

Second file is stored into database.

One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer In read/write memory medium, the computer program is when being executed, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, Any reference to memory, storage, database or other media used in each embodiment provided herein, Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms, Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..

Each technical characteristic of above example can be combined arbitrarily, to keep description succinct, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance Shield is all considered to be the range of this specification record.

The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art It says, under the premise of not departing from the application design, various modifications and improvements can be made, these belong to the protection of the application Range.Therefore, the protection domain of the application patent should be determined by the appended claims.

Claims

1. a kind of processing method of achievement data, which is characterized in that the method includes：

Judge whether the table in the first file that marking system generates has update according to the attribute information of table；Wherein, institute State attribute information include the title of table, the modification time of table, the size of table, table content it is at least one；

When determining that the table in first file has update, newer table is obtained, and judges the newer table Whether it is achievement data table；

If so, according to the mapping relations and the newer table that prestore, achievement analytical table is generated；Wherein, the mapping Relationship includes the correspondence between achievement data tableau format and achievement analysis tableau format.

2. according to the method described in claim 1, it is characterized in that, described judge whether the newer table is achievement data Table, including：

It whether there is preset examination information parameter according to the content in the newer table, determine the newer table Whether lattice are achievement data table；

Wherein, the examination information parameter includes examination paper mark under examination paper type identification, each examination paper type, each examines Inscribe at least one of the examination paper quantity under type.

3. according to the method described in claim 2, it is characterized in that, whether the content according in the newer table deposits In preset examination information parameter, determine whether the newer table is achievement data table, including：

According to the first table format of preset marking system, judge the content in the newer table with the presence or absence of preset Examination information parameter, and determine whether the newer table is achievement data table according to judging result.

4. according to the method described in claim 3, it is characterized in that, first table generated according to preset marking system Format judges that the content in the newer table whether there is preset examination information parameter, and according to judging result Determine whether the newer table is achievement data table, including：

Obtain the ranks mark that exam information parameter is stored in first table format；

Judge to join with the presence or absence of the examination information in ranks corresponding with ranks mark in the newer table Number；

If so, determining that the newer table is achievement data table.

5. according to claim 2-4 any one of them methods, which is characterized in that the method further includes：

After determining that the newer table is achievement data table, judge in the newer table under each examination paper mark Whether score value is located in preset numberical range；

If it is not, being then abnormal score by the award indicators.

6. according to the method described in claim 1, it is characterized in that, the attribute information according to table judges that marking system is given birth to At the first file in table whether have update, including：

If the title of the table in the first file described in current time is different from the title of the table of previous moment, it is determined that institute The table stated in the first file has update；

Alternatively,

If the modification time of the table at current time is different from the modification time of table described in previous moment, it is determined that described first Table in file has update；

Alternatively,

If table is of different sizes described in the size and previous moment of the table at current time, it is determined that in first file Table have update；

Alternatively,

If the content of the table at current time is different from the content of table described in previous moment, it is determined that in first file Table have update.

7. according to the method described in claim 1, it is characterized in that, the method further includes：

Judge under current path with the presence or absence of the second file with the name-matches of the first file, wherein second text Part folder is the file for storing the achievement analytical table；

If it is not, then creating the second file of same names according to the title of the first file, and the achievement analytical table is deposited In storage to second file.

8. a kind of processing unit of achievement data, which is characterized in that described device includes：

First judgment module, the table in the first file for judging marking system generation according to the attribute information of table are It is no to have update；Wherein, the attribute information includes the title of table, the modification time of table, the size of table, table content It is at least one；

Generation module, if being achievement data table for the newer table, according to the mapping relations that prestore and it is described more New table generates achievement analytical table；Wherein, the mapping relations include the lattice of achievement data tableau format and achievement analytical table Correspondence between formula.

9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists The step of method described in any one of claim 1 to 7 being realized when, the processor executes the computer program.

10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program The step of method described in any one of claim 1 to 7 is realized when being executed by processor.