| DAFTAR NILAI AKHIR TIK | |||||||||
| No Urut | NIS | Nama | Nilai | NILAI RATA-RATA | NILAI AKHIR | Keterangan | |||
| Tugas | Ulangan | Ujian | |||||||
| 1 | B | 0221 | Abdal | 65 | 50 | 70 | 61,67 | 61,88 | gagal |
| 2 | B | 0251 | Abdul | 65 | 75 | 75 | 71,67 | 73,75 | lulus |
| 3 | B | 0250 | Ami | 70 | 90 | 65 | 75,00 | 75,00 | lulus |
| 4 | B | 0269 | Angga | 70 | 90 | 55 | 71,67 | 70,00 | lulus |
| 5 | B | 0288 | Bondan | 45 | 60 | 65 | 56,67 | 60,63 | gagal |
| 6 | B | 0370 | Dohan | 55 | 86 | 65 | 68,67 | 71,63 | lulus |
| 7 | B | 0326 | Fian | 65 | 60 | 65 | 63,33 | 63,13 | gagal |
| 8 | B | 0354 | Imba | 75 | 60 | 65 | 66,67 | 64,38 | gagal |
| 9 | B | 0364 | Indra | 65 | 89 | 65 | 73,00 | 74,00 | lulus |
| 10 | B | 0383 | Nina | 70 | 90 | 65 | 75,00 | 75,00 | lulus |
| 11 | B | 0385 | Rafi | 70 | 90 | 55 | 71,67 | 70,00 | lulus |
| 12 | B | 0358 | Raka | 80 | 90 | 65 | 78,33 | 76,25 | lulus |
| 13 | B | 0386 | Rana | 70 | 90 | 83 | 81,00 | 84,00 | lulus |
| 14 | B | 0378 | Rika | 80 | 50 | 65 | 65,00 | 61,25 | gagal |
| 15 | B | 0382 | Rinda | 70 | 75 | 90 | 78,33 | 81,88 | lulus |
| 16 | B | 0380 | Zidan | 45 | 90 | 65 | 66,67 | 71,88 | lulus |
| Banyaknya Siswa | 16 | ||||||||
| Total Nilai | 1060 | ||||||||
| Rata-rata Nilai Seluruhnya | 66,25 | ||||||||
| Nilai Ulangan Tertinggi | 90 | ||||||||
| Rata-rata Terendah | 56,67 | ||||||||
| Nilai Akhir = | (Tugas + 3*Ulangan + 4*Ujian) | ||||||||
| 8 | |||||||||
| Keterangan : >=70"LULUS";"GAGAL" | |||||||||
| Formula | : =IF(Cell>=70;"lulus";"gagal") | ||||||||
