FORMULA:
=IF(COUNTIF(D7:M7,"-")=0,"A",IF(COUNTIF(D7:M7,"-")<3,"B",IF(COUNTIF(D7:M7,"-")<5,"C","D")))
NO | NAMA SISWA | NILAI | KET. |
1 | Adriana Ramadhani | 84 | LULUS |
2 | Almanda Lesa Herdhiyanti | 62 | TIDAK LULUS |
3 | Alim Wahyu Hadisasmito | 74 | LULUS |
4 | Anindya Shamara | 80 | LULUS |
5 | Davis Belmiro Satria | 74 | LULUS |
6 | Dian Mutiara Sofia | 72 | LULUS |
7 | Diati Fathania | 76 | LULUS |
8 | Enrico Chiesa Maulana | 76 | LULUS |
9 | Fauzia Widayati | 68 | TIDAK LULUS |
10 | Farhan Ramadan Alfarizi | 74 | LULUS |
11 | Hanjani Deandri Mutiara | 76 | LULUS |
12 | Indah Aulia Diani | 58 | TIDAK LULUS |
13 | Intan Tri Budiwardani | 72 | LULUS |
14 | Jeason Emanuelsihasale | 50 | TIDAK LULUS |
15 | Jeremy P | 70 | LULUS |
16 | Kartika Indriati H | 82 | LULUS |
17 | Larasati SH | 70 | LULUS |
18 | Muhammad Dzaky Prakara | 82 | LULUS |
19 | Muhammad Rayhan Firoos | 70 | LULUS |
20 | Muhammad Rizky Prayoga | 62 | TIDAK LULUS |
21 | Muhammad Yusuf Krisnamadana | 54 | TIDAK LULUS |
22 | Nabil Erga Kusumo Putra | 68 | TIDAK LULUS |
1 | Jumlah siswa yang lulus | | 22 |
2 | jumlah siswa yang tidak lulus | | 22 |
3 | Rata-rata nilai yang lulus | | 70.64 |
4 | Nilai terbesar yang lulus | | 84 |
5 | Nilai terkecil yang tidak lulus | | 50 |
NO. | NIS | NAMA | KELAS | NILAI SENI BUDAYA | RANK | |
1 | 6217 | Adriana Ramadhani | 8b | 80 | 13 | |
2 | 6260 | Almanda Lesa Herdhiyanti | 8b | 82 | 10 | |
3 | 6261 | Alim Wahyu Hadisasmito | 8b | 72 | 24 | |
4 | 6219 | Anindya Shamara | 8b | 51 | 30 | |
5 | 6220 | Davis Belmiro Satria | 8b | 88 | 6 | |
6 | - | Dian Mutiara Sofia | 8b | 42 | 32 | |
7 | 6265 | Diati Fathania | 8b | 77 | 16 | |
8 | 6242 | Enrico Chiesa Maulana | 8b | 74 | 22 | |
9 | - | Fauzia Widayati | 8b | 70 | 25 | |
10 | 6244 | Farhan Ramadan Alfarizi | 8b | 81 | 11 | |
11 | - | Hanjani Deandri Mutiara | 8b | 90 | 4 | |
12 | 6269 | Indah Aulia Diani | 8b | 75 | 21 | |
13 | 6224 | Intan Tri Budiwardani | 8b | 66 | 27 | |
14 | - | Jeason Emanuelsihasale | 8b | 59 | 29 | |
15 | - | Jeremy P | 8b | 49 | 31 | |
16 | 6226 | Kartika Indriati H | 8b | 83 | 9 | |
17 | 6228 | Larasati SH | 8b | 91 | 3 | |
18 | | Muhammad Dzaky Prakara | 8b | 92 | 2 | |
19 | 6272 | Muhammad Rayhan Firoos | 8b | 76 | 18 | |
20 | 6251 | Muhammad Rizky Prayoga | 8b | 89 | 5 | |
21 | 6270 | Muhammad Yusuf Krisnamadana | 8b | 79 | 14 | |
22 | 6230 | Nabil Erga Kusumo Putra | 8b | 84 | 8 | |
23 | 6274 | Rahma Dwikanusa Shavrina Putri | 8b | 79 | 14 | |
24 | 6275 | Rama Tri Putra | 8b | 77 | 16 | |
25 | 6276 | Raynaldi adityo | 8b | 76 | 18 | |
26 | 6233 | Refino Michael Ibrahim | 8b | 76 | 18 | |
27 | 6254 | Renaldo Herdiantoro | 8b | 66 | 27 | |
28 | | Reza Fadh Aji Putra | 8b | 70 | 25 | |
29 | 6236 | Shabrina Nadhila mawardini | 8b | 73 | 23 | |
30 | - | Vicky Erniza Andria | 8b | 88 | 6 | |
31 | 6258 | W.A.Didot P.J | 8b | 81 | 11 | |
32 | 6278 | Yoel Rananda Santoso | 8b | 96 | 1 |