Education performance assessment questionnaire generation and data statistical analysis method

Abstract

The invention discloses an educational performance assessment questionnaire generation and data statistical analysis method, and relates to the technical field of educational management, and the method comprises the steps: constructing a question bank, distributing educational scene attribute tags for questions in the question bank, and building a mapping relation table of keywords and tags; providing a sample confirmation interface, receiving investigation object attributes input by an organizer, and carrying out statistical analysis on the total sample quantity; calling a data interface of the school roll system, obtaining the total number of the investigated objects under each attribute dimension, calculating the sample size of each attribute, and generating a sample size distribution list; receiving keywords, question types and quantity input by an organizer, screening questions, and intelligently assembling the questions into a questionnaire; obtaining a contact way of the investigation object in the sample size distribution list, and directionally issuing a questionnaire; and recovering the questionnaire, rejecting invalid data, combining dimensions based on sample attributes selected by an organizer, calculating a question option proportion and an average score under each dimension, and generating a report. The method can be used for performance assessment scenes in the education field.

Description

Technical Field

[0001] This invention relates to the field of educational management technology, specifically a method for generating educational performance evaluation questionnaires and performing statistical analysis of data. Background Technology

[0002] In the field of education, the main educational stages include preschool education, compulsory education, high school education, and higher education. Roles are primarily categorized as students, graduates, parents, education administrators, teachers, and employers. To improve educational satisfaction among different roles at each stage, a questionnaire survey is needed to investigate the current state of education.

[0003] Currently, in the education field, there are many procedures and methods for conducting surveys, but they are cumbersome to use and cannot automatically generate questionnaires, screen survey participants, or generate analysis reports. At the same time, when the processing and access volume is very large, the pressure on the database increases, and the database connection pool and the database's ability to process data simultaneously will be greatly challenged. Once the database reaches its maximum capacity, its data processing efficiency will be greatly reduced. Summary of the Invention

[0004] This invention addresses the current limitations of intelligent and efficient performance evaluation in the education field, as well as the inability to quickly and scientifically generate analytical reports. It provides a method for generating educational performance evaluation questionnaires and conducting statistical data analysis, enabling intelligent questionnaire generation, rapid determination of survey samples, distribution of questionnaire notifications through multiple channels, and rapid output of multi-dimensional and multi-scenario analytical reports after questionnaire collection.

[0005] The present invention provides a method for generating educational performance evaluation questionnaires and statistically analyzing data. The technical solution adopted to solve the above-mentioned technical problems is as follows:

[0006] A method for generating educational performance evaluation questionnaires and performing statistical data analysis includes the following steps:

[0007] S1. Construct an education evaluation question bank, assign education scenario attribute tags to each performance assessment question in the question bank, and establish a mapping relationship table between keywords and tags, wherein each keyword in the mapping relationship table corresponds to at least one tag;

[0008] S2. Provide a sample confirmation interface to receive the survey object attribute dimensions and the total number of samples for statistical analysis input by the education performance assessment organizer; call the data interface of the student registration system to obtain the total number of survey objects under each attribute dimension, calculate the sample size of each attribute dimension, and generate a sample size allocation list.

[0009] S3, receiving the performance appraisal key words, question type and the number of each type of question input by the education performance appraisal organizer, screening the performance appraisal questions matched with the labels according to the mapping relationship table, intelligently assembling multiple questionnaires based on the question repetition rate rules for the organizer to select; obtaining the contact information of the survey objects in the sample size allocation list, and directing the selected questionnaire through the system message interface;

[0010] S4, cleaning and removing invalid data after recovering the questionnaire, receiving the sample attribute combination dimension selected by the organizer, calculating the proportion and average score of the question options under each dimension, and generating a report containing a column chart and an explanation document containing cleaning rules and statistical formulas.

[0011] Optionally, step S1 is performed, and the constructed education evaluation question bank contains various performance appraisal questions in the education field, covering teaching quality evaluation, student satisfaction survey and employer evaluation;

[0012] Each performance appraisal question in the question bank is assigned an education scene attribute label, which is specifically divided into an education stage label, a survey object label and an evaluation dimension label. Each label uses standardized coding for easy identification and matching in the future.

[0013] Optionally, the sample confirmation interface provided in step S2 is provided with a survey object attribute dimension input field and a statistical analysis total sample number input box, supporting the education performance appraisal organizer to complete information filling through drop-down selection or manual input.

[0014] Further optionally, step S2 is performed, the education performance appraisal organizer inputs the survey object attribute dimension and the statistical analysis total sample number through the sample confirmation interface, then calls the data interface of the student status system to obtain the total number of survey objects under each attribute dimension, and calculates the sample size of each attribute dimension based on the following formula:

[0015] N i =(M i / M total )×N total ,

[0016] In the formula, N i represents the sample size of the i-th attribute, M i represents the total number of the i-th attribute, M total represents the total number of all attributes, and N total represents the total sample number.

[0017] If the calculation result is not an integer, rounding is used to round it to an integer. After the calculation is completed, a sample size allocation list is generated, which includes the attribute dimension name, total number, sample size and proportion for the organizer to check and confirm.

[0018] Optionally, the step S3 specifically comprises:

[0019] S3.1, first receive the performance appraisal keywords input by the education performance appraisal organizer, automatically match the corresponding education scene attribute labels according to the mapping relationship table, filter out all the label matching questions to form a candidate question pool;

[0020] S3.2, then receive the question type and the corresponding quantity of each type of question input by the education performance appraisal organizer, randomly extract questions from the candidate question pool, and simultaneously detect the repetition rate of the extracted questions in real time to ensure that the repetition rate of the questions in the whole questionnaire is less than 5%, thereby completing the intelligent assembly of multiple questionnaires;

[0021] S3.3, the education performance appraisal organizer selects the questionnaire, then obtains the contact information of the survey objects in the sample size allocation list, and directly issues the selected questionnaire through the system message interface.

[0022] Further optionally, the step S3.3 is executed, the education performance appraisal organizer selects the questionnaire, then obtains the contact information of the survey objects in the sample size allocation list, and directly issues according to the survey object attribution through the system message interface, sends the unique questionnaire link or the two-dimensional code with parameters to the sample objects in the form of system push, email or short message, and records the questionnaire issuing time, issuing mode and delivery state of each sample object.

[0023] Optionally, the step S4 specifically comprises:

[0024] S4.1, set the questionnaire recovery period, after the deadline, automatically recover the questionnaire submitted by the survey object, clean the recovered questionnaire data based on the preset cleaning rules, and form a data cleaning report;

[0025] S4.2, provide a sample attribute combination dimension selection interface, support the education performance appraisal organizer to select a single or multiple attribute combinations as a statistical dimension, then classify and summarize the valid questionnaire data based on the selected dimension by the education performance appraisal organizer, and calculate the option ratio (objective questions) and average score (after conversion of subjective and objective question scores) of each question under each dimension;

[0026] S4.3, generate a statistical report containing a column chart according to the calculation result, the column chart clearly shows the comparison of statistical indicators of each dimension, and an explanation document is generated, which details the data cleaning rules (such as invalid questionnaire determination standard), statistical formula (such as average score calculation method, ratio statistical method) and interpretation suggestion of statistical result, and the report and explanation document are packaged for the organizer to download and use.

[0027] Further, the step S4.1 is performed to clean the recovered questionnaire data based on preset cleaning rules, filter out and remove invalid questionnaires with a filling time less than 30 seconds or an answer repetition rate greater than 90%, record the number of invalid questionnaires, invalid reasons and corresponding sample object information, and form a data cleaning report.

[0028] The education performance evaluation questionnaire generation and data statistical analysis method has the beneficial effects compared with the prior art:

[0029] The present application intelligently realizes the full-link coverage of the education performance evaluation from questionnaire customization, survey object screening, notification sending, user answering to statistical result output through the full-process design of constructing an education evaluation question bank, generating sample quantity distribution lists of each attribute dimension based on the attribute dimension of the survey object and the statistical analysis of the total sample quantity, selecting a questionnaire and sending a questionnaire notification in multiple ways, quickly recovering questionnaire data and automatically outputting statistical reports, effectively solves the problems that the education performance evaluation cannot be intelligently and efficiently carried out in the current education field, and it is difficult to scientifically and quickly output statistical results, and can meet most high-concurrency use scenarios in the education field. BRIEF DESCRIPTION OF DRAWINGS

[0030] ATTACHMENT Figure 1 is a method flowchart of the embodiment one of the present application. DETAILED DESCRIPTION

[0031] In order to make the technical solutions, technical problems solved and technical effects of the present application clearer and more apparent, the technical solutions of the present application are described clearly and completely in combination with specific embodiments.

[0032] Embodiment one:

[0033] In combination with the attached Figure 1 , the present embodiment proposes an education performance evaluation questionnaire generation and data statistical analysis method, which includes the following steps:

[0034] S1, constructing an education evaluation question bank, assigning an education scene attribute label to each performance evaluation question in the question bank, and establishing a mapping relationship table of keywords and labels, each keyword in the mapping relationship table corresponding to at least one label.

[0035] The education evaluation question bank constructed in this step contains various performance evaluation questions in the education field, covering teaching quality evaluation, student satisfaction survey and employer evaluation;

[0036] An education scene attribute label is assigned to each performance evaluation question in the question bank, which is specifically divided into an education stage label (such as early childhood education, primary education, vocational education, etc.), a survey object label (such as teachers, students, employers, etc.), and an evaluation dimension label (such as teaching ability, curriculum design, practical effect, etc.), each label uses standardized coding for subsequent identification and matching.

[0037] For example, the keyword "vocational teacher teaching ability" corresponds to "education stage label: vocational education", "evaluation object label: teacher", and "evaluation dimension label: teaching ability".

[0038] S2, a sample confirmation interface is provided to receive the survey object attribute dimensions and the total sample quantity for statistical analysis input by the education performance evaluation organizer; a data interface of a student status system is called to obtain the total quantity of survey objects under each attribute dimension, and the sample quantity of each attribute dimension is calculated to generate a sample quantity allocation list.

[0039] The sample confirmation interface provided in this step is provided with a survey object attribute dimension input field (such as unit employees, service objects, students, graduates, employers, or others) and a statistical analysis total sample quantity input box, which supports the education performance evaluation organizer to complete information filling through drop-down selection or manual input.

[0040] When this step is executed, the education performance evaluation organizer inputs the survey object attribute dimensions and the total sample quantity for statistical analysis through the sample confirmation interface, then calls the data interface of the student status system to obtain the total quantity of survey objects under each attribute dimension, and calculates the sample quantity of each attribute dimension based on the following formula:

[0041] N i =(M i / M total )×N total ,

[0042] In the formula, N i represents the sample quantity of the i-th attribute, M i represents the total quantity of the i-th attribute, M total represents the total quantity of all attributes, and N total represents the total sample quantity.

[0043] If the calculation result is not an integer, rounding is used to round it to an integer, and after the calculation is completed, a sample quantity allocation list is generated, which includes the attribute dimension name, total quantity, sample quantity, and proportion, for the organizer to view and confirm.

[0044] S3, receive the performance appraisal key words, topic type and the number of each type of question input by the education performance appraisal organizer, select the performance appraisal questions matched with the labels according to the mapping relationship table, and intelligently assemble multiple sets of questionnaires for the organizer to select based on the question repetition rate rule; obtain the contact information of the survey subjects in the sample size allocation list, and directly issue the selected questionnaires through the system message interface.

[0045] When this step is specifically implemented:

[0046] S3.1, first receive the performance appraisal key words input by the education performance appraisal organizer, automatically match the education scene attribute labels corresponding to the key words according to the mapping relationship table, select all the questions matched with the labels, and form a candidate question pool;

[0047] S3.2, then receive the question type (such as single-choice question, multiple-choice question, short answer question) and the number of each type of question input by the education performance appraisal organizer, randomly select questions from the candidate question pool, and simultaneously detect the repetition rate of the selected questions in real time to ensure that the repetition rate of the questions in the whole set of questionnaires is less than 5%, thereby completing the intelligent assembly of multiple sets of questionnaires;

[0048] S3.3, the education performance appraisal organizer selects the questionnaire, then obtains the contact information (such as system account, email, mobile phone number) of the survey subjects in the sample size allocation list, and directly issues the questionnaire according to the affiliation (such as school, post) of the survey subjects through the system message interface, sends the unique questionnaire link or parameterized two-dimensional code to the sample objects in the form of system push, email or short message, and records the questionnaire issuing time, issuing mode (system push / email / short message) and delivery status (delivered / not delivered / delivery failure and failure reason) of each sample object.

[0049] S4, after recovering the questionnaire, clean and remove invalid data, receive the sample attribute combination dimension selected by the organizer, calculate the proportion and average score of the question options under each dimension, generate a report containing a column chart and an explanation document containing cleaning rules and statistical formulas; specifically including:

[0050] S4.1, set the questionnaire recovery period, after the deadline, automatically recover the questionnaires submitted by the survey subjects, clean the recovered questionnaire data based on the pre-set cleaning rules, select and remove the invalid questionnaires with a filling time less than 30 seconds or an answer repetition rate greater than 90%, record the number of invalid questionnaires, invalid reasons and corresponding sample object information, and form a data cleaning report;

[0051] S4.2, a sample attribute combination dimension selection interface is provided, and selection of a single or multiple attribute combinations (such as "professional type + graduation year", "teaching age + teaching subject") as statistical dimensions is supported by an education performance evaluation organizer, then, based on the selected dimensions by the education performance evaluation organizer, valid questionnaire data is classified and summarized, and the option proportion (objective questions) and average score (after conversion of subjective questions and objective question scores) of each question under each dimension are calculated;

[0052] S4.3, a statistical report containing a column chart is generated according to the calculation results, the column chart clearly shows the comparison of statistical indicators of each dimension, and a specification document is generated, the document details the data cleaning rules (such as invalid questionnaire determination standards), statistical formulas (such as average score calculation methods, proportion statistical methods) and interpretation suggestions of statistical results, and the report and the specification document are packaged for the organizer to download and use.

[0053] As can be seen from the above, the education performance evaluation questionnaire generation and data statistical analysis method of the present application can realize full-link coverage of education performance evaluation from questionnaire customization, survey object screening, notification issuance, user answer to statistical result output, effectively solve the problem that the current education field cannot intelligently and efficiently carry out education performance evaluation, and it is difficult to scientifically and quickly output statistical results, and can meet most high-concurrency use scenarios in the education field.

[0054] The principles and implementation modes of the present application are described in detail by the above application specific examples, and these examples are only used to help understand the core technical content of the present application. Based on the above specific embodiments of the present application, any improvement and modification of the present application made by those skilled in the art without departing from the principles of the present application shall fall within the patent protection scope of the present application.

Claims

1. An education performance evaluation questionnaire generation and data statistical analysis method, characterized in that, The method comprises the following steps: S1, constructing an education evaluation question bank, assigning an education scene attribute label to each performance evaluation question in the question bank, and establishing a mapping relationship table between keywords and labels, wherein each keyword in the mapping relationship table corresponds to at least one label; S2, providing a sample confirmation interface, receiving the attribute dimensions of the survey objects and the total sample quantity for statistical analysis input by the education performance evaluation organizer, calling a data interface of a student record system to obtain the total quantity of the survey objects under each attribute dimension, and calculating the sample quantity of each attribute dimension to generate a sample quantity distribution list; S3, receiving the performance evaluation keywords, question types and the corresponding quantities of each type of question input by the education performance evaluation organizer, screening the performance evaluation questions matched with the labels according to the mapping relationship table, intelligently assembling multiple sets of questionnaires for the organizer to select based on the question repetition rate rule, obtaining the contact information of the survey objects in the sample quantity distribution list, and directly sending the selected questionnaires through a system message interface; S4, cleaning and removing invalid data after recovering the questionnaires, receiving the sample attribute combination dimensions selected by the organizer, calculating the option proportion and average score of each dimension, and generating a report containing a column chart and an explanation document containing cleaning rules and statistical formulas.

2. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 1, wherein, In step S1, the constructed education evaluation question bank contains various performance evaluation questions in the education field, covering teaching quality evaluation, student satisfaction survey and employer evaluation. Each performance evaluation question in the question bank is assigned an education scene attribute label, which is specifically divided into an education stage label, a survey object label and an evaluation dimension label. Each label uses standardized coding for subsequent identification and matching.

3. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 1, wherein, The sample confirmation interface provided in step S2 is provided with a survey object attribute dimension input field and a statistical analysis total sample quantity input box, which supports the education performance evaluation organizer to complete information filling through drop-down selection or manual input.

4. The method for generating and analyzing data of an education performance evaluation questionnaire according to claim 3, wherein, In step S2, the education performance evaluation organizer inputs the attribute dimensions of the survey objects and the total sample quantity for statistical analysis through the sample confirmation interface, then calls the data interface of the student record system to obtain the total quantity of the survey objects under each attribute dimension, and calculates the sample quantity of each attribute dimension based on the following formula: N i = (M i / M total ) x N total , where N i represents the sample size of the i-th attribute, M i represents the total number of the i-th attribute, M total represents the total number of all attributes, N total represents the total sample size; If the calculation result is not an integer, rounding is used to take the integer. After the calculation is completed, a sample quantity distribution list is generated, which includes the attribute dimension name, total quantity, sample quantity and proportion for the organizer to check and confirm.

5. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 1, wherein, Step S3 specifically includes: S3.1, first, receive the performance evaluation keywords input by the education performance evaluation organizer, automatically match the education scene attribute labels corresponding to the keywords according to the mapping relationship table, screen all label-matched questions to form a candidate question pool; S3.2, then receive the question types and the corresponding quantities of each type of question input by the education performance evaluation organizer, randomly select questions from the candidate question pool while detecting the repetition rate of the selected questions in real time to ensure that the repetition rate of the questions in the entire questionnaire is less than 5%, thereby intelligently assembling multiple sets of questionnaires; S3.3, the education performance evaluation organizer selects a questionnaire, then obtains the contact information of the survey subjects in the sample size allocation list, and sends the selected questionnaire through the system message interface.

6. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 5, wherein, Step S3.3 is performed, the education performance evaluation organizer selects a questionnaire, then obtains the contact information of the survey subjects in the sample size allocation list, and sends the selected questionnaire through the system message interface according to the survey subjects belonging, in the form of system push, email or short message, sends a unique questionnaire link or a two-dimensional code with parameters to the sample objects, and records the questionnaire sending time, sending mode and delivery state of each sample object.

7. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 1, wherein, The step S4 specifically comprises: S4.1, set the questionnaire recovery period, after the deadline, automatically recover the questionnaire submitted by the survey subjects, clean the recovered questionnaire data based on the preset cleaning rules, and form a data cleaning report; S4.2, provide a sample attribute combination dimension selection interface, support the education performance evaluation organizer to select a single or multiple attribute combinations as a statistical dimension, then classify and summarize the valid questionnaire data based on the dimension selected by the education performance evaluation organizer, and calculate the option proportion (objective question) and average score (after conversion of subjective and objective question scores) of each question under each dimension; S4.3, generate a statistical report containing a column chart according to the calculation result, the column chart clearly shows the comparison of statistical indicators of each dimension, and an explanation document is generated, which details the data cleaning rules (such as invalid questionnaire judgment standard), statistical formula (such as average score calculation method, proportion statistical method) and interpretation suggestion of statistical result, and the report and explanation document are packaged for the organizer to download and use.

8. The method for generating and analyzing data of an educational performance evaluation questionnaire according to claim 7, wherein, Step S4.1 is performed, the recovered questionnaire data is cleaned based on the preset cleaning rules, the invalid questionnaires with filling time less than 30 seconds or answer repetition rate greater than 90% are filtered out and removed, the number of invalid questionnaires, invalid reasons and corresponding sample object information are recorded, and a data cleaning report is formed.

Images