Note: Homework = 10% , Quiz = 20% , Exams = 45% , Final Exam = 25%
This is the formula I used to calculate your overall average:
[0.45 * (Exam Average) + (Homework Average) + 2* (Quiz Average)]/0.75
Should you have any questions, email me.
HA = Homework Average , QA = Quiz Average , OA = Overall Average
Column A = The total points (out of 100) you would need to score on the final exam in order to earn an "A" in the class.
Column B = The total points (out of 100) you would need to score on the final exam in order to earn a "B" in the class.
Column C = The total points (out of 100) you would need to score on the final exam in order to earn a "C" in the class.
|
|
|
E1 |
E2 |
E3 |
E4 |
E5 |
EA |
HA |
QA |
OA |
A |
B |
C |
|
1 |
900538955 |
96 |
96 |
97 |
96 |
84 |
96.25 |
5.27 |
9.14 |
89.14 |
92.58 |
52.58 |
12.58 |
|
2 |
900181658 |
104 |
97 |
92 |
90 |
107 |
100 |
10.00 |
10.14 |
100.36 |
58.91 |
18.91 |
-21.09 |
|
3 |
900489349 |
75 |
83 |
82 |
92 |
0 |
83 |
7.50 |
5.23 |
73.74 |
138.78 |
98.78 |
58.78 |
|
4 |
900563025 |
74 |
57 |
68 |
87 |
91 |
80 |
5.81 |
6.77 |
73.80 |
138.59 |
98.59 |
58.59 |
|
5 |
900509950 |
75 |
71 |
78 |
67 |
38 |
72.75 |
8.19 |
7.18 |
73.72 |
138.83 |
98.83 |
58.83 |
|
6 |
900552367 |
43 |
33 |
72 |
61 |
78 |
63.5 |
6.92 |
6.14 |
63.69 |
168.92 |
128.92 |
88.92 |
|
7 |
900563310 |
101 |
70 |
93 |
87 |
0 |
87.75 |
4.04 |
7.00 |
76.70 |
129.90 |
89.90 |
49.90 |
|
8 |
900551050 |
83 |
90 |
90 |
90 |
78 |
88.25 |
1.92 |
8.59 |
78.42 |
124.73 |
84.73 |
44.73 |
|
9 |
900562687 |
49 |
63 |
81 |
87 |
76 |
76.75 |
9.35 |
9.18 |
83.00 |
111.01 |
71.01 |
31.01 |
|
10 |
900483509 |
97 |
90 |
92 |
88 |
86 |
91.75 |
5.35 |
8.73 |
85.45 |
103.65 |
63.65 |
23.65 |
|
11 |
900563112 |
78 |
82 |
85 |
79 |
82 |
82 |
6.46 |
6.09 |
74.06 |
137.83 |
97.83 |
57.83 |
|
12 |
900552902 |
59 |
78 |
70 |
32 |
60 |
66.75 |
8.96 |
8.32 |
74.18 |
137.46 |
97.46 |
57.46 |
|
13 |
900565001 |
89 |
90 |
90 |
71 |
86 |
88.75 |
9.88 |
9.82 |
92.61 |
82.17 |
42.17 |
2.17 |
|
14 |
900470210 |
37 |
39 |
18 |
0 |
37 |
32.75 |
5.04 |
4.82 |
39.22 |
242.35 |
202.35 |
162.35 |
|
15 |
900562231 |
82 |
70 |
98 |
84 |
96 |
90 |
9.62 |
9.50 |
92.15 |
83.54 |
43.54 |
3.54 |
|
16 |
900554788 |
33 |
48 |
43 |
20 |
19 |
36 |
4.08 |
3.95 |
37.58 |
247.26 |
207.26 |
167.26 |
|
17 |
900548612 |
48 |
44 |
69 |
50 |
61 |
57 |
7.38 |
6.27 |
60.77 |
177.68 |
137.68 |
97.68 |
|
18 |
900565321 |
71 |
61 |
40 |
77 |
29 |
62.25 |
4.15 |
4.77 |
55.62 |
193.15 |
153.15 |
113.15 |
|
19 |
900428824 |
59 |
60 |
91 |
50 |
47 |
65 |
9.35 |
7.64 |
71.83 |
144.52 |
104.52 |
64.52 |
|
20 |
900563023 |
38 |
42 |
56 |
48 |
49 |
48.75 |
8.69 |
6.09 |
57.08 |
188.75 |
148.75 |
108.75 |
|
21 |
900565080 |
96 |
0 |
76 |
64 |
86 |
80.5 |
6.88 |
7.73 |
78.09 |
125.74 |
85.74 |
45.74 |
|
22 |
900575490 |
106 |
100 |
105 |
100 |
107 |
104.5 |
10.00 |
10.36 |
103.67 |
48.99 |
8.99 |
-31.01 |
|
23 |
900548637 |
65 |
56 |
57 |
24 |
76 |
63.5 |
5.23 |
7.41 |
64.83 |
165.50 |
125.50 |
85.50 |
|
24 |
900476851 |
72 |
65 |
63 |
54 |
73 |
68.25 |
6.04 |
6.50 |
66.33 |
161.00 |
121.00 |
81.00 |
|
25 |
900541029 |
57 |
65 |
79 |
58 |
77 |
69.75 |
7.58 |
7.86 |
72.92 |
141.23 |
101.23 |
61.23 |
|
26 |
900534938 |
93 |
67 |
63 |
4 |
0 |
56.75 |
4.19 |
4.86 |
52.61 |
202.17 |
162.17 |
122.17 |
|
27 |
900552839 |
67 |
60 |
43 |
33 |
0 |
50.75 |
5.58 |
4.86 |
50.86 |
207.43 |
167.43 |
127.43 |
|
28 |
900565801 |
68 |
51 |
28 |
81 |