JP2009290525A - Attendance confirmation system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To manage attendance/absence of students in accordance with a method that does not incur congestion within the period of validity of an authentication code, and to also reduce burdens on users (students). <P>SOLUTION: An attendance confirmation system includes: a course registration database 10 including an attendance/absence table for each course registration subject of a student with a mail address as a key, an authentication code database 11 including course registration subjects, an authentication code for each course registration subject and validity of the code, and a mail server 14. When a student is notified of an authentication code in a classroom, the student enters the authentication code in a subject of mail of a cellular phone 19 and transmits it to the mail server. The mail server collates the authentication code of the received mail, the period of validity of the code and the mail address with the database. If collated, attendance is registered and mail is redirected. As a result, a load is distributed by inputting attendance/absence by Web, and attendance/absence can be managed without congestion. Furthermore, it is also enough for a student to enter an authentication code and to transmit mail, thereby also reducing the burden on the student. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an attendance confirmation system capable of accurately and efficiently managing attendance of students who have relied on human resources using information technology based on IT.

  As a method of managing student attendance using information technology, for example, there is an attendance status management method as shown in Patent Document 1.

  In this management method, as shown in FIG. 10, the presence management server 1 and the keyword presentation device 2 are connected to a network 3 such as the Internet. For example, the keyword presentation device 2 installed in a classroom or the like is connected to the keyword presentation device 2 via the network. Keyword information is supplied from the presence management server 1 and presented. On the other hand, a student attending a course in the classroom looks at the presented keyword and accesses the homepage of the attendance management server 1 with his / her mobile phone (hereinafter, mobile phone) 4, for example, FIG. , (B) is displayed, and the previous keyword information and identification information such as a telephone number are input.

  In the attendance management server 1 to which the information is input, attendance management information, subject time, classroom, and calendar are extracted from the database using the input information as a key, and keyword display designation time and end time are extracted from the extracted attendance management information. Calculate whether the input is performed within the calculated effective time. At this time, if the input is made within a valid time, the course information and teacher / student information are extracted from the database using the input information as a key, and the subjects whose attendance is confirmed in the data It is determined whether or not there is a student of the telephone number supplied from the mobile phone 4 in the course information. If there is a student in this determination, check again whether the keywords match, update the attendance number or absence days of the course information, and read and read the course attendance status confirmation data of the course information from the database The student code corresponding to the student identification information (for example, telephone number) is written in the confirmer column of the course attendance status confirmation data.

By doing this, if the student participating in the course inputs the correct keyword information from the mobile phone 4 within the effective time, the student code of the student is the confirmer of the attendance column of the course information or the course attendance status confirmation data Registered in the column. In other words, by using the presence status management system of the present invention, attendance management can be performed by accurately and easily confirming the presence status.
JP 2002-290561 A

  However, in the above attendance status management system, keyword information must be input within the effective time. Therefore, there is a problem that access to the presence management server is concentrated in a short time. In particular, when there are a large number of students who need to attend, it is conceivable that access will be concentrated and congestion will occur. For this reason, it takes time to input, and it may be possible to lose lecture time. In addition, in order to alleviate this congestion state, it is necessary to increase the communication capacity as well as the capacity of the server. However, it is wasteful to increase in preparation for traffic that does not know when it occurs depending on the number of students.

  On the other hand, on the user (student) side, identification information such as a keyword and a telephone number must be entered on the input screen after access.

  Therefore, an object of the present invention is to make it possible to manage attendance in a way that does not cause congestion within the validity period of the keyword (authentication code), and to reduce the burden on the user (student). It is.

  In order to solve the above-mentioned problems, in the present invention, a student database having a student ID number with a mail address as a primary key, a student course with the student ID number, and a table of attendance data for each student course, and each student course and each student course An attendance management database consisting of an authentication code database with an authentication code database and a data table of the validity period of the code and a mail server are provided, and the authentication code notified in the classroom from the terminal to the mail server is described in the subject or text When the sent mail is sent, the mail server receives the sent mail, acquires the transmission time of the received mail and the authentication code of the subject or body, and registers it in the authentication code database of the acquired authentication code and attendance management database. If the authentication code matches If you can verify the subject from the ID code and check if it is within the valid period from the previously obtained transmission time, search the course database for the presence of the received email address, and if there is an applicable address Read the course and attendance data. If the read courses match, record the attendance in the attendance data of the matched course and send back an attendance reception email. On the other hand, compare the authentication codes and the validity period. In case of discrepancy, or when the subject is collated or when the e-mail address is searched, an error e-mail is returned when the corresponding address cannot be searched.

  By adopting such a configuration, an attendance procedure can be performed if an email in which an authentication code is entered is transmitted within the validity period of the code. Therefore, traffic can be made much smaller than when the server is directly accessed and input, so attendance can be managed in a manner that does not cause congestion. Therefore, it is not necessary to increase the server and the communication capacity in order to cope with a non-constant number of students. At that time, since the address of the mail server has only to be registered in the address book, the authentication code only needs to be entered once in the mail, and the user (student) does not have to do anything.

  At this time, when the authentication code is written in the local part of the address of the mail server and transmitted, the mail server can receive and acquire the authentication code from the transmission time and the transmission address of the received mail.

  By adopting such a configuration, the attendance procedure can be performed if the authentication code is written in the local part of the address of the mail server, so that it can be less time-consuming than writing it in the mail text.

  Also, at this time, a configuration is adopted in which a Web server is provided and the authentication code and the validity period of each code in the above authentication code database are set via the terminal from the Web and then notified to the student. can do.

  By adopting such a configuration, the authentication code and the validity period of the code can be set on the Web as long as there is an Internet connection environment, so it can also be set directly from the classroom according to the situation. .

  At this time, an authentication code database access ID and password manager data table is provided, and after authentication is performed using the access ID and password set in the data table, the authentication code and usage time are registered from the Web. A configuration in which settings are made can be adopted.

  By adopting such a configuration, security can be improved.

  In addition, at this time, code generation means for randomly generating alphanumeric characters used for the authentication code is provided, and the code generation means is configured to automatically generate and input the code when setting the authentication code from the web. A configuration can be employed.

  By adopting such a configuration, code setting can be made easier, so the burden on the administrator (teacher) can be reduced and the efficiency of attendance confirmation can be improved.

  Since the present invention is configured as described above, the load on the network is small, the cost of devices such as servers can be reduced, and attendance procedures can be simplified.

  The best mode for carrying out the present invention will be described below with reference to the drawings.

  As shown in FIG. 1, this form of attendance confirmation system comprises an attendance management database 13 comprising a course database 10, an authentication code database 11, and an administrator database 12, a mail server 14, and a web server 15. In the present embodiment, code generation means 16 is provided. The attendance management database 13, the mail server 14, and the web server 15 are connected to the Internet 18 through the firewall 17, and the student's mobile phone 19 and the administrator (faculty / staff) terminal via the Internet 18. (Mobile, personal computer) 20 can be accessed.

  The course database 10 includes a data table of course requirements such as a student ID number, name, course subject, attendance, and the like, and each data table is structured in a relational manner by normalizing an email address as a main key.

  The authentication code database 11 is constructed, for example, in a relational relationship between a course subject, an authentication code for each course subject, and a data table of the validity period of the code.

  The manager database 12 is a data table of IDs and passwords of managers such as faculty members who manage attendance using this system.

  The mail server 14 has a unique domain for attendance confirmation.

  Here, the Web server 15 is provided, for example, so that the database can be updated from the network, and even an administrator such as a teacher without knowledge of the database can easily perform it from a setting screen as described later using a browser. It is what I did.

  For example, the code generation means 16 generates a different code for each time as shown in FIG. 2, for example, a random alphanumeric character by the Monte Carlo method or the like. Here, 2 digits) are used.

  The firewall 17 is provided to prevent entry into the database 13 from the outside, and is intended to improve security.

  This form is configured as described above, and for the operation of this system, a course database is constructed by inputting data for identifying a student and course data of the student. For example, enter the name, mobile phone number, courses, etc. for each student.

  Further, the ID and password of the teacher who is the user are registered in the manager database 12.

  On the other hand, the student is informed of the address of the mail server in advance and registered in the address book of the mobile phone 19.

  In operation, it is necessary to register the authentication code and the validity period of the code in the authentication code database 11. Since this data can be registered from the Web server 15, it is performed immediately before confirming attendance.

  Specifically, in a place where attendance is taken, such as a classroom, a faculty member who is an administrator accesses the Web server 15 and inputs the screens shown in FIGS. 3A to 3D displayed on the display of the administrator's mobile phone 20. Thus, for example, the processing of the flowchart of FIG. 4 can be executed and registered.

  That is, when the Web server 15 is accessed, the process of FIG. 4 starts (process 100: “process” is omitted hereinafter), and the login screen 21a of FIG. Therefore, enter the teacher ID and password on the display screen and press the login button. Then, the manager database 12 is searched (110), and if the ID and password are registered, access (operation) to the authentication code database 11 in the attendance management database 13 becomes valid (120), The setting screen 21b of FIG. 3B is displayed. On the displayed setting screen 21b, a pull-down menu is prepared so that the setting can be easily made even on a screen with a small setting of a course subject. Also, if you select a course from the menu (130) and press the “Code issuance button” on the screen, an authentication code is automatically generated (140), and a registration screen 21c is displayed as shown in FIG. Therefore, if a valid period is selected from the pull-down menu (150) and the “start attendance confirmation” button is pressed, a start screen 21d is displayed as shown in FIG. Accordingly, if the student is informed of the authentication code and the valid time, the attendance confirmation system is activated and the administrator's operation is completed. In addition, an update button and a manual stop button are displayed on the start screen 21d so that the authentication code and the validity period can be reset and the system can be manually stopped (160 to 170).

  Thus, since the menu is selected and only notification is made by pressing a button, the burden on the attendance management of the manager can be reduced. Therefore, the efficiency of other tasks (classes) can be improved.

  On the other hand, when the student is notified of the authentication code in the classroom, the student activates the mail function of the mobile phone 19, and the authentication code is sent to the subject of the mail or the text (subject in FIG. 5A) as shown in FIG. Is entered, the address of the mail server 14 is entered in the address field, and transmission is made as shown in FIG. 5B, a mail notifying acceptance is returned as shown in FIG. 5C.

  That is, as shown in the flowchart of FIG. 6, when the process is started (200) and the mail server 14 receives the mail (210), the authentication code of the authentication code database 11 of the attendance management database 13 is read (220), Confirm that the code and the subject of the received email or the code described in the text exist (230), if there is, check against the subject (240), and if the subject can be verified, it will be sent within the valid time (250). This confirmation can be easily made by using, for example, a mail time stamp. If it is within the valid period that can be used for attendance confirmation, the course database 10 is accessed (260), the mail address is verified (270), and if there is an address, the student is identified and the database is identified. Register the student ID number and attendance of the subject in 10 (280). Then, an attendance registration completion mail is transmitted (290). If the authentication code is not described in the process 230 mail, or if the time is not valid in process 250, or if the mail address does not exist in process 270, an error mail is transmitted (235, 255, 275). Exit.

  Thus, by using mail, attendance processing can be performed without responding in real time (batch processing). Therefore, since the load can be distributed and processed as compared with the case where the web server 15 directly inputs attendance, attendance can be managed by a method that does not cause congestion. In addition, the burden on users (students) can be reduced.

  Next, authentication code generation processing will be described. For example, as shown in the flowchart of FIG. 7, this generation process searches for a valid code from the authentication code database 11 when issuing an authentication code (300), and randomly generates a code other than the searched authentication code. Adopt the code. In this way, an authentication code that does not overlap with a valid authentication code is created (320). The created authentication code is rechecked (330), and if there is no problem, it is registered in the authentication code database 11 (340), and a valid time is registered (see screen 21d in FIG. 3D). When the registration is completed, it is detected whether the manual stop button is pressed (370) or the validity period has passed (380). If the manual stop button is pressed, the authentication code stop process is performed (375). . If the valid time has elapsed, the authentication code is stopped (390). Note that the process 360 and the process 400 surrounded by the alternate long and short dash line are enabled in the case of Example 1 described later.

  In the first embodiment, as shown in FIG. 8A, the authentication code is written in the local part of the mail address. In this case, the mail account in which the authentication code is written in the local part of the mail address is sent to the mail. This is realized by registering in the server 14.

  Therefore, since the address of the authentication code is used, processing 530 is performed as shown in FIG. 9 instead of processing 230 in FIG. Further, in the authentication code generation process, as described above, the process 360 shown by the broken line in FIG. 7 is provided to issue the mail account, and the process 400 is provided to stop the mail account and manually Either the stop button is pressed (370) or the effective time has elapsed (380). Except for this part, the description is omitted because it has already been described with reference to FIG.

  Also, FIGS. 8B and 8C are the same display as FIGS. 5B and 5C and have the same functions and effects, and thus description thereof is omitted. Similarly, the processes 200 to 300 (excluding 230) in FIG. 6 are the same as the processes 500 to 600 (excluding 530) in FIG.

  In this embodiment, the network 18 is connected to the Internet 18. However, the present invention is not limited to this, and the network 18 may use a private LAN or a mobile phone network. In the embodiment and the example 1, an example in which a mobile phone is used as a terminal has been described. However, the terminal is not limited to a mobile phone, and is connected to a network 18 such as a personal computer, a PDA, or a smartphone. Any device capable of transmitting and receiving can be used.

Block diagram of the embodiment Authorization code table (A) (b) (c) (d) Administrator's mobile display screen Flow chart of embodiment Student mobile phone display screen Flow chart of embodiment Flow chart of embodiment Display screen of student's mobile phone in Example 1 Flow chart of the first embodiment Block diagram of conventional example (A), (b) Conventional display screen

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Course database 11 Authentication code database 12 Manager's database 13 Attendance management database 14 Mail server 15 Web server 16 Code generation means 18 Internet 19 Mobile 20 Mobile

Claims (5)

A student database with the student's student ID number using the email address as the primary key, a table of attendance data for each student's courses and courses, and a data table of the authentication codes for each course and course and the validity period of those codes An attendance management database consisting of an authentication code database with
Set up a mail server,
When the terminal sends an email with an authentication code notified in the classroom from the terminal to the mail server, the mail server receives the sent mail, and the received mail is sent and the subject or text authentication. If you get a code, compare the acquired authentication code with the authentication code registered in the authentication code database of the attendance management database, and match, the corresponding subject is verified from the matched authentication code, and if you can verify, send the previously acquired After checking whether the e-mail is within the validity period from the time, search the course database for the presence of the received e-mail address, and if there is a corresponding address, read the course and attendance data and if the read course matches, Record attendance in the attendance data of the matched courses, reply the attendance email, Attendance confirmation that returns an error e-mail when there is a discrepancy when comparing the certification code or the validity period, or when the corresponding address cannot be searched when checking the course or when searching for the e-mail address system.   When the authentication code is sent in the local part of the mail server address, the mail server receives it, acquires the authentication code from the transmission time and the transmission address of the received mail, and acquires the acquired authentication code and the attendance management database. If the authentication code registered in the authentication code database is compared and matched, the corresponding subject is verified from the matched authentication code, and if it can be verified, it is confirmed after confirming whether it is within the validity period from the transmission time acquired earlier Search the course database for the received e-mail address, and if there is a corresponding address, read the course and attendance data. If the read course matches, record the attendance in the attendance data of the matched course, When an attendance e-mail is replied, on the other hand, when the authentication code is compared or the validity period is compared, there is a mismatch Alternatively attendance check system of claim 1 corresponding address in the credit toward who searched for and mail addresses when the verification when it can not search, which returns an error message.   3. The information processing apparatus according to claim 1, wherein a Web server is provided, and an authentication code for each course subject to the authentication code database and a validity period of the code are set via a terminal from the Web, and then notified to a student. Attendance confirmation system.   A data table for an administrator of ID and password for access to the above authentication code database is provided, and after authentication is performed with the access ID and password set in the data table, the authentication code and usage time are set from the Web. The attendance confirmation system according to claim 3, which is performed.   The code generating means for randomly generating alphanumeric characters used for the authentication code, wherein the code generating means automatically generates and inputs the code when setting the authentication code from the Web. 4. Attendance confirmation system according to 4.

Images