HASIL YUDISIUM SEMESTER
POLITEKNIK UNAND PADANG
Fungsi-fungsi formula yang di gunakan :
1. 1. SUM : untuk menjumlahkan data sel
Caranya :
a. Ketik =SUM
b. Ketik buka kurung
c. Blok range data sel yang akan d jumlahkan
d. Ketik tutup kurung
e. Enter
22. AVERAGE : untuk mencari nilai rata-rata suatu range
Caranya :
a. Ketik =AVERAGE
b. Ketik buka kurung
c. Blok range data sel yang akan di gunakan
d. Ketik tutup kurung
e. Enter
3.3. MAX : untuk mencari nilai tertinggi
Caranya :
a. Ketik =MAX
b. Ketik buka kurung
c. Blok range data yang akan di gunakan
d. Ketik tutup kurung
e. Enter
44.MIN : untuk mencari nilai terendah
Caranya :
a. Ketik =MIN
b. Ketik buka kurung
c. Blok range data yang akan di gunakan
d. Ketik tutup kurung
e. Enter
5. 5. COUNTIF : untuk mencari banyaknya data dari suatu range
Contohnya :
=IF(AND(P9>=2,R9<1),"Lulus","Tidak Lulus")
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 | |||||||
3 | Madion | 90.0 | A | 4 | 79.0 | B | 3 | 90.0 | A | 4 | 60.0 | C | 2 | 319.0 | 3.08 | 0 | 0 | Lulus |
5 | M.Arif | 87.0 | A | 4 | 84.0 | A | 4 | 79.0 | B | 3 | 65.0 | C | 2 | 315.0 | 3.08 | 0 | 0 | Lulus |
1 | Jhoni Eka Putra | 78.0 | B | 3 | 84.0 | A | 4 | 81.0 | A | 4 | 78.0 | B | 3 | 321.0 | 3.50 | 0 | 0 | Lulus |
11 | Patrio Soneta | 85.0 | A | 4 | 80.0 | A | 4 | 81.0 | A | 4 | 67.0 | C | 2 | 313.0 | 3.33 | 0 | 0 | Lulus |
2 | Andri Fahmi | 94.0 | A | 4 | 56.0 | D | 1 | 87.0 | A | 4 | 80.0 | A | 4 | 317.0 | 3.25 | 1 | 0 | Lulus |
10 | Zalvinaldi | 89.0 | A | 4 | 78.0 | B | 3 | 71.0 | B | 3 | 68.0 | C | 2 | 306.0 | 2.83 | 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 |
13 | Vera Arizona | 91.0 | A | 4 | 71.0 | B | 3 | 81.0 | A | 4 | 50.5 | D | 1 | 293.5 | 2.75 | 1 | 0 | Lulus |
17 | Erizal | 85.0 | A | 4 | 83.0 | A | 4 | 78.0 | B | 3 | 53.5 | D | 1 | 299.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 |
4 | Husni Wenti | 88.0 | A | 4 | 80.0 | A | 4 | 81.0 | A | 4 | 44.0 | E | 0 | 293.0 | 2.67 | 0 | 1 | Tidak Lulus |
27 | Syukri Hamdani | 90.0 | A | 4 | 60.0 | C | 2 | 89.0 | A | 4 | 55.0 | D | 1 | 294.0 | 2.50 | 1 | 0 | Lulus |
40 | Muhammad Abrar | 87.0 | A | 4 | 73.0 | B | 3 | 70.0 | B | 3 | 55.5 | D | 1 | 285.5 | 2.50 | 1 | 0 | Lulus |
14 | Andre Devara | 92.0 | A | 4 | 75.0 | B | 3 | 81.0 | A | 4 | 46.0 | E | 0 | 294.0 | 2.42 | 0 | 1 | Tidak Lulus |
21 | Derit Wirrya Fitri | 95.0 | A | 4 | 83.0 | A | 4 | 80.0 | A | 4 | 43.0 | E | 0 | 301.0 | 2.67 | 0 | 1 | Tidak Lulus |
22 | Riki Juwito | 86.0 | A | 4 | 59.0 | D | 1 | 61.0 | C | 2 | 78.0 | B | 3 | 284.0 | 2.42 | 1 | 0 | Lulus |
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 | Tidak 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 |
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 |
43 | Marlina | 80.0 | A | 4 | 58.0 | D | 1 | 70.0 | B | 3 | 87.0 | A | 4 | 295.0 | 3.00 | 1 | 0 | Lulus |
12 | Reni Juita | 89.0 | A | 4 | 69.0 | C | 2 | 72.0 | B | 3 | 56.0 | D | 1 | 286.0 | 2.25 | 1 | 0 | Lulus |
20 | Hendri Yadi | 90.0 | A | 4 | 55.0 | D | 1 | 81.0 | A | 4 | 58.0 | D | 1 | 284.0 | 2.25 | 2 | 0 | Lulus |
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 |
15 | Meri Gusnita | 95.0 | A | 4 | 83.0 | A | 4 | 69.0 | C | 2 | 45.0 | E | 0 | 292.0 | 2.17 | 0 | 1 | Tidak Lulus |
25 | Mhd Arfansyah | 89.0 | A | 4 | 67.0 | C | 2 | 82.0 | A | 4 | 45.0 | E | 0 | 283.0 | 2.17 | 0 | 1 | Tidak Lulus |
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 | Tidak Lulus |
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 | Tidak Lulus |
42 | Afdianto | 92.0 | A | 4 | 84.0 | A | 4 | 63.0 | C | 2 | 43.0 | E | 0 | 282.0 | 2.17 | 0 | 1 | Tidak Lulus |
7 | Suherdian | 85.0 | A | 4 | 68.0 | C | 2 | 66.0 | C | 2 | 69.0 | C | 2 | 288.0 | 2.33 | 0 | 0 | Lulus |
26 | Fitri Yulia M | 86.0 | A | 4 | 58.0 | D | 1 | 68.0 | C | 2 | 64.0 | C | 2 | 276.0 | 2.08 | 1 | 0 | Lulus |
47 | Juprial | 93.0 | A | 4 | 46.0 | E | 0 | 73.0 | B | 3 | 65.0 | C | 2 | 277.0 | 2.08 | 0 | 1 | Tidak Lulus |
19 | Misdar Fitri Yeni | 73.0 | B | 3 | 56.0 | D | 1 | 66.0 | C | 2 | 66.0 | C | 2 | 261.0 | 1.92 | 1 | 0 | Tidak Lulus |
32 | Sugging Probowo | 89.0 | A | 4 | 69.0 | C | 2 | 75.0 | B | 3 | 43.0 | E | 0 | 276.0 | 1.92 | 0 | 1 | Tidak Lulus |
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 | Tidak Lulus |
35 | Rahmad Syah Mulia | 90.0 | A | 4 | 68.0 | C | 2 | 73.0 | B | 3 | 43.0 | E | 0 | 274.0 | 1.92 | 0 | 1 | Tidak Lulus |
36 | Citra Anisa Putri | 87.0 | A | 4 | 67.0 | C | 2 | 70.0 | B | 3 | 78.0 | B | 3 | 302.0 | 2.92 | 0 | 0 | Lulus |
37 | Syafriandi | 86.0 | A | 4 | 69.0 | C | 2 | 75.0 | B | 3 | 89.0 | A | 4 | 319.0 | 3.25 | 0 | 0 | Lulus |
39 | Julia Efanda | 91.0 | A | 4 | 69.0 | C | 2 | 73.0 | B | 3 | 56.0 | D | 1 | 289.0 | 2.25 | 1 | 0 | Lulus |
41 | Kardimas | 88.0 | A | 4 | 76.0 | B | 3 | 66.0 | C | 2 | 43.0 | E | 0 | 273.0 | 1.92 | 0 | 1 | Tidak Lulus |
16 | Tomi Firmansyah | 84.0 | A | 4 | 46.0 | E | 0 | 69.0 | C | 2 | 67.5 | 70 | ### | 266.5 | 1.17 | 0 | 1 | Tidak Lulus |
23 | Andres Boni Fatio | 88.0 | A | 4 | 56.0 | D | 1 | 69.0 | C | 2 | 56.0 | D | 1 | 269.0 | 1.75 | 2 | 0 | Tidak Lulus |
45 | Dien Novita | 81.0 | A | 4 | 49.0 | E | 0 | 72.0 | B | 3 | 58.0 | D | 1 | 260.0 | 1.75 | 1 | 1 | Tidak Lulus |
28 | Afrinal Efendi | 81.0 | A | 4 | 69.0 | C | 2 | 66.0 | C | 2 | 45.0 | E | 0 | 261.0 | 1.67 | 0 | 1 | Tidak Lulus |
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 | Tidak Lulus |
33 | Irsal | 73.0 | B | 3 | 49.0 | E | 0 | 67.0 | C | 2 | 68.0 | C | 2 | 257.0 | 1.67 | 0 | 1 | Tidak Lulus |
46 | Yusnita | 89.0 | A | 4 | 46.0 | E | 0 | 81.0 | A | 4 | 45.0 | E | 0 | 261.0 | 1.67 | 0 | 2 | Tidak Lulus |
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 | Tidak 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 | Tidak Lulus |
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 | Tidak Lulus |
49 | Armanto | 81.0 | A | 4 | 57.0 | D | 1 | 68.0 | C | 2 | 45.0 | E | 0 | 251.0 | 1.42 | 1 | 1 | Tidak Lulus |
NILAI RERATA | 87.5 | 66.9 | 73.8 | 56.8 | ||||||||||||||
NILAI TERTINGGI | 95.0 | 84.0 | 90.0 | 89.0 | ||||||||||||||
NILAI TERENDAH | 73.0 | 44.0 | 61.0 | 42.5 |