Проектування і програмна реалізація автоматизованої системи відвідуваності та аналізу даних в закладах освіти

Abstract

The work is devoted to the research of the optimal method of monitoring the attendance of educational institutions by students, both teachers and parents: the design and implementation of an automated system that allows to simplify this process, to develop the neces-sary reports, including notifying parents with information about the attendance of their children; creating modules for analyzing the received information using mathematical modeling methods and the Python programming language and libraries for data processing. The principle of operation of the system is that the information about the student who came to the educational institution is read by a scanner and sent to the local computer, where it is stored. On the same computer, the stored information is analyzed and the necessary reports are generated. Another approach to system development also uses a cloud server. Problems and shortcomings arising from various possibilities of organizing an automated system are analyzed. To save information on the computer to which the scanner is connected, approaches based on the use of the Python language are considered, which allows easy transfer of data to various databases, including Access and MySQL, and another where the scanned information is immediately stored in the Access database, which is located on the computer to which the scanner is connected. Database structures for storing and processing information have been developed and implemented. The system generates various reports with the necessary information, which can be the basis for making certain decisions: for example, a report for the dining hall on the number of students by class, on the total number of children in the school, the total number of people present and absent in absolute and relative terms, etc. The modern Telegram messenger was used to send messages. To implement the idea, Bot Father and the function of this platform were used, which allows you to create automatic robots to perform mailing tasks to its users. The bot logic is controlled using HTTPS requests to the bot system API. With the help of SQL queries, the necessary information is extracted, which is transferred to the developed software module for analysis on a separate group of students or on the institution as a whole. Regression analysis methods are used in software mode using Python tools. The work on the creation and implementation of an automated intellectual system was carried out on the order of a sec-ondary education institution.