perpustakaan.uns.ac.id
digilib.uns.ac.id
SISTEM INFORMASI AKADEMIK PENGOLAHAN NILAI BERBASIS WEBSITE DISMP N 1 JOGONALAN
TUGAS AKHIR Diajukan Untuk Memenuhi Salah Satu Syarat Mencapai Gelar Ahli Madya Program Diploma III Teknik Informatika
Disusun oleh : CATUR APRIYANTO NIM. M3110030
PROGRAM DIPLOMA III TEKNIK INFORMATIKA FAKULTAS MATEMATIKA DAN ILMU PENGETAHUAN ALAM UNIVERSITAS SEBELAS MARET 2013
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
ii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
iii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id ABSTRACT
Catur
Apriyanto,
2013.
WEB-BASED
ACADEMIC
INFORMATION
PROCESSING SYSTEM FOR SMP N 1 JOGONALAN. 3rd Years Diploma Degree of Informatics engineering, Mathematic and Natural Sciences Faculty, Sebelas Maret University, Surakarta.
Students assignments score have important
roles in
evaluating and
understanding the overall students progress. Students need scores transparency in every subjects taken. Are important for student to anticipate if there would be any scoring errors, so students could ask the teacher. Therefore, an application is needed to process the scoring system. The goal of this final project is to create a web-based information system for SMP Negeri 1 Jogonalan. The data collecting methods that have been used in this final project are observations and literature reviews. Stages of design that have been used including in this research designing databases, program flow, display program, making program script, and checking the course of program. The application is developed using PHP and processed using the MySQL database. The conclusion from the research is that system is an excellent tool to help Administration Staff, Instructors, and Students to process and access the scores. To access the website, Users must register. Once Users have registered, they can access the system and process the data.
Keywords: Information Systems, Score Information Systems, Academic System
iv
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id ABSTRAK
Catur Apriyanto, 2013. SISTEM INFORMASI AKADEMIK PENGOLAHAN NILAI BERBASIS WEBSITE DI SMP N 1 JOGONALAN. DIII Teknik Informtika, Fakultas Matematika dan Ilmu Pengetahuan Alam, Universitas Sebelas Maret Surakarta. Nilai merupakan bagian penting guna mengetahui hasil belajar siswa. Setiap semester yang ditempuh oleh siswa terdapat beberapa tugas dan ujian akhir semester. Siswa memerlukan transparansi nilai disetiap mata pelajaran yang telah ditempuh, hal ini juga diperlukan untuk mengantisipasi terjadinya kesalahan penilaian sehingga siswa dapat melakukan komplain pada pengajar bersangkutan. Untuk itu diperlukan sebuah aplikasi untuk melakukan pengolahan nilai tersebut. Tujuan dari Tugas Akhir ini adalah membuat sebuah sistem informasi penilaian berbasis website di SMP Negeri 1 JOGONALAN. Metode pengumpulan data yang dalam penyusunan Tugas Akhir ini adalah metode observasi dan studi pustaka. Tahapan perancangan yang digunakan meliputi perancangan database, perancangan alur program, perancangan tampilan program, pembuatan script program dan pengecekan jalannya program.
Aplikasi ini
dikembangkan dengan menggunakan PHP dan diolah dengan menggunakan database MySQL. Dari hasil penelitian yang dilakukan diperoleh kesimpulan bahwa Sistem Informasi Penilaian adalah suatu sarana yang dapat membantu proses pengolahan nilai bagi staff administrasi atau guru dan cara mudah bagi siswa untuk mengetahui nilainya. Untuk mengaksesnya pengguna harus sudah terdaftar. Setelah terdaftar pengguna baru bisa mengakses dan melakukan pengolahan atau melihat data.
Kata kunci : Sistem Informasi, Sistem Informasi Penilaian,Sistem Akademik
v
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id MOTTO DAN PERSEMBAHAN
1. Kau tidak akan mendapatkan apa-apa yang berguna untuk mu apabila kamu tidak memulai dari apa yang kamu bisa. (Catur) 2. We Have, We Will Share, We learn (VPC 48)
Kupersembahkan goresan tinta ini untuk : 1. Ayah dan ibu yang selalu mendo’akan, terima kasih untuk segalanya. 2. Budhe selalu memberikan semangat bagi saya. 3. Buat Teman saya Devri yang selalu memberikan
bantuan
nya
dalam
pengerjaan TA ini. 4. Buat Agatha, yang selalu menemani yang memberikan semangat untuk saya 5. Sahabat-sahabatku @VPC 48 dan AKC Crew yang selalu memberikan semangat, kecerian dalam selama kuliah ini 6. Teman-teman seperjuangan di D3 TI 2010 yang tidak bisa disebutkan satu per satu.
vi
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id KATA PENGANTAR
Puji syukur atas kehadirat Tuhan yang Maha Esa sudah berikan hikmat dan kelancaran bagi penulis dapat menyelesaikan tugas akhir dengan judul Sistem Informasi Akademik Pengolahan Nilai Berbasis Website di SMP Negeri 1 Jogonalan. Tugas akhir ini bertujuan untuk memenuhi dan melengkapi salah satu syarat dalam menempuh ujian untuk memperoleh derajat Ahli Madya pada studi Diploma III Ilmu Komputer Fakultas MIPA Universitas Sebelas Maret. Penulis mengucapkan banyak terima kasih dan memberikan penghargaan yang sebesar-besarnya kepada semua pihak yang telah membantu dan mendukung baik itu secara langsung maupun tidak langsung dalam penyusunan laporan Tugas Akhir ini mulai dari persiapan hingga tahap penyelesaiannya, terutama kepada: 1. Tuhan Yesus yang telah memberikan anugerah-Nya dan kesempatan, sehingga penulis bisa menyelesaikan pembuatan laporan ini. 2. Drs. YS. Palgunadi, M.Sc, selaku Ketua Program Diploma III Ilmu Komputer Fakultas Matematika dan Ilmu Pengetahuan Alam Universitas Sebelas Maret. 3. A.Bima Murti Wijaya, S.T.M.T. selaku pembimbing tugas akhir. 4. Bpk. Zaipudin Arahim, S.Pd. M.Pd selaku Kepala Sekolah di SMP Negeri 1 Jogonalan.
Akhir kata semoga tulisan ini bermanfaat khususnya untuk penulis dan para pembaca pada umumnya.
Surakarta, Juli 2013
Penulis
vii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id DAFTAR ISI
Halaman HALAMAN JUDUL .................................................................................................... i HALAMAN PERSETUJUAN ................................................................................... ii HALAMAN PENGESAHAN ...................................................................................iii HALAMAN ABSTRACT ......................................................................................... iv HALAMAN ABSTRAK............................................................................................. v MOTTO DAN PERSEMBAHAN ............................................................................ vi KATA PENGANTAR............................................................................................... vii DAFTAR ISI............................................................................................................. viii DAFTAR TABEL ...................................................................................................... xi DAFTAR GAMBAR ................................................................................................ xii BAB I PENDAHULUAN ........................................................................................... 1 1.1 Latar Belakang Masalah ..................................................................................... 1 1.2 Peumusan Masalah ............................................................................................ 2 1.3 Batasan Masalah ................................................................................................. 2 1.4 Tujuan .................................................................................................................. 2 1.5 Manfaat ................................................................................................................ 2 1.6 Metodologi Penelitian......................................................................................... 3 1.6.1 Studi literatur ........................................................................................... 3 1.6.2 Site Survey ........................................................................................................ 3 1.6.3 SDLC (System Development Life Cycle) ..................................................... 3 1.7 Sistematika Penulisan ......................................................................................... 5 BAB II LANDASAN TEORI ..................................................................................... 6 2.1 Pengertian Data ................................................................................................... 6 2.2 Pengertian Sistem informasi .............................................................................. 6 2.3 Pengertian Basis Data ......................................................................................... 7 viii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
2.4 Diagram Kontek.................................................................................................. 7 2.5 Pengertian Bahasa Pemrograman ...................................................................... 7 2.6 Data Flow Diagram (DFD) ............................................................................... 8 2.7 Entity Relationship Diagram (ERD).................................................................. 9 2.8 Pengertian Flowchart .......................................................................................... 9 2.13 Pengertian Sistem Informasi Akademik ........................................................ 10 BAB III DESAIN DAN PERANCANGAN ............................................................ 11 3.1 Sistem Penilaian di SMP Negeri 1 Jogonalan................................................. 11 3.2 Sistem Pengolahan nilai di SMP Negeri 1 Jogonalan. ................................... 12 3.3Data Flow Diagram (DFD) .............................................................................. 12 3.3.1 Context Diagram....................................................................................... 12 3.3.2 DFD Level 1 .............................................................................................. 14 3.3.3 DFD Level 2 Proses Mengolah Berita ..................................................... 15 3.3.4 DFD Level 2 Proses Mengolah sejarah ................................................... 15 3.3.5 DFD Level 2 Proses Mengolah index ...................................................... 15 3.3.6 DFD Level 2 Proses Mengolah visi dan misi .......................................... 16 3.3.7 DFD Level 2 Proses Mengolah user ........................................................ 16 3.3.8 DFD Level 2 Proses Mengolah mapel ..................................................... 17 3.3.9 DFD Level 2 Proses Mengolah ekstrakulikuler ...................................... 17 3.3.10 DFD Level 2 Proses Mengolah Guru .................................................... 18 3.3.11 DFD Level 2 Proses Mengolah kepribadian ......................................... 18 3.3.9 DFD Level 2 Proses Mengolah kelas ...................................................... 19 3.3.10 DFD Level 2 Proses Mengolah tahun ajar ............................................ 19 3.3.11 DFD Level 2 Proses Mengolah siswa .................................................... 20 3.3.12 DFD Level 2 Proses Mengolah ekstra siswa ......................................... 20 3.3.13 DFD Level 2 Proses Mengolah mapel ................................................... 21 3.3.14 DFD Level 2 Proses Mengolah nilai...................................................... 21 3.4 Entity Relationship Diagram (ERD) ............................................................... 22 3.5 Flowchart ........................................................................................................... 23 ix
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id LANJUTAN DAFTAR ISI
3.5.1 DFD Level 2 Proses Mengolah Berita ..................................................... 23 3.5.2 DFD Level 2 Proses Mengolah sejarah ................................................... 25 3.5.3 DFD Level 2 Proses Mengolah index ...................................................... 25 3.5.4 DFD Level 2 Proses Mengolah visi dan misi .......................................... 26 3.5.5 DFD Level 2 Proses Mengolah user ........................................................ 26 3.5.6 DFD Level 2 Proses Mengolah mapel ..................................................... 28 3.5.7 DFD Level 2 Proses Mengolah ekstrakulikuler ...................................... 30 3.5.8 DFD Level 2 Proses Mengolah Guru ...................................................... 32 3.5.9 DFD Level 2 Proses Mengolah kepribadian ........................................... 34 3.5.10 DFD Level 2 Proses Mengolah kelas .................................................... 36 3.5.11 DFD Level 2 Proses Mengolah tahun ajar ............................................ 38 3.5.12 DFD Level 2 Proses Mengolah siswa .................................................... 40 3.5.13 DFD Level 2 Proses Mengolah ekstra siswa ......................................... 42 3.5.14 DFD Level 2 Proses Mengolah mapel ................................................... 44 3.5.15 DFD Level 2 Proses Mengolah nilai...................................................... 46 3.6 Skema Diagram (Scheme Diagram) ................................................................ 48 3.7 Kamus Data ( Data Dictionary )...................................................................... 49 3.8 Perancangan Basis Data (Database Design)................................................... 53 3.9 Struktur dan Desain Program ........................................................................... 62 3.9.1 Peta Situs (Site Map) ................................................................................ 62 3.9.2 Desain Antarmuka (User Interface Design) ........................................... 63 BAB IV IMPLEMENTASI SISTEM ...................................................................... 67 4.1 Analisa Sistem................................................................................................... 67 4.2 Implementasi Sistem......................................................................................... 68 BAB V PENUTUP .................................................................................................... 82 5.1 Kesimpulan........................................................................................................ 82 5.2 Saran .................................................................................................................. 82 DAFTAR PUSTAKA ............................................................................................... 83 x
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id DAFTAR TABEL Halaman
1. Tabel 2.1 Notasi DFD ........................................................................................... 8 2. Tabel 2.2 Notasi ERD ........................................................................................... 9 3. Tabel 2.3 Notasi Flowchart ................................................................................ 10 4. Tabel 3.1 Kamus Data......................................................................................... 50 5. Tabel 3.2 Detail Tabel login ............................................................................... 54 6. Tabel 3.3 Detail Tabel Siswa.............................................................................. 55 7. Tabel 3.4 Detail Tabel mapel ............................................................................. 55 8. Tabel 3.5 Detail Tabel ekstrakulikuler............................................................... 56 9. Tabel 3.6 Detail Tabel guru ................................................................................ 56 10. Tabel 3.7 Detail Tabel kelas ............................................................................... 56 11. Tabel 3.8 Detail Tabel Kepribadian ................................................................... 57 12. Tabel 3.9 Detail Tabel Mempelajari .................................................................. 57 13. Tabel 3.10 Detail Tabel mengajar ...................................................................... 58 14. Tabel 3.11 Detail Tabel nilai ekstra ................................................................... 58 15. Tabel 3.12 Detail Tabel semester ....................................................................... 59 16. Tabel 3.13 Detail Tabel berita ............................................................................ 59 17. Tabel 3.14 Detail Tabel sejarah.......................................................................... 59 18. Tabel 3.15 Detail Tabel visi dan misi ................................................................ 60 19. Tabel 3.16 Detail Tabel index ............................................................................ 60 20. Tabel 3.17 Detail Tabel kehadiran ..................................................................... 60 21. Tabel 3.18 Detail Tabel nilai kepribadian ......................................................... 61 22. Tabel 3.19 Detail Tabel nilai kehadiran............................................................. 61 23. Tabel 3.20 Detail Tabel sejarah.......................................................................... 62
xi
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id DAFTAR GAMBAR
Halaman 1. Gambar 3.1 Context Diagram ............................................................................ 13 2. Gambar 3.2 DFD Level 1.................................................................................... 15 3. Gambar 3.3 DFD Level 2 Proses 1 Mengolah Berita ....................................... 16 4. Gambar 3.4 DFD Level 2 Proses 2 Mengolah Sejarah .................................... 16 5. Gambar 3.5 DFD Level 2 Proses 3 Mengolah lihat Index .............................. 16 6. Gambar 3.6 DFD Level 2 Proses 4 Mengolah Visi dan Misi........................... 17 7. Gambar 3.7 DFD Level 2 Proses 5 Mengolah user login ................................. 17 8. Gambar 3.8 DFD Level 2 Proses 6 Mengolah Mapel ....................................... 18 9. Gambar 3.9 DFD Level 2 Proses 7 Pengolahan ekstrakulikuler ...................... 18 10. Gambar 3.10 DFD Level 2 Proses 8 Pengolahan Guru .................................... 19 11. Gambar 3.11 DFD Level 2 Proses 9 Pengolahan Kepribadian ........................ 19 12. Gambar 3.12 DFD Level 2 Proses 10 Mengolah Kelas .................................... 20 13. Gambar 3.13 DFD Level 2 Proses 11 Mengolah tahun ajar............................. 20 14. Gambar 3.14 DFD Level 2 Proses 12 Mengolah Siswa ................................... 21 15. Gambar 3.15 DFD Level 2 Proses 13 Mengolah ekstra siswa ......................... 21 16. Gambar 3.16 DFD Level 2 Proses 14 Mengolah Mapel................................... 22 17. Gambar 3.17 DFD Level 2 Proses 15 Pengolahan Nilai .................................. 22 18. Gambar 3.18 ERD Sistem Informasi Pengolahan Nilai ................................... 23 19. Gambar 3.19 Flowchart Input berita proses 2.1.1 ............................................ 24 20. Gambar 3.20 Flowchart Update berita proses 2.1.2 ......................................... 25 21. Gambar 3.21 flowchart hapus berita proses 2.1.3 ............................................. 25 22. Gambar 3.22 flowchart Update Sejarah proses 2.2.1........................................ 26 23. Gambar 3.23 flowchart Update Home proses 2.3.1 .......................................... 26
xii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id LANJUTAN DAFTAR GAMBAR
24. Gambar 3.24 flowchart Update visi dan misi proses 2.4.1 ............................... 27 25. Gambar 3.25 flowchart Lihat User proses 2.5.1 ............................................... 27 26. Gambar 3.26 Flowchart Input User proses 2.5.2............................................... 28 27. Gambar 3.27 Flowchart update User proses 2.5.3 ............................................ 28 28. Gambar 3.28 flowchart delete User proses 2.5.4 .............................................. 29 29. Gambar 3.29 flowchart Lihat mapel proses 2.6.1 ............................................. 29 30. Gambar 3.30 flowchart Input mapel proses 2.6.2 ............................................. 30 31. Gambar 3.31 flowchart Update mapel proses 2.6.3 ......................................... 30 32. Gambar 3.32 flowchart delete mapel proses 2.6.4 ............................................ 31 33. Gambar 3.33 flowchart Lihat ekstrakulikuler proses 2.7.1 .............................. 31 34. Gambar 3.34 Flowchart Input ekstrakulikuler proses 2.7.2 ............................. 32 35. Gambar 3.35 Flowchart Update ekstrakulikuler proses 2.7.3 ......................... 32 36. Gambar 3.36 Flowchart delete ekstrakulikuler proses 2.7.4 ............................ 33 37. Gambar 3.37 Flowchart Lihat Guru proses 2.8.1 .............................................. 33 38. Gambar 3.38 Flowchart Input guru proses 2.8.2 ............................................... 34 39. Gambar 3.39 Flowchart Update guru proses 2.8.3........................................... 34 40. Gambar 3.40 Flowchart delete guru proses 2.8.4.............................................. 35 41. Gambar 3.41 Flowchart Lihat BK proses 2.9.1................................................. 35 42. Gambar 3.42 Flowchart Input BK proses 2.9.2................................................. 36 43. Gambar 3.43 Flowchart Update BK proses 2.9.3 ............................................ 36 44. Gambar 3.44 Flowchart delete BK proses 2.9.4 .............................................. 37 45. Gambar 3.45 Flowchart Lihat data kelas proses 2.10.1 .................................... 37 46. Gambar 3.46 Flowchart Input Data kelas proses 2.10.2 ................................... 38 47. Gambar 3.47 Flowchart Update data kelas proses 2.10.3................................ 38 48. Gambar 3.48 Flowchart delete data kelas proses 2.10.4.................................. 39 49. Gambar 3.49 Flowchart Lihat tahun ajar proses 2.11.1 ................................... 39
xiii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id LANJUTAN DAFTAR GAMBAR
50. Gambar 3.50 Flowchart Input tahun ajar proses 2.11.2 .................................... 40 51. Gambar 3.51 Flowchart Update tahun ajar proses 2.11.3................................ 40 52. Gambar 3.52 Flowchart delete tahun ajar proses 2.11.4.................................. 41 53. Gambar 3.53 Flowchart Lihat siswa proses 2.12.1 ........................................... 41 54. Gambar 3.54 Flowcahrt Input siswa proses 2.12.2 .......................................... 42 55. Gambar 3.55 Flowchart Update siswa proses 2.12.3 ....................................... 42 56. Gambar 3.56 Flowchart delete siswa proses 2.12.4 ......................................... 43 57. Gambar 3.57 Flowchart Lihat ekstrakuliukuler siswa proses 2.13.1 ............... 43 58. Gambar 3.58 Flowcahart Input ekstrakuliukuler siswa proses 2.13.2 ............. 44 59. Gambar 3.59 Flowchart delete ekstrakuliukuler siswa proses 2.13.4 ............. 44 60. Gambar 3.61 Flowchart Lihat mapel guru proses 2.14.1 ................................. 45 61. Gambar 3.62 Flowchart Input mapel guru proses 2.14.2 ................................. 45 62. Gambar 3.63 Flowchart Update mapel guru proses 2.14.3 .............................. 46 63. Gambar 3.64 Flowchart delete mapel guru proses 2.14.4. ............................... 46 64. Gambar 3.65 Flowcahrt Lihat nilai proses 2.15.1 ............................................ 47 65. Gambar 3.66 Flowchart Input nilai proses 2.15.2 ............................................. 47 66. Gambar 3.67 Flowchart Update nilai proses 2.15.3 .......................................... 48 67. Gambar 3.68 Pysical Data Model Sistem Informasi Pengolahan Nilai ........... 49 68. Gambar 3.69 Peta Situs ( Sitemap ) ................................................................... 63 69. Gambar 3.70 Rancangan Desain Halaman Utama ............................................ 64 70. Gambar 3.71 Rancangan Desain Halaman Login Admin, Siswa, Guru .......... 64 71. Gambar 3.72 Rancangan Desain Halaman Utama Admin ............................... 65 72. Gambar 3.73 Rancangan Desain editor tampilan halaman............................... 66 73. Gambar 3.74 Rancangan Pendataan Guru. ........................................................ 66 74. Gambar 3.75 Rancangan Pendataan siswa.. ...................................................... 67 75. Gambar 3.76 Rancangan penilaian. ................................................................... 67
xiv
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id LANJUTAN DAFTAR GAMBAR
76. Gambar 4.1 Halaman Home ............................................................................... 69 77. Gambar 4.2 Form Login ..................................................................................... 70 78. Gambar 4.3 Halaman Home admin.................................................................... 70 79. Gambar 4.4 Pendataan User ............................................................................... 71 80. Gambar 4.5 Pendataan Mata Pelajaran .............................................................. 71 81. Gambar 4.6 Pendataan Kegiatan ekstrakulikuler .............................................. 72 82. Gambar 4.7 Pendataan Kelas .............................................................................. 72 83. Gambar 4.8 Pendataan Guru............................................................................... 72 84. Gambar 4.9 Pendataan Kepribadian................................................................... 73 85. Gambar 4.10 Pendataan Siswa ........................................................................... 73 86. Gambar 4.11 Pendataan Ekstrakulikuler ........................................................... 74 87. Gambar 4.12 Pendataan Matapelajaran ............................................................. 74 88. Gambar 4.13 Daftar guru .................................................................................... 75 89. Gambar 4.14 Input Nilai ..................................................................................... 75 90. Gambar 4.15 Lap Nilai siswa ............................................................................. 75 91. Gambar 4.16 Input Nilai ekstrakulikuler ........................................................... 76 92. Gambar 4.17 Lap Nilai ekstrakulikuler ............................................................. 76 93. Gambar 4.18 Halaman Home Guru ................................................................... 77 94. Gambar 4.19 Halaman Input Pengumuman ...................................................... 77 95. Gambar 4.20 Input Nilai ..................................................................................... 78 96. Gambar 4.21 Daftar siswa kelas ......................................................................... 78 97. Gambar 4.22 Input Nilai kepribadian siswa ...................................................... 78 98. Gambar 4.23 Input Kehadiran Siswa ................................................................. 79 99. Gambar 4.24 Halaman home siswa.................................................................... 79 100.
Gambar 4.25 Daftar Nilai Pelajaran ............................................................. 79
101.
Gambar 4.26 Daftar Nilai Ekstrakulikuler................................................... 80
102.
Gambar 4.27 Import data ke excel ............................................................... 80 xv
commit to user
perpustakaan.uns.ac.id 103.
digilib.uns.ac.id
Gambar 4.26 Export data dari Mysql ........................................................... 80
xvi
commit to user
