Information and communication and chemical technologies

Vol. 1 No. 30 (2026) / 2026-03-30 / Number of views: 148

PERSONALIZED SQL TRAINING BASED ON RUBERT DIAGNOSTICS AND IRT-ADAPTIVE TESTING

Authors

Akhmet Baitursynuly Kostanay Regional University
https://orcid.org/0000-0003-4547-6697
L.N. Gumilyov Eurasian National University
https://orcid.org/0009-0009-6191-458X
Akhmet Baitursynuly Kostanay Regional University
https://orcid.org/0000-0003-4147-3843
L.N. Gumilyov Eurasian National University
https://orcid.org/0009-0004-0106-2526

Keywords

digital learning platforms, artificial intelligence, machine learning, learning models, assessment metrics

Link to DOI:

https://doi.org/10.58805/kazutb.v.1.30-1278

How to quote

Zharlykassov, B.Zh., et al. “PERSONALIZED SQL TRAINING BASED ON RUBERT DIAGNOSTICS AND IRT-ADAPTIVE TESTING”. Vestnik KazUTB, vol. 1, no. 30, Mar. 2026, doi:10.58805/kazutb.v.1.30-1278.

Abstract

Digital platforms and environments have become an integral part of educational technologies and the learning process. Learning materials and assignments are designed and provided to students in digital format, which has made significant changes to the process of learning and acquiring knowledge. These changes concern not only digital teaching methods but also knowledge testing.

The paper presents a comprehensive AI-based SQL training support system that combines three key components: a classification of student errors by type based on the RuBERT model, an XGBoost-based recommendation module for selecting revision topics based on error profile and work pace, and adaptive testing using a two-parameter item response theory model (IRT), allowing dynamic adjustment of the complexity of questions to the current assessment of the student's ability. The system is implemented as a web application and tested on data from 120 students majoring in Information Systems, collected during their natural use of the learning application (September 2024 – May 2025): SQL logs, answers to theoretical questions, and timestamps of passing tests.