Data Acquisition, Monitoring and Management of Purchased Items Using Java Programing

Authors

  • Rionel Belen Caldo Electronics and Communications Engineering Department, De La Salle University, 2401 Taft Avenue, 0922 Manila, Philippines.

Keywords:

Purchasing Department, Netbeans IDE, Java, Apache POI, Microsoft Excel, Software Engineering, Data Monitoring,

Abstract

The Purchasing department manages all related transaction of items and services of the institution. In Lyceum of the Philippines University – Laguna (LPU-L), the Purchasing department provides services to item purchases of the school (inside or outside the campus). The method of monitoring and storage of data is done manually. Considering that purchasing transaction is becoming plentiful in just a month’s notice because of different colleges requiring items to be bought, the task of in-charge personnel is becoming laborious and tedious. With increasing purchase of items and rendering of related services, it is essential that information will be kept organized and secured. This paper proposes a system for effective data monitoring and management of transactions related to purchasing of items in Netbeans IDE platform using Java programming language with additional use of Apache POI Application Program Interface (API) to control and manipulate Excel files. Item specifications and transactions are to be stored in a Spreadsheet, as it offers easy manipulation of cells, sheets and workbooks. Ergo, it is easy to manage formulas for arithmetic use and it provides visual presentation of data through graphs and charts. The developed system is capable of handling data entered by the user and it will easily store the data in its proper excel directories, which would simplify and speed up the manual method of managing data. The system is also equipped with searching methodology and printing of summary report. This would facilitate tangible monitoring of data and its status. Most importantly, the system could further assist the decision making of the department head.

References

A. Writing. (2017) What are the functions of a purchasing department in an organization? [Online]. http://smallbusiness.chron.com/functions-purchasing-departmentorganization-158.html

L. Magloff. (2017) Roles of a purchasing department [Online]. Available: http://smallbusiness.chron.com/roles-purchasingdepartment-2270.html

A. Majeed, “Developing countries and Internet-of-Everything (IoE),” in Proc. 7th Annual Computing and Communication Workshop and Conference (CCWC), 2017.

S. Aslam, A. Shahid, and K.G. Lee, “An efficient hybrid shopping mall with advanced purchasing system,” in Proc. 7th International Conference on Computing and Convergence Technology (ICCCT), Jun. 2013.

V. A. Titova, Y. V. Tomilina, and T. V. Titova, “Information technology in the system of purchasing decision-making based on models of long-term and short-term marketing actions,” in Proc. 9th International Forum on Strategic Technology (IFOST), Dec. 2014.

D. Lin and S. Jingtao, “A recommender system based on contextual information of click and purchase data to items for e-commerce,” in Proc. 3rd International Conference on Cyberspace Technology (CCT 2015), Apr. 2016.

J. Catapang, L. Carurucan, and R. Caldo, “Design, development and implementation of purchasing management system,” in Proc. DLSU Research Congress, Vol. 4, March 7-9, 2016.

D. Hughey. (2009) Comparing traditional systems analysis and design with agile methodologies. [Online]. Available: http://www.umsl.edu/~hugheyd/is6840/waterfall.html

S. Portny, Management for DUMMIES, 3rd ed., Wiley Publishing, Inc., Indianapolis, Indiana, 2010.

Y. Liang and L. Yansheng, “The atomic change set of Java programming language,” in Proc. 7th International Conference on Computer Science and Education (ICCSE), 2012.

C. Beach. (2016) What is an API? [Online]. Available: https://www.quora.com/what-is-an-api-4

V. Beal. (2017) API - application program interface [Online]. Available: http://www.webopedia.com/term/a/api.html

A. Oliver, G. Stampoultzis, A. Sengupta, R. Klute, and D. Fisher. (2017). Apache POI - the Java API for Microsoft documents [Online]. Available: https://poi.apache.org/

(2017) NetBeans IDE. [Online]. Available: https://netbeans.org/

Downloads

Published

2018-02-15

How to Cite

Caldo, R. B. (2018). Data Acquisition, Monitoring and Management of Purchased Items Using Java Programing. Journal of Telecommunication, Electronic and Computer Engineering (JTEC), 10(1-8), 1–7. Retrieved from https://jtec.utem.edu.my/jtec/article/view/3718

Issue

Vol. 10 No. 1-8: Breakthrough To Excellence in Communication and Computer Engineering IV

Section

Articles

License

TRANSFER OF COPYRIGHT AGREEMENT

The manuscript is herewith submitted for publication in the Journal of Telecommunication, Electronic and Computer Engineering (JTEC). It has not been published before, and it is not under consideration for publication in any other journals. It contains no material that is scandalous, obscene, libelous or otherwise contrary to law. When the manuscript is accepted for publication, I, as the author, hereby agree to transfer to JTEC, all rights including those pertaining to electronic forms and transmissions, under existing copyright laws, except for the following, which the author(s) specifically retain(s):

  1. All proprietary right other than copyright, such as patent rights
  2. The right to make further copies of all or part of the published article for my use in classroom teaching
  3. The right to reuse all or part of this manuscript in a compilation of my own works or in a textbook of which I am the author; and
  4. The right to make copies of the published work for internal distribution within the institution that employs me

I agree that copies made under these circumstances will continue to carry the copyright notice that appears in the original published work. I agree to inform my co-authors, if any, of the above terms. I certify that I have obtained written permission for the use of text, tables, and/or illustrations from any copyrighted source(s), and I agree to supply such written permission(s) to JTEC upon request.