Development of an Online Inventory System for the Engineering and Sciences Laboratory Office of Asia Pacific College through a Mobile Application with Equipment Serial Number Detection using OCR

Purpose -The Asia Pacific College's School of Engineering (APC-SoE) strongly establishes theories to its students and integrating all their theoretical knowledge through projects.Since the students need both software applications and hardware components, the Engineering and Sciences Laboratory Office (ESLO) supports them their needs and at the same time -is responsible for the maintenance of the said necessities.The ESLO, though capable of its duties, still does not have an inventory system to easily track each equipment.The developed application called SoE Keep is created for the ESLO to keep track of equipment that needs recalibration, create, edit, and delete equipment from the database, view reports that shows damaged, borrowed, approved, and returned items that students used.Methodology -The SoE Keep application was developed using Android Studio to work on devices using Android API 7.1.1 and newer version.SoE Keep's database is directly tied up to the database used by the ESLO Web Services to update the inventory and generate charts pertaining to the statistics of each item.Furthermore, the application uses Android OpenCV to perform the Optical Character Recognition (OCR) function.The OCR includes preprocessing tools such as masking and grayscale transformation for feature extraction.Practical Implications -SoE Keep, in compliance with ISO 2600 standard, provides practical assistance in implementing social obligations while considering cultural, sociological, environmental, and legal variations as well as economic development situations.