CN108765224A - Course classification is analyzed with the rate of attendance and device - Google Patents
Course classification is analyzed with the rate of attendance and device Download PDFInfo
- Publication number
- CN108765224A CN108765224A CN201810514495.8A CN201810514495A CN108765224A CN 108765224 A CN108765224 A CN 108765224A CN 201810514495 A CN201810514495 A CN 201810514495A CN 108765224 A CN108765224 A CN 108765224A
- Authority
- CN
- China
- Prior art keywords
- attendance
- rate
- course
- sum
- group
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000004458 analytical method Methods 0.000 claims abstract description 16
- 239000006185 dispersion Substances 0.000 claims description 6
- 238000012512 characterization method Methods 0.000 claims 7
- 230000000875 corresponding effect Effects 0.000 description 21
- 238000004364 calculation method Methods 0.000 description 13
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Educational Administration (AREA)
- Educational Technology (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
本发明实施例涉及教学管理技术领域,提供一种课程类别与出勤率分析方法及装置,所述方法包括:获得每个课程类别对应的学生出勤统计数据;依据学生出勤统计数据,计算出组内离差平方和及组间离差平方和;依据组内离差平方和组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差;若第一出勤率偏差小于或等于第二出勤率偏差,则依据第二出勤率偏差与第一出勤率偏差的比值得到出勤影响率;若出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。本发明实施例可以准确分析出课程类别是否对出勤率产生影响,从而指导学校教学管理系统根据分析结果合理修改不同课程类别的课程要求来提高教学质量。
The embodiment of the present invention relates to the technical field of teaching management, and provides a method and device for analyzing course categories and attendance rates. The method includes: obtaining the statistical data of student attendance corresponding to each course category; The sum of the squares of the deviations and the sum of the squares of the deviations between groups; based on the sum of the squares of the deviations within the group and the sum of the squares of the deviations between the groups, the first attendance rate deviation and the second attendance rate deviation are calculated; if the first attendance rate deviation is less than or equal to the second If the second attendance rate deviation is the ratio of the second attendance rate deviation to the first attendance rate deviation, the attendance influence rate is obtained; if the attendance influence rate is greater than the value corresponding to the F distribution table under the preset significant level, then determine the impact of the course category on the student attendance rate influential. The embodiment of the present invention can accurately analyze whether the course category has an impact on the attendance rate, thereby instructing the school teaching management system to reasonably modify the course requirements of different course categories according to the analysis results to improve the teaching quality.
Description
技术领域technical field
本发明实施例涉及教学管理技术领域,具体而言,涉及一种课程类别与出勤率分析及装置。The embodiment of the present invention relates to the technical field of teaching management, and specifically relates to a course category and attendance rate analysis and device.
背景技术Background technique
目前,大学生的课程可以分为公共必修课、公共选修课、专业必修课和专业选修课,不同类别的课程要求和难度不同,有些课程的出勤率极低,通常会将其原因归结为教师教学质量不佳,但也有可能是由于课程要求问题导致的部分类别课程不受学生重视,但是目前无法准确分析出学生出勤率是否会受到课程类别的影响,使得学校教学管理系统无法及时调整出勤率极低课程的要求。At present, the courses of college students can be divided into public compulsory courses, public elective courses, professional compulsory courses and professional elective courses. Different types of courses have different requirements and difficulties. The attendance rate of some courses is extremely low, which is usually attributed to teacher teaching. The quality is not good, but it may also be due to course requirements that some courses are not valued by students. However, it is currently impossible to accurately analyze whether the student attendance rate will be affected by the course category, making the school teaching management system unable to adjust the attendance rate in time. Low course requirements.
发明内容Contents of the invention
本发明实施例的目的在于提供一种课程类别与出勤率分析方法及装置,用以确定课程类别是否影响学生出勤率。The purpose of the embodiment of the present invention is to provide a method and device for analyzing course category and attendance rate to determine whether course category affects student attendance rate.
为了实现上述目的,本发明实施例采用的技术方案如下:In order to achieve the above object, the technical solution adopted in the embodiment of the present invention is as follows:
第一方面,本发明实施例提供了一种课程类别与出勤率分析方法,所述方法包括:获得每个课程类别对应的学生出勤统计数据;依据所述学生出勤统计数据,计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和;依据所述组内离差平方和所述组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差;若所述第一出勤率偏差小于或等于所述第二出勤率偏差,则依据第二出勤率偏差与所述第一出勤率偏差的比值得到出勤影响率;若所述出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。In the first aspect, an embodiment of the present invention provides a method for analyzing course categories and attendance rates. The method includes: obtaining student attendance statistics corresponding to each course category; The sum of the squares of the intragroup deviations of the individual errors in the category, and the sum of the squares of the squares of the intergroup deviations of the degree of difference between different course categories; Attendance rate deviation and second attendance rate deviation; if the first attendance rate deviation is less than or equal to the second attendance rate deviation, the attendance influence rate is obtained according to the ratio of the second attendance rate deviation to the first attendance rate deviation ; If the attendance impact rate is greater than the value corresponding to the F distribution table under the preset significant level, then it is determined that the course category has an impact on the student attendance rate.
第二方面,本发明实施例还提供了一种课程类别与出勤率分析装置,所述装置包括数据获得模块、第一计算模块、第二计算模块、第一执行模块及第二执行模块。其中,数据获得模块用于获得每个课程类别对应的学生出勤统计数据;第一计算模块用于依据所述学生出勤统计数据,计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和;第二计算模块用于依据所述组内离差平方和所述组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差;第一执行模块用于若所述第一出勤率偏差小于或等于所述第二出勤率偏差,则依据第二出勤率偏差与所述第一出勤率偏差的比值得到出勤影响率;第二执行模块用于若所述出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。In the second aspect, the embodiment of the present invention also provides a course category and attendance rate analysis device, the device includes a data acquisition module, a first calculation module, a second calculation module, a first execution module and a second execution module. Wherein, the data acquisition module is used to obtain the statistical data of student attendance corresponding to each course category; the first calculation module is used to calculate the sum of squared deviations within the group representing individual errors in the same course category according to the student attendance statistical data, And the sum of squares of the difference between different course categories; the second calculation module is used to calculate the first attendance rate deviation and the second deviation according to the square of the deviation within the group and the sum of the squares of the deviation between the groups. Attendance rate deviation; the first execution module is used to obtain the attendance influence rate according to the ratio of the second attendance rate deviation to the first attendance rate deviation if the first attendance rate deviation is less than or equal to the second attendance rate deviation ; The second execution module is used to determine that the course category has an impact on the student attendance rate if the attendance impact rate is greater than the value corresponding to the F distribution table under the preset significance level.
相对现有技术,本发明实施例提供的一种课程类别与出勤率分析及装置,首先,依据每个课程类别对应的学生出勤统计数据计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和;然后,依据组内离差平方和组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差,若第一出勤率偏差小于或等于第二出勤率偏差时依据第二出勤率偏差与第一出勤率偏差的比值得到出勤影响率;最后,若出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。本发明实施例可以准确分析出课程类别是否对出勤率产生影响,从而指导学校教学管理系统根据分析结果合理修改不同课程类别的课程要求来提高教学质量。Compared with the prior art, the embodiment of the present invention provides a course category and attendance rate analysis and device. First, according to the student attendance statistics data corresponding to each course category, the intra-group deviation square that characterizes the individual error in the same course category is calculated. and, as well as the sum of squares of deviations between groups of differences between different course categories; then, according to the sum of squares of deviations within a group and the sum of squares of deviations between groups, the deviation of the first attendance rate and the deviation of the second attendance rate are calculated, if the second When the first attendance rate deviation is less than or equal to the second attendance rate deviation, the attendance influence rate is obtained according to the ratio of the second attendance rate deviation to the first attendance rate deviation; finally, if the attendance influence rate is greater than the value corresponding to the F distribution table under the preset significant level , then it is determined that the course category has an impact on student attendance. The embodiment of the present invention can accurately analyze whether the course category has an impact on the attendance rate, thereby instructing the school teaching management system to reasonably modify the course requirements of different course categories according to the analysis results to improve the teaching quality.
为使本发明的上述目的、特征和优点能更明显易懂,下文特举较佳实施例,并配合所附附图,作详细说明如下。In order to make the above-mentioned objects, features and advantages of the present invention more comprehensible, preferred embodiments will be described in detail below together with the accompanying drawings.
附图说明Description of drawings
为了更清楚地说明本发明实施例的技术方案,下面将对实施例中所需要使用的附图作简单地介绍,应当理解,以下附图仅示出了本发明的某些实施例,因此不应被看作是对范围的限定,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他相关的附图。In order to illustrate the technical solutions of the embodiments of the present invention more clearly, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present invention, and thus It should be regarded as a limitation on the scope, and those skilled in the art can also obtain other related drawings based on these drawings without creative work.
图1示出了本发明实施例提供的电子设备的方框示意图。Fig. 1 shows a schematic block diagram of an electronic device provided by an embodiment of the present invention.
图2示出了本发明实施例提供的课程类别与出勤率分析方法流程图。FIG. 2 shows a flowchart of a method for analyzing course categories and attendance rates provided by an embodiment of the present invention.
图3示出了本发明实施例提供的课程类别与出勤率分析装置的方框示意图。Fig. 3 shows a schematic block diagram of a device for analyzing course categories and attendance rates provided by an embodiment of the present invention.
图标:100-电子设备;101-存储器;102-存储控制器;103-处理器;200-课程类别与出勤率分析装置;201-数据获得模块;202-第一计算模块;203-第二计算模块;204-第一执行模块;205-第二执行模块。Icons: 100-electronic equipment; 101-memory; 102-storage controller; 103-processor; 200-course category and attendance rate analysis device; 201-data acquisition module; 202-first calculation module; 203-second calculation module; 204-the first execution module; 205-the second execution module.
具体实施方式Detailed ways
下面将结合本发明实施例中附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分实施例,而不是全部的实施例。通常在此处附图中描述和示出的本发明实施例的组件可以以各种不同的配置来布置和设计。因此,以下对在附图中提供的本发明的实施例的详细描述并非旨在限制要求保护的本发明的范围,而是仅仅表示本发明的选定实施例。基于本发明的实施例,本领域技术人员在没有做出创造性劳动的前提下所获得的所有其他实施例,都属于本发明保护的范围。The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. The components of the embodiments of the invention generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations. Accordingly, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts belong to the protection scope of the present invention.
应注意到:相似的标号和字母在下面的附图中表示类似项,因此,一旦某一项在一个附图中被定义,则在随后的附图中不需要对其进行进一步定义和解释。同时,在本发明的描述中,术语“第一”、“第二”等仅用于区分描述,而不能理解为指示或暗示相对重要性。It should be noted that like numerals and letters denote similar items in the following figures, therefore, once an item is defined in one figure, it does not require further definition and explanation in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", etc. are only used to distinguish descriptions, and cannot be understood as indicating or implying relative importance.
请参照图1,图1示出了本发明实施例提供的电子设备100的方框示意图。电子设备100可以是,但不限于便携计算机、笔记本电脑、台式机等等。所述电子设备100包括课程类别与出勤率分析装置200、存储器101、存储控制器102及处理器103。Please refer to FIG. 1 , which shows a schematic block diagram of an electronic device 100 provided by an embodiment of the present invention. The electronic device 100 may be, but is not limited to, a portable computer, a notebook computer, a desktop computer, and the like. The electronic device 100 includes a course type and attendance analysis device 200 , a memory 101 , a storage controller 102 and a processor 103 .
所述存储器101、存储控制器102和处理器103各元件相互之间直接或间接地电性连接,以实现数据的传输或交互。例如,这些元件相互之间可通过一条或多条通讯总线或信号线实现电性连接。所述课程类别与出勤率分析装置200包括至少一个可以软件或固件(firmware)的形式存储于所述存储器101中或固化在所述电子设备100的操作系统(operating system,OS)中的软件功能模块。所述处理器103用于执行存储器101中存储的可执行模块,例如所述课程类别与出勤率分析装置200包括的软件功能模块或计算机程序。The components of the memory 101 , the memory controller 102 and the processor 103 are electrically connected to each other directly or indirectly to realize data transmission or interaction. For example, these components can be electrically connected to each other through one or more communication buses or signal lines. The course category and attendance rate analysis device 200 includes at least one software function that can be stored in the memory 101 in the form of software or firmware (firmware) or solidified in the operating system (operating system, OS) of the electronic device 100 module. The processor 103 is configured to execute executable modules stored in the memory 101 , such as software function modules or computer programs included in the course type and attendance rate analysis apparatus 200 .
其中,存储器101可以是,但不限于,随机存取存储器(Random Access Memory,RAM),只读存储器(Read Only Memory,ROM),可编程只读存储器(Programmable Read-OnlyMemory,PROM),可擦除只读存储器(Erasable Programmable Read-Only Memory,EPROM),电可擦除只读存储器(Electric Erasable Programmable Read-Only Memory,EEPROM)等。Wherein, memory 101 can be, but not limited to, random access memory (Random Access Memory, RAM), read-only memory (Read Only Memory, ROM), programmable read-only memory (Programmable Read-OnlyMemory, PROM), erasable In addition to read-only memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable read-only memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc.
处理器103可以是一种集成电路芯片,具有信号处理能力。上述的处理器103可以是通用处理器,包括中央处理器(Central Processing Unit,CPU)、网络处理器(NetworkProcessor,NP)、语音处理器以及视频处理器等;还可以是数字信号处理器、专用集成电路、现场可编程门阵列或者其他可编程逻辑器件、分立门或者晶体管逻辑器件、分立硬件组件。可以实现或者执行本发明实施例中的公开的各方法、步骤及逻辑框图。通用处理器可以是微处理器或者该处理器103也可以是任何常规的处理器等。The processor 103 may be an integrated circuit chip with signal processing capability. Above-mentioned processor 103 can be general-purpose processor, comprises central processing unit (Central Processing Unit, CPU), network processor (NetworkProcessor, NP), speech processor and video processor etc.; Integrated circuits, field programmable gate arrays or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. Various methods, steps and logic block diagrams disclosed in the embodiments of the present invention may be implemented or executed. The general-purpose processor may be a microprocessor, or the processor 103 may be any conventional processor or the like.
第一实施例first embodiment
请参照图2,图2示出了本发明实施例提供的课程类别与出勤率分析方法流程图。课程类别与出勤率分析方法包括以下步骤:Please refer to FIG. 2 , which shows a flowchart of a method for analyzing course categories and attendance rates provided by an embodiment of the present invention. The course category and attendance rate analysis method includes the following steps:
步骤S101,获得每个课程类别对应的学生出勤统计数据。Step S101, obtaining the attendance statistical data of students corresponding to each course category.
在本发明实施例中,课程类别包括公共必修课、公共选修课、专业必修课及专业选修课。首先,获取每门课程的学生出勤数据,每门课程的学生出勤数据均存储在学校的教学管理系统中;然后,按照预设的多个课程类别,将所有课程的学生出勤数据进行分组,得到每个课程类别对应的学生出勤统计数据,也就是说,根据公共必修课、公共选修课、专业必修课及专业选修课这四个课程类别将所有课程的学生出勤数据分为四组,得到每个课程类别对应的学生出勤统计数据。In the embodiment of the present invention, the course categories include public compulsory courses, public elective courses, professional compulsory courses and professional elective courses. First, the student attendance data of each course is obtained, and the student attendance data of each course are stored in the school's teaching management system; then, the student attendance data of all courses are grouped according to the preset multiple course categories, and the obtained The statistical data of student attendance corresponding to each course category, that is to say, according to the four course categories of public compulsory courses, public elective courses, professional compulsory courses and professional elective courses, the student attendance data of all courses are divided into four groups, and each Student attendance statistics for each course category.
不同课程类别的出勤率存在差异,但是这种差异不一定全是由课程类别导致的,也有可能是学生自身的原因,因此,将不同课程类别的出勤率偏差分为两类,包括相同课程类别之间不同课程的出勤率偏差、以及不同课程类别整体出勤率之间的偏差,相同课程类别之间不同课程的出勤率偏差由同一课程类别中的个体误差(包括学生个人差异及课程个体差异)造成、不同课程类别整体出勤率之间的偏差由不同课程类别的出勤率大小造成。There are differences in the attendance rate of different course categories, but this difference is not necessarily caused by the course category, and may also be caused by the students themselves. Therefore, the attendance rate deviation of different course categories is divided into two categories, including the same course category The deviation of attendance rate between different courses, and the deviation between the overall attendance rate of different course categories, the attendance rate deviation of different courses between the same course category is caused by the individual error in the same course category (including individual differences between students and individual courses) The deviation between the overall attendance rates of different course categories is caused by the attendance rates of different course categories.
步骤S102,依据学生出勤统计数据,计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和。Step S102 , according to the statistical data of student attendance, calculate the sum of squares of deviation within a group representing the individual error in the same course category, and the sum of squares of deviation between groups representing the degree of difference between different course categories.
在本发明实施例中,得到每个课程类别对应的学生出勤统计数据之后,首先,依据每个课程类别对应的学生出勤统计数据,计算每个课程类别的第一平均出勤率、以及所有课程的第二平均出勤率,第一平均出勤率用Xi,i=1,2,3,4表示,指每个课程类别的平均出勤率;第二平均出勤率用X表示,指所有课程的平均出勤率。In the embodiment of the present invention, after obtaining the student attendance statistical data corresponding to each course category, first, according to the student attendance statistical data corresponding to each course category, calculate the first average attendance rate of each course category, and the first average attendance rate of all courses. The second average attendance rate, the first average attendance rate is represented by Xi, i =1, 2, 3, 4, which refers to the average attendance rate of each course category; the second average attendance rate is represented by X, which refers to the average of all courses attendance.
然后,依据每门课程的学生出勤数据及第二平均出勤率,计算出表征所有课程出勤率离散程度的总偏差平方和,总偏差平方和为每门课程的学生出勤数与第二平均出勤率的离差平方和,是描述所有课程出勤率离散程度的一个指标。具体来说,依据每门课程的学生出勤数据及第二平均出勤率,按照第一公式计算出表征所有课程出勤率离散程度的总偏差平方和,其中,S2为所述总偏差平方和,Xi为每门课程的学生出勤数据,为所述第二平均出勤率,n为课程数。Then, based on the student attendance data of each course and the second average attendance rate, the total deviation sum of squares representing the dispersion degree of all course attendance rates is calculated, and the total deviation square sum is the student attendance number of each course and the second average attendance rate The sum of squared deviations of , is an indicator describing the degree of dispersion of attendance in all courses. Specifically, based on the student attendance data of each course and the second average attendance rate, according to the first formula Calculate the total deviation sum of squares that characterizes the degree of dispersion of all course attendance rates, wherein S 2 is the total deviation sum of squares, Xi is the student attendance data of each course, is the second average attendance rate, and n is the number of courses.
接下来,依据每门课程的学生出勤数据及每个课程类别的第一平均出勤率,计算出表征同一课程类别中个体误差的组内离差平方和,组内离差平方和反映了一个课程类别中的个体误差,即学生个人和某门课程本身误差的影响。具体来说,依据每门课程的学生出勤数据及每个课程类别的第一平均出勤率,按照第二公式计算出表征同一课程类别中个体误差的组内离差平方和,其中,SS组内为所述组内离差平方和,Xij为第i个课程类别下第j个课程的学生出勤数据,为每个课程类别的第一平均出勤率,k为课程类别数,n为课程数。Next, based on the student attendance data of each course and the first average attendance rate of each course category, the sum of squared deviations within a group representing individual errors in the same course category is calculated, and the sum of squared deviations within a group reflects the Individual error within a category, i.e. the effect of individual student and error in a course itself. Specifically, based on the student attendance data of each course and the first average attendance rate of each course category, according to the second formula Calculate the sum of squares of the individual errors in the same course category, wherein, within the SS group, it is the sum of squares of the deviations in the group, Xij is the student attendance data of the jth course under the ith course category, is the first average attendance rate of each course category, k is the number of course categories, and n is the number of courses.
最后,依据每个课程类别对应的第一平均出勤率及第二平均出勤率,计算出表征不同课程类别之间差异程度的组间离差平方和,组间离差平方和反映了各课程类别平均出勤率之间的差异程度。具体来说,依据每个课程类别对应的第一平均出勤率及第二平均出勤率,按照第三公式计算出表征不同课程类别之间差异程度的组间离差平方和,其中,SS组间为组间离差平方和,为每个课程类别的第一平均出勤率,为第二平均出勤率,k为课程类别数,n为课程数。Finally, according to the first average attendance rate and the second average attendance rate corresponding to each course category, the sum of squared deviations between groups representing the degree of difference between different course categories is calculated. The sum of squared deviations between groups reflects the degree of difference between each course category. The degree of variance between average attendance rates. Specifically, according to the first average attendance rate and the second average attendance rate corresponding to each course category, according to the third formula Calculate the sum of squares of variance between groups that characterizes the degree of difference between different course categories, where SS between groups is the sum of squares of variance between groups, is the first average attendance rate for each course category, is the second average attendance rate, k is the number of course categories, and n is the number of courses.
步骤S103,依据组内离差平方和组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差。Step S103 , calculating the first attendance rate deviation and the second attendance rate deviation according to the square of the deviation within the group and the sum of the squares of the deviation between the groups.
在本发明实施例中,第一出勤率偏差代表学生个人差异和课程个体差异导致的出勤率平均偏差,第二出勤率偏差代表不同课程类别带来的出勤率的平均偏差。第一出勤率偏差和第二出勤率偏差的计算方法可以包括:In the embodiment of the present invention, the first attendance rate deviation represents the average attendance rate deviation caused by individual differences of students and individual courses, and the second attendance rate deviation represents the average attendance rate deviation caused by different course categories. The calculation method of the first attendance rate deviation and the second attendance rate deviation may include:
首先,依据组内离差平方和所述组间离差平方和,按照第四公式计算出第一出勤率偏差,其中,MS组内为第一出勤率偏差,SS组内为组内离差平方和,k为课程类别数,n为课程数;First, according to the sum of squares of variance within a group and the sum of squares of variance between groups, according to the fourth formula Calculate the deviation of the first attendance rate, where the MS group is the first attendance rate deviation, the SS group is the sum of squared deviations within the group, k is the number of course categories, and n is the number of courses;
依据组内离差平方和组间离差平方和,按照第五公式计算出第二出勤率偏差,其中,MS组间为第二出勤率偏差,SS组间为组间离差平方和。According to the square of the deviation within the group and the sum of the square of the deviation between the groups, according to the fifth formula The second attendance rate deviation is calculated, wherein, the MS group is the second attendance rate deviation, and the SS group is the sum of squared deviations between groups.
步骤S104,若第一出勤率偏差小于或等于第二出勤率偏差,则依据第二出勤率偏差与所述第一出勤率偏差的比值得到出勤影响率。Step S104, if the first attendance rate deviation is less than or equal to the second attendance rate deviation, the attendance influence rate is obtained according to the ratio of the second attendance rate deviation to the first attendance rate deviation.
在本发明实施例中,如果第一出勤率偏差MS组内大于第二出勤率偏差MS组间,那么说明课程类别中的个体差异(包括学生个人差异及课程个体差异)对出勤率的影响较大,课程类别对出勤率的影响很小可忽略。如果第一出勤率偏差MS组内小于或等于第二出勤率偏差MS组间,那么说明课程类别对出勤率影响大,此时需要进一步计算课程类别对出勤率的出勤影响率。In the embodiment of the present invention, if the first attendance rate deviation MS group is greater than the second attendance rate deviation MS group , then the individual differences in the course category (including student individual differences and course individual differences) have a greater impact on the attendance rate. Large, the impact of course categories on attendance is negligible. If the first attendance rate deviation within the MS group is less than or equal to the second attendance rate deviation MS between groups , it means that the course category has a great influence on the attendance rate, and it is necessary to further calculate the attendance influence rate of the course category on the attendance rate.
出勤影响率F可以是第二出勤率偏差MS组间与第一出勤率偏差MS组内的比值,即出勤影响率F代表课程类别对出勤率的影响程度,课程类别对出勤率的影响程度越大则出勤影响率F越大。The attendance influence rate F can be the ratio between the second attendance rate deviation MS group and the first attendance rate deviation MS group , that is The attendance influence rate F represents the influence degree of the course category on the attendance rate, and the greater the influence degree of the course category on the attendance rate, the greater the attendance influence rate F.
步骤S105,若出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。Step S105, if the attendance influence rate is greater than the value corresponding to the F distribution table at the preset significance level, it is determined that the course category has an influence on the student attendance rate.
在本发明实施例中,实际应用中存在一定的小概率事件,即当前获取的学生出勤率分析后得到课程类别和出勤率高度相关,故需要确保小概率事件发生的概率要低于百分之一,即计算出来的出勤影响率F需要大于预设显著水平(例如,0.01)下F分布表对应的值,此时可以确定课程类别对学生出勤率有显著影响。In the embodiment of the present invention, there are certain low-probability events in practical applications, that is, after analyzing the currently obtained student attendance rate, the course category and attendance rate are highly correlated, so it is necessary to ensure that the probability of occurrence of low-probability events is lower than 100%. First, the calculated attendance influence rate F needs to be greater than the value corresponding to the F distribution table under the preset significant level (for example, 0.01), at this time it can be determined that the course category has a significant impact on the student attendance rate.
本发明实施例可以依据获取的每门课程的学生出勤数据来分析课程类别是否对出勤率存在影响,如果分析出课程类别对出勤率有显著影响,则可以去判断学校是否存在课程要求问题导致部分类别的课程不受学生重视,学校可以根据分析结果合理修改自己的课程要求来提高学生的出勤率,进一步提高教学质量。The embodiment of the present invention can analyze whether the course category has an impact on the attendance rate according to the obtained student attendance data of each course. If the analysis shows that the course category has a significant impact on the attendance rate, it can be judged whether there is a course requirement problem in the school. Classes of courses are not valued by students. Schools can reasonably modify their course requirements according to the analysis results to improve student attendance and further improve teaching quality.
第二实施例second embodiment
请参照图3,图3示出了本发明实施例提供的课程类别与出勤率分析装置200的方框示意图。课程类别与出勤率分析装置200包括数据获得模块201、第一计算模块202、第二计算模块203、第一执行模块204及第二执行模块205。Please refer to FIG. 3 , which shows a schematic block diagram of a course category and attendance rate analysis device 200 provided by an embodiment of the present invention. The apparatus 200 for analyzing course category and attendance rate includes a data acquisition module 201 , a first calculation module 202 , a second calculation module 203 , a first execution module 204 and a second execution module 205 .
数据获得模块201,用于获得每个课程类别对应的学生出勤统计数据。The data obtaining module 201 is used to obtain the statistical data of student attendance corresponding to each course category.
在本发明实施例中,数据获得模块201,具体用于获取每门课程的学生出勤数据;按照预设的多个课程类别,将所有课程的学生出勤数据进行分组,得到每个课程类别对应的学生出勤统计数据。In the embodiment of the present invention, the data obtaining module 201 is specifically used to obtain the student attendance data of each course; according to the preset multiple course categories, the student attendance data of all courses are grouped to obtain the student attendance data corresponding to each course category. Student attendance statistics.
第一计算模块202,用于依据学生出勤统计数据,计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和。The first calculation module 202 is configured to calculate the sum of squares of intragroup deviations representing individual errors in the same course category and the sum of squares of intergroup deviations representing the degree of difference between different course categories according to the statistical data of student attendance.
在本发明实施例中,第一计算模块202,具体用于依据每个课程类别对应的学生出勤统计数据,计算每个课程类别的第一平均出勤率、以及所有课程的第二平均出勤率;依据每门课程的学生出勤数据及第二平均出勤率,计算出表征所有课程出勤率离散程度的总偏差平方和;依据每门课程的学生出勤数据及每个课程类别的第一平均出勤率,计算出表征同一课程类别中个体误差的组内离差平方和;依据每个课程类别对应的第一平均出勤率及所述第二平均出勤率,计算出表征不同课程类别之间差异程度的组间离差平方和。In the embodiment of the present invention, the first calculation module 202 is specifically configured to calculate the first average attendance rate of each course category and the second average attendance rate of all courses according to the student attendance statistics data corresponding to each course category; Based on the student attendance data of each course and the second average attendance rate, calculate the total deviation sum of squares that characterizes the degree of dispersion of the attendance rates of all courses; based on the student attendance data of each course and the first average attendance rate of each course category, Calculate the sum of squared deviations within the group that characterizes individual errors in the same course category; calculate the group that characterizes the degree of difference between different course categories based on the first average attendance rate and the second average attendance rate corresponding to each course category The sum of squared differences.
第二计算模块203,用于依据组内离差平方和组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差。The second calculation module 203 is configured to calculate the first attendance rate deviation and the second attendance rate deviation according to the square of the intra-group deviation and the sum of the squares of the inter-group deviation.
在本发明实施例中,第二计算模块203,具体用于依据组内离差平方和组间离差平方和,按照第四公式计算出第一出勤率偏差,其中,MS组内为第一出勤率偏差,SS组内为组内离差平方和,k为课程类别数,n为课程数;依据组内离差平方和组间离差平方和,按照第五公式计算出第二出勤率偏差,其中,MS组间为第二出勤率偏差,SS组间为组间离差平方和。In the embodiment of the present invention, the second calculation module 203 is specifically configured to use the fourth formula Calculate the deviation of the first attendance rate, among them, the MS group is the first attendance rate deviation, the SS group is the sum of square deviations within the group, k is the number of course categories, and n is the number of courses; according to the sum of square deviations within the group The sum of squares of the deviations between them, according to the fifth formula The second attendance rate deviation is calculated, wherein, the MS group is the second attendance rate deviation, and the SS group is the sum of squared deviations between groups.
第一执行模块204,用于若第一出勤率偏差小于或等于第二出勤率偏差,则依据第二出勤率偏差与所述第一出勤率偏差的比值得到出勤影响率。The first execution module 204 is configured to obtain the attendance influence rate according to the ratio of the second attendance rate deviation to the first attendance rate deviation if the first attendance rate deviation is less than or equal to the second attendance rate deviation.
第二执行模块205,用于若出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。The second execution module 205 is configured to determine that the course category has an impact on the student attendance rate if the attendance impact rate is greater than the value corresponding to the F distribution table at a preset significance level.
综上所述,本发明实施例提供的一种课程类别与出勤率分析方法及装置,所述方法包括:获得每个课程类别对应的学生出勤统计数据;依据学生出勤统计数据,计算出表征同一课程类别中个体误差的组内离差平方和、以及不同课程类别之间差异程度的组间离差平方和;依据组内离差平方和组间离差平方和,计算出第一出勤率偏差和第二出勤率偏差;若第一出勤率偏差小于或等于第二出勤率偏差,则依据第二出勤率偏差与第一出勤率偏差的比值得到出勤影响率;若出勤影响率大于预设显著水平下F分布表对应的值,则确定课程类别对学生出勤率有影响。本发明实施例可以准确分析出课程类别是否对出勤率产生影响,从而指导学校教学管理系统根据分析结果合理修改不同课程类别的课程要求来提高教学质量。To sum up, the embodiment of the present invention provides a course category and attendance rate analysis method and device. The method includes: obtaining the student attendance statistical data corresponding to each course category; The sum of the squares of the intragroup deviation of the individual error in the course category, and the sum of the squares of the intergroup deviation of the degree of difference between different course categories; calculate the first attendance rate deviation based on the square of the intragroup deviation and the sum of the squares of the intergroup deviation and the second attendance rate deviation; if the first attendance rate deviation is less than or equal to the second attendance rate deviation, the attendance influence rate is obtained based on the ratio of the second attendance rate deviation to the first attendance rate deviation; if the attendance influence rate is greater than the preset significant The value corresponding to the F distribution table under the horizontal level determines that the course category has an impact on student attendance. The embodiment of the present invention can accurately analyze whether the course category has an impact on the attendance rate, thereby instructing the school teaching management system to reasonably modify the course requirements of different course categories according to the analysis results to improve the teaching quality.
在本申请所提供的几个实施例中,应该理解到,所揭露的装置和方法,也可以通过其它的方式实现。以上所描述的装置实施例仅仅是示意性的,例如,附图中的流程图和框图显示了根据本发明的多个实施例的装置、方法和计算机程序产品的可能实现的体系架构、功能和操作。在这点上,流程图或框图中的每个方框可以代表一个模块、程序段或代码的一部分,所述模块、程序段或代码的一部分包含一个或多个用于实现规定的逻辑功能的可执行指令。也应当注意,在有些作为替换的实现方式中,方框中所标注的功能也可以以不同于附图中所标注的顺序发生。例如,两个连续的方框实际上可以基本并行地执行,它们有时也可以按相反的顺序执行,这依所涉及的功能而定。也要注意的是,框图和/或流程图中的每个方框、以及框图和/或流程图中的方框的组合,可以用执行规定的功能或动作的专用的基于硬件的系统来实现,或者可以用专用硬件与计算机指令的组合来实现。In the several embodiments provided in this application, it should be understood that the disclosed devices and methods may also be implemented in other ways. The device embodiments described above are only illustrative. For example, the flowcharts and block diagrams in the accompanying drawings show the architecture, functions and possible implementations of devices, methods and computer program products according to multiple embodiments of the present invention. operate. In this regard, each block in a flowchart or block diagram may represent a module, program segment, or part of code that includes one or more Executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks in succession may, in fact, be executed substantially concurrently, or they may sometimes be executed in the reverse order, depending upon the functionality involved. It should also be noted that each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented by a dedicated hardware-based system that performs the specified function or action , or may be implemented by a combination of dedicated hardware and computer instructions.
另外,在本发明各个实施例中的各功能模块可以集成在一起形成一个独立的部分,也可以是各个模块单独存在,也可以两个或两个以上模块集成形成一个独立的部分。In addition, each functional module in each embodiment of the present invention can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part.
所述功能如果以软件功能模块的形式实现并作为独立的产品销售或使用时,可以存储在一个计算机可读取存储介质中。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括:U盘、移动硬盘、只读存储器(ROM,Read-Only Memory)、随机存取存储器(RAM,Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。需要说明的是,在本文中,诸如第一和第二等之类的关系术语仅仅用来将一个实体或者操作与另一个实体或操作区分开来,而不一定要求或者暗示这些实体或操作之间存在任何这种实际的关系或者顺序。而且,术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、方法、物品或者设备不仅包括那些要素,而且还包括没有明确列出的其他要素,或者是还包括为这种过程、方法、物品或者设备所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括所述要素的过程、方法、物品或者设备中还存在另外的相同要素。If the functions are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the essence of the technical solution of the present invention or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including Several instructions are used to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes. . It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that there is a relationship between these entities or operations. any such actual relationship or order exists between them. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of or also include elements inherent in such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.
以上所述仅为本发明的优选实施例而已,并不用于限制本发明,对于本领域的技术人员来说,本发明可以有各种更改和变化。凡在本发明的精神和原则之内,所作的任何修改、等同替换、改进等,均应包含在本发明的保护范围之内。应注意到:相似的标号和字母在下面的附图中表示类似项,因此,一旦某一项在一个附图中被定义,则在随后的附图中不需要对其进行进一步定义和解释。The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and changes. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention. It should be noted that like numerals and letters denote similar items in the following figures, therefore, once an item is defined in one figure, it does not require further definition and explanation in subsequent figures.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810514495.8A CN108765224A (en) | 2018-05-25 | 2018-05-25 | Course classification is analyzed with the rate of attendance and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810514495.8A CN108765224A (en) | 2018-05-25 | 2018-05-25 | Course classification is analyzed with the rate of attendance and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108765224A true CN108765224A (en) | 2018-11-06 |
Family
ID=64006546
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810514495.8A Pending CN108765224A (en) | 2018-05-25 | 2018-05-25 | Course classification is analyzed with the rate of attendance and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108765224A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110364049A (en) * | 2019-07-17 | 2019-10-22 | 石虹 | A kind of professional skill real training assisted teaching system and assistant teaching method with the correction control of irrelevance automatic feedback data closed loop |
CN112598546A (en) * | 2020-11-23 | 2021-04-02 | 深圳市大数据研究院 | Method and device for determining relative course arriving index |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120075322A1 (en) * | 2010-09-29 | 2012-03-29 | Hathaway William M | Systems and methods for presenting results of experiments |
CN104573304A (en) * | 2014-07-30 | 2015-04-29 | 南京坦道信息科技有限公司 | User property state assessment method based on information entropy and cluster grouping |
CN106772080A (en) * | 2016-12-21 | 2017-05-31 | 哈尔滨工业大学 | Space lithium ion battery accelerated degradation test time equivalence modeling method |
CN106952077A (en) * | 2017-03-16 | 2017-07-14 | 北京中电普华信息技术有限公司 | A method and device for generating a work order processing strategy |
CN107229600A (en) * | 2017-05-31 | 2017-10-03 | 北京邮电大学 | A kind of parallel variance analysis method and device based on big data |
-
2018
- 2018-05-25 CN CN201810514495.8A patent/CN108765224A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120075322A1 (en) * | 2010-09-29 | 2012-03-29 | Hathaway William M | Systems and methods for presenting results of experiments |
CN104573304A (en) * | 2014-07-30 | 2015-04-29 | 南京坦道信息科技有限公司 | User property state assessment method based on information entropy and cluster grouping |
CN106772080A (en) * | 2016-12-21 | 2017-05-31 | 哈尔滨工业大学 | Space lithium ion battery accelerated degradation test time equivalence modeling method |
CN106952077A (en) * | 2017-03-16 | 2017-07-14 | 北京中电普华信息技术有限公司 | A method and device for generating a work order processing strategy |
CN107229600A (en) * | 2017-05-31 | 2017-10-03 | 北京邮电大学 | A kind of parallel variance analysis method and device based on big data |
Non-Patent Citations (2)
Title |
---|
田兵: "单因素方差分析的数学模型及其应用", 《阴山学刊》 * |
郭萍: "单因素方差分析在数理统计中的应用", 《长春大学学报》 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110364049A (en) * | 2019-07-17 | 2019-10-22 | 石虹 | A kind of professional skill real training assisted teaching system and assistant teaching method with the correction control of irrelevance automatic feedback data closed loop |
CN110364049B (en) * | 2019-07-17 | 2021-03-30 | 石虹 | Professional skill training auxiliary teaching system with automatic deviation degree feedback data closed-loop deviation rectification control and auxiliary teaching method |
CN112598546A (en) * | 2020-11-23 | 2021-04-02 | 深圳市大数据研究院 | Method and device for determining relative course arriving index |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Garson | Hierarchical linear modeling: Guide and applications | |
Maydeu-Olivares et al. | Instrumental variables two-stage least squares (2SLS) vs. maximum likelihood structural equation modeling of causal effects in linear regression models | |
Cui et al. | Estimating classification consistency and accuracy for cognitive diagnostic assessment | |
Stock et al. | Twenty years of time series econometrics in ten pictures | |
Maydeu-Olivares et al. | Assessing approximate fit in categorical data analysis | |
McNeish | Should we use F-tests for model fit instead of chi-square in overidentified structural equation models? | |
Wu et al. | Evaluating model fit for growth curve models: Integration of fit indices from SEM and MLM frameworks. | |
Thai et al. | A comparison of bootstrap approaches for estimating uncertainty of parameters in linear mixed‐effects models | |
Zhong et al. | Bias and efficiency in structural equation modeling: Maximum likelihood versus robust methods | |
Lim et al. | Zero-inflated Poisson regression mixture model | |
CN108764710A (en) | Evaluation Method of Teaching Quality and device | |
Leung | Network Cluster‐Robust Inference | |
CN111367754B (en) | Data monitoring method, device, computer equipment and storage medium | |
CN111898247B (en) | Landslide displacement prediction method, landslide displacement prediction equipment and storage medium | |
Jin et al. | A nonparametric poolability test for panel data models with cross section dependence | |
Su et al. | Testing additive separability of error term in nonparametric structural models | |
Sundararajan et al. | Nonparametric change point detection in multivariate piecewise stationary time series | |
CN108765224A (en) | Course classification is analyzed with the rate of attendance and device | |
Laverde-Rojas et al. | Are average years of education losing predictive power for economic growth? An alternative measure through structural equations modeling | |
Xiang et al. | Fault classification for high‐dimensional data streams: A directional diagnostic framework based on multiple hypothesis testing | |
Nagelkerke et al. | Power and type I error of local fit statistics in multilevel latent class analysis | |
Cribari-Neto et al. | Leverage-adjusted heteroskedastic bootstrap methods | |
CN108696397B (en) | A method and device for power grid information security assessment based on AHP and big data | |
Ulkhaq | The determinants of Indonesian students’ mathematics performance: An analysis through PISA data 2018 wave | |
Murr et al. | Computing quantities of interest and their uncertainty using Bayesian simulation |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181106 |
|
RJ01 | Rejection of invention patent application after publication |