[go: up one dir, main page]

CN115130993A - Method for automatically drawing university course establishment relation topology structure diagram - Google Patents

Method for automatically drawing university course establishment relation topology structure diagram Download PDF

Info

Publication number
CN115130993A
CN115130993A CN202210774478.4A CN202210774478A CN115130993A CN 115130993 A CN115130993 A CN 115130993A CN 202210774478 A CN202210774478 A CN 202210774478A CN 115130993 A CN115130993 A CN 115130993A
Authority
CN
China
Prior art keywords
course
courses
semester
opening
offering
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
Application number
CN202210774478.4A
Other languages
Chinese (zh)
Inventor
薛兆廷
施珺
陈艳艳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jiangsu Ocean University
Original Assignee
Jiangsu Ocean University
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jiangsu Ocean University filed Critical Jiangsu Ocean University
Priority to CN202210774478.4A priority Critical patent/CN115130993A/en
Publication of CN115130993A publication Critical patent/CN115130993A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/109Time management, e.g. calendars, reminders, meetings or time accounting
    • G06Q10/1093Calendar-based scheduling for persons or groups
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/20Education
    • G06Q50/205Education administration or guidance

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Theoretical Computer Science (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Educational Technology (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Educational Administration (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Quality & Reliability (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for automatically drawing a topological structure diagram of the course establishment relationship in colleges and universities, which can automatically acquire professional establishment courses and establishment relationships among the courses directly from a culture scheme, a course library and a teaching outline, realize high-efficiency and high-quality automatic one-key drawing of the course establishment topological structure diagram, and simultaneously can flexibly modify on line and generate pictures to be filed or displayed on line. According to the invention, relevant lesson opening information can be automatically acquired according to different lesson opening conditions of each specialty, and automatic drawing of the relation topology structure chart of each specialty course is carried out, so that the time and energy for drawing the topology structure chart are saved, and the situations of low efficiency and easiness in omission of manual drawing are effectively avoided; when a talent culture scheme is formulated in colleges and universities, a topological structure diagram does not need to be drawn manually to set up courses, the efficiency and quality of teaching management work are improved, and education informatization level of colleges and universities is promoted to step a new step.

Description

一种自动绘制高校课程开设关系拓扑结构图的方法A method for automatically drawing the topological structure diagram of university course offering relationship

技术领域technical field

本发明涉及计算机软件开发领域,具体为一种自动绘制高校课程开设关系拓扑结构图的方法。The invention relates to the field of computer software development, in particular to a method for automatically drawing a topological structure diagram of a university course offering relationship.

背景技术Background technique

课程开设关系拓扑结构图是直观反映高校人才培养方案的一种常用图形,是高校制定各专业本科人才培养方案时必须完成的一项重要工作。目前,这类拓扑结构图一般都是在Visio或其它工具软件中手动绘制,效率极低;绘制时,需要将人才培养方案中开设的全部课程,按照开课学期、归属平台、课程性质,一个一个布局到适当位置,然后根据各门课程教学大纲中所列出的先修课程与后续课程,绘制出表达开课先后关系的连接线。这个过程中,不管是每门课程的添加/修改,还是课程开设顺序的获取/调整,以及关系连线的绘制/调整,都非常的耗时耗力,而且关系表达复杂、很容易出错。迄今为止,在已公开发布的软件中,未发现可以实现自动绘制课程开设关系拓扑结构图的软件或算法;为此提供了一种自动绘制高校课程开设关系拓扑结构图的方法。The topological structure diagram of the course offering relationship is a common graph that intuitively reflects the talent training program of colleges and universities, and it is an important task that colleges and universities must complete when formulating undergraduate talent training programs for various majors. At present, such topology diagrams are generally drawn manually in Visio or other tool software, which is extremely inefficient; when drawing, all courses offered in the talent training plan need to be sorted one by one according to the semester, the platform, and the nature of the course. Layout to an appropriate position, and then draw a connection line expressing the sequence of courses according to the prerequisite courses and follow-up courses listed in the syllabus of each course. In this process, whether it is the addition/modification of each course, the acquisition/adjustment of the course offering sequence, and the drawing/adjustment of relationship connections, it is very time-consuming and labor-intensive, and the relationship expression is complex and error-prone. So far, no software or algorithm has been found in the software that has been released to the public that can automatically draw the topological structure diagram of the course offering relationship; for this purpose, a method for automatically drawing the topological structure graph of the course offering relationship in colleges and universities is provided.

发明内容SUMMARY OF THE INVENTION

本发明的目的是针对现有技术的缺陷,提供一种自动绘制高校课程开设关系拓扑结构图的方法,以解决上述背景技术提出的问题。The purpose of the present invention is to provide a method for automatically drawing a topological structure diagram of a university course offering relationship in view of the defects of the prior art, so as to solve the problems raised by the above-mentioned background technology.

为实现上述目的,本发明提供如下技术方案:一种自动绘制高校课程开设关系拓扑结构图的方法,具体步骤如下:In order to achieve the above purpose, the present invention provides the following technical solutions: a method for automatically drawing a topological structure diagram of a university course offering relationship, the specific steps are as follows:

S1:获取专业开设的课程信息以及课程的开设关系信息,并将这些信息保存入课程开设拓扑结构图绘制模块的数据库中;S1: Obtain the course information offered by the major and the course offering relationship information, and save the information into the database of the course offering topology diagram drawing module;

S11:第一次绘制专业的拓扑结构图时,从专业的培养目标材料中获取该专业开设课程的详细信息,并将所有课程信息添加进入“开设课程数据表”中;S11: When drawing the topological structure diagram of the major for the first time, obtain the detailed information of the courses offered by the major from the training target materials of the major, and add all the course information into the "Course Opening Data Table";

S12:根据专业的所有开设课程,逐个去查询对应的课程教学大纲,将该课程以及该课程的后继课程一一存入“开课关系数据表”中,所有的后继课程以英文的“;”进行分隔;S12: According to all the courses offered by the major, check the corresponding course syllabus one by one, and store the course and the successor courses of the course into the "course opening relationship data table" one by one, and all the successor courses are conducted in English ";" separate;

S2:将专业的开课信息、课程开设关系信息从数据库中获取到算法中;S2: Obtain the professional course opening information and course opening relationship information from the database into the algorithm;

S21:根据专业号和年级号在数据库中查询,并将返回结果保存在数组中;S21: Query the database according to the professional number and grade number, and save the returned results in an array;

S22:其中课程开设关系的多个后继课程在数据库中是以中文的“;”进行分隔,获取到程序后,将每一个后继课程单独划分到一个数组中;S22: The multiple successor courses of the course offering relationship are separated by Chinese ";" in the database. After the program is obtained, each successor course is divided into an array separately;

S3:对获取到的专业开课信息数组进行进一步的初始化;S3: further initialize the acquired professional course opening information array;

S31:专业的开课情况展示在页面上是以4行8列的表格形式进行展示,4行分别对应4个课程归属平台,8列分别代表8个开课学期;S31: The course opening status of the major is displayed on the page in the form of a table with 4 rows and 8 columns. The 4 rows correspond to the 4 course attribution platforms, and the 8 columns represent the 8 semesters.

S32:分别统计4个归属平台中开设课程最多的一个学期的课程数目,然后在同一归属平台的其它学期添加补充数组*,使得同一归属平台各个学期的开课情况数组个数一样;S32: Count the number of courses in the semester with the most courses among the 4 attribution platforms, and then add supplementary arrays* in other semesters of the same attribution platform, so that the number of the same attribution platform is the same in each semester;

S4:在页面展示专业的课程开设情况;遍历课程开设情况数组,按照课程的归属平台、开课学期分别将他们放入到对应的4行8列表格中,补充数组也要进行放置但是会将其隐藏,在前端页面存在,但是不可见;S4: Display the professional course offerings on the page; traverse the array of course offerings, and put them into the corresponding 4-row 8-column table according to the course's attribution platform and the starting semester. The supplementary array is also placed but it will be Hidden, exists on the front-end page, but is not visible;

S5:调整课程位置;课程只能在自己当前的归属平台、开课学期表格中进行位置的调整,也就设计了点击课程就将该课程的位置下调一位的算法,用以调整课程到合适的位置以保证画线的时候足够简便;S5: Adjust the position of the course; the course can only be adjusted in its current attribution platform and in the form of the starting semester, and an algorithm is designed to adjust the position of the course by clicking on the course to adjust the course to the appropriate one. position to ensure that it is easy enough to draw lines;

S6:根据课程开设关系数组画出开设关系线条;因为要根据需求调整课程在拓扑图中的位置,所以要在课程位置确定之后进行画线,就要先生成一个html页面,展示所有开课情况,然后在此基础上进行画线,也就是要实现在DOM元素之间进行画线,此处采用组件Leader-line封装的svg画线方法实现在DOM元素之间进行画线。S6: Draw the opening relationship line according to the course opening relationship array; because the position of the course in the topology map needs to be adjusted according to the needs, so to draw the line after the course position is determined, it is necessary to generate an html page first, showing all the opening conditions, Then draw lines on this basis, that is, to draw lines between DOM elements. Here, the svg line drawing method encapsulated by the component Leader-line is used to draw lines between DOM elements.

作为本发明的一种优选技术方案,所述S11中从专业的培养目标材料中获取该专业开设课程的详细信息,所述详细信息包含有课程的开设学期、课程的归属平台。As a preferred technical solution of the present invention, in S11, the detailed information of the courses offered by the major is obtained from the training target materials of the major, and the detailed information includes the semester for which the course is offered and the platform to which the course belongs.

作为本发明的一种优选技术方案,所述S11将所有课程信息添加进入“开设课程数据表”中,开设学期在数据表中的存储为数字:1-8分别代表大学的8个学期,课程的归属平台在数据表重点存储为数字:1-4;1代表通识教育平台,2代表专业大类教育平台,3代表专业教育平台,4代表实践课程教育平台。As a preferred technical solution of the present invention, in S11, all course information is added into the "course opening data table", and the opening semesters are stored in the data table as numbers: 1-8 respectively represent the 8 semesters of the university, the courses The attribution of the platform is stored as numbers in the data table: 1-4; 1 represents the general education platform, 2 represents the professional education platform, 3 represents the professional education platform, and 4 represents the practical course education platform.

作为本发明的一种优选技术方案,所述S12将该课程以及该课程的后继课程一一存入“开课关系数据表”中,考虑课程教学大纲的可能未全部编写完成,该方式就获取不到课程开设关系的情况,增设手动管理来增删改查课程开设情况。As a preferred technical solution of the present invention, in the step S12, the course and the subsequent courses of the course are stored in the "course opening relationship data table" one by one. Considering that the course syllabus may not be fully compiled, this method will not obtain the In the case of the course offering relationship, add manual management to add, delete, modify and check the course offering.

作为本发明的一种优选技术方案,所述S32中具体实例如下:通识教育平台的8个学期的开设课程数目依次为:4,2,3,1,4,3,2,0,则通识教育平台开设课程最多的一个学期课程数目为4,这8个学期需要添加的补充数组数分别为:0,2,1,3,0,1,2,4。As a preferred technical solution of the present invention, the specific example in S32 is as follows: the number of courses offered in the 8 semesters of the general education platform is: 4, 2, 3, 1, 4, 3, 2, 0, then The maximum number of courses offered by the general education platform in one semester is 4. The number of supplementary arrays that need to be added in these 8 semesters are: 0, 2, 1, 3, 0, 1, 2, and 4.

作为本发明的一种优选技术方案,所述S32中补充数组*:只有学期、归属平台等一些基础信息,没有实际意义。As a preferred technical solution of the present invention, the supplementary array * in S32: only some basic information such as semester, belonging platform, etc., has no practical significance.

作为本发明的一种优选技术方案,所述S4的实例如下:如果一个课程信息数组的归属平台为1,开课学期为1,那么就将它放入到通识教育平台的第一学期表格中。As a preferred technical solution of the present invention, the example of S4 is as follows: if the attribution platform of a course information array is 1, and the starting semester is 1, then it is put into the first semester table of the general education platform .

本发明的有益效果是:本方法可以直接从培养方案、课程库、教学大纲中自动获取专业的开设课程以及课程之间的开设关系,实现高效率、高质量的一键自动绘制完成课程开设拓扑结构图,同时可以在线灵活修改,并一键生成图片存档或在线展示;The beneficial effects of the present invention are: the method can automatically obtain the professional offering courses and the offering relationship between the courses directly from the training scheme, the course library and the syllabus, so as to realize the high-efficiency and high-quality one-key automatic drawing to complete the course offering topology The structure diagram can be flexibly modified online at the same time, and a picture archive or online display can be generated with one click;

本发明可以针对各专业的不同开课情况,自动从培养方案、课程库、教学大纲中获取相关开课信息,进行各专业课程开设关系拓扑结构图的自动绘制,节省绘制拓扑结构图的时间和精力,有效避免人工绘制效率低下且容易发生疏漏的情形;在高校制定人才培养方案时,不需要再去手动绘制课程开设拓扑结构图,提高教学管理工作的效率和质量,促进高校教育信息化水平迈上新台阶。The present invention can automatically obtain relevant course opening information from the training scheme, course library and teaching syllabus according to the different course opening conditions of each major, and automatically draw the topology structure diagram of the course opening relationship of each major, saving the time and energy of drawing the topology structure diagram. Effectively avoid the situation that manual drawing is inefficient and prone to omissions; when colleges and universities formulate talent training plans, there is no need to manually draw the topology map of course offerings, improve the efficiency and quality of teaching management, and promote the level of college education informatization. new level.

附图说明Description of drawings

图1为在本发明的课程开设拓扑结构图自动生成界面;Fig. 1 is to open the topology structure diagram automatic generation interface in the course of the present invention;

图2为在本发明同行-相邻画线图;Fig. 2 is in the same line of the present invention-adjacent line drawing;

图3为在本发明同行-不相邻画线图;Fig. 3 is in the same line of the present invention - non-adjacent line drawing;

图4为在本发明同列-同归属-相邻画线图;Fig. 4 is in the same row of the present invention-same attribution-adjacent line drawing;

图5为在本发明同列-同归属-不相邻画线图;Fig. 5 is in the same row of the present invention-same attribution-non-adjacent line drawing;

图6为在本发明同列-不同归属画线图;Fig. 6 is a line drawing in the same row of the present invention-different attribution;

图7为在本发明右下方-同归属-相邻-可直接画线图;Fig. 7 is in the lower right of the present invention - the same attribution - adjacent - can be directly drawn;

图8为在本发明右下方-同归属-相邻-不可直接画线图;Fig. 8 is in the lower right corner of the present invention-same attribution-adjacent-cannot directly draw a line;

图9为在本发明右下方-同归属-不相邻-可直接画线图;Fig. 9 is in the lower right corner of the present invention - same attribution - not adjacent - can be directly drawn;

图10为在本发明右下方-同归属-不相邻-不可直接画线图;Fig. 10 is in the lower right corner of the present invention-same attribution-not adjacent-not directly drawing a line;

图11为在本发明右下方-不同归属-相邻画线图;Fig. 11 is in the lower right of the present invention-different attribution-adjacent line drawing;

图12为在本发明右下方-不同归属-不相邻-可直接画线图;Figure 12 is a diagram at the bottom right of the present invention - different attribution - not adjacent - can be directly drawn;

图13为在本发明右下方-不同归属-不相邻-不可直接画线图;Figure 13 is a diagram at the bottom right of the present invention - different attribution - not adjacent - not directly drawing lines;

图14为在本发明右上方-同归属-可直接画线图;Fig. 14 is the top right of the present invention - the same attribution - can be directly drawn;

图15为在本发明右上方-同归属-不可直接画线图;Fig. 15 is the top right of the present invention - the same attribution - can not directly draw a line;

图16为在本发明右上方-不同归属-不可直接画线图。Figure 16 is a diagram at the top right of the present invention - different attribution - not direct line drawing.

具体实施方式Detailed ways

下面结合附图对本发明的较佳实施例进行详细阐述,以使本发明的优点和特征能更易被本领域人员理解,从而对本发明的保护范围做出更为清楚明确的界定。The preferred embodiments of the present invention are described in detail below with reference to the accompanying drawings, so that the advantages and features of the present invention can be more easily understood by those skilled in the art, and the protection scope of the present invention can be more clearly defined.

本发明提供一种自动绘制高校课程开设关系拓扑结构图的方法,具体步骤如下:The invention provides a method for automatically drawing a topological structure diagram of a university course offering relationship, and the specific steps are as follows:

S1:获取专业开设的课程信息以及课程的开设关系信息,并将这些信息保存入课程开设拓扑结构图绘制模块的数据库中;S1: Obtain the course information offered by the major and the course offering relationship information, and save the information into the database of the course offering topology diagram drawing module;

S11:第一次绘制专业的拓扑结构图时,从专业的培养目标材料中获取该专业开设课程的详细信息,并将所有课程信息添加进入“开设课程数据表”中;S11: When drawing the topological structure diagram of the major for the first time, obtain the detailed information of the courses offered by the major from the training target materials of the major, and add all the course information into the "Course Opening Data Table";

S12:根据专业的所有开设课程,逐个去查询对应的课程教学大纲,将该课程以及该课程的后继课程一一存入“开课关系数据表”中,所有的后继课程以英文的“;”进行分隔;S12: According to all the courses offered by the major, check the corresponding course syllabus one by one, and store the course and the successor courses of the course into the "course opening relationship data table" one by one, and all the successor courses are conducted in English ";" separate;

S2:将专业的开课信息、课程开设关系信息从数据库中获取到算法中;S2: Obtain the professional course opening information and course opening relationship information from the database into the algorithm;

S21:根据专业号和年级号在数据库中查询,并将返回结果保存在数组中;S21: Query the database according to the professional number and grade number, and save the returned results in an array;

S22:其中课程开设关系的多个后继课程在数据库中是以中文的“;”进行分隔,获取到程序后,将每一个后继课程单独划分到一个数组中;S22: The multiple successor courses of the course offering relationship are separated by Chinese ";" in the database. After the program is obtained, each successor course is divided into an array separately;

S3:对获取到的专业开课信息数组进行进一步的初始化;S3: further initialize the acquired professional course opening information array;

S31:专业的开课情况展示在页面上是以4行8列的表格形式进行展示,4行分别对应4个课程归属平台,8列分别代表8个开课学期;S31: The course opening status of the major is displayed on the page in the form of a table with 4 rows and 8 columns. The 4 rows correspond to the 4 course attribution platforms, and the 8 columns represent the 8 semesters.

S32:分别统计4个归属平台中开设课程最多的一个学期的课程数目,然后在同一归属平台的其它学期添加补充数组*,使得同一归属平台各个学期的开课情况数组个数一样;S32: Count the number of courses in the semester with the most courses among the 4 attribution platforms, and then add supplementary arrays* in other semesters of the same attribution platform, so that the number of the same attribution platform is the same in each semester;

S4:在页面展示专业的课程开设情况;遍历课程开设情况数组,按照课程的归属平台、开课学期分别将他们放入到对应的4行8列表格中,补充数组也要进行放置但是会将其隐藏,在前端页面存在,但是不可见;S4: Display the professional course offerings on the page; traverse the array of course offerings, and put them into the corresponding 4-row 8-column table according to the course's attribution platform and the starting semester. The supplementary array is also placed but it will be Hidden, exists on the front-end page, but is not visible;

S5:调整课程位置;课程只能在自己当前的归属平台、开课学期表格中进行位置的调整,也就设计了点击课程就将该课程的位置下调一位的算法,用以调整课程到合适的位置以保证画线的时候足够简便;S5: Adjust the position of the course; the course can only be adjusted in its current attribution platform and in the form of the starting semester, and an algorithm is designed to adjust the position of the course by clicking on the course to adjust the course to the appropriate one. position to ensure that it is easy enough to draw lines;

S6:根据课程开设关系数组画出开设关系线条;因为要根据需求调整课程在拓扑图中的位置,所以要在课程位置确定之后进行画线,就要先生成一个html页面,展示所有开课情况,然后在此基础上进行画线,也就是要实现在DOM元素之间进行画线,通过查找资料目前仅发现组件Leader-line封装好了svg画线方法可以实现在DOM元素之间进行画线。S6: Draw the opening relationship line according to the course opening relationship array; because the position of the course in the topology map needs to be adjusted according to the needs, so to draw the line after the course position is determined, it is necessary to generate an html page first, showing all the opening conditions, Then draw lines on this basis, that is, to draw lines between DOM elements. By searching for data, we only find that the component Leader-line encapsulates the svg line drawing method to achieve line drawing between DOM elements.

具体的画线方法如下:The specific line drawing method is as follows:

起始课程与后继课程的位置关系与确定画线的类型一共有4大类,共计15种画线方法;图中黑点为画线坐标。There are 4 major categories of the positional relationship between the initial course and subsequent courses and the type of line drawing, with a total of 15 line drawing methods; the black dots in the figure are the line drawing coordinates.

1:同行课程关系线画法;同行课程是指起始课程与后继课程相同归属平台、相同下标的情况,共有2种画线方法。1: The line drawing method of the relationship of the peer course; the peer course refers to the situation where the starting course and the subsequent course belong to the same platform and have the same subscript. There are 2 line drawing methods.

1.1、起始课程与后继课程的开设学期相邻,画线形式如图2所示同行-相邻画线;1.1. The starting semester of the first course and the subsequent course are adjacent to each other, and the line drawing form is as shown in Figure 2. Line-adjacent lines;

1.2、起始课程与后继课程开设学期不相邻,画线形式如图3所示同行-不相邻画线。1.2. The initial course and the subsequent courses are not adjacent to each other, and the line drawing form is as shown in Figure 3. Lines are not adjacent to each other.

2.同列课程关系线画法;同列课程是指起始课程与后继课程开设学期一致的情况,共有3种画线方法;2. Line drawing method for the relationship between courses in the same column; courses in the same column refer to the situation where the starting course and the subsequent courses are opened in the same semester, and there are 3 methods for drawing lines;

2.1起始课程与后继课程在同一归属平台2.1 The initial course and subsequent courses are on the same platform

2.11、起始课程下标加一等于后继课程下标(相邻),画线形式如图4所示同列-同归属-相邻画线;2.11. Adding one to the subscript of the initial course is equal to the subscript of the subsequent course (adjacent), and the line drawing form is shown in Figure 4 in the same column-same attribution-adjacent line;

2.12、起始课程下标加一小于后继课程下标(不相邻),画线形式如图5所示同列-同归属-不相邻画线;2.12. The initial course subscript plus one is less than the subsequent course subscript (non-adjacent), and the line drawing form is shown in Figure 5 in the same column - same attribution - non-adjacent line;

2.2.起始课程与后继课程不在同一归属平台(这里不考虑后继课程在起始课程正上方这种不合理课程位置),画线形式如图6所示同列-不同归属画线。2.2. The starting course and the successor course are not on the same attribution platform (the unreasonable course position of the successor course directly above the starting course is not considered here).

3.后继课程在起始课程右下方关系线画法;共有7种画线方法;3. The relationship line drawing method in the lower right corner of the initial course for subsequent courses; there are 7 line drawing methods;

3.1、起始课程与后继课程同归属平台;3.1. The initial course and subsequent courses belong to the same platform;

(1)起始课程开设学期+1=后继课程开设学期(起始课程与后继课程开设学期相邻);(1) The starting semester of the course + 1 = the following semester of the course (the starting course and the subsequent course are adjacent to each other);

a.起始课程开始学期中从起始课程下标开始到后继课程下标中间无课程,画线形式如图7所示右下方-同归属-相邻-可直接画线;a. In the starting semester of the starting course, there is no course from the beginning of the subscript of the initial course to the subscript of the subsequent course. The line drawing form is shown in Figure 7. Bottom right - same attribution - adjacent - line can be drawn directly;

b.起始课程开始学期中从起始课程下标开始到后继课程下标中间有课程,画线形式如图8所示右下方-同归属-相邻-不可直接画线;b. In the beginning of the starting semester, there are courses from the subscript of the initial course to the subscript of the subsequent courses, and the line drawing form is shown in Figure 8. Bottom right-same attribution-adjacent-do not draw lines directly;

(2)起始课程开设学期+1<后继课程开设学期(起、终课程不相邻)(2) The starting semester of the course + 1 < the starting semester of the subsequent course (the starting and ending courses are not adjacent)

a.从起始课程学期开始到后继课程学期结束与起始课程相等下标位置无课程且从起始课程下标开始到后继课程下标结束与后继课程相同学期位置无课程,画线形式如图9所示右下方-同归属-不相邻-可直接画线;a. From the beginning of the semester of the starting course to the end of the semester of the subsequent course, there is no course in the same subscript position as the starting course, and there is no course in the same semester position as the subscript of the subsequent course from the beginning of the subscript of the starting course to the end of the subscript of the subsequent course. As shown in the lower right of Figure 9 - same attribution - not adjacent - lines can be drawn directly;

b.从起始课程学期开始到后继课程学期结束与起始课程相等下标位置有课程或从起始课程下标开始到后继课程下标结束与后继课程相同学期位置有课程,画线形式如图10所示右下方-同归属-不相邻-不可直接画线;b. There are courses in the same subscript position as the initial course from the beginning of the beginning course semester to the end of the subsequent course semester, or there are courses in the same semester position as the subsequent course from the beginning of the subscript of the initial course to the end of the subscript of the subsequent course. As shown in the lower right of Figure 10 - the same attribution - not adjacent - no line can be drawn directly;

3.2、起始课程与后继课程不同归属平台;3.2. The initial course and subsequent courses belong to different platforms;

(1)起始课程开设学期+1=后继课程开设学期(起始课程与后继课程开设学期相邻),画线形式如图11所示右下方-不同归属-相邻画线;(1) The starting semester of the course + 1 = the semester of the subsequent course (the starting course is adjacent to the semester of the subsequent course), the line drawing form is shown in Figure 11 at the bottom right - different attributions - adjacent lines;

(2)起始课程开设学期+1<后继课程开设学期(起始课程与后继课程开设学期不相邻)(2) The starting semester of the course + 1 < the starting semester of the subsequent course (the starting course and the starting semester of the subsequent course are not adjacent)

a.从起始课程开设学期开始到后继课程开始学期结束与起始课程下标相等位置无课程,画线形式如图12所示右下方-不同归属-不相邻-可直接画线;a. There is no course from the beginning of the starting semester of the starting course to the beginning of the subsequent course and the end of the semester is equal to the starting course. The line drawing form is shown in Figure 12. Bottom right - different attribution - not adjacent - the line can be drawn directly;

b.从起始课程开设学期开始到后继课程开始学期结束与起始课程下标相等位置有课程,画线形式如图13所示右下方-不同归属-不相邻-不可直接画线。b. From the beginning of the starting semester of the starting course to the beginning of the subsequent course and the end of the semester and the starting course, there are courses at the same position as the starting course. The line drawing form is shown in Figure 13 at the bottom right - different attribution - not adjacent - no line drawing directly.

4、后继课程在起始课程右上方关系线画法;共有3种画线方法;4. The relationship line drawing method in the upper right corner of the initial course for subsequent courses; there are 3 line drawing methods;

4.1、起始课程与后继课程归属平台一致;4.1. The starting course and subsequent courses belong to the same platform;

(1)从起始课程开始学期开始到后继课程开设学期结束与起始课程下标相等的位置无课程且从后继课程下标开设起始课程下标结束同一开课学期位置无课程,画线形式如图14所示右上方-同归属-可直接画线;(1) There is no course from the beginning of the starting semester of the starting course to the end of the starting semester of the subsequent course. There is no course at the position equal to the index of the starting course, and there is no course at the position of the same starting semester. As shown in Figure 14, the upper right - the same attribution - can directly draw lines;

(2)从起始课程开始学期开始到后继课程开设学期结束与起始课程下标相等的位置有课程或从后继课程下标开设起始课程下标结束同一开课学期位置有课程,画线形式如图15所示右上方-同归属-不可直接画线;(2) There is a course from the beginning of the starting semester to the end of the starting semester of the subsequent course, and there is a course at the position equal to the index of the starting course, or there is a course at the position of the same starting semester from the starting course of the subsequent course. As shown in Figure 15, the upper right - the same attribution - cannot directly draw a line;

4.2起始课程与后继课程归属平台不一致,画线形式如图16所示右上方-不同归属。4.2 The attribution platform of the initial course and subsequent courses is inconsistent, and the line drawing form is shown in the upper right of Figure 16 - different attribution.

本画线算法中判断是否可画线的算法:分为两种,横向可直接画线和纵向可直接画线;只要从起始课程的那一行到后继课程那一行之间的都没有其它课程,它们之间有补充数组,但是没有显示,就可以直接横向画线;纵向也是同理,调用这两个函数时分别传入起始课程和后继课程参数即可返回正确结果。The algorithm for judging whether a line can be drawn in this line drawing algorithm: it is divided into two types, the horizontal line can be directly drawn and the vertical line can be drawn directly; as long as there are no other courses from the line of the starting course to the line of the subsequent course , there are supplementary arrays between them, but they are not displayed, you can directly draw lines horizontally; the same is true for verticals, when calling these two functions, pass in the parameters of the initial course and the subsequent course to return the correct result.

以上算法都是程序自动运行,使用人员无需去理解原理即可一键自动生成课程开设关系拓扑结构图,之后可以将图片保存到本地,也可以点击上传按钮将生成好的课程开设关系拓扑结构图上传到服务器上,供所以人查看学习。The above algorithms are all programs that run automatically. Users can automatically generate a topology diagram of the course offering relationship with one click without understanding the principle. After that, they can save the picture locally, or click the upload button to generate a topology diagram of the course offering relationship. Upload it to the server for everyone to view and learn.

本发明可以针对各专业的不同开课情况,自动从培养方案、课程库、教学大纲中获取相关开课信息,进行各专业课程开设关系拓扑结构图的自动绘制,节省绘制拓扑结构图的时间和精力,有效避免人工绘制效率低下且容易发生疏漏的情形;在高校制定人才培养方案时,不需要再去手动绘制课程开设拓扑结构图,提高教学管理工作的效率和质量,促进高校教育信息化水平迈上新台阶。The present invention can automatically obtain relevant course opening information from the training scheme, course library and teaching syllabus according to the different course opening conditions of each major, and automatically draw the topology structure diagram of the course opening relationship of each major, saving the time and energy of drawing the topology structure diagram. Effectively avoid the situation that manual drawing is inefficient and prone to omissions; when colleges and universities formulate talent training plans, there is no need to manually draw the topology map of course offerings, improve the efficiency and quality of teaching management, and promote the level of college education informatization. New steps.

以上实施例仅表达了本发明的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本发明构思的前提下,还可以做出若干变形和改进,这些都属于本发明的保护范围。The above examples only represent several embodiments of the present invention, and the descriptions thereof are specific and detailed, but should not be construed as a limitation on the scope of the invention patent. It should be pointed out that for those of ordinary skill in the art, without departing from the concept of the present invention, several modifications and improvements can also be made, which all belong to the protection scope of the present invention.

Claims (7)

1.一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:具体步骤如下:1. a method for automatically drawing a college course offering relation topology diagram, is characterized in that: concrete steps are as follows: S1:获取专业开设的课程信息以及课程的开设关系信息,并将这些信息保存入课程开设拓扑结构图绘制模块的数据库中;S1: Obtain the course information offered by the major and the course offering relationship information, and save the information into the database of the course offering topology diagram drawing module; S11:第一次绘制专业的拓扑结构图时,从专业的培养目标材料中获取该专业开设课程的详细信息,并将所有课程信息添加进入“开设课程数据表”中;S11: When drawing the topological structure diagram of the major for the first time, obtain the detailed information of the courses offered by the major from the training target materials of the major, and add all the course information into the "Course Opening Data Table"; S12:根据专业的所有开设课程,逐个去查询对应的课程教学大纲,将该课程以及该课程的后继课程一一存入“开课关系数据表”中,所有的后继课程以英文的“;”进行分隔;S12: According to all the courses offered by the major, check the corresponding course syllabus one by one, and store the course and the successor courses of the course into the "course opening relationship data table" one by one, and all the successor courses are conducted in English ";" separate; S2:将专业的开课信息、课程开设关系信息从数据库中获取到算法中;S2: Obtain the professional course opening information and course opening relationship information from the database into the algorithm; S21:根据专业号和年级号在数据库中查询,并将返回结果保存在数组中;S21: Query the database according to the professional number and grade number, and save the returned results in an array; S22:其中课程开设关系的多个后继课程在数据库中是以中文的“;”进行分隔,获取到程序后,将每一个后继课程单独划分到一个数组中;S22: The multiple successor courses of the course offering relationship are separated by Chinese ";" in the database. After the program is obtained, each successor course is divided into an array separately; S3:对获取到的专业开课信息数组进行进一步的初始化;S3: further initialize the acquired professional course opening information array; S31:专业的开课情况展示在页面上是以4行8列的表格形式进行展示,4行分别对应4个课程归属平台,8列分别代表8个开课学期;S31: The course opening status of the major is displayed on the page in the form of a table with 4 rows and 8 columns. The 4 rows correspond to the 4 course attribution platforms, and the 8 columns represent the 8 semesters. S32:分别统计4个归属平台中开设课程最多的一个学期的课程数目,然后在同一归属平台的其它学期添加补充数组*,使得同一归属平台各个学期的开课情况数组个数一样;S32: Count the number of courses in the semester with the most courses among the 4 attribution platforms, and then add supplementary arrays* in other semesters of the same attribution platform, so that the number of the same attribution platform is the same in each semester; S4:在页面展示专业的课程开设情况;遍历课程开设情况数组,按照课程的归属平台、开课学期分别将他们放入到对应的4行8列表格中,补充数组也要进行放置但是会将其隐藏,在前端页面存在,但是不可见;S4: Display the professional course offerings on the page; traverse the array of course offerings, and put them into the corresponding 4-row 8-column table according to the course's attribution platform and the starting semester. The supplementary array is also placed but it will be Hidden, exists on the front-end page, but is not visible; S5:调整课程位置;课程只能在自己当前的归属平台、开课学期表格中进行位置的调整,也就设计了点击课程就将该课程的位置下调一位的算法,用以调整课程到合适的位置以保证画线的时候足够简便;S5: Adjust the position of the course; the course can only be adjusted in its current attribution platform and in the form of the starting semester, and an algorithm is designed to adjust the position of the course by clicking on the course to adjust the course to the appropriate one. position to ensure that it is easy enough to draw lines; S6:根据课程开设关系数组画出开设关系线条;因为要根据需求调整课程在拓扑图中的位置,所以要在课程位置确定之后进行画线,就要先生成一个html页面,展示所有开课情况,然后在此基础上进行画线,也就是要实现在DOM元素之间进行画线,此处采用组件Leader-line封装的svg画线方法实现在DOM元素之间进行画线。S6: Draw the opening relationship line according to the course opening relationship array; because the position of the course in the topology map needs to be adjusted according to the needs, so to draw the line after the course position is determined, it is necessary to generate an html page first, showing all the opening conditions, Then draw lines on this basis, that is, to draw lines between DOM elements. Here, the svg line drawing method encapsulated by the component Leader-line is used to draw lines between DOM elements. 2.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S11中从专业的培养目标材料中获取该专业开设课程的详细信息,所述详细信息包含有课程的开设学期、课程的归属平台。2. a kind of method for automatically drawing a topological structure diagram of a university course offering relationship according to claim 1, is characterized in that: in described S11, the detailed information of this major offering course is obtained from the specialized training target material, and the described detailed information is obtained. The information includes the opening semester of the course and the platform to which the course belongs. 3.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S11将所有课程信息添加进入“开设课程数据表”中,开设学期在数据表中的存储为数字:1-8分别代表大学的8个学期,课程的归属平台在数据表重点存储为数字:1-4;1代表通识教育平台,2代表专业大类教育平台,3代表专业教育平台,4代表实践课程教育平台。3. a kind of method that automatically draws the topological structure diagram of university course offering relationship according to claim 1, it is characterized in that: described S11 adds all course information into " opening course data table ", and opening semester is in the data table are stored as numbers: 1-8 represent the 8 semesters of the university respectively, and the attribution platform of the course is stored as numbers in the data table: 1-4; 1 represents the general education platform, 2 represents the major education platform, and 3 represents the major Education platform, 4 represents the practical course education platform. 4.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S12将该课程以及该课程的后继课程一一存入“开课关系数据表”中,考虑课程教学大纲的可能未全部编写完成,该方式就获取不到课程开设关系的情况,增设手动管理来增删改查课程开设情况。4. a kind of method that automatically draws university course offering relation topology structure diagram according to claim 1, is characterized in that: described S12 deposits this course and the successor course of this course in " course opening relation data table " one by one , considering that the syllabus of the course may not be fully written, this method cannot obtain the situation of the course offering relationship, and manual management is added to add, delete, modify and check the course offering. 5.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S32中具体实例如下:通识教育平台的8个学期的开设课程数目依次为:4,2,3,1,4,3,2,0,则通识教育平台开设课程最多的一个学期课程数目为4,这8个学期需要添加的补充数组数分别为:0,2,1,3,0,1,2,4。5. a kind of method that automatically draws university course offering relation topology structure diagram according to claim 1, is characterized in that: concrete example is as follows in described S32: the number of courses offered in 8 semesters of general education platform is successively: 4, 2, 3, 1, 4, 3, 2, 0, the maximum number of courses in a semester that the general education platform offers is 4, and the number of supplementary arrays that need to be added in these 8 semesters are: 0, 2, 1 , 3, 0, 1, 2, 4. 6.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S32中补充数组*:只有学期、归属平台等一些基础信息,没有实际意义。6. The method for automatically drawing a topological structure diagram of a university course offering relationship according to claim 1, wherein the supplementary array* in the S32: only has some basic information such as semester, attribution platform, and has no practical significance. 7.根据权利要求1所述的一种自动绘制高校课程开设关系拓扑结构图的方法,其特征在于:所述S4的实例如下:如果一个课程信息数组的归属平台为1,开课学期为1,那么就将它放入到通识教育平台的第一学期表格中。7. a kind of method that automatically draws university courses according to claim 1 opens relation topology structure diagram, it is characterized in that: the example of described S4 is as follows: if the attribution platform of a course information array is 1, and the opening semester is 1, Then put it into the first semester form of the general education platform.
CN202210774478.4A 2022-07-01 2022-07-01 Method for automatically drawing university course establishment relation topology structure diagram Pending CN115130993A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210774478.4A CN115130993A (en) 2022-07-01 2022-07-01 Method for automatically drawing university course establishment relation topology structure diagram

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210774478.4A CN115130993A (en) 2022-07-01 2022-07-01 Method for automatically drawing university course establishment relation topology structure diagram

Publications (1)

Publication Number Publication Date
CN115130993A true CN115130993A (en) 2022-09-30

Family

ID=83381521

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210774478.4A Pending CN115130993A (en) 2022-07-01 2022-07-01 Method for automatically drawing university course establishment relation topology structure diagram

Country Status (1)

Country Link
CN (1) CN115130993A (en)

Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030191765A1 (en) * 2000-08-24 2003-10-09 Bargh Christopher Ian Method of graphically defining a formula
JP2004110217A (en) * 2002-09-17 2004-04-08 Ricoh Co Ltd Graphical user interface, program, and recording medium
US20040157193A1 (en) * 2003-02-10 2004-08-12 Mejias Ulises Ali Computer-aided design and production of an online learning course
TW201205473A (en) * 2010-07-28 2012-02-01 Univ Nat Changhua Education System, method, and computer readable medium for curriculum mapping
CN103473724A (en) * 2013-09-16 2013-12-25 江苏金智教育信息技术有限公司 Intelligent course arrangement method and device
US20140344176A1 (en) * 2013-05-16 2014-11-20 Pearson Education, Inc. Instructional design and development interface
US20150010894A1 (en) * 2013-07-08 2015-01-08 Kahina Morisset System and Method for Authoring and Delivering Online Educational Courses
CN104637009A (en) * 2013-11-12 2015-05-20 北京化工大学 Dynamic curriculum map processing system and method based on curriculum system data
CN105957409A (en) * 2016-04-25 2016-09-21 北京葡萄藤信息技术有限公司 Automatic teaching method and automatic teaching platform based on task allocation
CN105976087A (en) * 2016-04-27 2016-09-28 国家电网公司 New method of analyzing enterprise information system fault influence range based on graphic modeling
CN108596807A (en) * 2018-05-29 2018-09-28 黑龙江省经济管理干部学院 A kind of School of High Profession Technology OBE curriculum development tutoring systems
CN108682211A (en) * 2018-05-29 2018-10-19 黑龙江省经济管理干部学院 A kind of efficient teaching system for facilitating student to learn
CN112612989A (en) * 2020-12-30 2021-04-06 深圳我家云网络科技有限公司 Data display method and device, computer equipment and storage medium
CN112615743A (en) * 2020-12-18 2021-04-06 江苏云柜网络技术有限公司 Topological graph drawing method and device
CN114255146A (en) * 2021-12-23 2022-03-29 山东大学 Custom course system construction method and system

Patent Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030191765A1 (en) * 2000-08-24 2003-10-09 Bargh Christopher Ian Method of graphically defining a formula
JP2004110217A (en) * 2002-09-17 2004-04-08 Ricoh Co Ltd Graphical user interface, program, and recording medium
US20040157193A1 (en) * 2003-02-10 2004-08-12 Mejias Ulises Ali Computer-aided design and production of an online learning course
TW201205473A (en) * 2010-07-28 2012-02-01 Univ Nat Changhua Education System, method, and computer readable medium for curriculum mapping
US20140344176A1 (en) * 2013-05-16 2014-11-20 Pearson Education, Inc. Instructional design and development interface
US20150010894A1 (en) * 2013-07-08 2015-01-08 Kahina Morisset System and Method for Authoring and Delivering Online Educational Courses
CN103473724A (en) * 2013-09-16 2013-12-25 江苏金智教育信息技术有限公司 Intelligent course arrangement method and device
CN104637009A (en) * 2013-11-12 2015-05-20 北京化工大学 Dynamic curriculum map processing system and method based on curriculum system data
CN105957409A (en) * 2016-04-25 2016-09-21 北京葡萄藤信息技术有限公司 Automatic teaching method and automatic teaching platform based on task allocation
CN105976087A (en) * 2016-04-27 2016-09-28 国家电网公司 New method of analyzing enterprise information system fault influence range based on graphic modeling
CN108596807A (en) * 2018-05-29 2018-09-28 黑龙江省经济管理干部学院 A kind of School of High Profession Technology OBE curriculum development tutoring systems
CN108682211A (en) * 2018-05-29 2018-10-19 黑龙江省经济管理干部学院 A kind of efficient teaching system for facilitating student to learn
CN112615743A (en) * 2020-12-18 2021-04-06 江苏云柜网络技术有限公司 Topological graph drawing method and device
CN112612989A (en) * 2020-12-30 2021-04-06 深圳我家云网络科技有限公司 Data display method and device, computer equipment and storage medium
CN114255146A (en) * 2021-12-23 2022-03-29 山东大学 Custom course system construction method and system

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
_IVENJ: ""拓扑排序原理分析及js实现"" *
不忘初心DBSDXQ: ""JS leader-liner 学习及问题总结"" *
妙趣前端: ""拓扑排序"" *
韩子卢: ""安利一个绘制指引线的JS库leader-line"" *

Similar Documents

Publication Publication Date Title
AU6732100A (en) Database system
EP1585036A2 (en) Management of parameterized database queries
CN113220920B (en) Satellite remote sensing image sample labeling system and method based on micro-service architecture
CN105608942A (en) System and method for homework correction
CN107480262A (en) A kind of general management system of database based on webpage
CN109522490A (en) A kind of map visualization method of internet information
CN105447907A (en) Engineering drawing assignment intelligent correcting method and engineering drawing assignment intelligent correcting system based on three-dimensional reconstruction
CN104616073B (en) Precision management method based on digitized two-dimensional cartoon making
WO2023116830A1 (en) Custom course system construction method and system
CN109446506B (en) Automatic reconstruction method and device for electronic form table
CN115130993A (en) Method for automatically drawing university course establishment relation topology structure diagram
CN110275938A (en) Knowledge extraction method and system based on non-structured document
CN110889069A (en) Resource access platform based on web online learning
CN109840269A (en) Data relationship visual management method based on four layer data frameworks
CN108073637A (en) A kind of method for establishing left-eyed flounder economic characters information database
US8595254B2 (en) Roster building interface
CN112487770A (en) Table data management method, storage medium and computer
Xie et al. NTEP‐DB 1.0: A relational database for the national turfgrass evaluation program
CN114741591B (en) Method and electronic device for recommending learning paths to learners
CN110347980A (en) A kind of tree structure automatic generation method, plug-in unit, electronic equipment and computer readable storage medium based on Unity3D
Guo Evaluation of College Teaching Quality Based on Association Data Mining
Yin et al. The Educational Applications of Knowledge Graph in Python Courses
Lönnqvist The research processes of humanities scholars
CN1770137A (en) Language learning system and method
Wang et al. Construction of an Artificial Intelligence Student Management Information System Under Big Data Analysis Algorithms

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20220930