HASIL YUDISIUM SEMESTER
POLITEKNIK UNAND PADANG
NO | N A M A | MK 1 | MK 2 | MK3 | MK4 | Jumlah | IP | JML NILAI D | JML NILAI E | Status | ||||||||
2 | 3 | 3 | 4 | 12 | ||||||||||||||
NA | NM | AM | NA | NM | AM | NA | NM | AM | NA | NM | AM | |||||||
1 | Jhoni Eka Putra | 90.0 | A | 4 | 84.0 | A | 4 | 81.0 | A | 4 | 58 | D | 1 | 313.0 | 3.00 | 1 | 0 | LULUS |
2 | Andri Fahmi | 92.0 | A | 4 | 56.0 | D | 1 | 81.0 | A | 4 | 70.5 | B | 3 | 299.5 | 2.92 | 1 | 0 | LULUS |
3 | Madion | 89.0 | A | 4 | 77.0 | B | 3 | 81.0 | A | 4 | 65 | C | 2 | 312.0 | 3.08 | 0 | 0 | LULUS |
4 | Husni Wenti | 88.0 | A | 4 | 81.0 | A | 4 | 81.0 | A | 4 | 44 | E | 0 | 294.0 | 2.67 | 0 | 1 | TIDAKLULUS |
5 | M.Arif | 93.0 | A | 4 | 84.0 | A | 4 | 79.0 | B | 3 | 60 | C | 2 | 316.0 | 3.08 | 0 | 0 | LULUS |
6 | Yazril Mahdi | 93.0 | A | 4 | 59.0 | D | 1 | 77.0 | B | 3 | 68.5 | C | 2 | 297.5 | 2.33 | 1 | 0 | LULUS |
7 | Suherdian | 85.0 | A | 4 | 58.0 | D | 1 | 66.0 | C | 2 | 69 | C | 2 | 278.0 | 2.08 | 1 | 0 | LULUS |
8 | Rizki Rahmat | 87.0 | A | 4 | 69.0 | C | 2 | 69.0 | C | 2 | 62.5 | C | 2 | 287.5 | 2.33 | 0 | 0 | LULUS |
9 | Ezzuari Hasril | 91.0 | A | 4 | 74.0 | B | 3 | 81.0 | A | 4 | 50.5 | D | 1 | 296.5 | 2.75 | 1 | 0 | LULUS |
10 | Zalvinaldi | 91.0 | A | 4 | 74.0 | B | 3 | 71.0 | B | 3 | 61 | C | 2 | 297.0 | 2.83 | 0 | 0 | LULUS |
11 | Patrio Soneta | 87.0 | A | 4 | 80.0 | A | 4 | 81.0 | A | 4 | 50.5 | D | 1 | 298.5 | 3.00 | 1 | 0 | LULUS |
12 | Reni Juita | 89.0 | A | 4 | 69.0 | C | 2 | 72.0 | B | 3 | 56 | D | 1 | 286.0 | 2.25 | 1 | 0 | LULUS |
13 | Vera Arizona | 90.0 | A | 4 | 71.0 | B | 3 | 81.0 | A | 4 | 50.5 | D | 1 | 292.5 | 2.75 | 1 | 0 | LULUS |
14 | Andre Devara | 92.0 | A | 4 | 71.0 | B | 3 | 81.0 | A | 4 | 46 | E | 0 | 290.0 | 2.42 | 0 | 1 | TIDAKLULUS |
15 | Meri Gusnita | 95.0 | A | 4 | 83.0 | A | 4 | 69.0 | C | 2 | 45 | E | 0 | 292.0 | 2.17 | 0 | 1 | TIDAKLULUS |
16 | Tomi Firmansyah | 84.0 | A | 4 | 46.0 | E | 0 | 69.0 | C | 2 | 67.5 | C | 2 | 266.5 | 1.83 | 0 | 1 | TIDAKLULUS |
17 | Erizal | 85.0 | A | 4 | 83.0 | A | 4 | 73.0 | B | 3 | 53.5 | D | 1 | 294.5 | 2.75 | 1 | 0 | LULUS |
18 | Afdila | 87.0 | A | 4 | 83.0 | A | 4 | 74.0 | B | 3 | 50.5 | D | 1 | 294.5 | 2.75 | 1 | 0 | LULUS |
19 | Misdar Fitri Yeni | 73.0 | B | 3 | 56.0 | D | 1 | 66.0 | C | 2 | 66 | C | 2 | 261.0 | 1.92 | 1 | 0 | TIDAKLULUS |
20 | Hendri Yadi | 90.0 | A | 4 | 55.0 | D | 1 | 81.0 | A | 4 | 58 | D | 1 | 284.0 | 2.25 | 2 | 0 | LULUS |
21 | Derit Wirrya Fitri | 95.0 | A | 4 | 83.0 | A | 4 | 73.0 | B | 3 | 43 | E | 0 | 294.0 | 2.42 | 0 | 1 | TIDAKLULUS |
22 | Riki Juwito | 86.0 | A | 4 | 59.0 | D | 1 | 61.0 | C | 2 | 70.5 | B | 3 | 276.5 | 2.42 | 1 | 0 | LULUS |
23 | Andres Boni Fatio | 88.0 | A | 4 | 56.0 | D | 1 | 69.0 | C | 2 | 58 | D | 1 | 271.0 | 1.75 | 2 | 0 | TIDAKLULUS |
24 | Noviardi | 92.0 | A | 4 | 58.0 | D | 1 | 82.0 | A | 4 | 52.5 | D | 1 | 284.5 | 2.25 | 2 | 0 | LULUS |
25 | Mhd Arfansyah | 89.0 | A | 4 | 60.0 | C | 2 | 82.0 | A | 4 | 45 | E | 0 | 276.0 | 2.17 | 0 | 1 | TIDAKLULUS |
26 | Fitri Yulia M | 86.0 | A | 4 | 58.0 | D | 1 | 68.0 | C | 2 | 64 | C | 2 | 276.0 | 2.08 | 1 | 0 | LULUS |
27 | Syukri Hamdani | 90.0 | A | 4 | 60.0 | C | 2 | 81.0 | A | 4 | 55 | D | 1 | 286.0 | 2.50 | 1 | 0 | LULUS |
28 | Afrinal Efendi | 81.0 | A | 4 | 69.0 | C | 2 | 66.0 | C | 2 | 45 | E | 0 | 261.0 | 1.67 | 0 | 1 | TIDAKLULUS |
29 | Boni Firma Putra | 85.0 | A | 4 | 70.0 | B | 3 | 71.0 | B | 3 | 42.5 | E | 0 | 268.5 | 2.17 | 0 | 1 | TIDAKLULUS |
30 | Gema Neni Elfina | 95.0 | A | 4 | 67.0 | C | 2 | 69.0 | C | 2 | 47.5 | E | 0 | 278.5 | 1.67 | 0 | 1 | TIDAKLULUS |
31 | Rivo Stephano | 95.0 | A | 4 | 80.0 | A | 4 | 73.0 | B | 3 | 42.5 | E | 0 | 290.5 | 2.42 | 0 | 1 | TIDAKLULUS |
32 | Sugging Probowo | 89.0 | A | 4 | 69.0 | C | 2 | 75.0 | B | 3 | 43 | E | 0 | 276.0 | 1.92 | 0 | 1 | TIDAKLULUS |
33 | Irsal | 73.0 | B | 3 | 49.0 | E | 0 | 67.0 | C | 2 | 68 | C | 2 | 257.0 | 1.67 | 0 | 1 | TIDAKLULUS |
34 | Mona Vera Wati H | 88.0 | A | 4 | 74.0 | B | 3 | 68.0 | C | 2 | 43.5 | E | 0 | 273.5 | 1.92 | 0 | 1 | TIDAKLULUS |
35 | Rahmad Syah Mulia | 90.0 | A | 4 | 68.0 | C | 2 | 73.0 | B | 3 | 43 | E | 0 | 274.0 | 1.92 | 0 | 1 | TIDAKLULUS |
36 | Citra Anisa Putri | 87.0 | A | 4 | 67.0 | C | 2 | 70.0 | B | 3 | 47.5 | E | 0 | 271.5 | 1.92 | 0 | 1 | TIDAKLULUS |
37 | Syafriandi | 86.0 | A | 4 | 69.0 | C | 2 | 75.0 | B | 3 | 43.5 | E | 0 | 273.5 | 1.92 | 0 | 1 | TIDAKLULUS |
38 | Ima Hidayatul Fahmi | 92.0 | A | 4 | 70.0 | B | 3 | 72.0 | B | 3 | 42.5 | E | 0 | 276.5 | 2.17 | 0 | 1 | TIDAKLULUS |
39 | Julia Efanda | 91.0 | A | 4 | 69.0 | C | 2 | 73.0 | B | 3 | 43 | E | 0 | 276.0 | 1.92 | 0 | 1 | TIDAKLULUS |
40 | Muhammad Abrar | 87.0 | A | 4 | 73.0 | B | 3 | 74.0 | B | 3 | 55.5 | D | 1 | 289.5 | 2.50 | 1 | 0 | LULUS |
41 | Kardimas | 88.0 | A | 4 | 76.0 | B | 3 | 66.0 | C | 2 | 43 | E | 0 | 273.0 | 1.92 | 0 | 1 | TIDAKLULUS |
42 | Afdianto | 92.0 | A | 4 | 84.0 | A | 4 | 63.0 | C | 2 | 43 | E | 0 | 282.0 | 2.17 | 0 | 1 | TIDAKLULUS |
43 | Marlina | 80.0 | A | 4 | 58.0 | D | 1 | 70.0 | B | 3 | 64 | C | 2 | 272.0 | 2.33 | 1 | 0 | LULUS |
44 | Antonius | 79.0 | B | 3 | 58.0 | D | 1 | 69.0 | C | 2 | 56.5 | D | 1 | 262.5 | 1.58 | 2 | 0 | TIDAKLULUS |
45 | Dien Novita | 81.0 | A | 4 | 49.0 | E | 0 | 72.0 | B | 3 | 58 | D | 1 | 260.0 | 1.75 | 1 | 1 | TIDAKLULUS |
46 | Yusnita | 89.0 | A | 4 | 46.0 | E | 0 | 81.0 | A | 4 | 45 | E | 0 | 261.0 | 1.67 | 0 | 2 | TIDAKLULUS |
47 | Juprial | 93.0 | A | 4 | 46.0 | E | 0 | 73.0 | B | 3 | 65 | C | 2 | 277.0 | 2.08 | 0 | 1 | TIDAKLULUS |
48 | Febrianto Nasution | 90.0 | A | 4 | 44.0 | E | 0 | 68.0 | C | 2 | 58.5 | D | 1 | 260.5 | 1.50 | 1 | 1 | TIDAKLULUS |
49 | Armanto | 81.0 | A | 4 | 57.0 | D | 1 | 68.0 | C | 2 | 45 | E | 0 | 251.0 | 1.42 | 1 | 1 | TIDAKLULUS |
50 | Agus Sutrisno | 84.0 | A | 4 | 58.0 | D | 1 | 74.0 | B | 3 | 42.5 | E | 0 | 258.5 | 1.67 | 1 | 1 | TIDAKLULUS |
Fungsi masing-masing rumus yaitu:
1. SUM
Berfungsi sebagai menjumlahkan data yang akan dijumlah kan.
2. AVERAGE
Mengetahui rata-rata data sel yg akan diketahui nilai nya
3. MAX
Mengetahui nilai tertinggi,
4. MIN
Mencari nilai terkecil,
5. Countif
Berfungsi untuk mencari banyak data suata sel
6. IF
Menentukan nilai yang akan dicari.,