Manuscript Title:

NEW OPTIMIZATION/AUTOMATION MODELS FOR HEI MANAGERIAL WORK: GRADING, REGISTERING ATTENDANCE, EXAMINATION SCHEDULING, ARCHIVING, AND TIMETABLING

Author:

ALBERT ALIPAN TAYONG, Dr. GULLIVER MAXI ROMA

DOI Number:

DOI:10.17605/OSF.IO/2XDUY

Published : 2023-07-10

About the author(s)

1. ALBERT ALIPAN TAYONG - Faculty of Information Technology, Majan University College, Muscat, Oman.
2. Dr. GULLIVER MAXI ROMA - University of Baguio, Philippines.

Full Text : PDF

Abstract

The purpose of the present study is to introduce novel optimization and/or automation models for Higher Education Institution (HEI) managers in certain academic processes like grade entry, registering online class attendance, identifying examination schedule clashes, setting-up a central filing system (data archiving), and developing timetable techniques. The study used advanced MS Excel functions and various techniques such as conditional formatting, inserting pivot tables (matrices) and charts, removing duplicates, and filters. Moreover, the study also used MS Teams, Google Sheets, and simulations to introduce novel techniques for other processes. It was found that converting raw scores to grades and generating module grade statistics for every module can be easily automated using MS Excel functions and charts, examination schedule clashes can be easily identified using pivot tables, and online class attendance can be easily and adequately monitored through the power of MS Excel functions. Additionally, the study revealed that HEI leaders and staff can effectively and efficiently collaborate as well as access and share files through MS Teams. Furthermore, the study found that collaborative scheduling along with various techniques in timetabling such as using dummies, group coding, re-arrangement of commitments, and rescheduling of classes can enhance the feasibility, speed, and accuracy of timetable management in any HEIs regardless of software programs used. HEIs are advised to apply these techniques with minor alterations depending on their objectives, constraints, and resources.


Keywords

Higher Education Institution, Central Filing System, Grade Analysis, Timetables, Examination Clashes.