TUGAS AKHIR
RANCANG BANGUN SISTEM PENDUKUNG KEPUTUSAN PENENTUAN KENAIKAN POSISI JABATAN PADA INSTANSI PEMERINTAHAN DENGAN METODE PROFILE MATCHING
HANIF PRIO ARIANTONO NIM. 0804405056
JURUSAN TEKNIK ELEKTRO FAKULTAS TEKNIK UNIVERSITAS UDAYANA BUKIT JIMBARAN 2015
i
RANCANG BANGUN SISTEM PENDUKUNG KEPUTUSAN PENENTUAN KENAIKAN POSISI JABATAN PADA INSTANSI PEMERINTAHAN DENGAN METODE PROFILE MATCHING
Tugas Akhir Diajukan Sebagai Prasyarat untuk Memperoleh Gelar Sarjana S1 (Strata1) pada Jurusan Teknik Elektro Fakultas Teknik Universitas Udayana
HANIF PRIO ARIANTONO NIM : 0804405056
JURUSAN TEKNIK ELEKTRO FAKULTAS TEKNIK UNIVERSITAS UDAYANA JIMBARAN-BALI 2015
ii
LEMBAR PERNYATAAN ORISINALITAS
Tugas Akhir/Skripsi ini adalah hasil karya saya sendiri, Dan semua sumber baik yang dikutip maupun dirujuk telah saya nyatakan dengan benar.
Nama
: Hanif Prio Ariantono
NIM
: 0804405056
Tanda Tangan
:
Tanggal
: 31 Juli 2015
iii
Lembar Pengesahan
Tugas Akhir ini diajukan oleh : Nama
: Hanif Prio Ariantono
NIM
: 0804405056
Jurusan
: Teknik Elektro
Judul Skripsi : Rancang Bangun Sistem Pendukung Keputusan Penentuan Kenaikan Posisi Jabatan Pada Instansi Pemerintahan Dengan Metode Profile Matching
Telah berhasil dipertahankan di hadapan Dewan Penguji dan diterima sebagai bagian persyaratan yang diperlukan untuk memperoleh gelar Sarjana Teknik (ST) pada Jurusan Teknik Elektro, Fakultas Teknik, Universitas Udayana
DEWAN PENGUJI Pembimbing I
: Dr. Ir. Made Sudarma, M.A.Sc.
(
)
Pembimbing II : Ir. Putu Arya Mertasana, M.Si., MT.
(
)
Penguji
: I Made Arsa Suyadnya, ST., M.Eng
(
)
Penguji
: Duman Care Khrisne, ST., MT.
(
)
Penguji
: Dr. Ir. Ida Bagus Alit Swamardika, M.Erg
(
)
Ditetapkan di : Kampus Universitas Udayana – Sudirman Tanggal : 30 Juni 2015
Mengetahui Ketua Jurusan Teknik Elektro
Ir. I Nyoman Setiawan, MT. NIP: 19631229 199103 1 001 iv
UCAPAN TERIMAKASIH
Segala puji syukur penulis panjatkan kehadapan Allah SWT Tuhan Yang Maha Esa karena atas rahmat dan karunia-Nya laporan tugas akhir dengan judul Rancang Bangun Sistem Pendukung Keputusan Penentuan Kenaikan Posisi Jabatan Pada Instansi Pemerintahan Dengan Metode Profile Matching ini akhirnya dapat terselesaikan. Penulis menyampaikan banyak terima kasih kepada: 1.
Bapak Prof. Ir. Ngakan Putu Gede Suardana, MT., Ph.D. sebagai Dekan Fakultas Teknik Universitas Udayana.
2.
Bapak Ir. I Nyoman Setiawan, MT. sebagai Ketua Jurusan Teknik Elektro Universitas Udayana.
3.
Bapak Dr. Ir. Made Sudarma. M.A.Sc. sebagai Dosen Pembimbing I
4.
Bapak Ir. Putu Arya Mertasana, M.Si., MT. sebagai Dosen Pembimbing II
5.
Bapak Ir. I Wayan Sukerayasa, MT. sebagai Dosen Pembimbing Akademik
6.
Orang tua dan kakak adik tercinta yang telah memberikan dukungan moral dan motivasi.
7.
Rekan-rekan Teknik Elektro angkatan 2008 dan teman-teman seperjuangan yang selalu kompak dalam memberikan dukungan dan bantuan dalam penyusunan Tugas Akhir ini. Penulis menyadari masih terdapat kekurangan dalam Tugas Akhir ini,
saran-saran yang membangun sangat diharapkan untuk menyempurnakan Tugas Akhir ini. Akhir kata penulis mengharapkan semoga Tugas Akhir ini dapat memberikan kontribusi dalam pengembangan ilmu pengetahuan yang bermanfaat bagi kita semua.
Jimbaran, Juni 2015
Hanif Prio Ariantono
v
ABSTRAK
Manajemen sumber daya manusia (SDM) memiliki bermacam proses, diantaranya proses seleksi yaitu proses pemilihan orang-orang yang memiliki kualifikasi yang dibutuhkan untuk mengisi jabatan disebuah organisasi. Aktivitas seleksi dan penempatan biasanya berfokus pada pengetahuan, keterampilan, dan kemampuan. Kesesuaian orang-pekerjaan (person-job fit) merupakan konsep sederhana tetapi penting yang melibatkan pencocokan pengetahuan, keterampilan, dan kemampuan orang-orang dengan karakteristik jabatan/pekerjaan. Sistem pendukung keputusan (SPK) menggunakan metode profile matching dapat menganalisa beberapa pegawai aparatur sipil negara (ASN) yang sesuai dengan profil jabatan yang ada, agar SDM dapat di tempatkan pada posisi jabatan yang sesuai dengan karakteristik yang diperlukan. Sistem yang dibuat akan lebih bersifat membantu khususnya pada bagian kepegawaian untuk memudahkan dalam pengambilan keputusan penempatan pegawai yang cocok untuk naik dalam suatu jabatan yang sesuai dengan kemampuan, keterampilan dan potensi dari pegawai tersebut. Sistem pendukung keputusan menyediakan media penyimpanan berupa basis data untuk menyimpan profil pegawai dan jabatan yang ada dalam instansi tertentu. Dan juga sistem yang dapat membantu pekerjaan yang sebelumnya dilakukan secara manual menjadi otomatis dengan sistem komputerisasi.
Kata kunci: SPK, Profile Matching, Basis Data
vi
ABSTRACT
Human Resource Management has a variety of processes, including the selection process is the process of selecting people who have the required qualifications to fill the position in an organization. Selection and placement activities typically focus on knowledge, skills, and abilities. Suitability of the job (person-job fit) is a simple but important concept that involves the matching of that person’s knowledge, skills, and abilities with characteristic of the jobs. Decision support systems (DSS) using profile matching method can analyze several ASN employees in accordance with the available position, so that HR can be placed in positions that correspond to the required characteristics. The system will be more helpful, especially to the human recourse department to making the staffing decision suitable for occupy position more suitable to the abilities, skills and potential of the employee. Decision support system provides a storage such as a database for storing employee profile and existing positions in certain institutions. And also a system that can help the work which have done manually before become automated with computerized systems.
Keywords: DSS, Profile Matching, Database
vii
DAFTAR ISI
SAMPUL HALAMAN ........................................................................................... i LEMBAR PERSYARATAN GELAR ................................................................. ii LEMBAR PERNYATAAN ORISINALITAS ................................................... iii LEMBAR PENGESAHAN ................................................................................. iv UCAPAN TERIMAKASIH...................................................................................v ABSTRAK ............................................................................................................ vi ABSTRACT ......................................................................................................... vii DAFTAR ISI ...................................................................................................... viii DAFTAR GAMBAR .......................................................................................... xii DAFTAR TABEL............................................................................................... xiv DAFTAR KODE PROGRAM ............................................................................xv
BAB I PENDAHULUAN 1.1
Latar Belakang .......................................................................................1
1.2
Rumusan Masalah ..................................................................................3
1.3
Tujuan Penelitian ...................................................................................3
1.4
Manfaat Penelitian .................................................................................3
1.5
Ruang Lingkup dan Batasan Masalah ....................................................4
1.6
Sistematika Penulisan.............................................................................4
BAB II KAJIAN PUSTAKA 2.1
Tinjauan Mutakhir..................................................................................6
2.2
Tinjauan Pustaka ....................................................................................8 2.2.1
Dinas Tenaga Kerja dan Transmigrasi Provinsi Bali ................8 2.2.1.1 Sejarah Disnakertrans .................................................8 2.2.1.2 Struktural Jabatan Disnakertrans .................................9
2.2.2 Universitas Udayana Bali .........................................................10 2.2.2.1 Sejarah Unud Bali .......................................................10 2.2.2.2 Struktur Jabatan Unud Bali ..........................................10 2.2.2.2.1 BAA ..............................................................12
viii
2.2.2.2.2 BAUK ...........................................................13 2.2.2.2.3 BAK ..............................................................14 2.2.2.2.4 BAPSI ...........................................................15 2.2.3 Pengangkatan PNS dalam Jabatan Struktural ..........................16 2.2.4 Sistem Pendukung Keputusan ..................................................16 2.2.4.1 Pengertian SPK ............................................................16 2.2.4.2 Manfaat Utama SPK ....................................................17 2.2.5 Profile Matching. .....................................................................20 2.2.6 Microsoft SQL Server...............................................................24 2.2.6.1 Pengertian Microsoft SQL Server.................................24 2.2.6.2 SQL Server ...................................................................25 2.2.6.3 Sistem Client/Server.....................................................25 2.2.6.3.1 Keuntungan Client ........................................26 2.2.6.3.2 Keuntungan Server .......................................26 2.2.6.4 Tipe Data SQL ..............................................................27 2.2.7 Visual Basic.Net .......................................................................30 2.2.7.1 Pengertian VB.Net ....................................................30 2.2.7.2 NET Framework ........................................................31 2.2.7.3 Komponen NET Framework .....................................31 2.3.7.4 Visual Basic 9.0 (VB 2008) .......................................31 2.2.8
Entity Relationship Diagram (ERD) ........................................32 2.2.8.1 One to One..................................................................33 2.2.8.2 One to Many / Many to One .......................................34 2.2.8.3 Many to Many..............................................................34
2.2.9
Data Flow Diagram (DFD) ....................................................34
BAB III METODE DAN PERANCANGAN SISTEM 3.1
Tempat dan Waktu Penelitian ..............................................................37
3.2
Data ......................................................................................................37 3.2.1 Sumber Data ................................................................................37 3.2.2 Metode Pengumpulan Data .........................................................38
3.3
Analisa Data .........................................................................................38
ix
3.3.1 Metode Pengembangan Sistem ...................................................39 3.4
Analisa Sistem ......................................................................................40
3.5
Kebutuhan Hardware dan Software .....................................................42
3.6
3.5.1
Kebutuhan Perangkat Keras ....................................................42
3.5.2
Kebutuhan Perangkat Lunak ...................................................42
3.5.3
Bahasa Pemrograman ..............................................................42
Perangkat Pemodelan Sistem ...............................................................43 3.6.1
Statement of Purpose (STP) ....................................................43
3.6.2
Daftar Kejadian .......................................................................43
3.6.3
Gambaran Umum Sistem ........................................................44
3.6.4
Diagram Konteks .....................................................................46
3.6.5
Alur Proses Sistem ..................................................................47
3.6.6
Data Flow Diagram (DFD) .....................................................49 3.6.6.1 Diagram Berjenjang (Hierarchy Chart) ....................49 3.6.6.2 DFD Level 0 ..............................................................50 3.6.6.3 DFD Level 1 Login ...................................................51 3.6.6.4 DFD Level 1 Pengelolaan Data Master ....................52 3.6.6.5 DFD Level 1 Proses Seleksi ......................................53
3.6.7
ERD (Entity Relationship Diagram) .......................................54
3.6.8
Hubungan Antar Tabel ............................................................56
3.6.9
Struktur Data ...........................................................................56
3.6.10 Perancangan User Interface ....................................................60 3.7
Metode Pengujian.................................................................................65 3.7.1
Metode Pengujian Black Box ..................................................65
3.7.1
Metode Pengujian Usability Testing .......................................66
BAB IV HASIL DAN PEMBAHASAN 4.1
Hasil .....................................................................................................67 4.1.1
4.2
Tahap-tahap Pengujian Untuk Mendapatkan Hasil.................67
Pembahasan Sistem ..............................................................................68 4.2.1
Menjalankan Server .................................................................69
4.2.2
Tampilan Awal Aplikasi .......................................................70
x
4.2.3
Login ........................................................................................70
4.2.4
Pendaftaran Admin dan User Baru ..........................................72
4.2.5
Melakukan Pengolahan Data ...................................................73 4.2.5.1 Pengolahan Data ASN ...............................................73 4.2.5.2 Pengolahan Data Jabatan ...........................................74 4.2.5.3 Pengolahan Data Kriteria ..........................................75 4.2.5.4 Pengolahan Data SubKriteria ....................................77
4.2.6
Seleksi Pegawai ASN ..............................................................78
4.2.7
Laporan Hasil Seleksi ..............................................................80 4.2.7.1 Laporan Total Nilai Hasil Seleksi ............................80 4.2.7.2 Laporan Hasil Seleksi Nilai Per Kriteria ..................82
4.3
Metode Profile Matching Pada Sistem.................................................83
4.4
Pengujian Sistem ..................................................................................94 4.4.1
Hasil Metode Pengujian Black Box .........................................94
4.4.2
Hasil Metode Pengujian Usabitity Testing ..............................95 4.4.2.1 Kriteria Variabel ........................................................95 4.4.2.2 Penetapan Skor ..........................................................96 4.4.2.3 Perhitungan dan Penyajian Data ...............................97 4.4.2.4 Uji Coba User pada Device .......................................98
4.5
Kelebihan Dan Kekurangan Sistem ...................................................101 4.3.1
Kelebihan Sistem ..................................................................101
4.3.2
Kekurangan Sistem ...............................................................102
BAB V SIMPULAN DAN SARAN 5.1
Simpulan ............................................................................................103
5.2
Saran...................................................................................................104
DAFTAR PUSTAKA .........................................................................................105 LAMPIRAN - LAMPIRAN
xi
DAFTAR GAMBAR
Gambar 2.1
Peta Jabatan Disnakertrans Prov. Bali th. 2014 ................................9
Gambar 2.2
Struktur Organisasi Unud ...............................................................11
Gambar 2.3
Jajaran Rektor dan PR Unud ..........................................................11
Gambar 2.4
Jajaran BAA Unud .........................................................................12
Gambar 2.5
Jajaran BAUK Unud .......................................................................13
Gambar 2.6
Jajaran BAK Unud .........................................................................14
Gambar 2.7
Jajaran BAPSI Unud .......................................................................15
Gambar 2.8
Dukungan Komputer Untuk Proses SPK .......................................20
Gambar 2.9
ERD One to One .............................................................................33
Gambar 2.10 ERD One to Many / Many to One ..................................................34 Gambar 2.11 ERD Many to Many ........................................................................34 Gambar 3.1
Waterfall Model ..............................................................................40
Gambar 3.2
Flowchart Alur Analisis Sistem .....................................................41
Gambar 3.3
Gambaran Umum Sistem ...............................................................45
Gambar 3.4
Diagram Konteks ............................................................................46
Gambar 3.5
Flowchart Sistem Pendukung Keputusan ......................................48
Gambar 3.6
Diagram Hierarki (Hierarchy Chart) .............................................49
Gambar 3.7
DFD Level 0 ...................................................................................50
Gambar 3.8
DFD Level 1 Login .........................................................................51
Gambar 3.9
DFD Level 1 Pengelolaan Data Master ..........................................52
Gambar 3.10 DFD Level 1 Proses Laporan .........................................................53 Gambar 3.11 ERD SPK Kenaikan Posisi Jabatan ................................................55 Gambar 3.12 Hubungan Antar Tabel ...................................................................56 Gambar 3.13 Rancangan Form Awal ...................................................................60 Gambar 3.14 Rancangan Form Login ..................................................................61 Gambar 3.15 Menu Sign Up Admin Baru.............................................................61 Gambar 3.16 Halaman Sign Up Admin Baru .......................................................62 Gambar 3.17 Rancangan Form Pegawai ..............................................................62 Gambar 3.18 Rancangan Form Jabatan ...............................................................63
xii
Gambar 3.19 Rancangan Form Kriteria ...............................................................64 Gambar 3.20 Rancangan Form Seleksi ................................................................64 Gambar 3.21 Rancangan Form Laporan Seleksi ..................................................65 Gambar 4.1
Tampilan SQL Server Service Manager .........................................69
Gambar 4.2
Start Debugging pada Microsoft Visual Studio 2008 .....................69
Gambar 4.3
Tampilan Awal Sistem Pendukung Keputusan ..............................70
Gambar 4.4
Menubar Belum Aktif ....................................................................70
Gambar 4.5
Menu Login .....................................................................................71
Gambar 4.6
Form Login .....................................................................................71
Gambar 4.7
Pilihan Menu...................................................................................71
Gambar 4.8
Form Sign Up New Admin ..............................................................72
Gambar 4.9
Tampilan Form Calon Kandidat.....................................................73
Gambar 4.10 Tampilan Form Jabatan ..................................................................74 Gambar 4.11 Tampilan Form Kriteria Seleksi .....................................................76 Gambar 4.12 Tampilan Form SubKriteria Seleksi ...............................................77 Gambar 4.13 Tampilan Form Seleksi ..................................................................78 Gambar 4.14 Tampilan Contoh Pengisian Form Seleksi .....................................79 Gambar 4.15 Tampilan Menu Menampilkan Hasil Seleksi .................................80 Gambar 4.16 Tampilan Form Hasil Seleksi .........................................................80 Gambar 4.17 Tampilan Form Laporan Detail Print.............................................81 Gambar 4.18 Tampilan Form Laporan Seleksi Per Kriteria ................................82 Gambar 4.19 Tampilan Form Print Laporan Seleksi Per Kriteria .......................83 Gambar 4.20 Tampilan Penginputan Data Seleksi ...............................................84
xiii
DAFTAR TABEL
Tabel 2.1 Tabel Bobot Nilai GAP ..........................................................................22 Tabel 2.2 Tipe Data Bilangan ................................................................................27 Tabel 2.3 Tipe Data Waktu ....................................................................................28 Tabel 2.4 Tipe Data Karakter .................................................................................29 Tabel 2.5 Komponen ERD .....................................................................................33 Tabel 2.6 Komponen DFD .....................................................................................36 Tabel 3.1 Tabel Kebutuhan Data ...........................................................................38 Tabel 3.2 Tabel Jabatan..........................................................................................56 Tabel 3.3 Tabel ASN..............................................................................................57 Tabel 3.4 Tabel Kriteria .........................................................................................58 Tabel 3.5 Tabel Sub Kriteria ..................................................................................58 Tabel 3.6 Tabel Seleksi ..........................................................................................59 Tabel 3.7 Tabel Detail Seleksi ...............................................................................59 Tabel 4.1 Definisi Kriteria Variabel Usability Testing ..........................................96 Tabel 4.2 Penilaian Aspek Variabel .......................................................................97 Tabel 4.3 Pengujian Aplikasi Pada Beberapa Perangkat Komputer ....................100
xiv
DAFTAR KODE PROGRAM
Kode Program 4.1
Identifikasi Data Input .......................................................84
Kode Program 4.2
Kode Pada Tombol Proses ..................................................85
Kode Program 4.3
Kode Sub caricfdansf..........................................................86
Kode Program 4.4
Kode Sub cocokanbobot .....................................................86
Kode Program 4.5
Kode Sub bacakosong ........................................................87
Kode Program 4.6
Kode Sub textbox ...............................................................87
Kode Program 4.7
Kode Sub caribagi ..............................................................88
Kode Program 4.8
Kode Sub caribobotcf .........................................................88
Kode Program 4.9
Kode Sub caricf ..................................................................89
Kode Program 4.10
Kode Sub caribobotsf .........................................................90
Kode Program 4.11
Kode Tombol Simpan Kriteria ...........................................90
Kode Program 4.12
Kode Sub simpandetail .......................................................91
Kode Program 4.13
Kode Sub updatekriteria .....................................................92
Kode Program 4.14
Kode Subisitotal .................................................................92
Kode Program 4.15
Kode Tombol Simpan .........................................................93
Kode Program 4.16
Kode Sub updatepegawai ...................................................94
xv
