Use of Microsoft Excel for Data Collection and Processing to Predict Students' Performance in EDM.
Saved in:
| Title: | Use of Microsoft Excel for Data Collection and Processing to Predict Students' Performance in EDM. |
|---|---|
| Authors: | Dol, Sunita M.1 sunita_aher@yahoo.com, Jawandhiya, P. M.2 pmjawandhiya@gmail.com, Satav, Pravin R.3 prsatav@gmail.com |
| Source: | Journal of Engineering Education Transformations. 2024 Special Issue, Vol. 37, p22-43. 22p. |
| Subject Terms: | *Electronic data processing, *Computer science, Data mining, Acquisition of data, Evidence gaps, Computer engineering, Electronic spreadsheets |
| Abstract: | Educational Data Mining (EDM) referes to the research designed to classify, analyze, and predict the students' academic performance from the data collected from educational setting. Data collection and data processing are an important task in any research such as EDM. In this research article, data collection and data processing task are explained in detailed to build the model for predicting students' performance and provide the recommendation in Educational Data Mining. In data collection step, we have collected the result ledgers in PDF form related to Four Year Computer Science and Engineering (CSE) course from university. The PDF ledgers for two academic years 2014-15 and 2015-16 of Four Years - First Year, Second Year, Third Year, and Final Year are downloaded from site http://www.sus.ac.in/examination/Online-Result-(Ledger) or https://su.digitaluniversity.ac/Content.aspx?ID=29445 to prepare the dataset to predict students' performance in Educational Data Mining (EDM). In current study, Syllabus structure of Four Year course of Computer Science and Engineering, Credit system pattern, attributes required for preparing dataset, and types of assessment methods such as Types of assessment methods such as Theory + Practical, Theory + Practical + Practical Oral Exam (POE), Practical + POE, Practical + OE, Practical, Term Work, and Theory are explained in detailed. So original data downloaded from university site for two academic years 2014-15 and 2015-16 of Four Years CSE course from Sem-I to Sem-VIII is prepared with the help of Excel and contain approximately 10,616 students data with 544 number of attributes. For data processing, Microsoft Excel is used. Microsoft Excel features such as Text to Column -- Delimited, Text to Column - Fixed width, Filter, and Conditional Formatting -- Highlight Cells Rules -- Text that contains -- are considered for preparation of dataset. Also various functions such as SUM, IF, COUNTIF, MOD and % are employed for processing the data. After data processing step, final dataset for two academic years 2014-15 and 2015-16 from Sem-I to Sem-VIII consists of 6906 students data with 970 number of attributes. In addition to the data collection and processing, research gaps related to the dataset size, etc. are also identified and mentioned the same in this article. These two steps - data collection and processing discussed in detailed in this research article will help the researcher working in EDM to prepare the dataset to build the model so that more work in education sector related to students' performance can be carried out to improve the teaching-learning process. [ABSTRACT FROM AUTHOR] |
| Copyright of Journal of Engineering Education Transformations is the property of Rajarambapu Institute of Technology and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Education Research Complete |
Be the first to leave a comment!
