sistem informasi penggajian guru honorer pada ma...
TRANSCRIPT
SISTEM INFORMASI PENGGAJIAN GURU HONORER
PADA MA NW AL-AKHYAR BAGIK POLAK BERBASIS
DESKTOP
TUGAS AKHIR
Oleh :
AMELIA RIZKI WULANDARI
1700320024
PROGRAM STUDI SISTEM INFORMASI
FAKULTAS TEKNIK DAN DESAIN
UNIVERSITAS BUMIGORA
MATARAM
2020
SISTEM INFORMASI PENGGAJIAN GURU HONORER
PADA MA NW AL-AKHYAR BAGIK POLAK BERBASIS
DESKTOP
TUGAS AKHIR
Diajukan Sebagai Salah Satu Syarat Untuk Memenuhi Kebulatan Studi
Tahap Diploma Tiga (D3) Program Sistem Informasi
Pada Universitas Bumigora
Oleh :
AMELIA RIZKI WULANDARI
1700320024
PROGRAM STUDI SISTEM INFORMASI
FAKULTAS TEKNIK DAN DESAIN
UNIVERSITAS BUMIGORA
MATARAM
2020
KATA PENGANTAR
Dengan nama Allah Yang Maha Pemurah lagi Maha Penyayang. Penulis
panjatkan puji syukur dan terimakasih yang sebesar-besarnya atas rahmat, nikmat,
kebahagiaan serta seluruh anugerah yang berbentuk apapun yang telah dilimpahkan
kepada seluruh hamba-hamba-Nya. Dengan segala rahmat-Nya penulis dapat
menyelesaikan Tugas Akhir yang berjudul “SISTEM INFORMASI
PENGGAJIAN GURU HONORER PADA MA NW AL-AKHYAR BAGIK
POLAK BERBASIS DESKTOP”.
Dengan selesainya Tugas Akhir ini, penulis ingin mengucapkan terima
kasih kepada pihak – pihak yang telah banyak membantu dalam penyelesaian Tugas
Akhir ini. Dalam kesempatan ini penulis menyampaikan ucapan terimakasih
kepada:
1. Bapak Dr. Ir. Anthony Anggrawan, MT., Ph.D. selaku Rektor Universitas
Bumigora.
2. Ibu Ni Gusti Ayu Dasriani, M.Kom, selaku Wakil Rektor I Universitas
Bumigora.
3. Bapak Ahmat Adil, M.Sc, selaku Dekan Fakultas Teknik dan Desain.
4. Ibu Melati Rosanensi, M.Kom selaku Ketua Program Studi D3 Sistem
Informasi.
5. Bapak Lalu Zazuli Azhar Mardedi, S.Kom M.Kom Dosen Pembimbing dalam
mengerjakan Tugas Akhir ini.
6. Bapak/Ibu Dosen yang telah memberikan ilmu selama dalam perkuliahan.
7. Tak terlupakan tercinta Bapak dan ibu yang telah memberikan dukungan moril
dan dukungan materi.
8. Teman-teman dan sahabat yang selalu memberi semangat.
Penulis sebagai manusia biasa, menyadari dengan sepenuhnya bahwa dalam
penulisan skripsi ini masih jauh dari kesempurnaan, maka penulis senantiasa
mengharapkan teguran, kritik serta saran yang sifatnya membangun untuk dapat
lebih sempurnanya pembuatan Tugas Akhir atau sejenisnya pada masa-masa yang
akan datang. Akhirnya penulis berharap semoga tulisan ini bermanfaat bagi semua
pihak.
Mataram, Agustus 2020
Penulis
DAFTAR ISI
Halaman
HALAMAN JUDUL
LEMBAR PENGESAHAN
Latar Belakang ........................................................................................1
Rumusan Masalah ...................................................................................2
Batasan Masalah ......................................................................................2
Tujuan dan Manfaat Penelitian .............................................................3
Tujuan Penelitian .............................................................................3
Manfaat Penelitian ...........................................................................3
Metodologi Penelitian ..............................................................................3
Sistematika Penulisan .............................................................................5
Tinjauan Organisasi ................................................................................7
Struktur Organisasi .........................................................................7
Tujuan Organisasi ............................................................................7
Visi Organisasi ..................................................................................8
Misi Organisasi .................................................................................8
Sistem Informasi ......................................................................................8
Penggajian ..............................................................................................11
Guru Honorer ........................................................................................12
Mysql ......................................................................................................13
Navicat ....................................................................................................16
Microsoft Visual Studio 2010 ...............................................................17
Crystal Reports ......................................................................................19
Flowchart ...............................................................................................20
Data Flow Diagram (DFD) ...................................................................23
Diagram Alur Data Fisik (DADF) ................................................24
Diagram Alur Data Logika (DADL) ............................................24
Entity Relationshi Diagram (ERD) ......................................................25
Perencanaan Sistem ..............................................................................26
Analisis Sistem .......................................................................................26
Analisis Permasalahan ...................................................................26
Analisis Kebutuhan ........................................................................27
Sistem Lama ...........................................................................................28
Sistem Alternatif ....................................................................................32
Normalisasi .............................................................................................34
3.5.1 Tujuan dari normalisasi ................................................................34
3.5.2 Proses Normalisasi .........................................................................34
Tahapan Normalisasi .....................................................................35
Struktur Database .................................................................................38
3.6.1 Tabel user ........................................................................................38
3.6.2 Tabel Guru ......................................................................................38
3.6.3 Tabel Matapelajaran .....................................................................39
Tabel Jadwal Mengajar .................................................................39
Tabel Rekap Absen ........................................................................40
Tabel Penggajian ............................................................................41
3.7 Relasi Databae .......................................................................................41
3.8 Entity Relationship Diagram (ERD) ....................................................42
3.9 Data Flow Diagram (DFD) ...................................................................42
3.9.1 Diagram Konteks ................................................................................42
3.9.2 Diagram Alir Data Level 1 ............................................................43
3.9.3 Diagram Alir Data Level 2 ............................................................45
3.10 Kamus Data ............................................................................................47
3.11 Bagan Berjenjang ..................................................................................49
3.12 Desain Tampilan ....................................................................................49
3.12.1 Tampilan Koneksi ..........................................................................49
3.12.2 Tampilan Menu Utama .................................................................49
3.12.3 Tampilan Login ..............................................................................50
3.12.4 Tampilan User ................................................................................51
3.12.5 Tampilan Data Guru .....................................................................51
3.12.6 Tampilan Matapelajaran ..............................................................52
3.12.7 Tampilan Jadwal Mengajar ..........................................................53
3.12.8 Tampilan Rekap Absen .................................................................54
3.12.9 Tampilan Penggajian .....................................................................55
3.12.10 Tampilan Laporan .....................................................................56
Tampilan Form Koneksi .......................................................................57
Tampilan Form Login ...........................................................................59
Tampilan Form Menu Utama ..............................................................61
Tampilan Form User .............................................................................63
Tampilan Data Guru .............................................................................65
Tampilan Form Data Guru ...........................................................65
Tampilan Form Input Data Guru ................................................66
Tampilan Form Matapelajaran ...........................................................67
Tampilan Jadwal Mengajar .................................................................69
Tampilan Form Jadwal Mengajar ...............................................69
Tampilan Form Input Jadwal Mengajar .....................................70
Tampilan Rekap Absen ........................................................................72
Tampilan Form Rekap Absen .......................................................72
Tampilan Form Input Rekap Absen ............................................73
Tampilan Form Transaksi Penggajian ................................................74
Tampilan laporan ..................................................................................76
Uji Coba Dan Hasil ................................................................................78
Pengujian Alpha .............................................................................78
Pengujian Beta ................................................................................82
Kesimpulan ............................................................................................87
Saran .......................................................................................................87
DAFTAR REFRENSI
LAMPIRAN
DAFTAR GAMBAR
Halaman
Gambar 1.1 Model Waterfall ................................................................................4
Gambar 2.1 Struktur Organisasi ..........................................................................7
Gambar 3.1 Flowchart Lama ..............................................................................29
Gambar 3.2 Flowchart Alternatif .......................................................................32
Gambar 3.4 Relasi Database ...............................................................................41
Gambar 3.5 ERD Penggajian Guru Honorarium .............................................42
Gambar 3.6 Diagram Konteks ............................................................................43
Gambar 3.7 Diagram Alir Data Level 1 .............................................................44
Gambar 3.8 Diagram Alir Data Level 2 Login ..................................................45
Gambar 3.9 Diagram Alir Data Level 2 Penginputan Data .............................45
Gambar 3.10 Diagram Alir Data Pengolahan Gaji ..........................................46
Gambar 3.11 Diagram Alir Data Cetak Laporan .............................................46
Gambar 3.12 Bagan Berjenjang .........................................................................49
Gambar 3.13 Tampilan Koneksi .........................................................................49
Gambar 3.14 Tampilan Menu Utama ................................................................50
Gambar 3.15 Tampilan Login .............................................................................50
Gambar 3.16 Tampilan User ...............................................................................51
Gambar 3.17 Tampilan Form Data Guru .........................................................52
Gambar 3.18 Tampilan Form Input Data Guru ...............................................52
Gambar 3.19 Tampilan Matapelajaran .............................................................53
Gambar 3.20 Tampilan Form Jadwal Mengajar ..............................................53
Gambar 3.21 Tampilan Form Input Jadwal Mengajar ...................................54
Gambar 3.22 Tampilan Form Rekap Absen .....................................................54
Gambar 3.23 Tampilan Input rekap Absen ......................................................55
Gambar 3.24 Tampilan Form Penggajian .........................................................55
Gambar 3.25 Tampilan Input Penggajian .........................................................56
Gambar 3.26 Tampilan Laporan ........................................................................56
Gambar 4.1 Form Koneksi ..................................................................................58
Gambar 4.2 Flowchart Form Koneksi ...............................................................58
Gambar 4.3 Form Login ......................................................................................59
Gambar 4.4 Flowchart Form Login ...................................................................60
Gambar 4.5 Form Menu Utama .........................................................................61
Gambar 4.6 Flowchart Form Menu Utama .......................................................62
Gambar 4.7 Form User ........................................................................................64
Gambar 4.8 Flowchart Form User .....................................................................64
Gambar 4.9 Form Data Guru .............................................................................66
Gambar 4.10 Form Input Data Guru .................................................................66
Gambar 4.11 Flowchart Form Data Guru .........................................................67
Gambar 4.12 Form Matapelajaran ....................................................................68
Gambar 4.13 Flowchart Form Matapelajaran ..................................................68
Gambar 4.14 Form Jadwal Mengajar ................................................................70
Gambar 4.15 Form Input Jadwal Mengajar .....................................................70
Gambar 4.16 Flowchart Form Jadwal Mengajar .............................................71
Gambar 4.17 Form Rekap Absen .......................................................................72
Gambar 4.18 Form Input Rekap Absen ............................................................73
Gambar 4.19 Flowchart Form Absen ................................................................73
Gambar 4.20 Form Transaksi Penggajian ........................................................74
Gambar 4.21 Flowchart Form Transaksi Penggajian ......................................75
Gambar 4.22 Laporan Data Guru ......................................................................76
Gambar 4.23 Absen ..............................................................................................76
Gambar 4.24 Laporan Rekap Absen .................................................................77
Gambar 4.25 Laporan Penggajian .....................................................................77
Gambar 4.26 Gambar Flowchart Laporan .......................................................78
Gambar 4.27 SUS Score ......................................................................................86
DAFTAR TABEL
Halaman
Tabel 3.1 Tabel Tidak Normal ............................................................................35
Tabel 3.2 Tabel Normal Pertama .......................................................................36
Tabel 3.3 Tabel Normal Kedua ...........................................................................37
Tabel 3.4 Tabel User ............................................................................................38
Tabel 3.5 Tabel Guru ...........................................................................................39
Tabel 3.6 Tabel Matapelajaran ...........................................................................39
Tabel 3.7 Tabel Jadwal Mengajar ......................................................................39
Tabel 3.8 Tabel Absen .........................................................................................40
Tabel 3.9 Tabel Penggajian .................................................................................41
Tabel 4.1 Tabel Pengujian Alpha .......................................................................79
Tabel 4.2 Tabel Pertanyaan Kusioner ................................................................82
Tabel 4.3 Tabel Kusioner ....................................................................................83
Tabel 4.4 Tabel Rekap SUS Score ......................................................................85
Tabel 4.5 Tabel rata-rata SUS Score ..................................................................85
