Data processing method and system

Abstract

The invention relates to a data processing method and system. The method comprises following steps: obtaining a spreadsheet recorded with student score data and basic information; performing keyword matching analysis on the spreadsheet according to the pre-stored basic information to identify the basic information in the spreadsheet and score data corresponding to the basic information; generating report data according to the identified basic information and score data corresponding to the basic information and sending the report data to a terminal device. Score data and basic information in a spreadsheet can be automatically identified and report data is generated without the need to use spreadsheet templates of fixed format based on the technical scheme of the invention so that the student score data collection and analysis are realized; data processing efficiency is high and compatibility is strong; the method and system can satisfy the usage requirement of schools with high examination frequency and the requirement that school managers, teachers and parents acquire scores of examinees.

Description

technical field [0001] The invention relates to the technical field of information integration, in particular to a data processing method and system. Background technique [0002] At present, the technical solutions for the management of candidates' grades mainly include data collection and data display. There are two main solutions for data collection: one is to manually organize the student list and transcripts according to the Excel table template required by the system, and then import them into the grade management system. The inventor When implementing this solution, it was found that the solution requires users to download a fixed Excel table template and cannot modify the template. If there is a problem when importing data, the user is required to repeatedly modify the data and import it again until it is correct. In addition, different grade management systems have their own. The fixed Excel table template has poor compatibility and high learning costs for users; an...

AI Technical Summary

Problems solved by technology

[0002] At present, the technical solutions for the management of candidates' grades mainly include data collection and data display. There are two main solutions for data collection: one is to manually organize the student list and transcripts according to the Excel table template required by the system, and then import them into the grade management system. The inventor When implementing this solution, it was found that the solution requires users to download a fixed Excel table template and cannot modify the template. If there is a problem when importing data, the user is required to repeatedly modify the data and import it again until it is correct. In addition, different grade management systems have their own. The fixed Excel table template has poor compatibility and high learning costs for users; another solution is electronic marking, which collects score data and analyzes data by scanning test papers. The organization and functions are very complicated, and it needs to cooperate with the marking and grouping system to do data processing and analysis, so it takes a lot of energy and cannot meet the needs of schools with high frequency of examinations.

Images