Demo School F.1A
Student No. Name Test 1 (20%) Test 2 (20%) Exam (60%) Average
1 Lucy 57 58 90 77
2 Moon 75 84 25 46.8
3 Nancy 72 95 82 82.6
4 O 76 25 84 70.6
5 Polly 53 53 63 59
6 Q 63 85 63 67.4
7 Roy 80 96 93 91
8 Susan 95 48 82 77.8
9 Yan 73 37 72 65.2
10 Ann 48 63 94 78.6
11 Bonnie 53 43 14 27.6
12 Candy 74 72 27 45.4
13 Don 63 62 82 74.2
14 E 69 55 16 34.4
15 F 55 94 37 52
16 GiGi 26 84 82 71.2
17 Helen 58 78 82 76.4
18 Ivy 94 64 72 74.8
19 John 41 52 93 74.4
20 Kary 22 64 26 32.8
Frequency Table
Grade Freq Curn. Freq Cun Freq. %
A 1 1 5
A- 1 2 10
B+ 7 9 45
B 2 11 55
B- 1 12 60
C+ 1 13 65
C 1 14 70
C- 0 14 70
D 1 15 75
F 5 20 100
Total 20
Frequency Distribution
8
6
4
No
2
4
No
2
0
A A- B+ B B- C+ C C- D F
Grade
A
PositionGrade Conversion Table for Total
5 B+ 0F
16 F 1F
2 A- 2F
11 B 3F
14 C 4F
12 B- 5F
1A 6F
4 B+ 7F
13 C+ 8F
3 B+ 9F
20 F 10 F
17 F 11 F
9 B+ 12 F
18 F 13 F
15 D 14 F
10 B 15 F
6 B+ 16 F
7 B+ 17 F
8 B+ 18 F
19 F 19 F
20 F
21 F
22 F
23 F
24 F
25 F
26 F
27 F
28 F
29 F
30 F
31 F
32 F
33 F
34 F
35 F
36 F
37 F
38 F
39 F
40 F
41 F
42 F
43 F
44 F
45 F
46 F
47 F
48 F
49 F
50 D
51 D
52 D
53 D
54 C-
55 C-
56 C-
57 C-
58 C
59 C
60 C
61 C
62 C+
63 C+
64 C+
65 C+
66 B-
67 B-
68 B-
69 B-
70 B
71 B
72 B
73 B
74 B+
75 B+
76 B+
77 B+
78 B+
79 B+
80 B+
81 A-
82 A-
83 A-
84 A-
85 A-
86 A
87 A
88 A
89 A
90 A
91 A
92 A
93 A
94 A
95 A
96 A
97 A
98 A
99 A
100 A
Demo School F.1A
Student No. Name Test 1 Test 2 Exam Aveage Position Grade
1 Ann 57 58 90 70.5 11 B
2 Bonnie 75 84 25 46.8 16 F
3 Candy 72 95 82 82.6 2 A-
4 Don 76 25 84 70.6 10 B
5 E 53 53 63 59 14 C
6 F 63 85 63 67.4 12 B-
7 GiGi 80 96 93 91 1 A
8 Helen 95 48 82 77.8 4 B+
9 Ivy 73 37 72 65.2 13 C+
10 John 48 63 94 78.6 3 B+
11 Kary 53 43 14 27.6 20 F
12 Lucy 74 72 27 45.4 17 F
13 Moon 63 62 82 74.2 8 B+
14 Nancy 69 55 16 34.4 18 F
15 O 55 94 37 52 15 D
16 Polly 26 84 82 71.2 9 B
17 Q 58 78 82 76.4 5 B+
18 Roy 94 64 72 74.8 6 B+
19 Susan 41 52 93 74.4 7 B+
20 Yan 22 64 26 32.8 19 F
Frequency Table
Grade Freq Curn. Freq Cun Freq. %
A 1 1 5
A- 1 2 10
B+ 6 8 40
B 3 11 55
B- 1 12 60
C+ 1 13 65
C 1 14 70
C- 0 14 70
D 1 15 75
F 5 20 100
Total 20
Frequency Distribution
8
8
6
4
No 2
0
A A- B+ B B- C+ C C- D F
Grade
1
wt. Of test wt. Of test wt. Of test 3
2
30% 30% 40%
63.635
Grand Average of the whole class:
Standard Deviation: 17.9099
Grand Average Test 2
63.635 10% 20% 30%
Test 1 10% 64.285 64.125 63.965
20% 64.12 63.96 63.8
30% 63.955 63.795 63.635
Standard Deviation Test 2
17.90987 10% 20% 30%
Test 1 10% 18.4013 18.23862 18.10278
20% 18.23396 18.09898 17.99146
30% 18.0952 17.98855 17.90987