A data warehouse-based interactive method and system for medical microbiology experiment teaching

Abstract

The present invention discloses a data warehouse-based medical microbiology experiment teaching interaction method and system, belonging to the field of teaching interaction technology. The method obtains students' experimental achievement data and operation standardization data, calculates students' performance values, and uses the performance values ​​as students' initial progress parameters; assigns students different levels of medical microbiology experimental steps; calculates progress parameters after each medical microbiology experiment, analyzes students' progress; calculates students' comprehensive learning level scores; calculates similarities between different students, presets similarity thresholds, analyzes and outputs medical microbiology experiment teaching strategies. By analyzing the progress parameters and progress after each experiment, the present invention can dynamically adjust the difficulty of experimental teaching and improve students' experimental literacy; implements differentiated teaching strategies, and ultimately achieves personalized and interactive medical microbiology experiment teaching interaction, improving the efficiency of differentiated teaching guidance.

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 instructions, but this method often fails to provide personalized feedback and progress assessment, making it impossible for students' learning outcomes to be reflected in teaching in a timely and accurate manner. To address these problems, data warehouse technology has gradually been introduced into the field of medical education. With its advantages of large-scale data storage and real-time data analysis, data warehouses provide an integrated management platform for students' learning behavior and experimental performance data, enabling teaching work to be systematized, standardized and refined. However, the current teaching methods applied to medical microbiology experiments lack quantitative assessment of students' operating standards and experimental achievement, and are unable to provide dynamic feedback and differentiated guidance based on students' individual performance, failing 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. As a result, due to the lack of effective teaching interaction feedback, it is 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 data warehouse-based medical microbiology experiment teaching interactive method 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 data warehouse-based medical microbiology experiment teaching interactive method 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 each 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 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 was 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 comparison results, and the proportion of consistent comparison results in all 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 operational 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 of the i-th student 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 this invention, the formula is used to calculate the learning level of students in the first experiment based on two key indicators: experimental performance EA i1 and operating specifications OS i1 ; It is a relative score, which will be divided into the student's experimental score EA i1 Compare this with the total scores of all students in the class to get a ratio that reflects the student's relative level in the class. This score calculation method avoids errors caused by different experimental difficulties and different absolute values ​​of scores, making the evaluation more fair. Used to measure students' operational standards, 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. This method can lower the scores of students with low standardization; this scoring formula is mainly used to measure students' overall learning performance 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 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 arrange the intermediate medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0025] For example: guide students to conduct co-culture experiments with multiple bacteria, observe their growth characteristics and interactions by isolating and culturing different bacterial species; let students conduct antibiotic sensitivity tests (such as the disc 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, 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) It represents the progress parameter of the i-th student after the a+1-th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1-th 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 standardization. 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; because the formula focuses on the relative progress of individual students in different experiments, regardless of the students' initial level, their personal growth can be objectively evaluated. In this way, students with lower initial levels will also be encouraged when they make significant progress, thereby improving their learning enthusiasm.

[0033] By comparing the progress parameter LO after the a+1th medical microbiology experiment i(a+1) and the progress parameter LO after the completion of the ath medical microbiology experiment 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 If [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+1th medical microbiology experiment. In the next medical microbiology experiment, the level of the existing medical microbiology experimental steps is maintained and operational guidance is provided.

[0038] If the progress V i If [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. 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 parameter and the influencing factor 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 entire experimental process, and then provide personalized teaching guidance for the students. For example, for students with lower learning levels, more detailed experimental step prompts or strengthened operational standardization training can be provided, while for students with higher 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 teaching effectiveness. 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 a simple experimental score. This comprehensiveness not only better meets the actual teaching needs, but also helps to cultivate 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 using the following formula:

[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 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.

[0051] A medical microbiology experiment teaching interactive system based on data warehouse includes: a student data storage and 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 into partitions in the data warehouse based on the number of students; and obtains 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 experiment steps to students based on the performance value; calculates the progress parameters after each medical microbiology experiment, and analyzes the student's 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 similarity between different students based on the comprehensive learning level scores of the students, presets a similarity threshold, analyzes and outputs the medical microbiology experiment teaching strategy.

[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 each 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 standardization 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 was 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 comparison results, and the proportion of consistent comparison results in all 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 during the medical microbiology experiment based on the experimental 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, which consists 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, the student will be arranged with 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 arranged with 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 arranged with basic medical microbiology experimental steps in the next medical microbiology experiment.

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

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

[0072] By comparing the progress parameters after the end of the second medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment, the students' progress can be analyzed.

[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 of the next medical microbiology experiment will be increased.

[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 medical microbiology experimental 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 of the next medical microbiology experiment will be reduced 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 student's comprehensive learning level score based on the progress parameter and the degree of progress.

[0079] The student similarity analysis unit calculates the difference in comprehensive learning level scores between different students based on the students' comprehensive learning level scores; calculates the similarity between different students based on the difference in comprehensive learning level scores; 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 the association relationship.

[0080] Compared with the prior art, the present invention achieves the following beneficial effects: the present invention provides a data warehouse-based medical microbiology experiment teaching interactive method and system, which achieves targeted data management and information protection by allocating independent data storage partitions for each student in the data warehouse to store experimental achievement data and operation standardization data; by comparing student experimental results with standard results, the accuracy rate is used as achievement data, and by comparing video recordings of student operations with 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 operation standardization within the class, providing a reliable basis for teachers to formulate personalized teaching plans; in subsequent teaching, based on the initial performance value range, experimental steps of different difficulty levels are automatically assigned, allowing students to gradually improve based on their own level; through progress parameter and progress analysis after each experiment, teachers can dynamically adjust the difficulty of experimental teaching, thereby improving students' learning enthusiasm and experimental literacy; finally, the comprehensive learning level score is used to measure students' overall performance in the course, and the correlation between students is determined based on score differences and similarities, and differentiated teaching strategies are implemented, ultimately achieving precise, personalized and interactive medical microbiology experiment teaching interaction, improving teaching effectiveness 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 diagram of a medical microbiology experiment teaching interactive system based on a data warehouse of the present invention. DETAILED DESCRIPTION

[0084] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. 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 making creative efforts 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, the method comprising the following steps:

[0086] 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.

[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 each 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 was 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 comparison results, and the proportion of consistent comparison results in all 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 operational 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 of the i-th student 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; progress parameters are calculated after each medical microbiology experiment, and the student's progress is analyzed based on the progress parameters.

[0102] Specifically, the preset performance value interval is recorded 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 arrange the intermediate medical microbiology experimental steps for the i-th student in the next medical microbiology experiment.

[0106] For example: guide students to conduct co-culture experiments with multiple bacteria, observe their growth characteristics and interactions by isolating and culturing different bacterial species; let students conduct antibiotic sensitivity tests (such as the disc 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, 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) It represents the progress parameter of the i-th student after the a+1-th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1-th 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 completion of the ath medical microbiology experiment 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 If [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+1th medical microbiology experiment. In the next medical microbiology experiment, the level of the existing medical microbiology experimental steps is maintained and operational guidance is provided.

[0118] If the progress V i If [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 progress respectively;

[0124] Furthermore, 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 using the following formula:

[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 i-th student is associated with the j-th student. All students who are associated with the i-th 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, which includes: a student data storage and 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 student's 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 similarity between different students based on the comprehensive learning level scores of the students, presets a similarity threshold, analyzes and outputs the medical microbiology experiment teaching strategy.

[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 each 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 standardization 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 was 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 comparison results, and the proportion of consistent comparison results in all 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 during the medical microbiology experiment based on the experimental 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, which consists 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, the student will be arranged with 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 arranged with 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 arranged with basic medical microbiology experimental steps in the next medical microbiology experiment.

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

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

[0152] By comparing the progress parameters after the end of the second medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment, the students' progress can be analyzed.

[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 of the next medical microbiology experiment will be increased.

[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 medical microbiology experimental 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 of the next medical microbiology experiment will be reduced 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 student's comprehensive learning level score based on the progress parameter and the degree of progress.

[0159] The student similarity analysis unit calculates the difference in comprehensive learning level scores between different students based on the students' comprehensive learning level scores; calculates the similarity between different students based on the difference in comprehensive learning level scores; 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 the association relationship.

[0160] In the third embodiment, a data warehouse-based interactive method for medical microbiology experiment teaching 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 begins by establishing storage partitions in the data warehouse, with each student corresponding to one 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 student's current ability level. After each round of experiments, students are grouped by calculating similarity in order to formulate a unified teaching strategy.

[0162] Table 1 Microbiology experiment interaction data

[0163]

[0164] As can be seen in Table 1, all students showed some degree of improvement in the later stages 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 and E whose initial performance values ​​are below 70), so that they can accumulate confidence in low-difficulty experimental tasks; after the progress degree exceeds the set threshold, the experimental tasks of these students are gradually increased in difficulty. This mechanism of adjusting teaching strategies based on the progress degree effectively helps students improve their experimental achievement and operational standardization at an appropriate challenge level.

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

[0167] Finally, it should be noted that the above description is merely 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 will be able to modify the technical solutions described in the aforementioned embodiments or substitute equivalents for some of the technical features. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention shall be included within the scope of protection of the present invention.

Claims

1. A data warehouse-based interactive method for medical microbiology experiment teaching, 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: Calculating the student's performance value based on the experiment achievement data and the operation standardization data, and using 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 progress parameters after each medical microbiology experiment, and analyzing the students' progress based on the progress parameters; Step S4: Calculating the comprehensive learning level score of the students based on the progress parameter and the degree of progress; Calculating the similarity between different students based on the comprehensive learning level score of the students, presetting a similarity threshold, analyzing and outputting the medical microbiology experiment teaching strategy; 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 each 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 experimental achievement data and 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: Comparing the students' experimental results in the medical microbiology experiment with the preset standard experimental results to obtain the students' accuracy rate in the medical microbiology experiment, and using the accuracy rate as the students' experimental achievement data; The method for obtaining the operation standardization data is as follows: Preset a standard operating procedure, record the standard operating procedure via video, and record the video 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; Compare the standard operation video with the student operation video frame by frame to obtain comparison results, and record the proportion of consistent comparison results in all comparison results as the student's operation standardization data; The specific implementation process of step S2 includes: Step S21: Based on the experimental achievement data EA ia and operational 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 of the i-th student 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; 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 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 ∈[τ low ,τ 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) It represents the progress parameter of the i-th student after the a+1-th medical microbiology experiment, EA i(a+1) represents the experimental achievement data of the i-th student in the a+1-th 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 operational standardization data, respectively; Step S32.2: Compare the progress parameter LO after the a+1th medical microbiology experiment i(a+1) and the progress parameter LO after the completion of the ath medical microbiology experiment 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 If [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; If the progress V i If [a→(a+1)]=0, it means that the student has not made any progress in the a+1th medical microbiology experiment. In this case, the student will maintain the current level of medical microbiology experimental steps in the next medical microbiology experiment and provide operational guidance. If the progress V i If [a→(a+1)]<0, it means that the student has regressed in the a+1th medical microbiology experiment, and 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.

2. The interactive method for medical microbiology experiment teaching based on data warehouse according to claim 1 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 progress respectively; Step S42: Based on the comprehensive learning level score of the i-th student, calculate the difference in comprehensive learning level scores between the i-th student and the j-th student. 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)>θ, it is determined that the i-th student is associated with the j-th student. All students who are associated with the i-th student are obtained, and a unified medical microbiology experiment teaching strategy is implemented.

3. A data warehouse-based medical microbiology experiment teaching interactive system, which executes a data warehouse-based medical microbiology experiment teaching interactive method according to any one of claims 1 to 2, 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 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 experiment steps to students based on the performance values; 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 similarity between different students based on the comprehensive learning level scores of the students, presets a similarity threshold, analyzes and outputs the medical microbiology experiment teaching strategy.

4. The data warehouse-based medical microbiology experimental teaching interactive system according to claim 3 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 each student, and after authorization by the student, stores the student's experimental record information in the medical microbiology experiment in the data storage partition; the experimental record information includes experimental achievement data and 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: Comparing the students' experimental results in the medical microbiology experiment with the preset standard experimental results to obtain the students' accuracy rate in the medical microbiology experiment, and using the accuracy rate as the students' experimental achievement data; The method for obtaining the operation standardization data is as follows: Preset a standard operating procedure, record the standard operating procedure via video, and record the video 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 comparison results, and the proportion of consistent comparison results in all comparison results is recorded as the student's operation standardization data.

5. The data warehouse-based medical microbiology experimental teaching interactive system according to claim 4 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 calculates the student's performance value based on the experiment achievement data and the operation standardization data; The initial progress parameter setting unit uses the student's performance value as the student's initial progress parameter.

6. The data warehouse-based medical microbiology experimental teaching interactive system according to claim 5, characterized in that: 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, which consists 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. The analysis process of each iteration 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 second medical microbiology experiment with the progress parameters after the end of the previous medical microbiology experiment, the students' progress is analyzed; If the progress degree is greater than 0, it means that the student has made progress in the next medical microbiology experiment, and the difficulty of the next medical microbiology experiment will be increased; 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 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, and the difficulty of the next medical microbiology experiment will be reduced, and operational guidance will be provided; After the last medical microbiology experiment is completed, the iteration is stopped.

7. The data warehouse-based medical microbiology experimental teaching interactive system according to claim 6, characterized in that: 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 student's comprehensive learning level score based on the progress parameter and the degree of progress; The student similarity analysis unit calculates the difference in comprehensive learning level scores between different students based on the students' comprehensive learning level scores; calculates the similarity between different students based on the difference in comprehensive learning level scores; 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 the association relationship.

Images