Student Grade Pt. Value Average %
1 A 4 sum(D3:D12)/10 30
2 A 4
3 A 4
4 B 3 20
5 B 3
6 C 2 30
7 C 2
8 C 2
9 D 1 20
10 D 1 2.6