Automated Data Integration, Cleaning and Analysis for Technical Schools Data Management in Malaysia

Students' performance plays major role in determining the quality of our education system. Sijil Pelajaran Malaysia (SPM) is a public examination compulsory to be taken by Form 5 students in Malaysia. The performance gap is not only a school and classroom issue but also a national issue that must be addressed properly. This study aims to integrate, clean and analysis through automated data mining techniques. Using data mining techniques is one of the processes of transferring raw data from current educational system to meaningful information that can be used to help the school community to make a right decision to achieve much better results. This proved DM provides means to assist both educators and students, and improve the quality of education. The result and findings in the study show that automated system will give the same result compare with manual system of integration and analysis and also could be used by the management to make faster and more efficient decision in order to map or plan efficient teaching approach for students in the future.