Learning Analytics Solution for Monitoring and Analyzing the Students’ Behavior in SQL Lab Work

Abdelkader Ouared, Moussa Amrani, Pierre-Yves Schobbens

2023

Abstract

Computer-assisted learning is widely discussed in the literature to aid the comprehension of SQL queries (Structured Query Language) in higher education. However, it is difficult for educators/instructors to track, monitor and analyze students’ learning situation due to the higher education massification, and institutions with large classes. Consequently, we need to provide for educators a learning dashboard to monitor and analyze the digital traces issued from students during the practice learning in SQL course. We propose a system called LSQL (Learning Analytics for SQL) that is a solution based on the learning analytics’ methodology. To this end, we propose (i) learning environment dedicated to help students understand the syntax and logic of SQL and getting data issued from these students during online SQL lab work, (ii) trace model which is designed to more effectively represent and capture the complex interactions/actions carried by a student during practice learning activities in virtual/remote laboratories, and (iii) learning analytics dashboard for educators to visualize the statistics and metrics that represent the students’ behavior, and control the students progress in SQL skills to enhance the teaching activities. Tool support is fully available.

Paper Citation

in Harvard Style

Ouared A., Amrani M. and Schobbens P. (2023). Learning Analytics Solution for Monitoring and Analyzing the Students’ Behavior in SQL Lab Work. In Proceedings of the 15th International Conference on Computer Supported Education - Volume 2: CSEDU, ISBN 978-989-758-641-5, SciTePress, pages 184-195. DOI: 10.5220/0011848200003470

in Bibtex Style

@conference{csedu23,
author={Abdelkader Ouared and Moussa Amrani and Pierre-Yves Schobbens},
title={Learning Analytics Solution for Monitoring and Analyzing the Students’ Behavior in SQL Lab Work},
booktitle={Proceedings of the 15th International Conference on Computer Supported Education - Volume 2: CSEDU,},
year={2023},
pages={184-195},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0011848200003470},
isbn={978-989-758-641-5},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 15th International Conference on Computer Supported Education - Volume 2: CSEDU,
TI - Learning Analytics Solution for Monitoring and Analyzing the Students’ Behavior in SQL Lab Work
SN - 978-989-758-641-5
AU - Ouared A.
AU - Amrani M.
AU - Schobbens P.
PY - 2023
SP - 184
EP - 195
DO - 10.5220/0011848200003470
PB - SciTePress