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

  • Juan Miguel Villarroel School of Engineering, Asia Pacific College, Philippines
  • Luigi Carlo M. De Jesus School of Engineering, Asia Pacific College, Philippines
  • Bea Daphne B. Baylon School of Engineering, Asia Pacific College, Philippines
  • Rissa Mikaela G. Beduya School of Engineering, Asia Pacific College, Philippines
  • Jayson T. Verzon School of Engineering, Asia Pacific College, Philippines
  • Leonardo A. Samaniego Jr. School of Engineering, Asia Pacific College, Philippines
  • Sergio R. Peruda Jr. School of Engineering, Asia Pacific College, Philippines
  • Stanley Glenn E. Brucal School of Engineering, Asia Pacific College, Philippines
  • Einstein D. Yong School of Engineering, Asia Pacific College, Philippines
  • Paulo Cosio School of Engineering, Asia Pacific College, Philippines

Abstract

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.

Result – The developed application was evaluated using its accuracy, reliability and its user-friendliness. The application got a 91.67% accuracy rating that is interpreted as a “Good” result. In terms of reliability, the application had a rating of 94.07% that is also interpreted as “Good”. The user-friendliness result was grouped into the set of possible users of the application: ESLO Head/Professors and Student Assistants. Furthermore, it had two sub-categories: Overall Experience and Overall Design. The overall experience of the student assistants was rated 3.78 and the overall design is 3.43. For the ESLO Head and Professors, the overall experience rated 4.8 and the overall design is 4.6.

Conclusion – The application developed resulted to the following conclusions that: it was able to have a good accuracy in capturing the serial numbers through an OCR, it also has a good reliability covering the precision of obtaining the correct serial numbers, good overall design and overall experience using the application for the Student Assistants, good overall design and overall experience using the application for the ESLO Head/Professors.

Recommendation – The following are the recommendations that must be taken into consideration: collecting more sample data in testing can further increase the precision of the Accuracy and Reliability ratings, improving the overall User Interface and User Experience of the application, improving the usability of the bounding box for capturing the image, improving the graphical visualizations and provide other options for viewing the data such as lists.

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.

Author Biographies

Juan Miguel Villarroel, School of Engineering, Asia Pacific College, Philippines

Juan Miguel H. Villarroel holds an Electronics Engineer (3rd Placer) and an Electronics Technician license. He is now pursuing his graduate degree at Mapua Institute of Technology. He is currently a Full-Time Faculty Member at Asia Pacific College's School of Engineering.

Luigi Carlo M. De Jesus, School of Engineering, Asia Pacific College, Philippines

Luigi Carlo M. De Jesus is a Master of Engineering Major in Computer Engineering graduate of Asia Pacific College. He is a licensed Electronics Engineer, Electronics Technician (2nd Placer), and the current Engineering and Science Laboratory Office (ESLO) Head of Asia Pacific College - School of Engineering.

Bea Daphne B. Baylon, School of Engineering, Asia Pacific College, Philippines

Bea Daphne Baylon is a Computer Engineering student at Asia Pacific College. She handles the application’s documentation, as well as its user interface and experience – two factors that are of utmost importance for customer satisfaction.

Rissa Mikaela G. Beduya, School of Engineering, Asia Pacific College, Philippines

Rissa Mikaela Beduya is a Computer Engineering undergraduate at Asia Pacific College. With her tasks mainly focusing on the program’s logic and database, she developed her forte in the CRUD process and in setting up the application’s database from scratch.

Jayson T. Verzon, School of Engineering, Asia Pacific College, Philippines

Jayson Verzon, a Computer Engineering Student at Asia Pacific College, has the role of a back-end developer. He handles mostly the main logic of the application, typically the ones that need a lot of research.

Leonardo A. Samaniego Jr., School of Engineering, Asia Pacific College, Philippines

Leonardo A. Samaniego Jr. holds an Electronics Engineer license. He also holds a Master of Engineering degree with a major in Electronics Engineering from MAPUA Institute of Technology. He is currently the Executive Director of Asia Pacific College's School of Engineering.

Sergio R. Peruda Jr., School of Engineering, Asia Pacific College, Philippines

Sergio R. Peruda Jr. is a Professional Computer Engineer. He is currently the Program Director of Computer Engineering at Asia Pacific College.

Stanley Glenn E. Brucal, School of Engineering, Asia Pacific College, Philippines

Stanley Glenn E. Brucal earned his BS Electronics Engineering from Adamson University (2003) and a Master of Engineering major in Electronics and Communications Engineering from De La Salle University (2006). He is a Professional Electronics Engineer (PECE), an ASEAN Chartered Professional Engineer (ACPE), and currently the Registrar of Asia Pacific College.

Einstein D. Yong, School of Engineering, Asia Pacific College, Philippines

Einstein D. Yong is a Professional Computer Engineer. He is currently an Associate Professor at Asia Pacific College's School of Engineering.

Paulo Cosio, School of Engineering, Asia Pacific College, Philippines

Paulo Cosio is a licensed Electronics Engineer. He is now pursuing his graduate degree at St. Joseph College. He is a Full-Time Faculty Member at Asia Pacific College's School of Engineering.

Published
2023-05-01
How to Cite
VILLARROEL, Juan Miguel et al. 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. International Journal of Computing Sciences Research, [S.l.], v. 7, p. 2137-2157, may 2023. ISSN 2546-115X. Available at: <//stepacademic.net/ijcsr/article/view/426>. Date accessed: 29 mar. 2024.
Section
Special Issue: IRCCETE 2023

Most read articles by the same author(s)