Top Banner
TRANSKIP NILAI CONTOH FUNGSI GABUNGAN BAHAN PRAKTEK EXCEL 1
23

PRAKTEK EXCEL 2.xlsx

Feb 11, 2016

Download

Documents

Hani

Semoga bermanfaat
Welcome message from author
This document is posted to help you gain knowledge. Please leave a comment to let me know what you think about it! Share it to your friends and learn new things together.
Transcript
Page 1: PRAKTEK EXCEL 2.xlsx

TRANSKIP NILAICONTOH FUNGSI

GABUNGANBAHAN PRAKTEK

EXCEL 1

Page 2: PRAKTEK EXCEL 2.xlsx

DAFTAR HADIR SEMESTER GENAP 2012/2013MADRASAH ALIYAH AL SYASIYAH

Mata Pelajaran : FisikaGuru Bidang Studi : Sofariatul BadriahKelas/Smt : XI A/ Genap

NomorNama Siswa

pertemuan ke-Urt NIM 1 2 3 4 5 6 7 8 9 10 11 1201 10111001 Farid Maruf h h h h h h h h h h s h02 10111002 Fitriatul Faridah h h h h h h a h h h h h03 10111003 Hendi Suhendi h h h h h h h h h h a h04 10111004 Ida Wahidah h h h h h h i h h h h h05 10111005 Novyanti a h h h h h h h h h s h06 10111006 Iwan Suwandi i h h h h h s h h h h h07 10111007 Jaini h h h h h h h h h h h h08 10111008 kartika h h a h h h h h h h h h09 10111009 Lili Mulyadi h h s h h h h h h h h h10 10111010 Momon Dahman h h i h h h h h h h h h11 10111011 Muriyanto h h h h h h h h h h h h12 10111012 Nina Rusmina h h h h h h h h h h h s13 10111013 Noviani Cicih h h h h h h h h h h h i14 10111014 Romi Diana h h h h h h h h h h h h15 10111015 Sarmo h h h h s h h h h h h h

h Hadir 0 0 0 0 0 0 0 0 0 0 0 0s Sakit 0 0 0 0 0 0 0 0 0 0 0 0i Ijin 0 0 0 0 0 0 0 0 0 0 0 0

a Alfa 0 0 0 0 0 0 0 0 0 0 0 0

Page 3: PRAKTEK EXCEL 2.xlsx

DAFTAR HADIR SEMESTER GENAP 2012/2013MADRASAH ALIYAH AL SYASIYAH

pertemuan ke- jml nilaiNilai Hadir

13 14 15 16 s i a hi h s a 2 1 1 12 84.375h h h h 0 0 1 15 93.75h h h h 0 0 1 15 93.75h h h h 0 1 0 15 96.875h h h h 1 0 1 14 90.625h h h h 1 1 0 14 93.75h h h h 0 0 0 16 100h h h h 0 0 1 15 93.75h h h h 1 0 0 15 96.875h h h h 0 1 0 15 96.875h h h h 0 0 0 16 100h h h h 1 0 0 15 96.875h h h h 0 1 0 15 96.875h h h h 0 0 0 16 100h h h h 1 0 0 15 96.875

0 0 0 00 0 0 00 0 0 00 0 0 0

Page 4: PRAKTEK EXCEL 2.xlsx

CONTOH PENGGUNAAN OPERATORNo A B C A+B+C A-B-C AxBxC A+BxC AxB+C A/B/C (A+B)xC1 2 1 -1 2 2 -2 1 1 -2 -32 4 3 -2 5 3 -24 -2 10 -0.666667 -143 6 5 -3 8 4 -90 -9 27 -0.4 -334 8 7 -4 11 5 -224 -20 52 -0.285714 -605 10 9 -5 14 6 -450 -35 85 -0.222222 -95

Page 5: PRAKTEK EXCEL 2.xlsx

CONTOH PENGGUNAAN OPERATOR(A+B)/C Ax(B-C) A²+B²+C² A²-B²-C² X₁ X₂ A>B C>A A=B A<>B

-3 4 6 2 0.5 -1 1 0 0 1-3.5 20 29 3 0.4253905 -1.175391 1 0 0 1

-3.666667 48 70 2 0.4040715 -1.237405 1 0 0 1-3.75 88 129 -1 0.3940084 -1.269008 1 0 0 1-3.8 140 206 -6 0.3881527 -1.288153 1 0 0 1

Page 6: PRAKTEK EXCEL 2.xlsx

CONTOH PENGGUNAAN OPERATORA>=C B<=C

1 FALSE1 FALSE1 FALSE1 FALSE1 FALSE

Page 7: PRAKTEK EXCEL 2.xlsx

DAFTAR NILAISekolah :SMP AL Barokah Guru : Nugraha, S.Pd.Kelas / SMT : VII / II Pelajaran : IPA

NomorNama

NilaiUrt No Ujian Tgs UTS UAS Akhir 1 Akhir 2 Akhir 301 08092001 Ai Rina 70.25 50.25 65.25 62.75 61.25 61.9202 08092002 Asep 65.30 75.25 55.25 62.76 64.76 65.2703 08092003 Asep Sani 75.25 65.25 75.25 72.75 71.75 71.9204 08092004 Cintia Dewi 40.00 50.75 55.25 50.31 49.86 48.6705 08092005 Evi Fitri Sumiati 50.20 65.25 55.25 56.49 57.49 56.90

Terbesar 40.00 50.25 55.25 50.31 49.86 48.67Terkecil 75.25 75.25 75.25 72.75 71.75 71.92

Rata-rata 60.20 61.35 61.25 61.01 61.02 60.93

Page 8: PRAKTEK EXCEL 2.xlsx

Sekolah : SMP Al-Barokah Guru : Alfi M.Pd.KeLas / SMT : VII / II Pelajaran :Fisika

NomorNama SiswaNilai Harian Nilai UAS Nilai AkhirNilai Huruf PeringkatKeterangan

Urt No Ujian01 28295321 Rusmina 72.25 75.25 74.25 B 1 BAIK02 28295322 Cicih 65.25 55.25 58.58 C 11 SEDANG03 28295323 Diana 60.25 52.25 54.92 D 13 KURANG04 28295324 Julia 75.25 65.25 68.58 B 3 BAIK05 28295325 Rahmat 55.25 65.25 61.92 C 8 SEDANG06 28295326 Ramadhan 52.25 65.25 60.92 C 10 SEDANG07 28295327 Mintarsih 65.25 60.25 61.92 C 8 SEDANG08 28295328 Kokom 45.25 75.25 65.25 B 5 BAIK09 28295329 Udin 65.25 75.00 71.75 B 2 BAIK10 28295330 Jamal 70.00 65.00 66.67 B 4 BAIK11 28295331 Kurnia 80.00 45.00 56.67 C 12 SEDANG12 28295332 Mustika 65.00 65.00 65.00 B 6 BAIK13 28295333 Maemunah 45.00 75.00 65.00 B 6 BAIK14 28295334 Siti 65.25 55.25 58.58 C 11 SEDANG15 28295335 Andini P 35.56 60.00 51.85 D 14 KURANG

terkecil 35.56 45.00 51.85terbesar 80.00 75.25 74.25rata-rata 61.14 63.62 62.79

Page 9: PRAKTEK EXCEL 2.xlsx

DEPARTEMEN AGAMASEKOLAH TINGGI ISLAM AL - MUBAROKAH

FAKULTAS TARBIYAHJl. Raya Purnawarman No. 50 Tanjungpinag Sumatera Selatan

TRANSKIP NILAINo. FT / 132 / III / 08

Nama : Dede DahliaNIM : 204428607Jur./Prodi : Pendidikan Bahasa Inggris Fakultas : Tarbiyah dan Keguruan

Nomor Ijaza: FTK/S/.1/709/2008

No Kode Sks Nilai Ak No Kode Sks1 001 Ulumul Hadits 2 A 8 21 021 English Syntax 22 002 Ilmu Tafsir 3 A 12 22 022 Semantic 23 003 Ushul Fiqh 2 A 8 23 023 Extensive Reading 24 004 Ilmi Tauhid 2 A 8 24 024 Prose 25 005 Akhlaq Taswuf 2 A 8 25 025 Drama 26 006 Filsafat Islam 2 A 8 26 026 Interpreting 27 007 MSI 2 A 8 27 027 Translation I 28 008 IAD 2 A 8 28 028 Translation II 29 009 Pancasila 2 A 8 29 029 EFSI 3

10 010 Bahasa indonesia 2 A 8 30 030 Eng. For Academic 311 011 Bahasa Inggris 2 A 8 31 031 English For Business I 312 012 Bahasa Arab 2 A 8 32 032 English For Business II 313 013 Ilmu Pendidikan 2 A 8 33 033 RC I 214 014 Bimbingan Kons 2 A 8 34 034 RC II 215 015 ELT Management 2 A 8 35 035 RC III 216 016 CMD I 2 A 8 36 036 RC IV 217 017 CMD II 3 B 9 37 037 RC C 218 018 TEFL Methodolog 3 B 9 38 038 Writing I 219 019 Comp. Based As 3 B 9 39 039 Writing II 220 020 ELT Media 2 A 8 40 040 Writing III 2

44 167 44

Jumlah 343IPK 3.898

BobotA 4B 3C 2D 1E 0

0 Nol1 Satu2 dua 3 tiga4 empat

Page 10: PRAKTEK EXCEL 2.xlsx

5 lima6 enam7 tujuh8 delapan9 sembilan

Page 11: PRAKTEK EXCEL 2.xlsx

DEPARTEMEN AGAMASEKOLAH TINGGI ISLAM AL - MUBAROKAH

FAKULTAS TARBIYAHJl. Raya Purnawarman No. 50 Tanjungpinag Sumatera Selatan

TRANSKIP NILAINo. FT / 132 / III / 08

Nilai AkA 8A 8A 8A 8A 8A 8A 8A 8A 12A 12A 12A 12A 8A 8A 8A 8A 8A 8A 8A 8

176

BACK

Page 12: PRAKTEK EXCEL 2.xlsx

CONTOH FUNGSI GABUNGANKode Barang Nama Barang Harga Barang Jumlah Barang Bayar100A001 Keyboard&Mouse Rp 100.000 2 Rp 200.000 200B002 HARDISK Rp 500.000 3 Rp 1,500.000 300C003 MAINBOARD Rp 750.000 4 Rp 3,000.000 400D004 MONITOR Rp 1,500.000 2 Rp 3,000.000 400E005 CPU Rp 1,500.000 2 Rp 3,000.000

Kode Nama BarangA Keyboard&MouseB HARDISKC MAINBOARDD MONITORE CPU

Kode 100 200 300 400 500Harga Rp 100.000 Rp 500.000 Rp 750.000 Rp 1,500.000 Rp 2,000.000

Page 13: PRAKTEK EXCEL 2.xlsx

BACK

Page 14: PRAKTEK EXCEL 2.xlsx

No123456789

1011121314151617181920212223242526272829303132333435363738394041424344454647

Page 15: PRAKTEK EXCEL 2.xlsx

484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495

Page 16: PRAKTEK EXCEL 2.xlsx

96979899

Page 17: PRAKTEK EXCEL 2.xlsx

DAFTAR HADIR SEMESTER GENAP 2012/2013MADRASAH ALIYAH AL SYASIYAH

Mata Pelajaran : FisikaGuru Bidang Studi : Sofariatul BadriahKelas/Smt : XI A/ Genap

NomorNama Siswa

pertemuan ke-Urt NIM 1 2 3 4 5 6 7 8 9 10 1101 10111001 Farid Maruf h h h h h h h h h h s02 10111002 Fitriatul Faridah h h h h h h a h h h h03 10111003 Hendi Suhendi h h h h h h h h h h a04 10111004 Ida Wahidah h h h h h h i h h h h05 10111005 Novyanti a h h h h h h h h h s06 10111006 Iwan Suwandi i h h h h h s h h h h07 10111007 Jaini h h h h h h h h h h h08 10111008 kartika h h a h h h h h h h h09 10111009 Lili Mulyadi h h s h h h h h h h h10 10111010 Momon Dahman h h i h h h h h h h h11 10111011 Muriyanto h h h h h h h h h h h12 10111012 Nina Rusmina h h h h h h h h h h h13 10111013 Noviani Cicih h h h h h h h h h h h14 10111014 Romi Diana h h h h h h h h h h h15 10111015 Sarmo h h h h s h h h h h h

h Hadir 0 0 0 0 0 0 0 0 0 0 0s Sakit 0 0 0 0 0 0 0 0 0 0 0i Ijin 0 0 0 0 0 0 0 0 0 0 0

a Alfa 0 0 0 0 0 0 0 0 0 0 0

Page 18: PRAKTEK EXCEL 2.xlsx

DAFTAR HADIR SEMESTER GENAP 2012/2013MADRASAH ALIYAH AL SYASIYAH

pertemuan ke- jml nilaiNilai Hadir

12 13 14 15 16 s i a hh i h s a 2 1 1 12 84.375h h h h h 0 0 1 15 93.75h h h h h 0 0 1 15 93.75h h h h h 0 1 0 15 96.875h h h h h 1 0 1 14 90.625h h h h h 1 1 0 14 93.75h h h h h 0 0 0 16 100h h h h h 0 0 1 15 93.75h h h h h 1 0 0 15 96.875h h h h h 0 1 0 15 96.875h h h h h 0 0 0 16 100s h h h h 1 0 0 15 96.875i h h h h 0 1 0 15 96.875h h h h h 0 0 0 16 100h h h h h 1 0 0 15 96.875

0 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 0

Page 19: PRAKTEK EXCEL 2.xlsx

FORMAT UAS GANJILTAHUN AJARAN 2013/2014

MADRASAH ALIYAH AL ISTIQOMAH

No Nama siswano soal kunci dan jawaban

kkm 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20B A A B c d E E A B C D A C D B A B E D

1 adi yaksa 70 B A C D C D E E A B D A A B B B A B E D2 agung nugraha 70 B A C B C D E E A B D A B E D3 furi chorina 704 rifki 705 anis 70

Jumlah jawaban benar tiap soalSlah

jumlah siswa yang menjawab

Page 20: PRAKTEK EXCEL 2.xlsx

FORMAT UAS GANJILTAHUN AJARAN 2013/2014

MADRASAH ALIYAH AL ISTIQOMAHJumlah no soal dan score uraian nilai

peringkat keteranganPG 1 2 3 4 5 urhuruf

20 5 10 5 5 10 20 1 2 315 4 5 6 8 6 29 0 5 1 1 0

3 1 3 5 7 6 22 43.5 3 1 1 15 2 5 4 3 5 19 46 2 1 1 14 2 4 5 6 7 24 50 1 0 0 00 2 4 4 5 6 21 31.5 4 0 0 0

1 1 11 1 1

ABCD

akhir 100

Page 21: PRAKTEK EXCEL 2.xlsx

4 50 11 10 10 00 01 11 1