olah nilai raport dengan miscrosoft excel
TRANSCRIPT
RUMUS :
(60% NILAI TUGAS DAN UH ) + 20% NILAI UTS + 20% NILAI UAS
KKM :…………………
MAPEL :………………..
NO NAMA SISWA ULANGAN HARIAN RATA TUGAS & PR R.PR & TUGAS R A+B+/2 60%R.TG
S/ PR UTS 20% UTS UAS 20% UKKNILAI
RAPOT
( E+F+G) 1 2 3 A 1 2 3 B D E TLS F G
1Khusnul Khalis Salafi 0 0 0 0 0.0 0 0
2Syafik Maulana 0 0 0 0 0.0 0 0
3Astuti
0 0 0 0 0.0 0 0
4Khusnul Khatimah 0 0 0 0 0.0 0 0
5Catur Wardana 0 0 0 0 0.0 0 0
6Muh.Nur Khalim 0 0 0 0 0.0 0 0
7Nadya Ayu Anggraini 0 0 0 0 0.0 0 0
8Muh.Syaiful Syafingi 0 0 0 0 0.0 0 0
9 Isna Mulyani 0 0 0 0 0.0 0 0
10Muh.Farhan Nuri
0 0 0 0 0.0 0 0
11Arifatul husni 0 0 0 0 0.0 0 0
12Rahmat Fauzan 0 0 0 0 0.0 0 0
13Zolanda Himawati 0 0 0 0 0.0 0 0
14Anas Afriana
0 0 0 0 0.0 0 0
15Muh.Indra Kurniawan 0 0 0 0 0.0 0 0
16Suranti 0 0 0 0 0.0 0 0
17Yudha Hadiyanto
0 0 0 0 0.0 0 0
18Shely Mei Indah Lestari 0 0 0 0 0.0 0 0
19Reza Julian Permana 0 0 0 0 0.0 0 0
20Arintya Tristanisah 0 0 0 0 0.0 0 0
21Tristi Susanti 0 0 0 0 0.0 0 0
22
21TR 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22TT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23JUMLAH 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24RATA-RATA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
KKM :……………
……
MAPEL :……………
…..
NO NAMA SISWA ULANGAN HARIAN RATA TUGAS & PR R.PR & TUGAS R A+B+/2 60%R.TGS
/ PR UTS 20% UTS UAS 20% UKKNILAI
RAPOT
( E+F+G) 1 2 3 A 1 2 3 B D E TLS F G
1Khusnul Khalis Salafi
0 0 0 0 0.0 0 0
2Syafik Maulana
0 0 0 0 0.0 0 0
3Astuti
0 0 0 0 0.0 0 0
4Khusnul Khatimah
0 0 0 0 0.0 0 0
5Catur Wardana
0 0 0 0 0.0 0 0
6Muh.Nur Khalim
0 0 0 0 0.0 0 0
7Nadya Ayu Anggraini
0 0 0 0 0.0 0 0
8Muh.Syaiful Syafingi
0 0 0 0 0.0 0 0
9Isna Mulyani
0 0 0 0 0.0 0 0
10Muh.Farhan Nuri
0 0 0 0 0.0 0 0
11Arifatul husni
0 0 0 0 0.0 0 0
12Rahmat Fauzan
0 0 0 0 0.0 0 0
13Zolanda Himawati
0 0 0 0 0.0 0 0
14Anas Afriana
0 0 0 0 0.0 0 0
15Muh.Indra Kurniawan
0 0 0 0 0.0 0 0
16Suranti
0 0 0 0 0.0 0 0
17Yudha Hadiyanto
0 0 0 0 0.0 0 0
18Shely Mei Indah Lestari
0 0 0 0 0.0 0 0
19Reza Julian Permana
0 0 0 0 0.0 0 0
20Arintya Tristanisah 0 0 0 0 0.0 0 0
21Tristi Susanti 0 0 0 0 0.0 0 0
22
21TR 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22TT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23JUMLAH 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
24RATA-RATA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Thank you.. Bisa langsung copy paste ke m. excel