APLIKASI STOK BARANG GUDANG BERBASIS VBA EXCEL DENGAN METODE WATERFALL DI UPT TIK UPGRIS

Abstract

Field work practice is carried out at the UPGRIS Information and Communication Technology Development Technical Implementation Unit (UPT PTIK), which provides services and facilities for the academic community, including the function of processing the computerized system of the PGRI University in Semarang, from September 1 2020 to October 15 2020. Practice Fieldwork that is done is making software. The software is a system for managing warehouse inventory at UP TIK. The features in the system include a form for inputting available items, an added item form and an outgoing goods form, then a report feature to search for item data using the search feature. During software development, the methodology used is waterfall. The first stage is analysis of the system to be made. The second stage is designing the application interface design. The third stage is coding using Visual Basic for Application from Excel. The final stage is testing which focuses on the software both logically and functionally and ensures that all parts have been tested. At the end of the Job Training, the software has been successfully created which is equipped with documentation of the finished software results. The conclusion of the whole Job Training process is this application will be useful for UPT TIK UPGRIS in monitoring the availability of warehouse goods.