Data Acquisition, Monitoring and Management of Purchased Items Using Java Programing
Keywords:Purchasing Department, Netbeans IDE, Java, Apache POI, Microsoft Excel, Software Engineering, Data Monitoring,
AbstractThe 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.
How to Cite
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):
- All proprietary right other than copyright, such as patent rights
- The right to make further copies of all or part of the published article for my use in classroom teaching
- 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
- 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.