Physics 111 - Fall 2009
A couple of comments about this grade sheet:
- The HW Total column
represents the total points available for homework (similarly for Lab Total).
Scaled Grade
corresponds to your current grade as calculated using the weightings specified in
the syllabus. %-age corresponds to your
overall percentage out of the total possible (from Scaled Grade).
Mod Exam is the current total of your exam points while making your highest exam score worth 1.5 times its actual value.
- If you notice any errors in the recording of your scores, please let me know.
- At the bottom of the spreadsheet, you can find the total points possible,
average scores, and the standard deviation for each assignment.
| Class ID |
HW #1 |
HW #2 |
HW #3 |
HW #4 |
HW #5 |
HW #6 |
HW #7 |
HW #8 |
Lab 1 |
Lab 2 |
Lab 3 |
Lab 4 |
Lab 5 |
Lab 6 |
Exam 1 |
Exam 2 |
HW Total |
Lab Total |
Exam Total |
Mod Exam |
Scaled Grade |
%-age |
| 105 |
77.5 |
90 |
110 |
60 |
100 |
100 |
110 |
50 |
63 |
77 |
117 |
75 |
83 |
87 |
78 |
68 |
697.5 |
502 |
146 |
185 |
68.5 |
85.7 |
| 106 |
90 |
21.66 |
102.5 |
50 |
- |
100 |
100 |
48.33 |
70 |
71 |
117 |
75 |
83 |
87 |
87 |
69 |
512.49 |
503 |
156 |
199.5 |
65.8 |
82.2 |
| 132 |
72.5 |
95 |
100 |
60 |
60 |
82.5 |
55 |
38.33 |
69 |
71 |
119 |
72 |
83 |
88 |
64 |
66 |
563.33 |
502 |
130 |
163 |
61.3 |
76.6 |
| 136 |
90 |
100 |
105 |
60 |
30 |
- |
50 |
48.33 |
63 |
75 |
119 |
74 |
|
88 |
94 |
71 |
483.33 |
419 |
165 |
212 |
63.7 |
79.6 |
| 152 |
70 |
81.66 |
100 |
60 |
50 |
82.5 |
66.25 |
40 |
68 |
71 |
119 |
73 |
82 |
88 |
63 |
63 |
550.41 |
501 |
126 |
157.5 |
60.0 |
75.0 |
| 184 |
90 |
100 |
102.5 |
60 |
93.75 |
100 |
110 |
50 |
66 |
77 |
117 |
75 |
83 |
84 |
92 |
82 |
706.25 |
502 |
174 |
220 |
74.4 |
93.0 |
| 213 |
85 |
100 |
105 |
55 |
90 |
92.5 |
105 |
50 |
63 |
77 |
112 |
75 |
83 |
88 |
95 |
81 |
682.5 |
498 |
176 |
223.5 |
74.1 |
92.7 |
| 225 |
85 |
92.5 |
105 |
45 |
- |
87.5 |
92.5 |
43.33 |
68 |
77 |
117 |
73 |
83 |
88 |
84 |
62 |
550.83 |
506 |
146 |
188 |
65.1 |
81.4 |
| 231 |
80 |
50 |
77.5 |
60 |
90 |
85 |
55 |
41.66 |
67 |
74 |
120 |
74 |
79 |
88 |
24 |
23 |
539.16 |
502 |
47 |
59 |
44.0 |
55.0 |
| 257 |
90 |
100 |
102.5 |
60 |
100 |
100 |
108.75 |
50 |
68 |
77 |
119 |
75 |
83 |
88 |
93 |
63 |
711.25 |
510 |
156 |
202.5 |
72.0 |
90.0 |
| 258 |
90 |
95 |
95 |
60 |
90 |
95 |
105 |
50 |
68 |
77 |
120 |
75 |
79 |
88 |
70 |
47 |
680 |
507 |
117 |
152 |
63.0 |
78.7 |
| 264 |
65 |
80 |
97.5 |
55 |
60 |
95 |
95 |
50 |
69 |
75 |
119 |
75 |
82 |
87 |
88 |
82 |
597.5 |
507 |
170 |
214 |
70.6 |
88.3 |
| 273 |
65 |
82.5 |
70 |
47.5 |
26.66 |
57.5 |
20 |
36.66 |
64 |
68 |
71 |
75 |
|
88 |
48 |
47 |
405.82 |
366 |
95 |
119 |
44.6 |
55.7 |
| 283 |
90 |
90.5 |
105 |
60 |
91.66 |
90 |
110 |
50 |
70 |
76 |
120 |
75 |
83 |
87 |
72 |
59 |
687.16 |
511 |
131 |
167 |
65.7 |
82.2 |
| 303 |
65 |
- |
67.5 |
30 |
65 |
- |
- |
- |
66 |
77 |
114 |
73 |
83 |
|
23 |
47 |
227.5 |
413 |
70 |
93.5 |
37.4 |
46.7 |
| 309 |
82.5 |
95 |
37.5 |
60 |
20 |
95 |
110 |
26.66 |
62 |
76 |
97 |
73 |
77 |
79 |
82 |
72 |
526.66 |
464 |
154 |
195 |
63.9 |
79.9 |
| 331 |
72.5 |
87.5 |
102.5 |
55 |
100 |
92.5 |
102.5 |
50 |
69 |
70 |
118 |
75 |
83 |
88 |
76 |
68 |
662.5 |
503 |
144 |
182 |
67.1 |
83.9 |
| 345 |
90 |
97.5 |
110 |
50 |
65 |
77.5 |
82.5 |
43.33 |
68 |
76 |
110 |
74 |
|
86 |
91 |
74 |
615.83 |
414 |
165 |
210.5 |
66.9 |
83.7 |
| 354 |
77.5 |
97.5 |
97.5 |
60 |
50 |
95 |
92.5 |
47.5 |
70 |
76 |
116 |
74 |
83 |
88 |
86 |
66 |
617.5 |
507 |
152 |
195 |
68.1 |
85.1 |
| 389 |
70 |
85 |
100 |
60 |
95 |
100 |
99.5 |
50 |
59 |
77 |
114 |
75 |
83 |
88 |
86 |
77 |
659.5 |
496 |
163 |
206 |
70.6 |
88.3 |
| 401 |
77.5 |
29.5 |
27.5 |
50 |
25 |
92.5 |
20 |
30.83 |
62 |
75 |
80 |
73 |
83 |
|
51 |
54 |
352.83 |
373 |
105 |
132 |
45.5 |
56.8 |
| 444 |
25 |
30 |
- |
- |
- |
- |
- |
- |
69 |
73 |
81 |
74 |
|
|
10 |
|
55 |
297 |
10 |
15 |
15.5 |
19.4 |
| 484 |
67.5 |
83.83 |
85 |
40 |
45 |
77.5 |
67.5 |
40 |
63 |
75 |
118 |
73 |
82 |
88 |
72 |
36 |
506.33 |
499 |
108 |
144 |
56.6 |
70.7 |
| 510 |
90 |
100 |
57.5 |
60 |
25 |
87.5 |
95 |
50 |
70 |
76 |
116 |
75 |
83 |
88 |
82 |
64 |
565 |
508 |
146 |
187 |
65.4 |
81.8 |
| 532 |
85 |
97.33 |
97.5 |
55 |
75 |
100 |
108.75 |
50 |
65 |
72 |
120 |
75 |
83 |
85 |
81 |
73 |
668.58 |
500 |
154 |
194.5 |
69.2 |
86.5 |
| 585 |
85 |
92.5 |
72.5 |
45 |
40 |
60 |
67.5 |
38.33 |
66 |
73 |
120 |
51 |
83 |
86 |
84 |
74 |
500.83 |
479 |
158 |
200 |
64.6 |
80.7 |
| 611 |
90 |
100 |
110 |
60 |
100 |
100 |
110 |
50 |
68 |
77 |
118 |
74 |
83 |
88 |
94 |
87 |
720 |
508 |
181 |
228 |
76.3 |
95.4 |
| 634 |
82.5 |
95 |
100 |
60 |
100 |
100 |
110 |
50 |
64 |
75 |
120 |
73 |
83 |
87 |
77 |
72 |
697.5 |
502 |
149 |
187.5 |
68.9 |
86.2 |
| 639 |
75 |
56.5 |
87.5 |
57.5 |
25 |
90 |
90 |
40 |
66 |
75 |
118 |
74 |
83 |
88 |
76 |
72 |
521.5 |
504 |
148 |
186 |
63.9 |
79.9 |
| 684 |
85 |
95 |
102.5 |
60 |
81.66 |
82.5 |
75 |
40 |
67 |
75 |
114 |
75 |
81 |
88 |
90 |
77 |
621.66 |
500 |
167 |
212 |
70.7 |
88.4 |
| 702 |
75 |
38 |
15 |
10 |
27.5 |
77.5 |
10 |
31.66 |
66 |
73 |
120 |
74 |
83 |
84 |
44 |
36 |
284.66 |
500 |
80 |
102 |
43.7 |
54.7 |
| 710 |
90 |
100 |
110 |
60 |
100 |
100 |
106.5 |
50 |
70 |
77 |
120 |
75 |
83 |
88 |
96 |
99 |
716.5 |
513 |
195 |
244.5 |
79.0 |
98.8 |
| 727 |
55 |
88.5 |
80 |
55 |
- |
65 |
10 |
- |
69 |
77 |
119 |
|
83 |
81 |
81 |
71 |
353.5 |
429 |
152 |
192.5 |
57.3 |
71.7 |
| 754 |
85 |
92.5 |
105 |
60 |
100 |
100 |
109 |
50 |
68 |
77 |
117 |
74 |
83 |
88 |
82 |
77 |
701.5 |
507 |
159 |
200 |
71.3 |
89.1 |
| 767 |
65 |
74.16 |
80 |
45 |
60 |
45 |
55 |
25 |
68 |
76 |
110 |
60 |
83 |
88 |
71 |
59 |
449.16 |
485 |
130 |
165.5 |
57.9 |
72.3 |
| 773 |
77.5 |
92.5 |
95 |
50 |
71.66 |
97.5 |
98.75 |
50 |
69 |
75 |
117 |
75 |
83 |
88 |
86 |
84 |
632.91 |
507 |
170 |
213 |
71.4 |
89.3 |
| 775 |
80 |
92.5 |
75 |
60 |
85 |
90 |
105 |
50 |
68 |
75 |
119 |
74 |
79 |
82 |
59 |
67 |
637.5 |
497 |
126 |
159.5 |
62.6 |
78.3 |
| 787 |
85 |
83.33 |
85 |
55 |
66.66 |
90 |
67.5 |
50 |
66 |
76 |
108 |
74 |
82 |
88 |
49 |
76 |
582.49 |
494 |
125 |
163 |
61.5 |
76.9 |
| 806 |
50 |
9.16 |
20 |
30 |
20 |
31.25 |
- |
20 |
69 |
75 |
82 |
75 |
82 |
88 |
60 |
55 |
180.41 |
471 |
115 |
145 |
46.6 |
58.2 |
| 840 |
75 |
90 |
92.5 |
55 |
72.5 |
92.5 |
105 |
48.33 |
70 |
76 |
116 |
74 |
83 |
88 |
79 |
78 |
630.83 |
507 |
157 |
196.5 |
68.7 |
85.9 |
| 851 |
87.5 |
100 |
107.5 |
60 |
95 |
100 |
102.5 |
50 |
70 |
74 |
120 |
75 |
83 |
88 |
72 |
85 |
702.5 |
510 |
157 |
199.5 |
71.3 |
89.1 |
| 889 |
90 |
100 |
110 |
55 |
90 |
87.5 |
70 |
15 |
68 |
77 |
115 |
75 |
79 |
86 |
67 |
50 |
617.5 |
500 |
117 |
150.5 |
60.7 |
75.9 |
| 890 |
90 |
97.5 |
55 |
42.5 |
46.66 |
65 |
51.25 |
48.33 |
70 |
75 |
115 |
70 |
83 |
88 |
76 |
83 |
496.24 |
501 |
159 |
200.5 |
65.4 |
81.7 |
| 899 |
75 |
95 |
87.5 |
52.5 |
85 |
82.5 |
105 |
48.33 |
70 |
69 |
120 |
74 |
79 |
86 |
75 |
59 |
630.83 |
498 |
134 |
171.5 |
64.4 |
80.5 |
| 913 |
90 |
100 |
110 |
60 |
- |
- |
- |
- |
63 |
76 |
115 |
|
|
|
91 |
|
360 |
254 |
91 |
136.5 |
41.7 |
52.2 |
| 922 |
70 |
73.33 |
60 |
30 |
47.5 |
52.5 |
32.5 |
40 |
61 |
74 |
119 |
70 |
83 |
86 |
93 |
66 |
405.83 |
493 |
159 |
205.5 |
63.4 |
79.2 |
| 959 |
90 |
100 |
107.5 |
60 |
95 |
100 |
97.5 |
50 |
64 |
75 |
119 |
75 |
79 |
88 |
86 |
70 |
700 |
500 |
156 |
199 |
70.8 |
88.5 |
| 978 |
75 |
87.5 |
57.5 |
52.5 |
75 |
87.5 |
16.25 |
45 |
63 |
75 |
86 |
71 |
83 |
88 |
67 |
90 |
496.25 |
466 |
157 |
202 |
64.3 |
80.3 |
| pts. poss. |
90 |
100 |
110 |
60 |
100 |
100 |
110 |
50 |
70 |
77 |
120 |
75 |
83 |
88 |
100 |
100 |
720 |
513 |
200 |
250 |
80 |
100 |
| average |
78.4 |
83.7 |
86.9 |
52.9 |
68.2 |
85.9 |
80.8 |
43.7 |
66.7 |
74.9 |
112.9 |
73.2 |
82.1 |
86.9 |
73.9 |
67.4 |
551.4 |
477.8 |
138.5 |
176.6 |
62.2 |
77.7 |
| std. dev. |
12.8 |
23.0 |
24.8 |
10.5 |
27.3 |
16.3 |
31.5 |
8.9 |
2.9 |
2.3 |
12.1 |
4.1 |
1.6 |
2.0 |
19.5 |
15.0 |
153.0 |
55.3 |
35.3 |
43.8 |
11.8 |
14.8 |