Using of Data Mining Techniques to Predict of Student’s Performance in Industrial Institute of Al-Diwaniyah, Iraq

Authors

  • Y.K. Salal South Ural State University
  • S. M. Abdullaev South Ural State University

DOI:

https://doi.org/10.14529/ctcr190111

Keywords:

individual learning, data mining techniques, SQL server business intelligence development studio, clustering, classification, association rules, anomaly detection

Abstract

The aim of paper is to show the benefits of the educational data mining (EDM) techniques, in order to understand about of the factors which lead to technical student’s success and failure, and predict their performance and determine the individual learning ability in engineering sciences. For these goals, we use the individual data of 311 student and their grades that were collected in Industrial Institute of Al-Diwaniyah city (Iraq) during 2015–2017 academic years, in order to predict the results of final theoretical exam in industrial drawing by applying EDM techniques, such as association rules mining, classification with decision tree algorithm learning, clustering with Apriori algorithm and anomaly detection implemented as the output model of the clustering. Using Microsoft SQL Server Business Intelligence Development Studio 2012 platform and based on Cross Industry Standard Process for Data Mining, we prepare of 13 nominal and numerical attributes for each student and consequently apply and finally evaluate all 4 EDM techniques. We conclude that: 1) association rules were revealed that the most important factor which contribute to the failure of the student is the “project” attribute; 2) decision tree classification permit to the teacher predict the future students and to correct the student's prediction path, but 3) clustering collects of the students into successful and failure groups and helps to the teacher to guide each group separately, and 4) to detect anomaly by аn extension DMX for SQL and correct the education process for students located on the border of the cluster.

Author Biographies

Y.K. Salal, South Ural State University

аспирант кафедры системного программирования

S. M. Abdullaev, South Ural State University

д-р геогр. наук, профессор кафедры системного программирования

References

Han J., Kamber M., Pei J. Data Mining Concepts and Techniques. Morgan Kaufman. Third Edition, USA, 2011. 744 p.

Romero C., Ventura S., Pechenizkiy P., Baker M.R. Hand Book of Educational Data Mining. CRC Press, USA, 2010. 535 p.

Fernandes E. et al. Educational Data Mining: Predictive Analysis of Academic Performance of Public School Students in the Capital of Brazil. Journal of Business Research, Elsevier Inc., 2019, vol. 94, no. 1, pp. 335–343. DOI: 10.1016/j.jbusres.2018.02.012

Abdullaev S.M., Lenskaya O.Yu., Salal Y.K. [Computer System of Individual Education: Features of the Student Model]. University of the XXI Century in the System of Continuous Education. Proceedings of the IV International Scientific Practical Conference. Chelyabinsk, SUSU Publishing Center, 2018, pp. 7–13. (in Russ.)

Matsebula F., Mnrandla E. A Big Data Architecture for Learning Analytics in Higher Education. AFRICON, IEEE Trans., 2017, pp. 951–956. DOI: 10.1109/AFRCON.2017.8095610

Zimek S. Outlier detection. In: Encyclopedia of Database Systems. Springer, New York, NY, 2017, pp. 1–5.

Brown M.S. What IT Needs To Know About The Data Mining Process. Published by Forbes. Available at: https://www.forbes.com/sites/metabrown/2015/07/29/what-it-needs-to-know-about-thedata-mining-process/#9c974cc515.

Mariscal G., Marbán Ó., Fernández C. A Survey of Data mining and Knowledge Discovery Process Models and Methodologies. The Knowledge Engineering Review, 2010, vol. 25, no. 2. pp. 137–166. DOI: 10.1017/S0269888910000032

Hou Z. Data Mining Method and Empirical Research for Extension Architecture Design. International Conference on Intelligent Transportation, Big Data & Smart City (ICITBS). IEEE Trans., 2018, pp. 275–278. DOI: 10.1109/ICITBS.2018.00077

Introducing Business Intelligence Development Studio. Available at: https://msdn.microsoft.com/it-it/library/ms173767 (v=sql.105).aspx.

MacLennan J., Tang Z., Crivat B. Data Mining with SQL Server 2008. Wiley Publ., Indianapolis, Indiana, US. 2008. 672 p.

Noughabi Z.E.A. et al. Predicting Students' Behavioral Patterns in University Networks for Efficient Bandwidth Allocation: A Hybrid Data Mining Method (Application Paper). 17th Int. Conf. on Information Reuse and Integration (IRI). IEEE Trans., 2016, pp. 102–109. DOI: 10.1109/IRI.2016.21

Zhang W., Qin S. A Brief Analysis of the Key Technologies and Applications of Educational Data Mining on Online Learning Platform. IEEE 3rd International Conference on Big Data Analysis (ICBDA). IEEE Trans., 2018, pp. 83–86. DOI: 10.1109/ICBDA.2018.8367655

Agrawal S., Agrawal J. Survey on Anomaly Detection Using Data Mining Techniques. Procedia Computer Science, 2015, vol. 60, pp. 708–713. DOI: 10.1016/j.procs.2015.08.220

Abdullaev S.M., Lenskaya O.Yu., Salal Ya.K. Computer Systems of Individual Instruction: Background and Perspectives. Bulletin of the South Ural State University. Ser. Education. Educational Sciences, 2018, vol. 10, no. 4, pp. 64–71. (in Russ.) DOI: 10.14529/ped180408

Downloads

Published

2019-02-21

Issue

Section

Short messages