Medical microbiological experiment teaching interaction method and system based on data warehouse

Abstract

The invention discloses a medical microorganism experiment teaching interaction method and system based on a data warehouse, and belongs to the technical field of teaching interaction. Obtaining experiment achievement degree data and operation specification degree data of students, calculating performance values of the students, and taking the performance values as initial progress parameters of the students; medical microorganism experiment steps of different grades are distributed to the students; calculating progress parameters after each medical microbiological experiment is finished, and analyzing the progress degree of the students; calculating a comprehensive learning level score of the student; and calculating the similarity between different students, presetting a similarity threshold, and analyzing and outputting a medical microbiological experiment teaching strategy. According to the invention, by analyzing the progress parameter and progress degree after each experiment, the experiment teaching difficulty can be dynamically adjusted, and the experiment quality of students is improved; and a differential teaching strategy is implemented, so that personalized and interactive medical microbiological experiment teaching interaction is finally realized, and the efficiency of differential teaching guidance is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of teaching interaction, and in particular to a medical microbiology experiment teaching interaction method and system based on a data warehouse. Background Art

[0002] Medical microbiology experimental teaching occupies a key position in the current medical education system; traditional experimental teaching methods usually rely on classroom lectures and laboratory operation guidance, but this method often fails to provide personalized feedback and progress evaluation, making it impossible for students' learning outcomes to be reflected in teaching in a timely and accurate manner; to solve these problems, data warehouse technology has gradually been introduced into the field of medical teaching; data warehouses, with their advantages of large-scale data storage and real-time data analysis, provide an integrated management platform for students' learning behavior and experimental performance data, making teaching work systematic, standardized and refined; however, the current teaching methods applied to medical microbiology experiments lack quantitative evaluation of students' operating specifications and experimental achievement, and cannot provide dynamic feedback and differentiated guidance based on students' individual performance, and fail to effectively support students' progress and the cultivation of experimental literacy.

[0003] Data warehouse applications in existing technologies are mainly used for centralized storage of experimental data, and a few will evaluate students' comprehensive levels. However, most evaluation methods lack quantitative analysis and dynamic adjustment of students' gradual learning progress, and only provide static evaluation scores. They ignore the degree of standardization of students' operations during the experiment and its long-term impact on knowledge mastery, resulting in a lack of effective teaching interaction feedback, making it difficult to improve the efficiency of differentiated teaching guidance. Summary of the invention

[0004] The purpose of the present invention is to provide a medical microbiology experiment teaching interactive method and system based on a data warehouse to solve the problems raised in the above background technology.

[0005] In order to solve the above technical problems, the present invention provides the following technical solutions:

[0006] A medical microbiology experiment teaching interaction method based on a data warehouse comprises the following steps: dividing data storage partitions in a data warehouse based on the number of students; obtaining students' experiment achievement data and operation standardization data; calculating students' performance values ​​based on the experiment achievement data and the operation standardization data, and using the performance values ​​as students' initial progress parameters; allocating students with different levels of medical microbiology experiment steps based on the performance values; calculating progress parameters after each medical microbiology experiment, and analyzing students' progress based on the progress parameters; calculating students' comprehensive learning level scores based on the progress parameters and the progress; calculating similarities between different students based on the students' comprehensive learning level scores, presetting similarity thresholds, and analyzing and outputting medical microbiology experiment teaching strategies.

[0007] As a preferred solution of the medical microbiology experiment teaching interaction method based on data warehouse described in the present invention, data storage partitions are divided in the data warehouse based on the number of students in the class, wherein one data storage partition is allocated to one student, and after authorization by the student, the student's experimental record information in the medical microbiology experiment is stored in the data storage partition; the experimental record information includes the experimental achievement data and operation standardization data of the medical microbiology experiment.

[0008] The experimental achievement data and operation standardization data of the i-th student in the a-th medical microbiology experiment are recorded as EA ia and OS ia .

[0009] The method for obtaining the experimental achievement data is as follows:

[0010] The experimental results of students in the medical microbiology experiment are compared with the preset standard experimental results to obtain the accuracy rate of students in the medical microbiology experiment, and the accuracy rate is used as the experimental achievement data of students.

[0011] The method for obtaining the operation standardization data is as follows:

[0012] A standard operating procedure is preset, and the standard operating procedure is recorded as a standard operating procedure video.

[0013] During the medical microbiology experiment, the students' operation process during the medical microbiology experiment is video recorded and recorded as the student operation video.

[0014] The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

[0015] As a preferred solution of the medical microbiology experiment teaching interactive method based on data warehouse described in the present invention, based on the experimental achievement data EA ia and operating specification data OS ia , the comprehensive ability level of the i-th student in the medical microbiology experiment is scored as follows:

[0016] Construct the performance value formula for the i-th student, the formula is as follows:

[0017]

[0018] Among them, LO i1 represents the performance value of the i-th student, EA i1 represents the experimental achievement data of the i-th student in the initial medical microbiology experiment, OS i1 represents the operational standardization data of the i-th student in the initial medical microbiology experiment, I represents the total number of students, ω1 and ω2 represent the influencing factors of the preset experimental achievement data and operational standardization data, respectively, OS std Indicates the standard value of operational specification.

[0019] In the present invention, this formula is used to calculate the learning level of students in the first experiment based on two key indicators: experimental score EA i1 and operating specifications OS i1 ; is a relative score that takes the student's experimental score EA i1 Compare it with the total score of all students in the class to get a ratio value, which can reflect the relative level of students in the class. This score calculation method avoids the errors caused by different experimental difficulties and different absolute values ​​of scores, making the evaluation more fair. Used to measure students' operational standardization, using the standard value OS std As a benchmark, calculate the degree of deviation between the student's operation standard and the standard. The smaller the deviation, the higher the score, which means the operation is more standardized. The scoring formula is mainly used to measure the overall learning performance of students in the initial experiment and provide a benchmark for subsequent personalized progress monitoring. Because the initial learning level directly affects the students' subsequent learning progress, accurate initial scoring can help teachers better formulate personalized learning plans, and also allow teachers to understand students' basic operational capabilities and theoretical understanding, and provide targeted guidance for students with deviations.

[0020] The performance value of the i-th student LO i1 As the initial progress parameter of the i-th student.

[0021] As a preferred solution of the data warehouse-based medical microbiology experiment teaching interactive method of the present invention, the performance value interval is preset, denoted as [τ low , τ high ], where τ low Indicates low performance value, τ high Indicates high performance values ​​and arranges different levels of medical microbiology experimental steps for students, as follows:

[0022] If the performance value of the i-th student is LO i >τ high , then arrange the advanced medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0023] For example: arrange PCR amplification experiments to guide students to detect gene fragments of specific pathogens and understand the application of molecular biology in microbial identification; let students use biochemical identification, serotyping and other methods to accurately identify and type pathogenic microorganisms, simulating the actual process of clinical microbiology laboratories.

[0024] If the performance value of the i-th student LO i ∈[τ low , τ high ], then in the next medical microbiology experiment, the intermediate medical microbiology experimental steps will be arranged for the ith student.

[0025] For example: guide students to conduct multiple bacterial co-culture experiments, separate and culture different bacterial species, and observe their growth characteristics and interactions; let students conduct antibiotic sensitivity tests (such as paper diffusion method) to analyze the sensitivity of different bacteria to various antibiotics in order to understand the mechanism of action of antibiotics; teach students to perform Gram staining, fluorescent staining and other operations to master the staining characteristics of different microorganisms and their interpretation techniques.

[0026] If the performance value of the i-th student LO i <τ low , then arrange the basic medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0027] For example: guide students to master laboratory safety and aseptic operations, such as wearing gloves and masks correctly, and understand how to avoid experimental contamination; arrange simple microbial sample culture experiments, such as the culture process of common bacteria, and observe the bacterial growth environment and growth curve; guide students to master the basic operation methods of microscopes, and observe and identify the morphological structure of common microorganisms.

[0028] Let a=a+1, and perform iterative analysis of medical microbiology experiments. The analysis process for each a iteration is as follows:

[0029] Calculate the progress parameter of the i-th student after the a+1-th medical microbiology experiment. The calculation formula is as follows:

[0030]

[0031] Among them, a∈[1,A-1], A represents the total number of medical microbiology experiments, LO i(a+1) represents the progress parameter of the i-th student after the a+1th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1th medical microbiology experiment, OS i(a+1) represents the operational standardization data of the i-th student in the a+1-th medical microbiology experiment, α and β represent the influencing factors of the experimental achievement data and the operational standardization data, respectively.

[0032] In the present invention, The ratio of the two experimental scores is used to reflect the student's progress in theoretical knowledge. If the ratio is greater than 1, it means that the student's performance has improved; if it is less than 1, it means that the performance has declined. The ratio of the current operation standardization to the previous standardization reflects whether the operation is tending to be standardized. If the operation gradually meets the standard, the score will gradually increase. This formula can generate an updated learning progress parameter after each experiment, reflecting the student's progress in the course in real time. The LO after each update i(a+1) It can help teachers understand students' learning situation in a timely manner; since the formula focuses on the relative progress of individual students in different experiments, no matter what the students' initial level is, their personal growth can be objectively evaluated. In this way, students with low initial levels will also be encouraged when they make significant progress, thereby improving their enthusiasm for learning.

[0033] By comparing the progress parameter LO after the a+1th medical microbiology experiment i(a+1) and the progress parameter LO after the ath medical microbiology experiment is completed ia , analyze the students' progress, the analysis formula is as follows:

[0034]

[0035] Among them, V i [a→(a+1)] represents the progress of the i-th student between the a-th medical microbiology experiment and the a+1-th medical microbiology experiment.

[0036] If the progress V i [a→(a+1)]>0, it means that the student has made progress in the a+1th medical microbiology experiment, and the difficulty of the next medical microbiology experiment will be increased.

[0037] If the progress Vi [a→(a+1)]=0, which means that the student has not made any progress in the (a+1)th medical microbiology experiment. In the next medical microbiology experiment, the existing level of the medical microbiology experiment steps is maintained and operational guidance is provided.

[0038] If the progress V i [a→(a+1)]<0, it means that the student has regressed in the a+1th medical microbiology experiment. In this case, the difficulty of the next medical microbiology experiment will be reduced and operational guidance will be provided.

[0039] When a+1=A, the iteration stops.

[0040] As a preferred solution of the data warehouse-based medical microbiology experiment teaching interactive method of the present invention, the comprehensive learning level score of the i-th student is calculated based on the progress parameter and the degree of progress, and the calculation formula is as follows:

[0041]

[0042] in, represents the comprehensive learning level score of the i-th student, δ1 and δ2 represent the preset progress parameters and the influencing factors of the progress, respectively.

[0043] In the present invention, the formula is used to calculate the comprehensive learning level score of the students. By calculating the final comprehensive learning level score of each student, the teacher can accurately understand the comprehensive performance of the students in the whole experimental process, and then provide personalized teaching guidance for the students. For example, for students with low learning levels, more detailed experimental step prompts or strengthening of operational normative training can be provided, while for students with high learning levels, the experimental difficulty can be increased or challenging tasks can be added. The final comprehensive learning level score can also help teachers dynamically adjust the experimental teaching progress. For example, if the student's progress is low, the teaching progress can be slowed down, supplementary exercises and additional guidance can be added; if the progress is high, the progress can be accelerated, and the depth and breadth of the experimental content can be increased. Such dynamic adjustment can better adapt to the learning rhythm of different students and improve the teaching effect; the final comprehensive learning level score takes into account the student's progress parameters and progress, which can more comprehensively reflect the student's learning status than the simple experimental results. This comprehensiveness is not only more in line with actual teaching needs, but also more conducive to cultivating students' experimental literacy and normative awareness.

[0044] Based on the comprehensive learning level score of the i-th student, the difference in comprehensive learning level scores between the i-th student and the j-th student is calculated. The calculation formula is as follows:

[0045]

[0046] Where ΔLOfinal represents the difference in comprehensive learning level scores between the i-th student and the j-th student, Represents the comprehensive learning level score of the jth student.

[0047] Based on the difference in comprehensive learning level scores ΔLO final , calculate the similarity between the i-th student and the j-th student, the calculation formula is as follows:

[0048]

[0049] Among them, SD(i→j) represents the similarity between the i-th student and the j-th student.

[0050] Step S43: Preset a similarity threshold θ. If SD(i→j)>θ, determine that the ith student is associated with the jth student, obtain all students who are associated with the ith student, and implement a unified medical microbiology experiment teaching strategy.

[0051] A medical microbiology experiment teaching interactive system based on data warehouse includes: a student data storage management module, a student ability level scoring module, a dynamic progress tracking and analysis module, and a comprehensive learning level analysis and similarity evaluation module.

[0052] The student data storage management module divides the data storage partitions in the data warehouse based on the number of students and obtains the students' experimental achievement data and operation standardization data.

[0053] The student ability level scoring module calculates the student's performance value based on the experiment achievement data and the operation standardization data, and uses the performance value as the student's initial progress parameter.

[0054] The dynamic progress tracking and analysis module: assigns different levels of medical microbiology experimental steps to students based on the performance value; calculates the progress parameters after each medical microbiology experiment, and analyzes the students' progress based on the progress parameters.

[0055] The comprehensive learning level analysis and similarity assessment module calculates the comprehensive learning level scores of students based on progress parameters and progress; calculates the similarities between different students based on the comprehensive learning level scores of the students, presets similarity thresholds, and analyzes and outputs medical microbiology experiment teaching strategies.

[0056] Furthermore, the student data storage management module includes a data partition management unit and an experiment achievement data and operation standardization data acquisition unit.

[0057] The data partition management unit divides the data storage partitions in the data warehouse based on the number of students in the class, wherein one data storage partition is allocated to one student, and after authorization by the student, the student's experimental record information in the medical microbiology experiment is stored in the data storage partition; the experimental record information includes the experimental achievement data and operation specification data of the medical microbiology experiment.

[0058] The experimental achievement data and operation standardization data acquisition unit: The method for acquiring the experimental achievement data is as follows:

[0059] The experimental results of students in the medical microbiology experiment are compared with the preset standard experimental results to obtain the accuracy rate of students in the medical microbiology experiment, and the accuracy rate is used as the experimental achievement data of students.

[0060] The method for obtaining the operation standardization data is as follows:

[0061] A standard operating procedure is preset, and the standard operating procedure is recorded as a standard operating procedure video.

[0062] During the medical microbiology experiment, the students' operation process during the medical microbiology experiment is video recorded and recorded as the student operation video.

[0063] The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

[0064] Furthermore, the student ability level scoring module includes a student performance value calculation unit and an initial progress parameter setting unit.

[0065] The student performance value calculation unit scores the comprehensive ability level of students in the medical microbiology experiment based on the experiment achievement data and the operation standardization data, specifically as follows: calculates the student's performance value.

[0066] The initial progress parameter setting unit uses the student's performance value as the student's initial progress parameter.

[0067] Furthermore, the dynamic progress tracking and analysis module includes an experiment level adjustment unit and a progress parameter and progress degree analysis unit.

[0068] The experimental level adjustment unit: presets a performance value interval, wherein the performance value interval is composed of a preset low performance value and a preset high performance value, and arranges different levels of medical microbiology experimental steps for students, as follows:

[0069] If the student's performance value is greater than the preset high performance value, advanced medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment; if the student's performance value is within the performance value range, intermediate medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment; if the student's performance value is less than the preset low performance value, basic medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment.

[0070] The progress parameter and progress analysis unit performs iterative analysis on the medical microbiology experiment, and each iterative analysis process is as follows:

[0071] Calculate the students' progress parameters after the end of the next medical microbiology experiment.

[0072] The students' progress was analyzed by comparing the progress parameters after the end of the next medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment.

[0073] If the progress is greater than 0, it means that the student has made progress in the next medical microbiology experiment, and the difficulty will be increased in the next medical microbiology experiment.

[0074] If the progress degree is equal to 0, it means that the student has not made any progress in the next medical microbiology experiment. In this case, the current level of the medical microbiology experiment steps will be maintained in the next medical microbiology experiment, and operational guidance will be provided.

[0075] If the progress is less than 0, it means that the student has regressed in the next medical microbiology experiment. In this case, the difficulty will be reduced in the next medical microbiology experiment, and operational guidance will be provided.

[0076] After the last medical microbiology experiment is completed, the iteration is stopped.

[0077] Furthermore, the comprehensive learning level analysis and similarity assessment module includes a comprehensive learning level calculation unit and a student similarity analysis unit.

[0078] The comprehensive learning level calculation unit calculates the comprehensive learning level score of the student based on the progress parameter and the degree of improvement.

[0079] The student similarity analysis unit: based on the students' comprehensive learning level scores, calculates the difference in comprehensive learning level scores between different students; based on the difference in comprehensive learning level scores, calculates the similarity between different students; presets a similarity threshold, and if the similarity between different students is greater than the similarity threshold, it is determined that there is an association relationship between the students, and a unified medical microbiology experiment teaching strategy is implemented for all students with an associated relationship.

[0080] Compared with the prior art, the beneficial effects achieved by the present invention are as follows: in a medical microbiology experiment teaching interaction method and system based on a data warehouse provided by the present invention, by dividing an independent data storage partition for each student in the data warehouse, storing the experimental achievement data and the operation standardization data, targeted data management and information protection are achieved; by comparing the student's experimental results with the standard results, the accuracy rate is used as the achievement data, and by comparing the video records of the student's operation with the standard operation specifications, the student's operation standardization is quantified, thereby obtaining an accurate performance value; the performance value reflects the student's relative level and the degree of operation standardization in the class, and provides a reliable basis for teachers to formulate personalized teaching plans; in subsequent teaching, based on the initial performance value interval, experimental steps of different difficulties are automatically allocated, so that students can gradually improve on the basis of adapting to their own level; through the progress parameter and progress analysis after each experiment, the teacher can dynamically adjust the difficulty of experimental teaching, and improve students' learning enthusiasm and experimental literacy; finally, the comprehensive performance of students in the course is measured by the comprehensive learning level score, the correlation between students is determined based on the score difference and similarity, and a differentiated teaching strategy is implemented, and finally a precise, personalized and interactive medical microbiology experiment teaching interaction is achieved, which improves the teaching effect and students' experimental ability. BRIEF DESCRIPTION OF THE DRAWINGS

[0081] The accompanying drawings are used to provide further understanding of the present invention and constitute a part of the specification. They are used to explain the present invention together with the embodiments of the present invention and do not constitute a limitation of the present invention.

[0082] Figure 1 It is a schematic diagram of the steps of a data warehouse-based medical microbiology experiment teaching interactive method of the present invention;

[0083] Figure 2 It is a structural schematic diagram of a medical microbiology experiment teaching interactive system based on a data warehouse of the present invention. DETAILED DESCRIPTION

[0084] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0085] See also Figure 1 In the first embodiment, a medical microbiology experiment teaching interactive method based on a data warehouse is provided, and the method comprises the following steps:

[0086] Step S1: Based on the number of students, divide the data storage partitions in the data warehouse; obtain the students' experimental achievement data and operation standardization data.

[0087] Specifically, based on the number of students in the class, data storage partitions are divided in the data warehouse, wherein one data storage partition is allocated to one student. After authorization by the student, the student's experimental record information in the medical microbiology experiment is stored in the data storage partition; the experimental record information includes the experimental achievement data and operation specification data of the medical microbiology experiment.

[0088] Furthermore, the experimental achievement data and operation standardization data of the i-th student in the a-th medical microbiology experiment are recorded as EA ia and OS ia .

[0089] The method for obtaining the experimental achievement data is as follows:

[0090] The experimental results of students in the medical microbiology experiment are compared with the preset standard experimental results to obtain the accuracy rate of students in the medical microbiology experiment, and the accuracy rate is used as the experimental achievement data of students.

[0091] The method for obtaining the operation standardization data is as follows:

[0092] A standard operating procedure is preset, and the standard operating procedure is recorded as a standard operating procedure video.

[0093] During the medical microbiology experiment, the students' operation process during the medical microbiology experiment is video recorded and recorded as the student operation video.

[0094] The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

[0095] Step S2: Calculate the student's performance value based on the experiment achievement data and the operation standardization data, and use the performance value as the student's initial progress parameter.

[0096] Specifically, based on the experimental achievement data EA ia and operating specification data OS ia , the comprehensive ability level of the i-th student in the medical microbiology experiment is scored as follows:

[0097] Construct the performance value formula for the i-th student, the formula is as follows:

[0098]

[0099] Among them, LO i1 represents the performance value of the i-th student, EA i1 represents the experimental achievement data of the i-th student in the initial medical microbiology experiment, OS i1 represents the operational standardization data of the i-th student in the initial medical microbiology experiment, I represents the total number of students, ω1 and ω2 represent the influencing factors of the preset experimental achievement data and operational standardization data, respectively, OS std Indicates the standard value of operational specification.

[0100] Furthermore, the performance value LO of the i-th student i1 As the initial progress parameter of the i-th student.

[0101] Step S3: Based on the performance value, different levels of medical microbiology experiment steps are assigned to students; the progress parameters after each medical microbiology experiment are calculated, and the students' progress is analyzed based on the progress parameters.

[0102] Specifically, the preset performance value interval is denoted as [τ low , τ high ], where τ low Indicates low performance value, τ high Indicates high performance values ​​and arranges different levels of medical microbiology experimental steps for students, as follows:

[0103] If the performance value of the i-th student LO i >τ high , then arrange the advanced medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0104] For example: arrange PCR amplification experiments to guide students to detect gene fragments of specific pathogens and understand the application of molecular biology in microbial identification; let students use biochemical identification, serotyping and other methods to accurately identify and type pathogenic microorganisms, simulating the actual process of clinical microbiology laboratories.

[0105] If the performance value of the i-th student LO i ∈[τ low , τ high ], then in the next medical microbiology experiment, the intermediate medical microbiology experimental steps will be arranged for the ith student.

[0106] For example: guide students to conduct multiple bacterial co-culture experiments, separate and culture different bacterial species, and observe their growth characteristics and interactions; let students conduct antibiotic sensitivity tests (such as paper diffusion method) to analyze the sensitivity of different bacteria to various antibiotics in order to understand the mechanism of action of antibiotics; teach students to perform Gram staining, fluorescent staining and other operations to master the staining characteristics of different microorganisms and their interpretation techniques.

[0107] If the performance value of the i-th student LO i <τ low , then arrange the basic medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0108] For example: guide students to master laboratory safety and aseptic operations, such as wearing gloves and masks correctly, and understand how to avoid experimental contamination; arrange simple microbial sample culture experiments, such as the culture process of common bacteria, and observe the bacterial growth environment and growth curve; guide students to master the basic operation methods of microscopes, and observe and identify the morphological structure of common microorganisms.

[0109] Furthermore, let a=a+1 and perform iterative analysis of medical microbiology experiments. The analysis process for each a iteration is as follows:

[0110] Calculate the progress parameter of the i-th student after the a+1-th medical microbiology experiment. The calculation formula is as follows:

[0111]

[0112] Among them, a∈[1,A-1], A represents the total number of medical microbiology experiments, LO i(a+1) represents the progress parameter of the i-th student after the a+1th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1th medical microbiology experiment, OS i(a+1) represents the operational standardization data of the i-th student in the a+1-th medical microbiology experiment, α and β represent the influencing factors of the experimental achievement data and the operational standardization data, respectively.

[0113] By comparing the progress parameter LO after the a+1th medical microbiology experiment i(a+1) and the progress parameter LO after the ath medical microbiology experiment is completed ia , analyze the students' progress, the analysis formula is as follows:

[0114]

[0115] Among them, V i [a→(a+1)] represents the progress of the i-th student between the a-th medical microbiology experiment and the a+1-th medical microbiology experiment.

[0116] If the progress V i [a→(a+1)]>0, it means that the student has made progress in the a+1th medical microbiology experiment, and the difficulty of the next medical microbiology experiment will be increased.

[0117] If the progress V i [a→(a+1)]=0, which means that the student has not made any progress in the (a+1)th medical microbiology experiment. In the next medical microbiology experiment, the existing level of the medical microbiology experiment steps is maintained and operational guidance is provided.

[0118] If the progress V i [a→(a+1)]<0, it means that the student has regressed in the a+1th medical microbiology experiment. In this case, the difficulty of the next medical microbiology experiment will be reduced and operational guidance will be provided.

[0119] When a+1=A, the iteration stops.

[0120] Step S4: Based on the progress parameters and the degree of progress, the comprehensive learning level score of the students is calculated; based on the comprehensive learning level score of the students, the similarity between different students is calculated, a similarity threshold is preset, and the medical microbiology experiment teaching strategy is analyzed and output.

[0121] Specifically, based on the progress parameter and the degree of progress, the comprehensive learning level score of the i-th student is calculated using the following formula:

[0122]

[0123] in, represents the comprehensive learning level score of the i-th student, δ1 and δ2 represent the preset progress parameter and the influencing factor of the progress, respectively;

[0124] Furthermore, based on the comprehensive learning level score of the ith student, the difference in comprehensive learning level scores between the ith student and the jth student is calculated, and the calculation formula is as follows:

[0125]

[0126] Where ΔLO final represents the difference in comprehensive learning level scores between the i-th student and the j-th student, Represents the comprehensive learning level score of the jth student.

[0127] Based on the difference in comprehensive learning level scores ΔLO final , calculate the similarity between the i-th student and the j-th student, the calculation formula is as follows:

[0128]

[0129] Among them, SD(i→j) represents the similarity between the i-th student and the j-th student.

[0130] Furthermore, a similarity threshold θ is preset. If SD(i→j)>θ, it is determined that the ith student is associated with the jth student, and all students who are associated with the ith student are obtained, and a unified medical microbiology experiment teaching strategy is implemented.

[0131] See also Figure 2 In the second embodiment of the present invention, a medical microbiology experiment teaching interactive system based on a data warehouse is provided, the system comprising: a student data storage management module, a student ability level scoring module, a dynamic progress tracking and analysis module, and a comprehensive learning level analysis and similarity evaluation module.

[0132] The student data storage management module divides the data storage partitions in the data warehouse based on the number of students and obtains the students' experimental achievement data and operation standardization data.

[0133] The student ability level scoring module calculates the student's performance value based on the experiment achievement data and the operation standardization data, and uses the performance value as the student's initial progress parameter.

[0134] The dynamic progress tracking and analysis module: assigns different levels of medical microbiology experiment steps to students based on the performance value; calculates the progress parameters after each medical microbiology experiment, and analyzes the students' progress based on the progress parameters.

[0135] The comprehensive learning level analysis and similarity assessment module calculates the comprehensive learning level scores of students based on progress parameters and progress; calculates the similarities between different students based on the comprehensive learning level scores of the students, presets similarity thresholds, and analyzes and outputs medical microbiology experiment teaching strategies.

[0136] Furthermore, the student data storage management module includes a data partition management unit and an experiment achievement data and operation standardization data acquisition unit.

[0137] The data partition management unit divides the data storage partitions in the data warehouse based on the number of students in the class, wherein one data storage partition is allocated to one student, and after authorization by the student, the student's experimental record information in the medical microbiology experiment is stored in the data storage partition; the experimental record information includes the experimental achievement data and operation specification data of the medical microbiology experiment.

[0138] The experimental achievement data and operation standardization data acquisition unit: The method for acquiring the experimental achievement data is as follows:

[0139] The experimental results of students in the medical microbiology experiment are compared with the preset standard experimental results to obtain the accuracy rate of students in the medical microbiology experiment, and the accuracy rate is used as the experimental achievement data of students.

[0140] The method for obtaining the operation standardization data is as follows:

[0141] A standard operating procedure is preset, and the standard operating procedure is recorded as a standard operating procedure video.

[0142] During the medical microbiology experiment, the students' operation process during the medical microbiology experiment is video recorded and recorded as the student operation video.

[0143] The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

[0144] Furthermore, the student ability level scoring module includes a student performance value calculation unit and an initial progress parameter setting unit.

[0145] The student performance value calculation unit scores the comprehensive ability level of students in the medical microbiology experiment based on the experiment achievement data and the operation standardization data, specifically as follows: calculates the student's performance value.

[0146] The initial progress parameter setting unit uses the student's performance value as the student's initial progress parameter.

[0147] Furthermore, the dynamic progress tracking and analysis module includes an experiment level adjustment unit and a progress parameter and progress degree analysis unit.

[0148] The experimental level adjustment unit: presets a performance value interval, wherein the performance value interval is composed of a preset low performance value and a preset high performance value, and arranges different levels of medical microbiology experimental steps for students, as follows:

[0149] If the student's performance value is greater than the preset high performance value, advanced medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment; if the student's performance value is within the performance value range, intermediate medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment; if the student's performance value is less than the preset low performance value, basic medical microbiology experimental steps will be arranged for the student in the next medical microbiology experiment.

[0150] The progress parameter and progress analysis unit performs iterative analysis on the medical microbiology experiment, and each iterative analysis process is as follows:

[0151] Calculate the students' progress parameters after the end of the next medical microbiology experiment.

[0152] The students' progress was analyzed by comparing the progress parameters after the end of the next medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment.

[0153] If the progress is greater than 0, it means that the student has made progress in the next medical microbiology experiment, and the difficulty will be increased in the next medical microbiology experiment.

[0154] If the progress degree is equal to 0, it means that the student has not made any progress in the next medical microbiology experiment. In this case, the current level of the medical microbiology experiment steps will be maintained in the next medical microbiology experiment, and operational guidance will be provided.

[0155] If the progress is less than 0, it means that the student has regressed in the next medical microbiology experiment. In this case, the difficulty will be reduced in the next medical microbiology experiment, and operational guidance will be provided.

[0156] After the last medical microbiology experiment is completed, the iteration is stopped.

[0157] Furthermore, the comprehensive learning level analysis and similarity assessment module includes a comprehensive learning level calculation unit and a student similarity analysis unit.

[0158] The comprehensive learning level calculation unit calculates the comprehensive learning level score of the student based on the progress parameter and the degree of improvement.

[0159] The student similarity analysis unit: based on the students' comprehensive learning level scores, calculates the difference in comprehensive learning level scores between different students; based on the difference in comprehensive learning level scores, calculates the similarity between different students; presets a similarity threshold, and if the similarity between different students is greater than the similarity threshold, it is determined that there is an association relationship between the students, and a unified medical microbiology experiment teaching strategy is implemented for all students with an associated relationship.

[0160] In the third embodiment, a medical microbiology experiment teaching interactive method based on a data warehouse is provided. In order to verify the beneficial effects of the present invention, scientific demonstration is carried out through economic benefit calculation and simulation experiments.

[0161] The experiment starts with the establishment of storage partitions in the data warehouse, with each student corresponding to a partition to record the degree of experimental achievement and operational standardization. After each round of experiments, the progress parameters and progress are recalculated based on the experimental achievement data and operational standardization data, and the difficulty of subsequent experimental steps is adjusted according to the set threshold to adapt to the students' current ability level. After each round of experiments, students are grouped by calculating similarities in order to formulate a unified teaching strategy.

[0162] Table 1 Microbiology experiment interaction data

[0163]

[0164] According to Table 1, all students showed a certain degree of progress in the later stage of the experiment, especially those with lower initial performance values ​​(such as students C and E), whose achievement and operational standardization in multiple rounds of experiments were significantly improved; this shows that the teaching method based on dynamic adjustment and personalized feedback can effectively help students with weaker performance gradually improve their experimental ability.

[0165] Specifically, in the embodiment, by calculating the performance value, simpler experimental steps are assigned to students with lower performance values ​​(such as students C, E, etc. whose initial performance values ​​are below 70), so that they can accumulate confidence in low-difficulty experimental tasks; after the degree of progress exceeds the set threshold, the experimental tasks of these students are gradually increased in difficulty. This mechanism of adjusting teaching strategies based on the degree of progress effectively helps students improve their experimental achievement and operational standardization at an appropriate level of challenge.

[0166] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0167] Finally, it should be noted that the above is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A data warehouse-based medical microbiology experiment teaching interactive method, characterized in that: The method comprises the following steps: Step S1: Divide the data storage partitions in the data warehouse based on the number of students; obtain the students' experimental achievement data and operation standardization data; Step S2: Calculate the student's performance value based on the experiment achievement data and the operation standardization data, and use the performance value as the student's initial progress parameter; Step S3: assigning different levels of medical microbiology experiment steps to students based on the performance values; calculating the progress parameters after each medical microbiology experiment, and analyzing the students' progress based on the progress parameters; Step S4: Based on the progress parameters and the degree of progress, the comprehensive learning level score of the students is calculated; based on the comprehensive learning level score of the students, the similarity between different students is calculated, a similarity threshold is preset, and the medical microbiology experiment teaching strategy is analyzed and output.

2. According to the data warehouse-based medical microbiology experiment teaching interactive method according to claim 1, it is characterized in that: The specific implementation process of step S1 includes: Step S11: Based on the number of students in the class, data storage partitions are divided in the data warehouse, wherein one data storage partition is allocated to one student, and after authorization by the student, the experimental record information of the student in the medical microbiology experiment is stored in the data storage partition; the experimental record information includes the experimental achievement data and the operation standardization data of the medical microbiology experiment; Step S12: Record the experimental achievement data and operation standardization data of the i-th student in the a-th medical microbiology experiment as EA ia and OS ia ; The method for obtaining the experimental achievement data is as follows: Compare the experimental results of students in the medical microbiology experiment with the preset standard experimental results to obtain the correct rate of students in the medical microbiology experiment, and use the correct rate as the experimental achievement data of students; The method for obtaining the operation standardization data is as follows: Preset a standard operating procedure, record the standard operating procedure by video, and record it as a standard operating procedure video; During the medical microbiology experiment, the students' operation process in the medical microbiology experiment is recorded and recorded as the student operation video; The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

3. According to claim 2, a data warehouse-based medical microbiology experiment teaching interactive method is characterized in that: The specific implementation process of step S2 includes: Step S21: Based on the experimental achievement data EA ia and operating specification data OS ia , the comprehensive ability level of the i-th student in the medical microbiology experiment is scored as follows: Construct the performance value formula for the i-th student, the formula is as follows: Among them, LO i1 represents the performance value of the i-th student, EA i1 represents the experimental achievement data of the i-th student in the initial medical microbiology experiment, OS i1 represents the operational standardization data of the i-th student in the initial medical microbiology experiment, I represents the total number of students, ω1 and ω2 represent the influencing factors of the preset experimental achievement data and operational standardization data, respectively, OS std Indicates the standard value of operational specification; Step S22: Set the performance value LO of the i-th student i1 As the initial progress parameter of the i-th student.

4. According to claim 3, a data warehouse-based medical microbiology experiment teaching interactive method is characterized in that: The specific implementation process of step S3 includes: Step S31: Preset the performance value interval, denoted as [τ low , τ high ], where τ low Indicates low performance value, τ high Indicates high performance values ​​and arranges different levels of medical microbiology experimental steps for students, as follows: Step S31.1: If the performance value of the i-th student is LO i >τ high , then arrange the advanced medical microbiology experimental steps for the i-th student in the next medical microbiology experiment; If the performance value of the i-th student LO i ∈[τ kow , τ high ], then arrange the intermediate medical microbiology experimental steps for the i-th student in the next medical microbiology experiment; If the performance value of the i-th student LO i <τ low , then arrange the basic medical microbiology experimental steps for the i-th student in the next medical microbiology experiment; Step S32: Let a=a+1, and perform iterative analysis of the medical microbiology experiment. The analysis process for each a iteration is as follows: Step S32.1: Calculate the progress parameter of the i-th student after the a+1-th medical microbiology experiment. The calculation formula is as follows: Among them, a∈[1,A-1], A represents the total number of medical microbiology experiments, LO i(a+1) represents the progress parameter of the i-th student after the a+1th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1th medical microbiology experiment, OS i(a+1) represents the operational standardization data of the i-th student in the a+1-th medical microbiology experiment, α and β represent the influencing factors of the experimental achievement data and the operational standardization data respectively; Step S32.2: By comparing the progress parameter LO after the a+1th medical microbiology experiment i(a+1) and the progress parameter LO after the ath medical microbiology experiment is completed ia , analyze the students' progress, the analysis formula is as follows: Among them, V i [a→(a+1)] represents the progress of the i-th student between the a-th medical microbiology experiment and the a+1-th medical microbiology experiment; Step S32.3: If the progress V i [a→(a+1)]>0, it means that the student has made progress in the a+1th medical microbiology experiment, so the difficulty of the next medical microbiology experiment will be increased; If the progress V i [a→(a+1)]=0, which means that the student has not made any progress in the a+1th medical microbiology experiment, and the current level of the medical microbiology experiment steps is maintained in the next medical microbiology experiment, and operation guidance is provided; If the progress V i [a→(a+1)]<0, it means that the student has regressed in the a+1th medical microbiology experiment, so the difficulty of the next medical microbiology experiment will be reduced and operational guidance will be provided; Step S32.4: Return to step S32, and when a+1=A, stop iteration.

5. According to claim 4, a data warehouse-based medical microbiology experiment teaching interactive method is characterized in that: The specific implementation process of step S4 includes: Step S41: Based on the progress parameter and the degree of progress, the comprehensive learning level score of the i-th student is calculated using the following formula: in, represents the comprehensive learning level score of the i-th student, δ1 and δ2 represent the preset progress parameter and the influencing factor of the progress, respectively; Step S42: Based on the comprehensive learning level score of the ith student, the difference in comprehensive learning level scores between the ith student and the jth student is calculated, and the calculation formula is as follows: Where ΔLO final represents the difference in comprehensive learning level scores between the i-th student and the j-th student, represents the comprehensive learning level score of the jth student; Based on the difference in comprehensive learning level scores ΔLO final , calculate the similarity between the i-th student and the j-th student, the calculation formula is as follows: Among them, SD(i→j) represents the similarity between the i-th student and the j-th student; Step S43: Preset a similarity threshold θ. If SD(i→j)>θ, determine that the i-th student is associated with the j-th student, obtain all students who are associated with the i-th student, and implement a unified medical microbiology experiment teaching strategy.

6. A medical microbiology experiment teaching interactive system based on a data warehouse, executing a medical microbiology experiment teaching interactive method based on a data warehouse as described in any one of claims 1 to 5, characterized in that: The system includes: a student data storage management module, a student ability level scoring module, a dynamic progress tracking and analysis module, and a comprehensive learning level analysis and similarity assessment module; The student data storage management module: divides the data storage partitions in the data warehouse based on the number of students; obtains the students' experimental achievement data and operation standardization data; The student ability level scoring module calculates the student's performance value based on the experiment achievement data and the operation standardization data, and uses the performance value as the student's initial progress parameter; The dynamic progress tracking and analysis module: assigns different levels of medical microbiology experimental steps to students based on the performance value; calculates the progress parameters after each medical microbiology experiment, and analyzes the students' progress based on the progress parameters; The comprehensive learning level analysis and similarity assessment module calculates the comprehensive learning level scores of students based on progress parameters and progress; calculates the similarities between different students based on the comprehensive learning level scores of the students, presets similarity thresholds, and analyzes and outputs medical microbiology experiment teaching strategies.

7. The medical microbiology experiment teaching interactive system based on data warehouse according to claim 6 is characterized by: The student data storage management module includes a data partition management unit and an experiment achievement data and operation standardization data acquisition unit; The data partition management unit: divides the data storage partitions in the data warehouse based on the number of students in the class, wherein one data storage partition is allocated to one student, and after authorization by the student, stores the experimental record information of the student in the medical microbiology experiment in the data storage partition; the experimental record information includes the experimental achievement data and the operation standardization data of the medical microbiology experiment; The experimental achievement data and operation standardization data acquisition unit: The method for acquiring the experimental achievement data is as follows: Compare the experimental results of students in the medical microbiology experiment with the preset standard experimental results to obtain the correct rate of students in the medical microbiology experiment, and use the correct rate as the experimental achievement data of students; The method for obtaining the operation standardization data is as follows: Preset a standard operating procedure, record the standard operating procedure by video, and record it as a standard operating procedure video; During the medical microbiology experiment, the students' operation process in the medical microbiology experiment is recorded and recorded as the student operation video; The standard operation specification video and the student operation video are compared frame by frame to obtain a comparison result, and the proportion of the consistent comparison results in all the comparison results is recorded as the student's operation standardization data.

8. The medical microbiology experiment teaching interactive system based on data warehouse according to claim 7 is characterized by: The student ability level scoring module includes a student performance value calculation unit and an initial progress parameter setting unit; The student performance value calculation unit: based on the experimental achievement data and the operation standardization data, scores the comprehensive ability level of the students in the medical microbiology experiment process, specifically as follows: calculate the student's performance value; The initial progress parameter setting unit uses the student's performance value as the student's initial progress parameter.

9. The medical microbiology experiment teaching interactive system based on data warehouse according to claim 8 is characterized by: The dynamic progress tracking and analysis module includes an experiment level adjustment unit and a progress parameter and progress degree analysis unit; The experimental level adjustment unit: presets a performance value interval, wherein the performance value interval is composed of a preset low performance value and a preset high performance value, and arranges different levels of medical microbiology experimental steps for students, as follows: If the student's performance value is greater than the preset high performance value, the student will be assigned advanced medical microbiology experimental steps in the next medical microbiology experiment; if the student's performance value is within the performance value range, the student will be assigned intermediate medical microbiology experimental steps in the next medical microbiology experiment; if the student's performance value is less than the preset low performance value, the student will be assigned basic medical microbiology experimental steps in the next medical microbiology experiment; The progress parameter and progress analysis unit performs iterative analysis on the medical microbiology experiment, and each iterative analysis process is as follows: Calculate the students' progress parameters after the end of the next medical microbiology experiment; By comparing the progress parameters after the end of the next medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment, the students' progress can be analyzed; If the progress degree is greater than 0, it means that the student has made progress in the next medical microbiology experiment, so the difficulty will be increased in the next medical microbiology experiment; If the progress degree is equal to 0, it means that the student has not made any progress in the next medical microbiology experiment, and the current level of medical microbiology experimental steps will be maintained in the next medical microbiology experiment, and operation guidance will be provided; If the progress is less than 0, it means that the student has regressed in the next medical microbiology experiment, so the difficulty of the next medical microbiology experiment will be reduced and operation guidance will be provided; After the last medical microbiology experiment is completed, the iteration is stopped.

10. The medical microbiology experiment teaching interactive system based on data warehouse according to claim 9 is characterized by: The comprehensive learning level analysis and similarity assessment module includes a comprehensive learning level calculation unit and a student similarity analysis unit; The comprehensive learning level calculation unit calculates the comprehensive learning level score of the student based on the progress parameter and the degree of progress; The student similarity analysis unit: based on the students' comprehensive learning level scores, calculates the difference in comprehensive learning level scores between different students; based on the difference in comprehensive learning level scores, calculates the similarity between different students; presets a similarity threshold, and if the similarity between different students is greater than the similarity threshold, it is determined that there is an association relationship between the students, and a unified medical microbiology experiment teaching strategy is implemented for all students with an associated relationship.

Images