APLIKASI PENGOLAHAN PENDATAAN USAHA KESEHATAN SEKOLAH (UKS) PADA KANTOR UNIT PELAKSANA TEKNIS DINAS (UPTD) KECAMATAN ILIR TIMUR I PALEMBANG
LAPORAN AKHIR
Disusun untuk memenuhi syarat menyelesaikan Pendidikan Diploma III Jurusan Manajemen Informatika Politeknik Negeri Sriwijaya
Oleh: Setyabudi Susilawati 0611 3080 1332
POLITEKNIK NEGERI SRIWIJAYA PALEMBANG 2014
MOTTO DAN PERSEMBAHAN Motto Bahwa tiada yang orang dapatkan, kecuali yang ia usahakan, Dan bahwa usahanya akan kelihatan nantinya. (Q.S. An Najm ayat 39-40)
Jangan terlalu memikirkan masa lalu karena telah pergi dan selesai, dan jangan
terlalu memikirkan masa depan hingga dia datang sendiri. Karena jika melakukan yang terbaik dihari ini maka hari esok akan lebih baik.
Kupersembahkan Kepada : Kedua Orang Tua Kedua Pembimbingku (Ibu Hetty Meileni dan Ibu Indri Ariyanti) Semua Pihak yang telah membantu Penulis dalam menyelesaikan Laporan Teman-teman seperjuanganku 6 MI A Almamaterku
ii
ABSTRAK Judul pada laporan akhir ini adalah “Aplikasi Pengolahan Pendataan Usaha Kesehatan Sekolah (UKS) pada Kantor Unit Pelaksana Teknis Dinas (UPTD) Kecamatan Ilir Timur I Palembang”. Data didapatkan dari hasil wawancara pada kantor Unit Pelaksana Teknis Dinas (UPTD) Pendidikan Pemuda dan Olahraga yang beralamat di di Jl. Mayor Santoso 20 Ilir D III Kamboja, Palembang. Hasil yang didapat dari penelitian yang dilakukan yaitu proses pengolahan pendataan Usaha Kesehatan Sekolah (UKS) yang berjalan masih harus menggunakan menggunakan aplikasi pengolahan data Microsoft Excel dalam proses penginputan dan pengolahan data hasil pendataan Usaha Kesehatan Sekolah sehingga, sering terjadi kesulitan dalam pencarian data, hal tersebut membuat proses penginputan dan pengolahan tidak barjalan dengan tepat dan akurat. Dari permasalahan tersebut, penulis bertujuan membangun “Aplikasi Pengolahan Pendataan Usaha Kesehatan Sekolah (UKS) pada Kantor Unit Pelaksana Teknis Dinas (UPTD) Kecamatan Ilir Timur I Palembang”, dimana aplikasi ini dapat menghasilkan output yang akurat dan cepat. Pembuatan aplikasi ini menggunakan bahasa Pemrograman Berbasis Web (PHP dengan menggunakan database MySQL).
iii
ABSTRACT The title on the final report is "application Processing School Health Efforts Logging (UKS) in Implementing the Technical Service Unit Office (UPTD) Sub Ilir Timur I, Palembang". The Data obtained from the results of the interviews on Implementing Technical Service Unit Office (UPTD) education youth and sports is located at JL. Maj. Santoso 20 Ilir D III of Cambodia, Palembang. The results obtained from the research that is processing the logging Business School Health (UKS) which runs but still have to use data processing applications using Microsoft Excel in the input of the processing the result of the data of Health Business School, so that often occur the difficulties in processing the data, it makes the process of input and processing the data doesn’t work correctly and accurately. Based on these problems, the author aims to build "the application of Processing Logging Venture Health School (UKS) in Implementing the Technical Service Unit Office (UNIT) Sub Ilir Timur I, Palembang", where these applications can generate output that is accurate and fast. Making for the application using Web-based programming languages (PHP, using a MySQL database).
iv
DAFTAR ISI
Halaman HALAMAN JUDUL ................................................................................
i
HALAMAN PENGESAHAN ..................................................................
ii
HALAMAN MOTTO DAN PERSEMBAHAN ...................................... iii ABSTRAK ................................................................................................ vi ABSTRACT..............................................................................................
v
KATA PENGANTAR .............................................................................. vi DAFTAR ISI ............................................................................................ viii DAFTAR GAMBAR ................................................................................ xiv DAFTAR TABEL .................................................................................... xvi BAB I PENDAHULUAN 1.1 Latar Belakang ............................................................................
1
1.2 Perumusan Masalah .....................................................................
3
1.3 Batasan Masalah ..........................................................................
3
1.4 Tujuan dan Manfaat .....................................................................
3
1.4.1 Tujuan ................................................................................
3
1.4.2 Manfaat...............................................................................
4
1.5 Metodologi Penelitian ..................................................................
4
1.5.1 Lokasi Pengambilan Data ....................................................
6
1.5.2 Metode Pengumpulan Data .................................................
6
1.6 Sistematika Penulisan ..................................................................
7
BAB II TINJAUAN PUSTAKA 2.1 Teori Umum ................................................................................
9
2.1.1 Pengertian Komputer ..........................................................
9
2.1.2 Pengertian Sistem ...............................................................
9
v
2.1.3 Pengertian Informasi ........................................................... 10 2.1.4 Pengertian Sistem Informasi................................................ 10 2.1.5 Metode Pengembangan Sistem ............................................ 10 2.2 Teori Judul .................................................................................. 11 2.2.1 Pengertian Aplikasi ............................................................. 11 2.2.2 Pengertian Pengolahan ....................................................... 12 2.2.3 Pengertian Pendataan .......................................................... 12 2.2.4 Pengertian Usaha ................................................................ 12 2.2.5 Pengertian Kesehatan .......................................................... 12 2.2.6 Pengertian Sekolah ............................................................. 12 2.2.7 Pengertian Unit ................................................................... 13 2.2.8 Pengertian Pelaksana ........................................................... 13 2.2.9 Pengertian Teknis ................................................................ 13 2.2.10 Pengertian Dinas ............................................................... 13 2.2.11 Pengertian Aplikasi Pengolahan Pendataan Usaha Kesehatan Sekolah (UKS) pada Kantor Unit Pelaksana Teknis Dinas (UPTD) Kecamatan Ilir Timur I Palembang ...................... 13 2.3 Teori Khusus ............................................................................... 14 2.3.1 Pengertian (DFD) Data Flow Diagram ............................... 14 2.3.2 Kamus Data ........................................................................ 16 2.3.3 Flowchart .......................................................................... 17 2.3.4 Blokchart ............................................................................ 18 2.3.5 Entity Relationship( ERD)................................................... 20 2.4 Teori Program ............................................................................. 21 2.4.1 Sekilas PHP (Hypertext Preprocessor) ................................ 21 2.4.1.1 Pengertian PHP ....................................................... 21 2.4.1.2 Script PHP .............................................................. 22 vi
2.4.1.3 Teknik Penulisan Script PHP .................................. 22 2.4.2 Sekilas Tentang MySQL ..................................................... 23 2.4.2.1 Pengertian MySQL .................................................. 23 2.4.2.2 Fungsi-fungsi MySQL ............................................. 24 2.4.2.3 Keistimewaan MySQL ............................................ 26 2.4.3 Sekilas Tentang Adobe Dreamweaver CS5 .......................... 27 2.4.3.1 Pengertian Adobe Dreamweaver CS5 ...................... 27 2.4.3.2 Starting Page........................................................... 27 2.4.3.3 Ruang Kerja Adobe Dreamweaver CS5 ................... 28 BAB III GAMBARAN UMUM INSTANSI 3.1 Sejarah Singkat ............................................................................ 32 3.1.1 Sejarah Kelembagaan Unit Pelaksana Teknis Dinas (UPTD) 32 3.2 Visi dan Misi ............................................................................... 32 3.2.1 Visi ..................................................................................... 32 3.2.2 Misi .................................................................................... 32 3.3 Struktur Organisasi ...................................................................... 33 3.4 Tugas Pokok dan Fungsi .............................................................. 34 3.5 Prosedur yang Sedang Berjalan .................................................... 41 3.6 Prosedur Sistem yang Akan Diterapkan ....................................... 42 BAB IV HASIL DAN PEMBAHASAN 4.1 Analisa Sistem ............................................................................. 44 4.1.1 Lokasi Penelitian................................................................. 44 4.1.2 Kesempatan ........................................................................ 44 4.1.3 Alat Bantu Aplikasi ............................................................. 44 4.1.5 Studi Kelayakan .................................................................. 45 4.2 Perancangan Sistem ..................................................................... 46 4.2.1 Desain Sistem ..................................................................... 47 4.2.1.1 Konseptual ............................................................... 47 vii
4.2.1.1.1 Diagram Konteks ....................................... 47 4.2.1.1.1.1 Diagram Konteks ...................... 47 4.2.1.1.1.2 DFD Level 0 ............................. 48 4.2.1.1.1.3 ERD .......................................... 51 4.2.1.1.1.4 Blokchart .................................. 52 4.2.1.1.1.5 Flowchart ................................. 53 4.2.1.2 Logikal .................................................................... 57 4.2.1.2.1 Kamus Data ............................................... 57 4.2.1.2.1.1 Database Formulir Pendataan ... 57 4.2.1.2.1.2 Database Intrumen Supervisi .... 58 4.2.1.2.1.3 Database Izin ............................ 59 4.2.1.2.1.4 Database Laporan Tim Pembina UKS ......................................... 60 4.2.1.2.1.5 Database Level ......................... 62 4.2.1.2.1.6 Database Pengguna ................... 63 4.2.1.2.1.7 Desain Tabel Formulir Pendataan 63 4.2.1.2.1.8 Desain Tabel Instrumen Supervisi 65 4.2.1.2.1.9 Desain Tabel Izin ...................... 68 4.2.1.2.1.10 Desain Tabel Laporan Tim Pembina UKS ....................................... 69 4.2.1.2.1.11 Desain Tabel Level ................. 73 4.2.1.2.1.12 Desain Tabel Pengguna ........... 73 4.2.2 Desain Program ................................................................... 74 4.2.2.1 Desain Form Login .................................................. 74 4.2.2.2 Desain Form Formulir Pendataan ............................ 75 4.2.2.3 Desain Form Level ................................................. 75 4.2.2.4 Desain Form Izin .................................................... 76 viii
4.2.2.5 Desain Form Formulir Pendataan > Tambah Ke ...... 77 4.2.2.6 Desain Form Instrumen Supervisi ........................... 78 4.2.2.7 Desain Form Laporan Tim Pembina UKS ............... 79 4.3 Pengkodean Sistem ..................................................................... 80 4.3.1 Pengkodean Database .......................................................... 80 4.3.2 Tampilan Program ............................................................... 86 4.3.2.1 Tampilan Form Login .............................................. 86 4.3.2.2 Tampilan Form Formulir Pendataan ......................... 86 4.3.2.3 Tampilan Form Level .............................................. 87 4.3.2.4 Tampilan Form Izin ................................................. 87 4.3.2.5 Tampilan Form Formulir Pendataan > Tambah Ke .. 88 4.3.2.6 Tampilan Form Instrumen Supervisi > Tambah Ke .. 88 4.3.2.7 Tampilan Form Instrumen Supervisi ........................ 89 4.3.2.8 Tampilan Form Laporan Tim Pembina UKS ............ 89 4.3.2.9 Tampilan Form Laporan Tim Pembina UKS > Tambah ke........................................................................... 90 4.4 Pengujian Sistem ......................................................................... 90 4.4.1 Rencana Pengujian ............................................................ 90 4.4.2 Kasus dan Hasil Pengujian................................................. 91 4.4.3 Kesimpulan Hasil Pengujian .............................................. 98 4.5 Pemeliharaan Sistem ................................................................... 98 BAB V KESIMPULAN DAN SARAN 5.1 Kesimpulan ................................................................................. 99 5.2 Saran ........................................................................................... 99 DAFTAR PUSTAKA ............................................................................... 100 LAMPIRAN
ix
DAFTAR GAMBAR Halaman Gambar 1.1 Ilustrasi Model Waterfall............................................................
4
Gambar 2.1 Tampilan Program HTML pada Browser..................................
22
Gambar 2.2 Tampilan awal Adobe Dreamweaver CS5 ................................
27
Gambar 2.3 Tampilan Ruang Kerja Dreamweaver CS5................................
29
Gambar 2.4 Application Bar pada Dreamweaver CS5..................................
29
Gambar 2.5 Toolbar Document pada Dreamweaver CS5 ...........................
29
Gambar 2.6 Document Window pada Dreamweaver CS5.............................
30
Gambar 2.7 Workspace Switcher pada Dreamweaver CS5...........................
30
Gambar 2.8 Panel Groups pada Dreamweaver CS5......................................
30
Gambar 2.9 Teg Selector pada Dreamweaver CS5………...........................
31
Gambar 2.10 Property Inspector pada Dreamweaver CS5..............................
31
Gambar 2.11 Toolbar Browser Navigation pada Dreamweaver CS5..............
31
Gambar 3.1
Struktur Organisasi Unit Pelaksana Teknis Dinas (UPTD) ......
33
Gambar 3.2
Prosedur yang Sedang Berjalan……………………………......
41
Gambar 4.1 Diagram Konteks .......................................................................
48
Gambar 4.2 Data Flow Diagram…………………….........................................
49
Gambar 4.3 Entity Relationship Diagram……………………........................
51
Gambar 4.4 Blokchart Diagram…………………………………........................
52
Gambar 4.5 Flowchart sebagai Staf UPTD…………….……….......................
54
Gambar 4.6 Flowchart sebagai Pembina UKS Sekolah..................................
55
Gambar 4.7 Flowchart sebagai Kepala Dinas Kesehatan………….................. 56 Gambar 4.8 Desain Form Login………………...…………………….………… 74 Gambar 4.9 Desain Form Formulir Pendataan…………………......................... 75 Gambar 4.10 Desain Form Level…………………................................................ 75 x
Gambar 4.11 Desain Form Izin………………. …………………......................... 76 Gambar 4.12 Desain Form Formulir Pendataan > Tambah Ke……………....... 77 Gambar 4.13 Desain Form Instrumen Supervisi………………. ………………... 78 Gambar 4.14 Desain Form Laporan Tim Pembina UKS………………. …….... 79 Gambar 4.15 Desain Tampilan Form Login………………. …………………...... 86 Gambar 4.16 Desain Tampilan Form Formulir Pendataan ………………. …… 86 Gambar 4.17 Desain Tampilan Form Level……………… ………………. …. 87 Gambar 4.18 Desain Tampilan Form Izin………………... ………………. …. 87 Gambar 4.19 Desain Tampilan Form Formulir Pendataan > Tambah Ke ……. 88 Gambar 4.20 Desain Tampilan Form Instrumen Supervisi > Tambah Ke …… 88 Gambar 4.21 Desain Tampilan Form Instrumen Supervisi………………. …… 89 Gambar 4.22 Desain Tampilan Form Laporan Tim Pembina UKS …………… 89 Gambar 4.23 Desain Tampilan Form Laporan Tim Pembina UKS > Tambah Ke……………………………………………………………….
xi
90
DAFTAR TABEL
Halaman Tabel 2.1
Simbol-Simbol Data Flow Diagram Yourdan & De Marco.........................................................................................
14
Tabel 2.2 Simbol-Simbol Data Flow Diagram Gane & Sarson.........................................................................................
15
Tabel 2.3 Simbol-Simbol Data Flow Diagram...........................................
15
Tabel 2.4
Simbol-simbol Kamus Data........................................................
16
Tabel 2.5
Simbol-simbol Flowchart ..........................................................
17
Tabel 2.6
Simbol-simbol Blokchart….........................................................
18
Tabel 2.7
Simbol-simbol Entity Relational Diagram..................................
21
Tabel 2.8
Script Dasar PHP.......................................................................
23
Tabel 2.9
Fungsi-fungsi MySQL dalam PHP..............................................
24
Tabel 4.1
Desain Tabel Formulir Pendataan................................................
63
Tabel 4.2
Desain Tabel Instrumen Supervisi................................................
66
Tabel 4.3
Desain Tabel Izin.........................................................................
69
Tabel 4.4
Desain Tabel Laporan Tim Pembina UKS...................................
69
Tabel 4.5
Desain Tabel Level………………………………………………
73
Tabel 4.6
Desain Tabel Pengguna..................................................................
73
Tabel 4.7
Tabel Rencana Pengujian...............................................................
91
Tabel 4.8
Kasus dan Pengujian Form Login...................................................
91
Tabel 4.9
Kasus dan Pengujian Form Data Level............................................ 92
Tabel 4.10 Kasus dan Pengujian Form Data Izin..............................................
93
Tabel 4.11 Kasus dan Pengujian Form Data Pengguna..................................... 94 Tabel 4.12 Kasus dan Pengujian Form Data Formulir Pendataan..................... 95 Tabel 4.13 Kasus dan Pengujian Form Data Instrumen Supervisi....................
96
Tabel 4.14 Kasus dan Pengujian Form Data Laporan Tim Pembina UKS.......
97
xii
xiii
