sistem informasi akademik pengolahan nilai berbasis

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

perpustakaan.uns.ac.id digilib.uns.ac.id

commit to user

ii


commit to user

iii


commit to user

iv

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


commit to user

v

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


commit to user

vi

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.


commit to user

vii

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


commit to user

viii

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


commit to user

ix

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


commit to user

x

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


commit to user

xi

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


commit to user

xii

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


commit to user

xiii

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


commit to user

xiv


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


commit to user

xv


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


commit to user

xvi

103. Gambar 4.26 Export data dari Mysql ........................................................... 80


commit to user

sistem informasi akademik pengolahan nilai berbasis

Documents