perpustakaan.uns.ac.id digilib.uns.ac.id sistem pengolah...

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

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

commit to user

ii


commit to user

iii


commit to user

iv

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


commit to user

v

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


commit to user

vi

MOTTO

Dream as if you will live forever

Aku datang, aku belajar, aku ujian, aku revisi dan aku menang!


commit to user

vii

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


commit to user

viii

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


commit to user

ix

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


commit to user

x

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


commit to user

xi

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


commit to user

xii

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

BAB V PENUTUP

5.1 Kesimpulan ....................................................................................... 48

5.2 Saran ................................................................................................... 49

DAFTAR PUSTAKA ................................................................................................ 50


commit to user

xiii

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


commit to user

xiv

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


commit to user

xv

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


commit to user

perpustakaan.uns.ac.id digilib.uns.ac.id sistem pengolah...

Documents