Nilai Akhir Semester
|
NO.
|
NAMA
|
Tanggal Pelaksanaan:
|
Th. Akademik 2013/2014
|
|||||
|
NIM
|
Dalam Angka
|
Nilai
|
Keterangan (L/TL)
|
|||||
|
xt
|
xm
|
Ft
|
Akhir
|
Huruf
|
||||
|
|
|
|
|
|
|
|
|
|
|
1
|
M. Zulfan
|
A1B1107082
|
80
|
80
|
74
|
77.6
|
B+
|
L
|
|
2
|
Risda Hidayati
|
A1B1109083
|
80
|
87
|
74
|
79.7
|
B+
|
L
|
|
3
|
Ellyanie
|
A1B1109084
|
75
|
80
|
76
|
76.9
|
B+
|
L
|
|
4
|
Yunita Halifah
|
A1B1109085
|
75
|
78
|
75
|
75.9
|
B+
|
L
|
|
5
|
Rianyanti
|
A1B1109086
|
80
|
80
|
78
|
79.2
|
B+
|
L
|
Nilai akhir : =((D5*3)+(E5*3)+(F5*4))/10
Nilai Huruf : =IF(G5>80,"A",IF(G5>75,"B+",IF(G5>70,"B")))
Keterangan : =IF(H5="A","L",IF(H5="B+","L",IF(H5="B","L")))
Tidak ada komentar:
Posting Komentar