CN109035104B - Student information management system and method supporting shift system - Google Patents
Student information management system and method supporting shift system Download PDFInfo
- Publication number
- CN109035104B CN109035104B CN201811266826.7A CN201811266826A CN109035104B CN 109035104 B CN109035104 B CN 109035104B CN 201811266826 A CN201811266826 A CN 201811266826A CN 109035104 B CN109035104 B CN 109035104B
- Authority
- CN
- China
- Prior art keywords
- information
- database
- client
- student
- statistical table
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims description 22
- 238000007726 management method Methods 0.000 claims abstract description 51
- 238000000605 extraction Methods 0.000 claims abstract description 16
- 230000001174 ascending effect Effects 0.000 claims description 8
- 230000008520 organization Effects 0.000 description 15
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000001143 conditioned effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—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 discloses a student information management system supporting a shift system and a student information management method, comprising the following steps: the first database establishing module is used for establishing a first database; the second database establishing module is used for establishing a second database; the query receiving module is used for receiving a query request sent from a client; the first information extraction module is used for accessing the first database according to the query request; the second information extraction module is used for recording the subject information into the current statistical table; the extraction judging module is used for judging whether to acquire subject information corresponding to the last student information in the current statistical table; and if the subject information corresponding to the last student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client. The invention can directly send the generated final statistical table to the client for the user to track and analyze the learning condition of the students at any time point.
Description
Technical Field
The invention relates to the technical field of teaching, in particular to a student information management system supporting a shift system and a student information management method.
Background
The 'working system' refers to a teaching method that a subject classroom is fixed with a teacher, students select self-developed level classes to give lessons according to own capability level and interest wish, the teaching content and the degree requirements of different levels of classes are different, and the difficulties of homework and examination are also different.
In the prior art shift teaching, in the systematic scheme, students are in class, so all behaviors of one student should be reflected under the class, and the class also can run through the learning career of the whole school year of the students. Similarly, in the school year, the relation between the class and the teacher is also fixed, so that part of the problems of the shift system can be solved, but the shift system is not flexible enough, and special scenes such as:
1. student class is not fixed: the student may be in class a for a certain period of time and in class B for a certain period of time, so that the student's learning status obviously cannot be reacted through a certain class;
2. subject class is not fixed: the language of the student is on class A and the mathematics are on class B, so that the language or the mathematics of the student are counted, and obviously the student cannot react through a class;
3. class and discipline relationship is not fixed:
scene 1, partial shift: first (1) class, as an administrative class, the class is only subject to two subjects of Chinese and mathematics;
scene 2, full shift: first (1) class, as an administrative class, but the class is not in any subject, all subjects are on the shift.
Scene 3, mixing class. First (1) class, as administrative class, part of students are on the English subject of this class, and the rest of students are on the English subject of the walking class;
the above scenario cannot simply be conditioned on class when the student performance is counted from class latitude.
Accordingly, it is a need in the art to provide a student information management method that can accommodate complex and frequent changes in student organizational relationships.
Disclosure of Invention
In view of the above, the invention provides a student information management system and a student information management method supporting a shift system, which solve the problems of poor adaptability, low operation flexibility and the like in the current student information management.
In order to solve the technical problems, in one aspect, the present invention provides a student information management system supporting a shift system, including: the system comprises a first database establishing module, a second database establishing module, a query receiving module, a first information extracting module, a second information extracting module and an extracting judging module;
the first database establishing module is used for establishing a first database; the first database takes class information as a basis to group, records the class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
the second database establishing module is used for establishing a second database; the second database records a relationship among the class information, the student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
the query receiving module is used for receiving a query request sent from a client; the query request comprises class information to be queried;
the first information extraction module is used for accessing the first database according to the query request and acquiring all student information in the same group as the class information to be queried; generating a current statistical table according to the query request and all the student information;
the second information extraction module is used for accessing the second database according to the current statistical table, sequentially obtaining the subject information corresponding to each piece of student information in the current statistical table, and recording the subject information into the current statistical table;
the extraction judging module is used for judging whether to acquire the subject information corresponding to the last piece of student information in the current statistical table; if the subject information corresponding to the last piece of student information in the current statistical table is not acquired, continuing to access the second database; and if the subject information corresponding to the last piece of student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client.
Preferably, the management system further comprises a marking module;
the marking module is used for judging whether the starting time and the ending time in each subject information reach effective learning time or not respectively; if the start time and the end time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; and if the starting time and the ending time in the discipline information do not reach the effective learning time, marking the discipline information as a non-ascending annual discipline.
Preferably, the management system further comprises a feedback module;
the feedback module is used for prompting whether the client side continues the query operation or not; receiving selection information sent by the client; judging whether the selection information is to continue to inquire; if the selection information is the continuous query, prompting the client to input the query request; and if the selection information is the query stopping information, returning query ending information to the client.
Preferably, the management system further comprises a third database building module, a login receiving module and a login judging module;
the third database establishing module is used for establishing a third database; the third database records account information of a user, wherein the account information comprises an account and a password of the user;
the login receiving module is used for receiving a login request sent from the client; the login request comprises an account number and a password of the current user;
the login judging module is used for judging whether the account number and the password of the current user are recorded in the third database; if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; and if the account number and the password of the current user are recorded in the third database, prompting the client to input the query request.
Preferably, the management system further comprises a printing module;
the printing module is used for receiving a printing request sent by the client; judging whether the client is connected with a printer or not; if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
On the other hand, the invention also provides a student information management method supporting the shift system, which comprises the following steps:
establishing a first database; the first database takes class information as a basis to group, records the class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
establishing a second database; the second database records a relationship among the class information, the student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
receiving a query request sent from a client; the query request comprises class information to be queried;
accessing the first database according to the query request, and acquiring all student information in the same group as the class information to be queried;
generating a current statistical table according to the query request and all the student information;
accessing the second database according to the current statistical table, sequentially acquiring the subject information corresponding to each piece of student information in the current statistical table, and recording the subject information into the current statistical table;
judging whether to acquire the subject information corresponding to the last student information in the current statistical table;
if the subject information corresponding to the last piece of student information in the current statistical table is not acquired, continuing to access the second database; and if the subject information corresponding to the last piece of student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client.
Preferably, after the step of creating the second database, the method further includes:
judging whether the start time and the end time in each subject information reach effective learning time or not respectively;
if the start time and the end time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; and if the starting time and the ending time in the discipline information do not reach the effective learning time, marking the discipline information as a non-ascending annual discipline.
Preferably, after the step of sending the current statistics table as a final statistics table to the client, the method further includes:
prompting the client whether to continue the query operation;
receiving selection information sent by the client;
judging whether the selection information is to continue to inquire;
if the selection information is the continuous query, prompting the client to input the query request; and if the selection information is the query stopping information, returning query ending information to the client.
Preferably, before the step of receiving the query request sent from the client, the method further includes:
establishing a third database; the third database records account information of a user, wherein the account information comprises an account and a password of the user;
receiving a login request sent from the client; the login request comprises an account number and a password of the current user;
judging whether the account number and the password of the current user are recorded in the third database;
if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; and if the account number and the password of the current user are recorded in the third database, prompting the client to input the query request.
Preferably, after the step of sending the current statistics table as a final statistics table to the client, the method further includes:
receiving a printing request sent by the client;
judging whether the client is connected with a printer or not;
if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
Compared with the prior art, the student information management system and the student information management method supporting the shift system at least realize the following beneficial effects:
(1) According to the student information management system and the student information management method supporting the shift system, the on-demand information of all students in the shift can be inquired through setting the shift names, the shift types and the school years in the shift information;
(2) According to the student information management system and the student information management method supporting the shift system, no necessary connection exists between the administrative shift and the shift, no necessary connection exists between the shift and the discipline, no matter how the organization relation of students changes, the statistics of the relation among students, the shift and the discipline can be carried out on the basis of the student information within a range, and the complex and frequent change situation of the organization relation of the students can be adapted;
(3) The student information management system and the student information management method supporting the shift system are simple and convenient in query information setting and high in operation efficiency, and can directly send the generated final statistical table to the client side for a user to track and analyze the student learning condition at any time point so as to formulate a more reasonable teaching scheme.
Of course, it is not necessary for any one product embodying the invention to achieve all of the above technical effects at the same time.
Other features of the present invention and its advantages will become apparent from the following detailed description of exemplary embodiments of the invention, which proceeds with reference to the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the invention.
Fig. 1 is a schematic structural diagram of a student information management system supporting a shift system according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of another student information management system supporting shift system according to an embodiment of the present invention;
fig. 3 is a schematic flow chart of a student information management method supporting shift system according to an embodiment of the present invention;
fig. 4 is a workflow diagram of a student information management system and a student information management method supporting a shift system according to an embodiment of the present invention.
Detailed Description
Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless it is specifically stated otherwise.
The following description of at least one exemplary embodiment is merely exemplary in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to one of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, the techniques, methods, and apparatus should be considered part of the specification.
In all examples shown and discussed herein, any specific values should be construed as merely illustrative, and not a limitation. Thus, other examples of exemplary embodiments may have different values.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further discussion thereof is necessary in subsequent figures.
Example 1
As shown in fig. 1, the student information management system supporting a shift system in this embodiment includes: the first database establishing module 10, the second database establishing module 20, the query receiving module 30, the first information extracting module 40, the second information extracting module 50 and the extraction judging module 60;
a first database creation module 10 for creating a first database; the first database is used for grouping according to class information, recording class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
a second database creation module 20 for creating a second database; the second database records a relationship among class information, student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
a query receiving module 30, configured to receive a query request sent from a client; the query request comprises class information to be queried;
a first information extraction module 40, configured to access a first database according to a query request, and obtain all student information in the same group as the class information to be queried; generating a current statistical table according to the query request and all student information;
the second information extraction module 50 is configured to access a second database according to the current statistics table, sequentially obtain subject information corresponding to each student information in the current statistics table, and record the subject information into the current statistics table;
an extraction determination module 60, configured to determine whether to acquire subject information corresponding to the last piece of student information in the current statistics table; if the subject information corresponding to the last student information in the current statistical table is not acquired, continuing to access the second database; and if the subject information corresponding to the last student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client.
The current statistical table after the statistics of all student organization relations of the class is completed is the required final statistical table, and the final statistical table is sent to a client side for a user to track and analyze the student learning situation at any time point so as to formulate a more reasonable teaching scheme.
Of course, the management system of the present embodiment may further include a marking module 70, a feedback module 80, a third database establishing module 90, a login receiving module 100, a login determining module 110, and a printing module 120, as shown in fig. 2:
a marking module 70 for judging whether the start time and the end time in each subject information reach the effective learning time, respectively; if the starting time and the ending time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; if the starting time and the ending time in the discipline information do not reach the effective learning time, marking the discipline information as a non-ascending annual discipline;
a feedback module 80, configured to prompt the client whether to continue the query operation; receiving selection information sent by a client; judging whether the selection information is continuous inquiry or not; if the selected information is the continuous query, prompting the client to input a query request; if the selected information is the stopping inquiry, returning inquiry ending information to the client;
a third database creation module 90 for creating a third database; the third database records account information of the user, wherein the account information comprises an account and a password of the user;
a login receiving module 100, configured to receive a login request sent from a client; the login request comprises the account number and the password of the current user;
a login determination module 110, configured to determine whether an account number and a password of a current user are recorded in a third database; if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; if the account number and the password of the current user are recorded in the third database, prompting the client to input a query request;
a print module 120, configured to receive a print request sent by a client; judging whether the client is connected with a printer or not; if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
Therefore, the query operation is more convenient and safer, and the statistical information of the statistical table sent to the client is more visual and clear.
Example 2
As shown in fig. 3, the student information management method supporting the shift system in the present embodiment includes the following steps:
step 301, establishing a first database; the first database is used for grouping according to class information, recording class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
step 302, establishing a second database; the second database records a relationship among class information, student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
step 303, receiving a query request sent from a client; the query request comprises class information to be queried;
step 304, accessing a first database according to the query request, and acquiring all student information in the same group as the class information to be queried;
step 305, generating a current statistical table according to the query request and all student information;
step 306, accessing a second database according to the current statistical table, sequentially acquiring subject information corresponding to each student information in the current statistical table, and recording the subject information into the current statistical table;
step 307, judging whether to acquire subject information corresponding to the last student information in the current statistical table;
step 308, if the subject information corresponding to the last student information in the current statistical table is not obtained, continuing to access the second database; and if the subject information corresponding to the last student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client.
Through the above step 301, the class information and the student information corresponding to the class information are recorded in the first database, and when the subsequent situation of the student of a certain class needs to be queried, the relevant information can be directly obtained from the first database.
Through the above step 302, the relationships among the class information, the student information, and the subject information are recorded in the second database, which is actually a comprehensive database, so that the organization relationship of the students can be conveniently retrieved as required.
It should be noted that, the organization relationship related in the present invention may be an organization relationship between a student and a class, or may be an organization relationship between a class, a student, and a subject, or may be other organization relationships, which is not specifically limited in the present invention, and will not be described in detail later.
Through the steps 303 to 305, a current statistical table may be generated, where all student information corresponding to the class information to be queried is recorded in the statistical table, which is equivalent to an organization relationship table between a class and students, and the status of the class as-read students can be clearly seen. The class information also comprises the school year, so that when the inquiry request is set, all students of the class can read the situation under a certain school year time, only one school year can be set in one inquiry request, and the situation that students of different school years read the situation is mixed into the current statistical table is prevented, and the subsequent analysis of the student learning situation is influenced.
Through the steps 306 to 308, the current statistical table obtained in the step 305 can be continuously updated to the organization relations of the students by accessing the second database, and the current statistical table after statistics of all the organization relations of the students in the class is completed is the required final statistical table, and is sent to the client for the user to track and analyze the learning situation of the students at any time point so as to formulate a more reasonable teaching scheme.
After the step 302, the method may further include:
judging whether the starting time and the ending time in each subject information reach the effective learning time or not respectively;
if the starting time and the ending time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; if the start time and the end time in the discipline information do not reach the effective learning time, the discipline information is marked as a non-ascending discipline.
The final statistics table sent to the client also contains the learning condition of the student for each subject, such as the subject marked as the advanced subject, which indicates that the student has completed the learning time requirement of the subject; for the disciplines marked as non-ascending disciplines, the learning time requirement that the student does not complete the discipline is indicated, and for the reasons of incomplete, remarks can be added according to actual needs.
After the step 308, the method may further include:
prompting the client whether to continue the query operation;
receiving selection information sent by a client;
judging whether the selection information is continuous inquiry or not;
if the selected information is the continuous query, prompting the client to input a query request; and if the selection information is to stop the inquiry, returning inquiry ending information to the client.
The user can perform query operation for many times through the client until the user can continuously and actively select to stop querying, each query result is sent to the client through a final statistical table respectively, and the query result can be divided into a plurality of statistical tables with smaller space and sent to the client under the condition that the space of the statistical table is larger. Of course, an upper limit value of the number of queries per day may also be set to ease the query burden of the system.
Before the step 303, the method may further include:
establishing a third database; the third database records account information of the user, wherein the account information comprises an account and a password of the user;
receiving a login request sent from a client; the login request comprises the account number and the password of the current user;
judging whether the account number and the password of the current user are recorded in a third database or not;
if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; if the account number and the password of the current user are recorded in the third database, prompting the client to input a query request.
Therefore, only the user who logs in the request can enter the system to perform query operation, information in the first database and the second database is prevented from being leaked, and the security of the query operation can be effectively improved. The user information in the third database can be updated periodically according to actual needs so as to increase or decrease the user quantity. For example, after the teacher a leaves the job, the system deletes the account information related to the teacher a in the third database; and when the teacher B joins the teaching work of the school, the system adds the account information of the teacher B in the third database.
The user according to the present invention may be a teacher, a parent, or other person, and the user is only taken as an example of the teacher as long as the user can have login authority.
Based on the setting of the login request, after step 308, the method may further include:
receiving a printing request sent by a client;
judging whether the client is connected with a printer or not;
if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
Only the user who logs in the request can print the final statistics table, thereby being beneficial to further improving the security of the system. And when the client is not connected with the printer correctly, the user is prompted to print failure information, and the user can reset the access information of the printer according to actual conditions.
Example 3
On the basis of embodiment 1 and embodiment 2, as shown in fig. 4, the workflow of the student information management system and management method supporting the shift system in this embodiment includes the following steps:
step 401, a first database is established; the first database is used for grouping according to class information, recording class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers; this step is accomplished by the first database creation module 10.
Step 402, establishing a second database; the second database records a relationship among class information, student information, and discipline information, the discipline information including a discipline name, a start time, and an end time; this step is accomplished by the second database creation module 20.
Step 403, receiving a query request sent from a client; the query request comprises class information to be queried; this step is accomplished by the query receiving module 30.
Step 404, accessing a first database according to the query request, and acquiring all student information in the same group as the class information to be queried;
step 405, generating a current statistical table according to the query request and all student information;
the above steps are completed by the first information extraction module 40.
Step 406, accessing a second database according to the current statistical table, sequentially obtaining subject information corresponding to each student information in the current statistical table, and recording the subject information into the current statistical table; this step is accomplished by the second information extraction module 50.
Step 407, judging whether to acquire subject information corresponding to the last student information in the current statistical table; if the subject information corresponding to the last student information in the current statistics table is not obtained, continuing to step 406;
step 408, if the subject information corresponding to the last student information in the current statistical table is acquired, sending the current statistical table as a final statistical table to the client;
the above steps are completed by the extraction determination module 60. The class information and the student information corresponding to the class information are recorded in the first database, when the subsequent student condition of a certain class needs to be queried, the related information can be directly obtained from the first database, and then the organization relation of the students is called from the second database according to the requirement.
All student information corresponding to class information to be queried is recorded in the current statistical table, which is equivalent to an organization relation table between a class and students, and the on-demand student condition of the class can be clearly seen, so that the learning condition of the students is analyzed.
After the step 402, the method may further include:
step 409, judging whether the start time and the end time in each subject information reach the effective learning time;
step 410, if the start time and the end time in the subject information reach the effective learning time, marking the subject information as an advanced school year subject;
step 411, if the start time and the end time in the subject information do not reach the effective learning time, marking the subject information as a non-ascending year subject;
the above steps are accomplished by the marking module 70. The final statistics table sent to the client also contains the learning condition of the student for each subject.
After the step 408, the method may further include:
step 412, prompting the client whether to continue the query operation;
step 413, receiving selection information sent by the client;
step 414, judging whether the selection information is a continuous query;
step 415, if the selected information is the continuous query, prompting the client to input a query request;
step 416, if the selected information is stopping the query, returning query ending information to the client;
the above steps are accomplished by the feedback module 80. The user can perform query operation for a plurality of times through the client until the user actively selects to stop the query, and the query result is sent to the client in the form of a final statistical table.
Before the step 403, the method may further include:
step 417, establishing a third database; the third database records account information of the user, wherein the account information comprises an account and a password of the user; this step is accomplished by the third database creation module 90.
Step 418, receiving a login request sent from a client; the login request comprises the account number and the password of the current user; this step is accomplished by the login receiving module 100.
Step 419, judging whether the account number and the password of the current user are recorded in a third database;
step 420, if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; if the account number and password of the current user are already recorded in the third database, continuing to step 415;
the above steps are completed by the login determination module 110. Only the user who logs in the request can enter the system to perform query operation, information leakage in the first database and the second database is prevented, and the security of query operation can be effectively improved.
Based on the settings from step 417 to step 420, after step 416, the method may further include:
step 421, receiving a print request sent by a client;
step 422, judging whether the client is connected with a printer;
step 423, if the client is not connected with the printer, returning printing failure information;
step 424, if the client is connected with a printer, performing a printing operation on the final statistics table;
the above steps are completed by the print module 120. So that all final statistics are printed out after the query operation is fully completed. Of course, the above operation may also be performed after step 408, so that the corresponding final statistics are printed after each query operation, which is not particularly limited in this embodiment.
According to the above embodiments, the student information management system and method supporting the shift system provided by the invention have the following beneficial effects:
(1) According to the student information management system and the student information management method supporting the shift system, the on-demand information of all students in the shift can be inquired through setting the shift names, the shift types and the school years in the shift information;
(2) According to the student information management system and the student information management method supporting the shift system, no necessary connection exists between the administrative shift and the shift, no necessary connection exists between the shift and the discipline, no matter how the organization relation of students changes, the statistics of the relation among students, the shift and the discipline can be carried out on the basis of the student information within a range, and the complex and frequent change situation of the organization relation of the students can be adapted;
(3) The student information management system and the student information management method supporting the shift system are simple and convenient in query information setting and high in operation efficiency, and can directly send the generated final statistical table to the client side for a user to track and analyze the student learning condition at any time point so as to formulate a more reasonable teaching scheme.
It will be apparent to those skilled in the art that embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
While certain specific embodiments of the invention have been described in detail by way of example, it will be appreciated by those skilled in the art that the above examples are for illustration only and are not intended to limit the scope of the invention. It will be appreciated by those skilled in the art that modifications may be made to the above embodiments without departing from the scope and spirit of the invention. The scope of the invention is defined by the appended claims.
Claims (8)
1. A student information management system supporting a shift system, comprising: the system comprises a first database establishing module, a second database establishing module, a query receiving module, a first information extracting module, a second information extracting module, an extracting judging module and a marking module;
the first database establishing module is used for establishing a first database; the first database takes class information as a basis to group, records the class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
the second database establishing module is used for establishing a second database; the second database records a relationship among the class information, the student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
the query receiving module is used for receiving a query request sent from a client; the query request comprises class information to be queried;
the first information extraction module is used for accessing the first database according to the query request and acquiring all student information in the same group as the class information to be queried; generating a current statistical table according to the query request and all the student information;
the second information extraction module is used for accessing the second database according to the current statistical table, sequentially obtaining the subject information corresponding to each piece of student information in the current statistical table, and recording the subject information into the current statistical table;
the extraction judging module is used for judging whether to acquire the subject information corresponding to the last piece of student information in the current statistical table; if the subject information corresponding to the last piece of student information in the current statistical table is not acquired, continuing to access the second database; if the subject information corresponding to the last piece of student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client;
the marking module is used for judging whether the starting time and the ending time in each subject information reach effective learning time or not respectively; if the start time and the end time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; and if the starting time and the ending time in the discipline information do not reach the effective learning time, marking the discipline information as a non-ascending annual discipline.
2. The student information management system supporting shift work as defined in claim 1, wherein the management system further comprises a feedback module;
the feedback module is used for prompting whether the client side continues the query operation or not; receiving selection information sent by the client; judging whether the selection information is to continue to inquire; if the selection information is the continuous query, prompting the client to input the query request; and if the selection information is the query stopping information, returning query ending information to the client.
3. The student information management system supporting shift work as defined in claim 1, wherein the management system further comprises a third database creation module, a login receiving module and a login judging module;
the third database establishing module is used for establishing a third database; the third database records account information of a user, wherein the account information comprises an account and a password of the user;
the login receiving module is used for receiving a login request sent from the client; the login request comprises an account number and a password of the current user;
the login judging module is used for judging whether the account number and the password of the current user are recorded in the third database; if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; and if the account number and the password of the current user are recorded in the third database, prompting the client to input the query request.
4. The student information management system supporting shift work as defined in claim 3, wherein the management system further comprises a printing module;
the printing module is used for receiving a printing request sent by the client; judging whether the client is connected with a printer or not; if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
5. The student information management method supporting the shift system is characterized by comprising the following steps:
establishing a first database; the first database takes class information as a basis to group, records the class information and student information corresponding to the class information, wherein the class information comprises class names, class types and school years, and the student information comprises student account numbers, student types and school numbers;
establishing a second database; the second database records a relationship among the class information, the student information, and discipline information, the discipline information including a discipline name, a start time, and an end time;
receiving a query request sent from a client; the query request comprises class information to be queried;
accessing the first database according to the query request, and acquiring all student information in the same group as the class information to be queried;
generating a current statistical table according to the query request and all the student information;
accessing the second database according to the current statistical table, sequentially acquiring the subject information corresponding to each piece of student information in the current statistical table, and recording the subject information into the current statistical table;
judging whether to acquire the subject information corresponding to the last student information in the current statistical table;
if the subject information corresponding to the last piece of student information in the current statistical table is not acquired, continuing to access the second database; if the subject information corresponding to the last piece of student information in the current statistical table is acquired, the current statistical table is used as a final statistical table to be sent to the client; and
after the step of establishing the second database, the method further comprises:
judging whether the start time and the end time in each subject information reach effective learning time or not respectively;
if the start time and the end time in the discipline information reach the effective learning time, marking the discipline information as an advanced discipline; and if the starting time and the ending time in the discipline information do not reach the effective learning time, marking the discipline information as a non-ascending annual discipline.
6. The student information management method supporting shift walking as defined in claim 5, further comprising, after the step of transmitting the current statistical table as a final statistical table to the client:
prompting the client whether to continue the query operation;
receiving selection information sent by the client;
judging whether the selection information is to continue to inquire;
if the selection information is the continuous query, prompting the client to input the query request; and if the selection information is the query stopping information, returning query ending information to the client.
7. The student information management method supporting shift work as defined in claim 5, wherein before the step of receiving the query request from the client, further comprising:
establishing a third database; the third database records account information of a user, wherein the account information comprises an account and a password of the user;
receiving a login request sent from the client; the login request comprises an account number and a password of the current user;
judging whether the account number and the password of the current user are recorded in the third database;
if the account number and the password of the current user are not recorded in the third database, returning login failure information to the client; and if the account number and the password of the current user are recorded in the third database, prompting the client to input the query request.
8. The student information management method supporting shift walking as defined in claim 7, further comprising, after the step of transmitting the current statistical table as a final statistical table to the client:
receiving a printing request sent by the client;
judging whether the client is connected with a printer or not;
if the client is not connected with the printer, returning printing failure information; and if the client is connected with the printer, performing printing operation on the final statistical table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811266826.7A CN109035104B (en) | 2018-10-29 | 2018-10-29 | Student information management system and method supporting shift system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811266826.7A CN109035104B (en) | 2018-10-29 | 2018-10-29 | Student information management system and method supporting shift system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109035104A CN109035104A (en) | 2018-12-18 |
| CN109035104B true CN109035104B (en) | 2023-11-28 |
Family
ID=64614320
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811266826.7A Active CN109035104B (en) | 2018-10-29 | 2018-10-29 | Student information management system and method supporting shift system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109035104B (en) |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103735A (en) * | 2010-12-22 | 2011-06-22 | 山东省电力学校 | Computer automatic management system for teaching load |
| KR20110122267A (en) * | 2010-05-04 | 2011-11-10 | 하정현 | System and method for managing scholastic ability to automatically provide custom-made studying data |
| CN103164822A (en) * | 2012-12-11 | 2013-06-19 | 魏勇 | Open-ended educational management system framework |
| CN103246961A (en) * | 2013-05-23 | 2013-08-14 | 新疆卡尔罗媒体科技有限公司 | School intelligent information management system and method |
| CN104281925A (en) * | 2014-10-16 | 2015-01-14 | 沈阳化工大学 | Student status information management system |
| CN104598582A (en) * | 2015-01-15 | 2015-05-06 | 任中硕 | Whole-course academic tracing analysis system |
| CN105512214A (en) * | 2015-11-28 | 2016-04-20 | 华中师范大学 | Knowledge database, construction method and learning situation diagnosis system |
| CN105551314A (en) * | 2016-01-12 | 2016-05-04 | 四川文轩教育科技有限公司 | Resource classification, screening and integrating method applied in on-line digital teaching |
| CN106485625A (en) * | 2016-10-29 | 2017-03-08 | 合肥桐科电子科技有限公司 | Management of students school roll system based on middle and primary schools' information platform |
| CN107424103A (en) * | 2017-08-01 | 2017-12-01 | 太仓市智联信息科技有限公司 | MIS of Student |
| CN107609782A (en) * | 2017-09-22 | 2018-01-19 | 皇晓琳 | A kind of curricula-variable method towards new middle college entrance examination reform |
| KR20180027147A (en) * | 2016-09-06 | 2018-03-14 | 주식회사 코리아잡스쿨 | Intelligent personalized education management system |
| CN108053098A (en) * | 2017-11-24 | 2018-05-18 | 河南大学 | A kind of school grade analysis method based on big data |
| CN108062734A (en) * | 2017-12-15 | 2018-05-22 | 佛山市晴天视觉数字科技有限公司 | A kind of Student Information Management System |
| CN108230471A (en) * | 2018-03-02 | 2018-06-29 | 深圳市伟业兴科技有限公司 | Based on cloud platform with realize in many ways interaction automatic attendance checking system |
| CN108364246A (en) * | 2018-05-10 | 2018-08-03 | 东华大学 | A kind of Student Information Management System |
| CN108682212A (en) * | 2018-05-29 | 2018-10-19 | 黑龙江省经济管理干部学院 | The learning system that a kind of exploitation design for professorship's activity curriculum is implemented with development |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040009461A1 (en) * | 2000-04-24 | 2004-01-15 | Snyder Jonathan Scott | System for scheduling classes and managing eductional resources |
| WO2003021480A1 (en) * | 2001-09-04 | 2003-03-13 | International Limited | Database management system |
| US20140280328A1 (en) * | 2013-03-15 | 2014-09-18 | Parlant Technology, Inc. | Database Interface to Create Queries for Multiple Databases |
-
2018
- 2018-10-29 CN CN201811266826.7A patent/CN109035104B/en active Active
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20110122267A (en) * | 2010-05-04 | 2011-11-10 | 하정현 | System and method for managing scholastic ability to automatically provide custom-made studying data |
| CN102103735A (en) * | 2010-12-22 | 2011-06-22 | 山东省电力学校 | Computer automatic management system for teaching load |
| CN103164822A (en) * | 2012-12-11 | 2013-06-19 | 魏勇 | Open-ended educational management system framework |
| CN103246961A (en) * | 2013-05-23 | 2013-08-14 | 新疆卡尔罗媒体科技有限公司 | School intelligent information management system and method |
| CN104281925A (en) * | 2014-10-16 | 2015-01-14 | 沈阳化工大学 | Student status information management system |
| CN104598582A (en) * | 2015-01-15 | 2015-05-06 | 任中硕 | Whole-course academic tracing analysis system |
| CN105512214A (en) * | 2015-11-28 | 2016-04-20 | 华中师范大学 | Knowledge database, construction method and learning situation diagnosis system |
| CN105551314A (en) * | 2016-01-12 | 2016-05-04 | 四川文轩教育科技有限公司 | Resource classification, screening and integrating method applied in on-line digital teaching |
| KR20180027147A (en) * | 2016-09-06 | 2018-03-14 | 주식회사 코리아잡스쿨 | Intelligent personalized education management system |
| CN106485625A (en) * | 2016-10-29 | 2017-03-08 | 合肥桐科电子科技有限公司 | Management of students school roll system based on middle and primary schools' information platform |
| CN107424103A (en) * | 2017-08-01 | 2017-12-01 | 太仓市智联信息科技有限公司 | MIS of Student |
| CN107609782A (en) * | 2017-09-22 | 2018-01-19 | 皇晓琳 | A kind of curricula-variable method towards new middle college entrance examination reform |
| CN108053098A (en) * | 2017-11-24 | 2018-05-18 | 河南大学 | A kind of school grade analysis method based on big data |
| CN108062734A (en) * | 2017-12-15 | 2018-05-22 | 佛山市晴天视觉数字科技有限公司 | A kind of Student Information Management System |
| CN108230471A (en) * | 2018-03-02 | 2018-06-29 | 深圳市伟业兴科技有限公司 | Based on cloud platform with realize in many ways interaction automatic attendance checking system |
| CN108364246A (en) * | 2018-05-10 | 2018-08-03 | 东华大学 | A kind of Student Information Management System |
| CN108682212A (en) * | 2018-05-29 | 2018-10-19 | 黑龙江省经济管理干部学院 | The learning system that a kind of exploitation design for professorship's activity curriculum is implemented with development |
Non-Patent Citations (6)
| Title |
|---|
| 学生信息管理系统的设计与实现;石敏力;;科技资讯(第12期);21+23 * |
| 学生成绩查询系统的设计及实现;李君芳;赵艳杰;;电脑知识与技术(学术交流)(第06期);35-37 * |
| 浅析设计类研究生党员的思想政治教育工作;李可佳;科教文汇(上旬刊)(第19期);14+25 * |
| 浅谈任课教师对学生的管理;谭郑春;;科学中国人(第12期);106 * |
| 论学生领导下的班本课程合作开发――以某小学"班级午间项目课程"为例;顾惠芬;李家成;;现代教学(第08期);55-59 * |
| 高校班级与学生管理及评比系统的设计与开发;蔡保飞;许威;;科技致富向导(第11期);36-37 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109035104A (en) | 2018-12-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Li et al. | Language history questionnaire (LHQ 2.0): A new dynamic web-based research tool | |
| O'Brien et al. | The systematic literature review method: Trials and tribulations of electronic database searching at doctoral level | |
| JP2019016355A (en) | Test question supply and test result determination system and test management system | |
| US10497275B2 (en) | Systems and methods for inquiry-based learning including collaborative question generation | |
| CN109948995B (en) | Teaching management system | |
| US20140065593A1 (en) | Automated Assessment and Analysis System | |
| CN104881480A (en) | Database-based annotating method and device | |
| Vergés Bausili | From piloting e‐submission to electronic management of assessment (EMA): Mapping grading journeys | |
| Abdullahi et al. | Assessment of information needs and seeking behaviour of undergraduates in university of Ilorin, Ilorin, Nigeria | |
| CN113034319A (en) | User behavior data processing method and device in teaching management, electronic equipment and storage medium | |
| CN108073603B (en) | Job distribution method and device | |
| KR20140119536A (en) | e-Test and e-learning system | |
| CN111028585A (en) | Post-class learning job publishing method and system | |
| Bloomfield | Evolution of a digital paper exam grading system | |
| CN109035104B (en) | Student information management system and method supporting shift system | |
| CN108665751A (en) | A kind of interactive assessment method and system based on cloud document | |
| Smith III et al. | The idea of qualitative research in medical education | |
| US20080280280A1 (en) | Method of capturing workflow | |
| Ma | A database selection expert system based on reference librarian's database selection strategy: A usability and empirical evaluation | |
| Abdullah et al. | Collaborative digital library of historical resources: Evaluation of first users | |
| Schmucker et al. | Measuring the impact of student diversity on performance with classroom response systems | |
| Riegel et al. | Research designs of subject-matter teaching and learning | |
| US20030177203A1 (en) | Developer tools for web-based education | |
| JP2005221895A (en) | Examination system, examination problem updating program and automatic updating method of examination problem | |
| CN112181988B (en) | Method for arranging seats in multimedia classroom |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |