Logical model of the automated system statistical rating assessment of quality students’ performance
Mathematical support and software for computers, complexes and networks
1. Moscow Aviation Institute (National Research University), 4, Volokolamskoe shosse, Moscow, А-80, GSP-3, 125993, Russia
The article discusses the logical model of the automated system of statistical rating assessment of the quality of students’ performance. University educational process model, which is automated by authors’ software, has been described. System architecture is presented. Information system is based on 1C:Enterprise technical platform.
Authors have developed a formula that defines student rating by session. Then researchers have identified the limitations of the 1C:Enterprise platform standard capabilities for accelerating calculation of student rating by session, which are defined by this fomula. The article mentions the features of implementation of 1C:Enterprise technologies in information system development. After this, authors have suggested their own ways of accelerating report generation through the use of new aggregates. System data storages have been presented as ER diagrams.
The old and the new structures of queries that calculate student rating by session have been presented by schemes. The practicability of the described approach has been proven by computational experiment. Researchers have compared the time required to execute the old and the new queries. The testing has been based on information about performance of real students from the Faculty of Applied Mathematics and Physics of the Moscow Aviation Institute. There are 5934 records in testing tables. Computational experiment results have been measured twice. At first, the queries have been executed without cache influence. Secondly, the queries have been executed with cache influence. Without cache influence, it took 7.25 times less time to execute the new query using aggregate suggested by authors in comparison with the old query. With cache influence, the new query using aggregate suggested by authors has been executed 3.77 times faster than the old query.
Results of this research can be used in automated rating system or information system for educational process automation that are based on 1C:Enterprise technical platform.
Keywords:information system, database architecture, aggregates, rating system
Gur’yanova S. Yu. Kachestvo. Innovatsii. Obrazovanie, 2013, no. 1. pp. 3-14.
Gress E. S., Krylov S. S. Kachestvo. Innovatsii. Obrazovanie, 2014, no. 4, pp.14-19.
Federal’nye Gosudarstvennye Obrazovatel’nye Standarty, available at: http://минобрнауки.рф/documents/336 (available at: 01.03.2012).
Bosov A. V., Gress E. S., Krylov S. S. Materialy X Mezhdunarodnoi konferentsii po neravnovesnym protsessam v soplakh i struyakh (NPNJ’2014), Alushta, Crimea, 2014, pp. 582-583.
Gress E. S., Krylov S. S, Naumov A. V. Materialy XVIII Mezhdunarodnoi konferentsii po vychislitel’noi mekhanike i sovremennym prikladnym programmnym sistemam (VMSPPS’ 2013), Alushta, Crym, 2013, pp. 838-840.
1S:Predriyatie 8: Tekhnologicheskaya platforma, available at: http://v8.1c.ru/overview/Platform.htm (accessed 25.12.2015)
Gabets A. P., Kozyrev D. V., Kukhlevskii D. S., Khrustaleva E.Yu. Realizatsiya prikladnykh zadach v sisteme «1S:Predpriyatie 8.2» (The realization of applied tasks in the system «1C:Enterprise 8.2»), Moscow, LLC «1C Publishing», 2010, 714 p.
Bosov A. V., Gress E. S., Naumov A. V. Sistemy i sredstva informatiki, 2015, vol. 25, no. 2, pp. 123-139.
Gress E. S., Krylov S. S. Sbornik nauchnykh trudov 15-i mezhdunarodnoi nauchno-prakticheskoi konferentsii «Novye informatsionnye tekhnologii v obrazovanii» (Primenenie tekhnologii «1C» dlya formirovaniya innovatsionnoi sredy obrazovaniya i biznesa). Chast’ 1, Moscow, 2015, pp. 396-399.
Radchenko M. G., Khrustaleva E. Yu. Arkhitektura i rabota s dannymi «1S:Predpriyatie 8.2» (Architecture and work with data «1C:Enterprise 8.2»), Moscow, LLS «1C Publishing», 2011, 268 p.