CN110874375A - Course arrangement method, device, equipment, medium and system based on two-dimensional plane - Google Patents
Course arrangement method, device, equipment, medium and system based on two-dimensional plane Download PDFInfo
- Publication number
- CN110874375A CN110874375A CN201911105479.4A CN201911105479A CN110874375A CN 110874375 A CN110874375 A CN 110874375A CN 201911105479 A CN201911105479 A CN 201911105479A CN 110874375 A CN110874375 A CN 110874375A
- Authority
- CN
- China
- Prior art keywords
- teacher
- student
- time state
- module
- blank
- 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.)
- Withdrawn
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Abstract
The invention belongs to the technical field of computers, and particularly relates to a course arrangement method, device, equipment, medium and system based on a two-dimensional plane. The course arrangement method mainly comprises the steps of receiving request data of a user side, wherein the request data comprises student information, subject information, grade information, course number M and a time period of courses to be arranged; calling a teacher time state table; calling a student time state table of the student from a preset database by using student information; intercepting the called teacher time state table and the student time state table by using a time period, and intercepting a teacher time state part table and a student time state part table in the time period; merging the teacher time state part table and the student time state part table; generating a teacher class schedule and a student class schedule; and returning the generated teacher class schedule and student class schedule to the user side. The invention can avoid conflict between the course arrangement and students or teachers and can display course arrangement results visually.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to a course arrangement method, device, equipment, medium and system based on a two-dimensional plane.
Background
The students can gradually go online from offline, and the traditional education purely manual course arrangement can not meet the requirement of online large amount of course arrangement
At present, the mainstream course arrangement in the market has two modes:
one is excel table format course arrangement, the abscissa is date, the ordinate is time, and the data in the table are any lesson teacher and any lesson course. Excel form arrangement lessons have the advantage of intuition, and student class lists can be directly sent to students and teachers for confirmation and archiving after being generated.
The other mode is a course arrangement system with conflict detection, wherein the idle time of a teacher, the teaching capacity and the course arrangement time of students are all recorded into the system in advance. And then the user selects a teacher, a student and time to carry out course arrangement, the conflict detection in time is carried out in each course arrangement, and if the conflict exists, the teacher is replaced, or the time is changed.
In the excel table type course arrangement, the abscissa is the date, the ordinate is the time, the table is marked as a lessee-giving teacher, and after the course tables are arranged, the class-giving time and teacher information of students are clear at a glance, however, the rest time of the teacher in the course of course arrangement is the rest time of the teacher, the course tables of other students of the teacher must be familiar with the teacher, or the teacher is free by remembering or reviewing the other course tables of the teacher, and the time of each course arrangement is determined, and the teacher is free, and the students are also free. Subsequent changes can be cumbersome to debug, requiring the student to be renewed and the teacher to communicate new session hours if found before class. If the student finds that the time is wasted on the day of class, the user experience is not good.
There is the classrooms system of arranging that the conflict detected, teacher's idle time, teaching ability, student's the system of all typing in of class arrangement time, then the user selects mr, student, and the time is arranged the class, arranges the class at every turn and carries out the conflict detection in the time, if there is the conflict then change the teacher, perhaps the time. Compared with the excel table format course arrangement mode, the mode is improved a lot, and the course arrangement error rate is low. However, since the conflict detection is performed every time of course arrangement, the course arrangement personnel is also required to be familiar with the idle time, the course arrangement condition, the teaching ability and the like of the teacher. Otherwise, most of the time of one lesson arrangement is wasted on the time of retry.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a course arrangement strategy based on a two-dimensional plane, which can intuitively arrange courses without conflict, in view of the above-mentioned deficiencies in the prior art.
The invention discloses a course arrangement method based on a two-dimensional plane in a first aspect, which comprises the following steps,
step one, receiving request data of a user side, wherein the request data comprises student information, subject information, grade information, class number M and a time period of courses to be scheduled;
step two, screening teacher time state tables meeting the conditions in a preset database by using subject information and grade information, and entering step ten if the number of the screened teacher time state tables is 0; if the number of the screened teacher time state tables is more than or equal to 1, entering a third step;
the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods every day, the cells of the content part of the teacher time state table are blank to indicate that the teacher is free, and the cells are not blank to indicate that the teacher is occupied;
step three, calling a teacher time state table;
step four, counting the number of blank cells in the time period in the time state table of the taken out teacher by using the time period, entering step seven if the counted number N is larger than or equal to M, and entering step five if the counted number N is smaller than M;
step five, calling a next teacher time state table and entering step four; if no next teacher time state table exists, entering the step ten;
step six, calling a student time state table of the student from a preset database by utilizing the student information; the abscissa of the student time state table is date, the ordinate is a plurality of daily learning time periods, the blank cell of the content part of the student time state table indicates that the student is idle, and the non-blank cell indicates that the student is occupied;
a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table one by one, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
step seven, intercepting the called teacher time state table and the student time state table by using the time period, and intercepting a teacher time state part table and a student time state part table in the time period;
step eight, combining the teacher time state part table and the student time state part table; taking cells in the student time state part table and the teacher time state part table with the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
step nine, adding course information into blank cells in the table after the step eight is completed, and generating a teacher's course table and a student's course table; returning the generated teacher class schedule and student class schedule to the user side;
step ten, returning the course arrangement failure to the user side.
The course arrangement method based on the two-dimensional plane further comprises the eleventh step of respectively updating the content information of the teacher's class schedule and the student's class schedule in the ninth step into the corresponding cell of the called teacher's time state table and the corresponding cell of the student's time state table, and returning the updated teacher's time state table and the updated student's time state table to the preset database.
The invention discloses a course arrangement device based on a two-dimensional plane, which comprises a data receiving module, a screening module, a first calling module, a counting module, a second calling module, a table intercepting module, a table merging module, a course table generating module, a course table output module and a failure returning module, wherein the screening module is used for screening the course data;
the data receiving module is used for receiving request data of a user side, wherein the request data comprises student information, subject information, grade information, class number M and a time period of a course to be scheduled;
the screening module is used for screening a teacher time state table meeting the conditions in a preset database by using the subject information and the grade information; the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods of each day, the cells of the content part of the teacher time state table are blank, the teacher is free, and the cells are not blank, so that the teacher is occupied;
the first calling module is used for calling the teacher time state table which is screened by the screening module and meets the conditions one by one;
the counting module is used for counting the number of blank cells in the time period in the time state table of the taken teacher by utilizing the time period;
the second calling module is used for calling the student time state table of the student from the preset database by utilizing the student information; the abscissa of the student time state table is date, the ordinate is a plurality of daily learning time periods, the blank cell of the content part of the student time state table represents that the student is idle, and the non-blank cell represents that the student is occupied; a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table one by one, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
the table intercepting module is used for intercepting the called teacher time state table and the student time state table by utilizing the time period and intercepting a teacher time state part table and a student time state part table in the time period;
the table merging module is used for merging the teacher time state part table and the student time state part table; taking cells in a student time state part table and cells in a teacher time state part table which have the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
the school timetable generating module is used for sending the tables merged by the table merging module to the user side and receiving the tables sent by the user side and obtained after adding course information to the merged tables; and generating a teacher class schedule and a student class schedule;
the school timetable output module is used for returning the teacher school timetable and the student school timetable generated by the school timetable generation module to the client;
the failure returning module is used for returning the course arrangement failure to the user side when the number of the teacher time state tables screened by the screening module is 0; and the first calling module is also used for returning the course arrangement failure to the user side when the first calling module does not call the teacher time state table.
The course arrangement device based on the two-dimensional plane further comprises an updating module and a form returning module;
the updating module is used for updating the content information of the teacher timetable into the corresponding cell of the called teacher timetable and updating the content information of the student timetable into the corresponding cell of the called student timetable;
and the form returning module is used for returning the updated teacher time state form and the updated student time state form to the preset database.
The third aspect of the invention discloses a device, which comprises a processor and a memory, wherein the processor is in communication connection with the memory; the processor is configured to read a program in the memory to execute the method provided by the foregoing first aspect or any implementation manner of the first aspect.
A fourth aspect of the present invention discloses a non-volatile storage medium, in which a program is stored, and when the program is executed by a computing device, the program causes the computing device to execute the method provided by the first aspect or any implementation manner of the first aspect.
The fifth aspect of the present invention discloses a course arrangement system based on a two-dimensional plane, comprising: a user terminal, a database of presets, and a computing device comprising the apparatus of claim 3 or 4.
Compared with the prior art, the invention has the following advantages: the invention screens out the specific time capable of arranging courses by combining the teacher time state table and the student time state table, thereby avoiding the conflict of the arranged courses to students or teachers and visually displaying the course arrangement result.
The technical solution of the present invention is further described in detail by the accompanying drawings and embodiments.
Drawings
Fig. 1 is a schematic diagram of a course arrangement system based on a two-dimensional plane according to an embodiment of the present invention.
Fig. 2 is a flowchart of a course arrangement method based on a two-dimensional plane according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a course arrangement device based on a two-dimensional plane according to an embodiment of the present invention.
Detailed Description
As shown in fig. 1, an embodiment of the present invention discloses a course arrangement system based on a two-dimensional plane, comprising: a user terminal 100, a preset database 200 and a computing device 300.
The user end 100 is used for generating a class schedule by a user through a course scheduling system. The user end 100 may be a WEB page end, software installed on a PC, or APP or applet on a mobile terminal such as a mobile phone.
When a class schedule is generated by using the course scheduling system, the computing device 300 receives request data sent by the user terminal 100, wherein the request data comprises student information, subject information, grade information, class number M and time period of a course to be scheduled;
the computing device 300 utilizes the subject information and the grade information to screen a teacher time state table meeting the conditions in the preset database 200, wherein the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods of each day, a cell of the content part of the teacher time state table is blank to indicate that the teacher is idle, and a cell is not blank to indicate that the teacher is occupied;
for a clearer explanation of the present invention, a teacher time status table is given here as an example, as follows:
TABLE 1
The computing device 300 uses the student information to retrieve the student time status table of the student from the preset database 200; the abscissa of the student time state table is a date, the ordinate is a plurality of daily learning time periods, a blank cell of the content part of the student time state table indicates that the student is idle, and a non-blank cell indicates that the student is occupied;
a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table one by one, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
for a clearer explanation of the present invention, a student time status table is given here as an example, as follows:
TABLE 2
If the number of the screened teacher time status tables is 0, the computing device 300 returns a course arrangement failure to the user terminal 100, which indicates that there is no eligible teacher, for example, the subject information and the grade information are four grades and drawing respectively, and if the number of the screened teacher time status tables is 0, the computing device 300 indicates that there is no teacher time status table of the four-grade drawing teacher in the preset database 200.
If the number of the screened teacher time state tables is larger than or equal to 1, the computing equipment 300 calls a teacher time state table; counting the number of blank cells in the time period in the taken teacher time state table by using the time period, if the counted number N is less than M, it is indicated that the time that the teacher can be scheduled for courses corresponding to the time state table cannot meet the requirement of completing the course number, at this time, taking the next teacher time state table, if the teacher time state table is not taken, returning the course arrangement failure to the user terminal 100, if the counted number N is more than or equal to M, the computing device 300 intercepts both the taken teacher time state table and the taken student time state table by using the time period, and intercepts the teacher time state part table and the student time state part table in the time period; for example, assuming that the time period is 2019.11.05-2019.11.08, the called time status table is shown in table 1 above, and the called student time status table is shown in table 2 above, the truncated time status part table and student time status part table are shown in tables 3 and 4 below.
TABLE 3
TABLE 4
in the actual combination process, the contents in the student time state part table can be combined into the teacher time state part table to form a combined table, and the contents in the teacher time state part table can also be combined into the student time state part table to form a combined table.
Here, the above tables 3 and 4 are combined to obtain the following table 5,
TABLE 5
The computing device 300 sends the merged table to the user end 100, and the user end 100 can add the course information to the blank cells in the merged table.
Before sending the merged table to the user side 100, the non-blank cells in the merged table may be locked, so that after the merged table is sent to the user side 100, the non-blank cells in the table cannot be deleted and written.
Here an exemplary presentation of a lesson schedule obtained after adding a physical lesson,
TABLE 6
The user terminal 100 transmits the table to which the course information is added to the computing device 300 after the course information is added, and the computing device 300 extracts information in the table to which the course information is added, generates a teacher's course table and a student's course table, here illustratively given the generated teacher's course table and student's course table,
TABLE 7
TABLE 8
The computing device 300 returns the generated teacher schedule and student schedule to the user terminal 100; updating the content information of the teacher timetable into the corresponding cell of the called teacher timetable, and updating the content information of the student timetable into the corresponding cell of the called student timetable; the updated teacher time status table and student time status table are returned to the preset database 200.
In another embodiment of the present invention, as shown in fig. 1, the computing device 300 may further comprise a two-dimensional plane-based course arrangement apparatus, which includes a data receiving module 301, a screening module 302, a first retrieving module 303, a counting module 304, a second retrieving module 305, a table intercepting module 306, a table merging module 307, a table generating module 308, a table output module 309, and a failure returning module 310.
The data receiving module 301 is configured to receive request data of the user side 100; the screening module 302 is configured to screen a teacher time status table meeting the condition in the preset database 200 by using the subject information and the grade information; the first invoking module 303 is configured to invoke the teacher time status table meeting the conditions and screened by the screening module 302 one by one; the counting module 304 is configured to count the number of blank cells in the time period in the exchanged teacher time state table by using the time period; the second retrieving module 305 is configured to retrieve the student time status table of the student from the preset database 200 by using the student information; the table intercepting module 306 is configured to intercept both the called teacher time state table and the called student time state table by using a time period, and intercept a teacher time state part table and a student time state part table in the time period; the table merging module 307 is configured to merge the teacher time status part table and the student time status part table; the school timetable generating module 308 is configured to send the tables merged by the table merging module 307 to the user terminal 100, and receive the tables obtained after adding the course information to the merged tables sent by the user terminal 100; generating a teacher class schedule and a student class schedule; the class schedule output module 309 is configured to return the teacher class schedule and the student class schedule generated by the class schedule generation module 308 to the user side 100; the failure returning module 310 is configured to return a course arrangement failure to the user end 100 when the number of the teacher time status table screened by the screening module 302 is 0; and is also used for returning the course arrangement failure to the user terminal 100 when the first calling module 303 does not call the teacher time status table.
The two-dimensional plane-based course arrangement device further comprises an updating module 311 and a table returning module 312; the updating module 311 is configured to update the content information of the teacher timetable to the corresponding cell of the called teacher time status table, and update the content information of the student timetable to the corresponding cell of the called student time status table;
and a form returning module 312, configured to return the updated teacher time status form and the updated student time status form to the preset database 200.
In this embodiment, the computing device 300 may be various apparatuses, devices and machines for processing data, such as a programmable processor, a computer, a workstation or a server, and so on. Each unit module included in the present invention may be hardware or a dedicated logic circuit, such as an FPGA or an ASIC, and may also be code, software, logic, or routine for implementing the corresponding function.
As shown in fig. 2, another embodiment of the present invention further discloses a course arrangement method based on two-dimensional plane, comprising the following steps,
step one, receiving request data of a user terminal 100, wherein the request data comprises student information, subject information, grade information, class number M and a time period of a course to be scheduled; for example, one request for data is two students, physical, three grades, four classes, 2019.11.05-2019.11.08.
Step two, screening a teacher time state table meeting the conditions in a preset database 200 by using subject information and grade information, and entering step ten if the number of the screened teacher time state tables is 0; if the number of the screened teacher time state tables is more than or equal to 1, entering a third step;
referring to table 1 in the above embodiment, the abscissa of the teacher time status table is the date, the ordinate is a plurality of working time periods of each day, the blank cell of the content part of the teacher time status table indicates that the teacher is free, and the non-blank cell indicates that the teacher is occupied;
step three, calling a teacher time state table;
step four, counting the number of blank cells in the time period in the time state table of the taken out teacher by using the time period, entering step seven if the counted number N is larger than or equal to M, and entering step five if the counted number N is smaller than M;
step five, calling a next teacher time state table and entering step four; if no next teacher time state table exists, entering the step ten;
step six, calling a student time state table of the student from the preset database 200 by utilizing the student information; the abscissa of the student time state table is date, the ordinate is a plurality of daily learning time periods, the blank cell of the content part of the student time state table indicates that the student is idle, and the non-blank cell indicates that the student is occupied;
referring to table 2 in the above embodiment, a plurality of learning time periods of each day in the student time status table correspond to a plurality of work time periods of each day in the teacher time status table one by one, and the starting point and the ending point of the corresponding learning time period and work time period are the same;
step seven, intercepting the called teacher time state table and the student time state table by using the time period, and intercepting a teacher time state part table and a student time state part table in the time period; as shown in tables 3 and 4 in the above examples;
step eight, combining the teacher time state part table and the student time state part table; taking cells in the student time state part table and the teacher time state part table with the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
the combined table refers to table 5 in the above embodiment.
Step nine, adding course information into blank cells in the table after the step eight is completed, referring to the table 6 in the embodiment by the added table, generating a teacher course table and a student course table, and referring to the table 7 and the table 8 in the embodiment; returning the generated teacher's lesson schedule and student's lesson schedule to the user terminal 100;
step ten, returning the course arrangement failure to the user terminal 100;
eleventh, respectively updating the content information of the teacher timetable and the student timetable in the ninth step into the cells corresponding to the called teacher timetable and the cells corresponding to the student timetable, and returning the updated teacher timetable and student timetable to the preset database 200.
It should be noted that, by recording the teacher time status table and the student time status table into the preset database 200 in advance, the teacher time status table and the student time status table meeting the conditions are directly called for merging when in actual use, the merging process can be implemented by only reading and writing the content in one table into the other table, and the merging of tables is the prior art and is not described in detail herein. Through the combination of the two tables, the blank cells can be clearly and prominently displayed, so that the problem of course arrangement conflict can be avoided when course information is added to the blank cells in the follow-up process.
As shown in fig. 3, another embodiment of the present invention further discloses a two-dimensional plane-based course arrangement device, which includes a data receiving module 301, a screening module 302, a first retrieving module 303, a statistics module 304, a second retrieving module 305, a table intercepting module 306, a table merging module 307, a table generating module 308, a table output module 309, and a failure returning module 310;
a data receiving module 301, configured to receive request data of a user end 100, where the request data includes student information, subject information, class number M, and a time period of a course to be scheduled;
a screening module 302, configured to screen a teacher time status table meeting the condition in the preset database 200 by using the subject information and the grade information; the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods every day, the cells of the content part of the teacher time state table are blank to indicate that the teacher is free, and the cells are not blank to indicate that the teacher is occupied;
the first calling module 303 is configured to call the teacher time status table meeting the conditions, which is screened by the screening module 302, one by one;
the counting module 304 is configured to count the number of blank cells in the time period in the exchanged teacher time state table by using the time period;
a second retrieving module 305, configured to retrieve the student time status table of the student from the preset database 200 by using the student information; the abscissa of the student time state table is date, the ordinate is a plurality of learning time periods of each day, the blank cell of the content part of the student time state table indicates that the student is idle, and the non-blank cell indicates that the student is occupied; a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table in a one-to-one mode, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
the table intercepting module 306 is configured to intercept both the called teacher time state table and the student time state table by using a time period, and intercept a teacher time state part table and a student time state part table in the time period;
a table merging module 307 for merging the teacher time status part table and the student time status part table; taking cells in the student time state part table and the teacher time state part table with the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
a lesson sheet generation module 308, configured to send the sheets merged by the sheet merging module 307 to the user terminal 100, and receive the sheets obtained after adding the course information to the merged sheets sent by the user terminal 100; generating a teacher class schedule and a student class schedule;
a class schedule output module 309, configured to return the teacher class schedule and the student class schedule generated by the class schedule generation module 308 to the user side 100;
a failure returning module 310, configured to return a course arrangement failure to the user terminal 100 when the number of the teacher time status table screened by the screening module 302 is 0; and is also used for returning the course arrangement failure to the user terminal 100 when the first invoking module 303 does not invoke the teacher time status table.
The course arrangement device based on the two-dimensional plane in this embodiment further includes an update module 311 and a table return module 312;
the updating module 311 is configured to update the content information of the teacher timetable to the corresponding cell of the called teacher time status table, and update the content information of the student timetable to the corresponding cell of the called student time status table;
and a form returning module 312, configured to return the updated teacher time status form and the updated student time status form to the preset database 200.
The invention also discloses equipment, which comprises a processor and a memory, wherein the processor is in communication connection with the memory; the processor is used for reading the program in the memory to execute the course arrangement method based on the two-dimensional plane in fig. 2.
Another embodiment of the present invention also discloses a non-volatile storage medium, wherein the non-volatile storage medium stores a program, and when the program is executed by the computing device 300, the program causes the computing device 300 to execute the method for course arrangement based on two-dimensional plane as described in fig. 2.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and all simple modifications, changes and equivalent structural changes made to the above embodiment according to the technical spirit of the present invention still fall within the protection scope of the technical solution of the present invention.
Claims (7)
1. The course arrangement method based on the two-dimensional plane is characterized by comprising the following steps,
step one, receiving request data of a user side, wherein the request data comprises student information, subject information, grade information, class number M and a time period of a course to be scheduled;
step two, screening a teacher time state table meeting the conditions in a preset database by using the subject information and the grade information, and entering step ten if the number of the screened teacher time state tables is 0; if the number of the screened teacher time state tables is more than or equal to 1, entering a third step;
the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods every day, the cells of the content part of the teacher time state table are blank to indicate that the teacher is free, and the cells are not blank to indicate that the teacher is occupied;
step three, calling a teacher time state table;
step four, counting the number of blank cells in the time period in the time state table of the taken out teacher by using the time period, entering step seven if the counted number N is larger than or equal to M, and entering step five if the counted number N is smaller than M;
step five, calling a next teacher time state table and entering step four; if no next teacher time state table exists, entering the step ten;
step six, calling a student time state table of the student from a preset database by utilizing the student information; the abscissa of the student time state table is date, the ordinate is a plurality of daily learning time periods, the blank cell of the content part of the student time state table indicates that the student is idle, and the non-blank cell indicates that the student is occupied;
a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table one by one, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
step seven, intercepting the called teacher time state table and the student time state table by using the time period, and intercepting a teacher time state part table and a student time state part table in the time period;
step eight, combining the teacher time state part table and the student time state part table; taking cells in a student time state part table and cells in a teacher time state part table which have the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
step nine, adding course information into blank cells in the table after the step eight is completed, and generating a teacher course table and a student course table; returning the generated teacher class schedule and student class schedule to the user side;
step ten, returning the course arrangement failure to the user side.
2. The course arrangement method based on two-dimensional plane as claimed in claim 1, further comprising a step eleven of updating the contents information of the teacher's course table and the student's course table in the step nine to the cells corresponding to the called teacher's time status table and the cells corresponding to the student's time status table, respectively, and returning the updated teacher's time status table and student's time status table to the preset database.
3. The course arrangement device based on the two-dimensional plane is characterized by comprising a data receiving module, a screening module, a first calling module, a counting module, a second calling module, a form intercepting module, a form merging module, a course table generating module, a course table output module and a failure returning module;
the data receiving module is used for receiving request data of a user side, wherein the request data comprises student information, subject information, grade information, class number M and a time period of a course to be scheduled;
the screening module is used for screening a teacher time state table meeting the conditions in a preset database by using the subject information and the grade information; the abscissa of the teacher time state table is date, the ordinate is a plurality of working time periods every day, the cells of the content part of the teacher time state table are blank to indicate that the teacher is free, and the cells are not blank to indicate that the teacher is occupied;
the first calling module is used for calling the teacher time state table which is screened by the screening module and meets the conditions one by one;
the counting module is used for counting the number of blank cells in the time period in the time state table of the taken teacher by utilizing the time period;
the second calling module is used for calling the student time state table of the student from the preset database by utilizing the student information; the abscissa of the student time state table is date, the ordinate is a plurality of daily learning time periods, the blank cell of the content part of the student time state table indicates that the student is idle, and the non-blank cell indicates that the student is occupied; a plurality of daily learning time periods in the student time state table correspond to a plurality of daily working time periods in the teacher time state table one by one, and the starting points and the ending points of the corresponding learning time periods and the working time periods are the same;
the table intercepting module is used for intercepting the called teacher time state table and the student time state table by utilizing the time period and intercepting a teacher time state part table and a student time state part table in the time period;
the table merging module is used for merging the teacher time state part table and the student time state part table; taking cells in a student time state part table and cells in a teacher time state part table which have the same abscissa and ordinate, wherein if both the cells are non-blank, the cell in the combined table is non-blank, if one of the two cells is non-blank, the cell in the combined table is non-blank, and if both the cells are blank, the cell in the combined table is blank;
the school timetable generating module is used for sending the tables merged by the table merging module to the user side and receiving the tables sent by the user side and obtained after adding course information to the merged tables; generating a teacher class schedule and a student class schedule;
the school timetable output module is used for returning the teacher school timetable and the student school timetable generated by the school timetable generation module to the user side;
the failure returning module is used for returning the course arrangement failure to the user side when the number of the teacher time state tables screened by the screening module is 0; and the first calling module is also used for returning the course arrangement failure to the user side when the first calling module does not call the teacher time state table.
4. The two-dimensional plane-based course scheduling apparatus according to claim 1, further comprising an updating module and a table returning module;
the updating module is used for updating the content information of the teacher timetable into the corresponding cell of the called teacher timetable and updating the content information of the student timetable into the corresponding cell of the called student timetable;
and the form returning module is used for returning the updated teacher time state form and the updated student time state form to the preset database.
5. An apparatus comprising a processor, a memory, the processor establishing a communication connection with the memory; the processor for reading a program in the memory to perform the method as claimed in claim 1 or 2.
6. A non-volatile storage medium, in which a program is stored which, when executed by a computing device, causes the computing device to carry out the method as claimed in claim 1 or 2.
7. A course arrangement system based on a two-dimensional plane is characterized by comprising: a user terminal, a preset database and a computing device comprising an apparatus as claimed in claim 3 or 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911105479.4A CN110874375A (en) | 2019-11-12 | 2019-11-12 | Course arrangement method, device, equipment, medium and system based on two-dimensional plane |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911105479.4A CN110874375A (en) | 2019-11-12 | 2019-11-12 | Course arrangement method, device, equipment, medium and system based on two-dimensional plane |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110874375A true CN110874375A (en) | 2020-03-10 |
Family
ID=69717968
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911105479.4A Withdrawn CN110874375A (en) | 2019-11-12 | 2019-11-12 | Course arrangement method, device, equipment, medium and system based on two-dimensional plane |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110874375A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113507505A (en) * | 2021-06-22 | 2021-10-15 | 北京爱论答科技有限公司 | Intelligent online teaching training method and system |
| CN114663075A (en) * | 2022-05-25 | 2022-06-24 | 正方软件股份有限公司 | Time conflict detection method and device, storage medium and electronic equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1667018A2 (en) * | 2004-10-14 | 2006-06-07 | Sap Ag | Using customized data to control transaction processing in a computer application |
| CN105976156A (en) * | 2016-04-25 | 2016-09-28 | 北京高思博乐教育科技有限公司 | Course arrangement method |
| CN106204378A (en) * | 2016-07-26 | 2016-12-07 | 天闻数媒科技（湖南）有限公司 | The processing method of a kind of lesson data arrangement and system |
| CN109583609A (en) * | 2018-11-02 | 2019-04-05 | 广州睿致教育咨询有限公司 | A kind of course reserving method for Online Video teaching |
| CN109657821A (en) * | 2018-11-02 | 2019-04-19 | 广州睿致教育咨询有限公司 | A kind of course reservation system of Online Video tutoring system |
| CN109978733A (en) * | 2018-12-28 | 2019-07-05 | 福建云脉教育科技股份有限公司 | A kind of processing method and system of autonomous curricula-variable row class |
-
2019
- 2019-11-12 CN CN201911105479.4A patent/CN110874375A/en not_active Withdrawn
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1667018A2 (en) * | 2004-10-14 | 2006-06-07 | Sap Ag | Using customized data to control transaction processing in a computer application |
| CN105976156A (en) * | 2016-04-25 | 2016-09-28 | 北京高思博乐教育科技有限公司 | Course arrangement method |
| CN106204378A (en) * | 2016-07-26 | 2016-12-07 | 天闻数媒科技（湖南）有限公司 | The processing method of a kind of lesson data arrangement and system |
| CN109583609A (en) * | 2018-11-02 | 2019-04-05 | 广州睿致教育咨询有限公司 | A kind of course reserving method for Online Video teaching |
| CN109657821A (en) * | 2018-11-02 | 2019-04-19 | 广州睿致教育咨询有限公司 | A kind of course reservation system of Online Video tutoring system |
| CN109978733A (en) * | 2018-12-28 | 2019-07-05 | 福建云脉教育科技股份有限公司 | A kind of processing method and system of autonomous curricula-variable row class |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113507505A (en) * | 2021-06-22 | 2021-10-15 | 北京爱论答科技有限公司 | Intelligent online teaching training method and system |
| CN113507505B (en) * | 2021-06-22 | 2022-04-15 | 北京爱论答科技有限公司 | Intelligent online teaching training method and system |
| CN114663075A (en) * | 2022-05-25 | 2022-06-24 | 正方软件股份有限公司 | Time conflict detection method and device, storage medium and electronic equipment |
| CN114663075B (en) * | 2022-05-25 | 2022-09-06 | 正方软件股份有限公司 | Time conflict detection method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Chen | Mobile technology in educational services | |
| CN102881191B (en) | Independent lesson preparation and interactive teaching system supporting intelligent terminal equipment | |
| US20080241809A1 (en) | Graphical user interface and method for providing a learning system | |
| US20170046966A1 (en) | Connected Learning Management System | |
| KR20000048616A (en) | Automated Testing and Electroic Instructional Delivery and Student Management System | |
| CN102945625B (en) | Method for implementing paperless safety teaching | |
| Visscher et al. | Evaluation of the implementation, use and effects of a computerised management information system in English secondary schools | |
| CN110874375A (en) | Course arrangement method, device, equipment, medium and system based on two-dimensional plane | |
| CN111415541A (en) | Operation recitation processing method, system and storage medium | |
| US20110136092A1 (en) | Educational systems, methods and apparatus | |
| CN104282089A (en) | Campus intelligent information terminal system and using method thereof | |
| CN113268190B (en) | Information interaction method, system, device, electronic equipment and storage medium | |
| Merrick et al. | Student Success in a Standards-Based System: Moving Beyond Social Promotion and Retention. A Position Paper of the Association of California School Administrators. | |
| CN112634099A (en) | Practice management method, device and equipment based on big data and readable storage medium | |
| CN106652610A (en) | Multimedia teaching auxiliary system based on computer software | |
| García et al. | Learning analytics sources: Beyond learning platforms | |
| Latha | Development and Validation of Video Lesson Package for Flipped Mastery Classroom in Computer Science Teaching for Higher Secondary School Students | |
| US20180122251A1 (en) | Systems, methods and techniques for e-education on an interactive information platform | |
| CN203311524U (en) | Campus intelligent information terminal system | |
| Hailes et al. | Universities, dearing, and the future | |
| CN105825731A (en) | Interactive English learning system and interactive English learning method | |
| TW201830353A (en) | Projection briefing file export system for question bank suitable for use in an electronic teaching environment | |
| JP5666874B2 (en) | Information management system, information management method, information management program and recording medium for faculty and staff | |
| Gayke et al. | Data Analytics and Visualization Using Microsoft Power BI | |
| Watjen | General purpose software for the counselor. |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200310 |