APPLICATION OF DATA AGGREGATION METHODS IN THE INFORMATION SYSTEM OF EDUCATIONAL PROCESS CONTROL

Abstract

Modern information technologies play a significant role in many areas of human activity. One of such areas is education (primary, secondary, higher, profile, etc.), the main criterion for assessing the quality of which is the presence of certain competencies (knowledge, skills and abilities) of students in the learning process. Management of the educational process can be implemented with a certain degree of automation, the use of information systems and control systems (specialized software). The purpose is to develop a software module of the information system of control of the educational process of CRM system with the ability to specify custom templates of aggregation and data display. JSON API specifications and REST API services are used in data aggregation technology to display selected parameters of the educational process. The subject of the study is the analysis of functional features and architectural solutions of software and data aggregation technologies in the information system CRM architecture control of the educational process of higher education. Justification of the choice of architecture and functionality of the software module for aggregation and display of data when creating queries from the SQL database of the information system of educational process management and development of query architecture using JSON API specification and REST API services. To achieve this goal, the following tasks were formulated: eview of functional and architectural features of CRM architecture systems in the control of the educational process; analysis of CRM architecture systems for educational institutions using RPC, SOAP, REST, GraphQL technology; analysis of software and data aggregation technologies in the CRM architecture system for the educational institution; substantiation of technology for data collection, downloading and aggregation in the IS control of the educational process; application of JSON API specification, REST API services in IS of CRM architecture learning process control and query architecture development; choice of graphical interface for displaying aggregate data. Choice of library of graphic visualization and design of graphic interface.The developed software module of control of the selected parameters of educational process by aggregation of data with use of user templates is suitable for integration as a component of already operating CRM systems with open source code. This allows you to create on the basis of CRM architecture services aimed at achieving the main goal and objectives of the educational process of public and private educational institutions. It is possible to obtain analytical information about the quality of teachers' work and the level of competencies of students, which allows you to assess the current state of the educational process and plan possible options for its improvement.