Institutional Practice for Engineering Students Employability: Automate Offline Employability Tracking Instrument with Data Mining

Abstract

The analysis of graduate employability is substantial to interpret Higher Education Institutions (HEIs) capability to produce career-ready graduates. Therefore, data gathering related to employment and employability to assess the current trends is crucial. However, developing a fast and accurate programming language for analysing enormous data is a challenging task. This paper presents an Automate Offline Employability (AOE) data analysis using a spreadsheet program; it reduces the time consumption in analysing lots of data and increases data analysis accuracy. The system utilises various Excel formulas and functions to execute multitasking algorithms simultaneously. The instrument can sort the data according to various study fields, matching the initial and current data, analysing them based on employability attributes, and generating multiple interpretable graphs. It can also extract the Uniform Resource Locator (URL) of email and WhatsApp of graduate. Additionally, it has a desktop layout to help the user retrieve any information with a single click. All functions provided by the instrument has successfully executed and verified to achieve the design objectives. Using the instrument, the user can only gather 211 data within 12 days. The instrument provides various information such as the percentage of employment status, field of work, salary, and entrepreneurship.