perpustakaan.uns.ac.id
digilib.uns.ac.id
SISTEM PENGOLAH NILAI SEKOLAH MENENGAH PERTAMA NEGERI 3 TERAS BOYOLALI Diajukan Untuk Memenuhi Salah Satu Syarat Mencapai Gelar Ahli MadyaProgram Diploma III Teknik Informatika
Disusun Oleh : Dini Sulistyaningrum M3110044
PROGRAM DIPLOMA III ILMU KOMPUTER 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
Dini Sulistyaningrum, 2013. THE INFORMATION SYSTEM OF SCORE PROCESSING AT JUNIOR HIGH SCHOOL STATE 3 TERAS. DIII Information enginering , Mathematics and Natural Sciences Faculty, Sebelas Maret University Surakarta
JUNIOR HIGH SCHOOL STATE 3 TERAS in an institution that engaged in education. Problem often arise in processing score by using the traditional are slow calculation and the existing data storage.. The Method of collecting data in preparation in this Final Project are observation study and literature study method. The Design stage include database design, design flow of the program, the program display design, manufacturing program script and checking the course of the program. The application is developed using PHP and processed using MySQL database. From the results of research it can be concluded that the score processing Information System is a tool that can assist in the score processing of JUNIOR HIGH SCHOOL STATE 3 TERAS BOYOLALI. Keywords: PHP, MYSQL, Information System of score processing
iv
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id ABSTRAK
Dini Sulistyaningrum, 2013. SISTEM INFORMASI PENGOLAH NILAI SMP N 3 TERAS. DIII Teknik Informatika, Fakultas Matematika dan Ilmu Pengetahuan Alam, Universitas Sebelas Maret Surakarta.
SMPN 3 TERAS adalah institusi yang bergerak dalam bidang pendidikan. Permasalahan yang sering timbul dalam pengolahan nilai dengan menggunakan cara yang masih tradisional adalah kurang cepatnya perhitungan yang di lakukan dan penyimpanan data nilai yang pernah ada. 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 pengolah nilai adalah suatu sarana yang dapat membantu proses perhitungan nilai di SMP N 3 TERAS BOYOLALI.
Keywords; PHP, MYSQL , Sistem Informasi Pengolah Nilai
v
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
MOTTO
Dream as if you will live forever Aku datang, aku belajar, aku ujian, aku revisi dan aku menang!
vi
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
PERSEMBAHAN
Kupersembahkan tulisan ini untuk : 1. Kedua
orang
tuaku
yang
telah
mendoakan ku 2. D’Sastro Martono my big family yang selalu menberi motivasi untuk selalu berjuang meraih mimpi 3. Adik ku yang telah memberku motivasi. 4. Sahabat-sahabatku tersayang yang selalu memberikan semangat, terima kasih atas motivasi
kalian
Atika,
Ambar,
Ais,Bety,Desy,Dewi,Devi,Eky <3 5. Kakak Tingkat yang walaupun lagi sibuk kerja masih mau mengajari adik tingkat mu ini :D 6. Teman-teman TI A 2010 yang walaupun lagi ribet juga tetep mau mambantu 7. Teman-teman seperjuangan di D3 TI 2010 yang tidak bisa disebutkan satu per satu. 8. My best ever plen SH
vii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
KATA PENGANTAR
Bismillahirahmannirrahim, Alhamdulliahirobbil’alamin, penulis panjatkan puji syukur kehadirat AllahSWT atas karunia, hidayah serta inayahNya sehingga penulis dapatmenyelesaikan tugas akhir dengan judul Sistem Informasi Akademik sub Pembelajaran.Tugas akhir ini bertujuan untuk memenuhi dan melengkapi salah satusyarat dalam menempuh ujian untuk memperoleh derajat Ahli Madya pada studiDiploma 3 Teknik Informatika FMIPA Universitas Sebelas Maret. Penulis mengucapkan banyak terima kasih dan memberikan penghargaanyang sebesar-besarnya kepada semua pihak yang telah membantu dan mendukungbaik itu secara langsung maupun tidak langsung dalam penyusunan laporanTugas Akhir ini mulai dari persiapan hingga tahap penyelesaiannya, terutamakepada: 1. Allah SWT yang telah memberikan rahmat dan kesempatan, sehingga penulis bisa menyelesaikan pembuatan laporan ini. 2. Bapak Drs. YS. Palgunadi, M.Sc, selaku Ketua Program Diploma III IlmuKomputer Fakultas Matematika dan Ilmu Pengetahuan Alam Universitas Sebelas Maret. 3. Bapak Taufiqurrakhmannh, S.Kom selaku pembimbing tugas akhir. Akhir kata semoga tulisan ini bermanfaat khususnya untuk penulis danpara pembaca pada umumnya.
Surakarta, Juni 2013 Penulis
viii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
DAFTAR ISI HALAMAN JUDUL .................................................................................................
i
HALAMAN PERSETUJUAN .................................................................................
ii
HALAMAN PENGESAHAN ..................................................................................
iii
HALAMAN ABSTRAK ...........................................................................................
iv
HALAMAN ABSTRAK ...........................................................................................
v
HALAMAN MOTTO ...............................................................................................
vi
HALAMAN PERSEMBAHAN ...............................................................................
vii
KATA PENGANTAR ............................................................................................... viii DAFTAR ISI ..............................................................................................................
ix
DAFTAR TABEL ..................................................................................................... xiii DAFTAR GAMBAR ................................................................................................ xiv BAB I
PENDAHULUAN 1.1. Latar Belakang ..................................................................................
1
1.2. Perumusan Masalah ..........................................................................
2
1.3. Batasan Masalah ...............................................................................
2
1.4. Tujuan dan Manfaat Kegiatan .........................................................
2
1.5. Metodologi Penelitian .....................................................................
3
1.6. Sistematika Penulisan ........................................................................
4
BAB II LANDASAN TEORI
ix
commit to user
perpustakaan.uns.ac.id digilib.uns.ac.id 2.1. Sistem Informasi ............................................................................... 5 2.2. Database ............................................................................................
5
2.3. PHP.............................................................. ....................................
5
2.4. MySQL.............................................................. ..............................
6
2.5. Apache Server ................... ..............................................................
6
2.6. Context Diagram ..............................................................................
7
2.7. Data Flow Diagram .........................................................................
7
2.8. Entity Relationship Diagram ...........................................................
8
BAB III DESAIN DAN PERANCANGAN 3.1. Kebutuhan Sistem..............................................................................
10
3.1.1. Kebutuhan Perangkat Lunak ................................................
10
3.1.2. Kebutuhan Perangkat Keras .................................................
10
3.2. Analisis dan Perancangan Sistem .....................................................
11
3.2.1. Context Diagram (CD) ........................................................
11
3.2.2. DFD Level 0 .........................................................................
14
3.2.3. DFD Level 1 Proses 2 ...........................................................
15
3.2.4. DFD Level 1 Proses 5 ...........................................................
16
3.3. Perancangan Database .......................................................................
17
3.3.1. ERD........................................................................................
17
3.3.2. Scema Diagram (Relasi Anar Tabel) ...................................
18
3.3.3. Desain Database ...................................................................
18
3.4. Tahapan penggunaan gammu ...........................................................
27
x
commit to user
perpustakaan.uns.ac.id digilib.uns.ac.id 3.5. Struktur dan Desain Program ............................................................ 31 3.5.1. Rancangan Halaman Admin.................................................
31
3.5.2. Rancangan Halaman Guru....................................................
32
3.5.3. Rancangan Halaman Kepala Sekolah ..................................
32
3.5.4. Rancangan Halaman Walikelas............................................
33
3.5.5. Rancangan Halaman Siswa ..................................................
33
BAB IV IMPLEMENTASI DAN ANALISA 4.1. Implementasi Sistem dan Analisa.....................................................
34
4.1.1. Halaman Login ......................................................................
34
4.1.2. Halaman Lihat Data Guru ....................................................
35
4.1.2.1 Halaman input Data Guru..........................................
35
4.1.2.2 Halaman Edit Data Guru ...........................................
36
4.1.2.3 Halaman Hapus Data Guru........................................
36
4.1.2.4 Halaman Detail Data guru .........................................
37
4.1.2.5 Halaman Lihat Matapelajaran ....................................
37
4.1.2.6 Halaman Add Matapelajaran ......................................
37
4.1.2.7 Halaman Edit Matapelajaran .....................................
38
4.1.2.8 Halaman Lihat Data Siswa ........................................
38
4.1.2.9 Halaman Tambah Siswa .............................................
39
4.1.2.10 Halaman Edit Siswa .................................................
39
4.1.2.11 Halaman Detail Data Siswa.....................................
40
4.1.2.12 Halaman Data Kelas ................................................
40
xi
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id 4.1.2.13 Halaman Edit Kelas ................................................. 41 4.1.2.14 Halaman Tambah Kelas ..........................................
41
4.1.3. Halaman Guru ........................................................................
41
4.1.3.1 Halaman Profil Guru ..............................................
42
4.1.3.2 Halaman Ampu ........................................................
42
4.1.3.3 Halaman Input Nilai ................................................
42
4.1.4. Halaman Kepala Sekolah ......................................................
43
4.1.4.1 Halaman Lihat Nilai Siswa ......................................
43
4.1.4.2 Halaman Melihat Rata-Rata .....................................
43
4.1.4.3 Halaman Lihat Rangking Pararel .............................
44
4.1.5. Halaman Wali Kelas ..............................................................
44
4.1.5.1 Halaman Melihat Data Siswa ....................................
45
4.1.5.2 Halaman Lihat Nilai Siswa........................................
45
4.1.5.3 Cetak Raport ...............................................................
45
4.1.6. Halaman Interface Siswa.......................................................
46
4.1.6.1 Halaman Profil Siswa ..............................................
46
4.1.6.2 Halaman Nilai Siswa ..............................................
47
5.1
Kesimpulan .......................................................................................
48
5.2
Saran ...................................................................................................
49
DAFTAR PUSTAKA ................................................................................................
50
BAB V PENUTUP
xii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
DAFTAR TABEL Tabel 2.1
Tabel Simbol Context Diagram.......................................................... 7
Tabel 2.2
Tabel Simbol Data Flow Diagram ..................................................... 7
Tabel 2.3
Tabel ERD ........................................................................................... 8
Tabel 2.4
Tabel Ampu ........................................................................................ 18
Tabel 2.5
Tabel Guru ......................................................................................... 19
Tabel 2.6
Tabel Kelas ........................................................................................ 19
Tabel 2.7
Tabel Komp_nilai .............................................................................. 20
Tabel 2.8
Tabel Matapelajaran ........................................................................... 20
Tabel 2.9
Tabel Nilai ......................................................................................... 21
Tabel 2.10 Tabel Siswa ....................................................................................... 21 Tabel 2.11 Tabel Gammu .................................................................................... 22 Tabel 2.12 Tabel Phones ..................................................................................... 22 Tabel 2.13 Tabel Outbox ..................................................................................... 23 Tabel 2.14 Tabel Pbk ........................................................................................... 23 Tabel 2.15 Tabel Pbk_groups .............................................................................. 24 Tabel 2.16 Tabel Daemons .................................................................................. 24 Tabel 2.17 Tabel Inbox ........................................................................................ 24 Tabel 2.18 Tabel Outbox_multipart .................................................................... 25 Tabel 2.19 Tabel Sentitems ................................................................................. 25 Tabel 2.20 Tabel tahun_ajar .................................................................................. 26
xiii
commit to user
perpustakaan.uns.ac.id
digilib.uns.ac.id
DAFTAR GAMBAR Gambar 3.1 Context Diagram ..................................................................................
11
Gambar 3.2 DFD Level 0.........................................................................................
14
Gambar 3.3 DFD Level 1Proses Managemen Data ...............................................
15
Gambar 3.4 DFD Level 1 Proses 5 Cetak Nilai ...................................................
16
Gambar 3.5 ERD (Entity Relational Diagram) ......................................................
17
Gambar 3.6 Scema Diagram .....................................................................................
18
Gambar 3.7 Rancangan Halaman Admin .................................................................
27
Gambar 3.8 Rancangan Halaman Guru ....................................................................
28
Gambar 3.9 Rancangan Halaman Kepala Sekolah ...................................................
28
Gambar 3.10 Rancangan Halaman Wali Kelas ........................................................
29
Gambar 3.11 Rancangan Halaman Siswa .................................................................
29
Gambar 4.1 Halaman Login.......................................................................................
30
Gambar 4.2 Halaman Lihat Data Guru .....................................................................
31
Gambar 4.3 Halaman Input Data Guru .....................................................................
31
Gambar 4.4 Halaman Edit Data Guru .......................................................................
32
Gambar 4.5 Halaman Hapus Data Guru ..................................................................
32
Gambar 4.6 Halaman Detail Data Guru ....................................................................
33
Gambar 4.7 Halaman Lihat Matapelajaran ...............................................................
33
Gambar 4.8 Halaman Add Matapelajaran.................................................................
33
Gambar 4.9 Halaman Edit Matapelajaran .................................................................
34
xiv
commit to user
perpustakaan.uns.ac.id digilib.uns.ac.id Gambar 4.10 Halaman Lihat Data Siswa .................................................................. 34 Gambar 4.11 Halaman Tambah Siswa ......................................................................
35
Gambar 4.12 Halaman Edit Siswa.............................................................................
35
Gambar 4.13 Halaman Detail Siswa ........................................................................
36
Gambar 4.14 Halaman Data Kelas ............................................................................
36
Gambar 4.15 Halaman Edit Data Kelas ....................................................................
37
Gambar 4.16 Halaman Tambah Kelas ......................................................................
37
Gambar 4.17 Halaman Guru ......................................................................................
37
Gambar 4.18 Halaman Profil Guru ...........................................................................
38
Gambar 4.19 Halaman Ampu ....................................................................................
38
Gambar 4.20 Halaman Input Nilai ............................................................................
38
Gambar 4.21 Halaman Kepala Sekolah ....................................................................
39
Gambar 4.22 Halaman Lihat Nilai Siswa .................................................................
39
Gambar 4.23 Halaman Nilai Rata-Rata ....................................................................
40
Gambar 4.24 Halaman Lihat Rangking Pararel........................................................
40
Gambar 4.25 Halaman Wali Kelas ............................................................................
41
Gambar 4.26 Halaman Data Siswa Yang di Bimbing..............................................
41
Gambar 4.27 Halaman Lihat Nilai Siswa .................................................................
41
Gambar 4.28 Cetak Raport.........................................................................................
42
Gambar 4.29 Halaman Interface Siswa .....................................................................
43
Gambar 4.30 Halaman Profil Siswa ..........................................................................
43
Gambar 4.31 Halaman Nilai Siswa ...........................................................................
44
xv
commit to user
