ii

DAFTAR ISIHalaman

KATA PENGANTAR ........................................................................................................................................ iDAFTAR ISI ....................................................................................................................................................... iiDAFTAR TABEL ............................................................................................................................................... ivDAFTAR GAMBAR .......................................................................................................................................... vBAB I PENDAHULUAN .................................................................................................................................. 11.1 Latar Belakang ....................................................................................................................................... 11.2 Tujuan ....................................................................................................................................................... 11.3 Manfaat ..................................................................................................................................................... 21.4 Batasan ..................................................................................................................................................... 2BAB II TINJAUAN PUSTAKA ....................................................................................................................... 32.1 Pemrograman Komputer Berorientasi Objek .......................................................................... 32.2 Algoritma ................................................................................................................................................. 32.3 Flowchart ................................................................................................................................................ 32.3.1 Jenis – Jenis Flowchart ................................................................................................................... 42.3.2 Simbol – Simbol Flowchart ........................................................................................................... 52.4 Struktur Kontrol Pemrograman ..................................................................................................... 62.4.1 Struktur Kontrol Keputusan ........................................................................................................ 62.4.2 Struktur Kontrol Pengulangan .................................................................................................... 72.5 Event, Property, Method, dan Objek ............................................................................................ 72.6 Event Driven Programming ............................................................................................................. 82.7 Visual Basic for Application (VBA) with Microsoft Excel 2013 ........................................ 82.7.1 Visual Basic for Application (VBA) ........................................................................................... 82.7.2 Microsoft Excel 2013 ...................................................................................................................... 82.7.2.1 Macro Excel 2013 ......................................................................................................................... 92.7.2.1.1 Perekaman Macro ..................................................................................................................... 92.7.2.1.2 Macro dengan VBE .................................................................................................................... 11BAB III HASIL DAN PEMBAHASAN .......................................................................................................... 123.1 Deskripsi Program .............................................................................................................................. 123.2 Algoritma Pemrogram ...................................................................................................................... 123.3 Diagram Alir (Flowchart) Program ............................................................................................. 143.4 User Interface ....................................................................................................................................... 153.5 Listing Code Program ........................................................................................................................ 20

iii

3.6 Cara Kerja Program ............................................................................................................................ 28BAB IV PENUTUP ........................................................................................................................................... 294.1 Kesimpulan ............................................................................................................................................ 294.2 Saran .......................................................................................................................................................... 29DAFTAR PUSTAKALAMPIRAN

iv

DAFTAR TABELHALAMAN

Tabel 2.1 Event, Property, Method ......................................................................................................... 7

v

DAFTAR GAMBARHalaman

Gambar 2.1 Contoh Flowchart dalam kehidupan Sehari – Hari ................................................. 4Gambar 2.2 Simbol – Simbol Flowchart ............................................................................................... 5Gambar 2.3 Tampilan Tab Developer ................................................................................................... 10Gambar 2.4 Tampilan Kotak Dialog Record Macro ......................................................................... 10Gambar 3.1 Diagram Alir (Flowchart) Program ............................................................................... 14Gambar 3.2 Form Login .............................................................................................................................. 15Gambar 3.3 Menu Utama ............................................................................................................................ 15Gambar 3.4 Menu Input Akun .................................................................................................................. 16Gambar 3.5 Menu Klaim ............................................................................................................................. 16Gambar 3.6 Daftar Input Akun ................................................................................................................. 17Gambar 3.7 Daftar Pembayaran Cicilan ............................................................................................... 17Gambar 3.8 Menu Cetak Struk Bayar .................................................................................................... 18Gambar 3.9 Daftar Proses Klaim ............................................................................................................. 18Gambar 3.10 Menu Cetak Struk Klaim .................................................................................................. 19Gambar 3.11 Menu Tutup Aplikasi ......................................................................................................... 19