The first 6 columns moving from left to right below are the Quiz #1 pts missed, Quiz #1 % grade, the Quiz #2 pts missed, Quiz #2 % grade,
the experiment report score if you have turned in an experiment, and the total number of 1S1P pts earned on Assignment #1

The writing grade estimate in the next column is based on both your experiment report grade and the total number of 1S1P pts you have earned.
It takes into account the fact that even though most students haven't yet earned 45 1S1P pts, they will have by the end of the semester.
An average experiment report grade (32 pts out of 40) is assumed for students that haven't turned in a report yet just so that you can see the
effect that the writing grade will have on your overall grade.

The last two columns provide an estimate of the grade you will have at the end of the semester if "you keep on doing as you have been doing so far" this semester.
The first average (no quizzes dropped) is the one that must be 90.0 or above in order to not have to take the Final Exam.
The second average drops your lowest quiz grade.

The extra credit points that many students have earned haven't yet been included in these estimates. 

Class ID Quiz #1 Q1(%) Quiz #2 Q2(%) Expt. 1S1P Asst. 1 Writing grade Overall average Overall average





report pts total estimate no quizzes dropped lowest quiz dropped
a0 -20 88.6 -24 86.7 0 10 73.1 84.7 84.7
a2 -30 82.9 -35 80.6 0 37 96.3 84.6 86.2
a3 -58 66.9 -60 66.7 0 10 73.1 68.0 68.4
a4 -18 89.7 -40 77.8 37.5 18 103.1 87.6 93.1
a5 -120 31.4 -51 71.7 0 0 40.0 49.2 63.8
a6 -30 82.9 -51 71.7 38 37 103.8 82.6 88.1
a7 -5 97.1 -15 91.7 0 40 96.3 94.8 96.9
a8 5 102.9 -35 80.6 35 20 100.0 93.4 102.1
a9 -105 40.0 -107 40.6 30 0 37.5 39.7 39.8
b0 -45 74.3 -52 71.1 32 35 96.3 77.4 79.8
b1 0 100.0 -10 94.4 34.5 9 72.9 92.4 93.2
b2 -65 62.9 -57 68.3 29 12.5 77.6 68.0 70.7
b3 -50 71.4 -29 83.9 0 19.5 96.3 81.4 87.0
b4 -70 60.0 -60 66.7 28.5 8 62.1 63.1 65.5
b5 -25 85.7 -26 85.6 37 24.5 102.5 89.0 89.9
b8 -25 85.7 -55 69.4 36 0 45.0 71.1 75.5
b9 -55 68.6 -85 52.8 20.5 7.5 50.4 58.6 64.0
c0 -35 80.0 -51 71.7 0 7 63.2 73.3 75.8
c1 -90 48.6 -70 61.1 30 33.5 93.8 62.6 69.3
c2 -175 0.0 -36 80.0 0 0 40.0 40.0 70.0
c3 -45 74.3 -32 82.2 37.5 11 83.3 79.3 82.5
c5 -42 76.0 -180 0.0 0 0 40.0 38.4 67.0
c6 -45 74.3 -69 61.7 35.5 22 100.6 74.5 80.9
c7 -10 94.3 5 102.8 37.5 0 46.9 88.2 88.8
c8 -25 85.7 -55 69.4 33 9 71.0 76.3 82.0
c9 -15 91.4 -83 53.9 34.5 19 99.4 78.0 93.4
d0 -35 80.0 -45 75.0 37.5 0 46.9 71.4 71.7
d1 -20 88.6 -41 77.2 36.5 17.5 101.9 86.7 91.9
d3 -40 77.1 -37 79.4 35.5 20.5 100.6 82.8 84.7
d4 -50 71.4 -42 76.7 31.5 0 39.4 67.1 67.3
d5 -20 88.6 -47 73.9 37 8 72.7 79.5 84.6
d6 -60 65.7 76 142.2 24 0 30.0 89.2 114.2
d7 -55 68.6 -64 64.4 27.5 0 34.4 60.1 60.0
d8 -5 97.1 -25 86.1 0 10 73.1 87.9 91.1
d9 0 100.0 -5 97.2 0 26.5 96.3 98.1 99.1
e1 -175 0.0 -180 0.0 0 0 40.0 8.0 10.0
e2 -25 85.7 -19 89.4 34 11 78.9 85.8 86.8
e3 -10 94.3 -30 83.3 38 27 103.8 91.8 96.7
e4 -85 51.4 -84 53.3 0 37 96.3 61.2 64.1
e5 -8 95.4 -25 86.1 26.5 18 89.4 90.5 93.9
e6 5 102.9 -7 96.1 0 8.5 68.1 93.2 94.2
e7 -27 84.6 -26 85.6 36.5 7.5 70.4 82.1 81.8
e8 -30 82.9 -74 58.9 21.5 7 50.0 66.7 74.7
f0 -25 85.7 -61 66.1 0 0 40.0 68.7 74.3
f1 -30 82.9 -95 47.2 0 0 40.0 60.0 72.1
f3 -45 74.3 -35 80.6 37.5 23.5 103.1 82.6 86.2
f4 -15 91.4 -25 86.1 28.5 8 62.1 83.4 84.1
f6 -65 62.9 -50 72.2 36 8 71.5 68.3 72.0
f7 -35 80.0 -75 58.3 0 0 40.0 63.3 70.0
f8 -73 58.3 -89 50.6 0 0 40.0 51.5 53.7
g1 -75 57.1 -35 80.6 0 4 53.2 65.7 73.7
g2 -68 61.1 -30 83.3 37.5 18 103.1 78.4 88.3
g3 -25 85.7 -46 74.4 28 20 91.3 82.3 87.1
g4 -13 92.6 -32 82.2 36.5 8 72.1 84.3 87.5
g5 -25 85.7 -30 83.3 0 25 96.3 86.9 88.3
g6 -25 85.7 -6 96.7 36 29.5 101.3 93.2 97.8
g7 -70 60.0 -84 53.3 33.5 29 98.1 65.0 69.5
g8 -20 88.6 -36 80.0 0 9 69.8 81.4 83.9
h0 -85 51.4 -110 38.9 27.5 22 90.6 54.3 61.2
h1 -105 40.0 -180 0.0 0 0 40.0 24.0 40.0
h2 -35 80.0 -50 72.2 38 28 103.8 81.6 85.9
h3 -20 88.6 30 116.7 28.5 9 65.4 95.2 103.9
h4 -10 94.3 -25 86.1 32.5 15.5 91.9 90.5 93.7
h5 -10 94.3 -25 86.1 36.5 37 101.9 92.5 96.2
h6 -15 91.4 -50 72.2 29 10 69.3 79.3 85.9
h7 -70 60.0 -64 64.4 36.5 0 45.6 58.9 59.7
h8 -70 60.0 -50 72.2 38 7.5 72.3 67.4 72.2
h9 -80 54.3 -87 51.7 32 0 40.0 50.4 50.7
j0 -78 55.4 -79 56.1 0 0 40.0 52.6 52.1
j1 -175 0.0 -180 0.0 0 0 40.0 8.0 10.0
j3 -65 62.9 -101 43.9 0 10 73.1 57.3 65.4
j5 -25 85.7 -51 71.7 25 19.5 87.5 80.5 86.2
j6 -12 93.1 -20 88.9 37 8 72.7 87.4 88.0
j7 -78 55.4 -180 0.0 0 0 40.0 30.2 51.6
j8 -65 62.9 -36 80.0 0 9 69.8 71.1 77.4
j9 5 102.9 0 100.0 38 29 103.8 101.9 103.1
k0 -100 42.9 -114 36.7 0 0 40.0 39.8 42.1
k1 -15 91.4 -15 91.7 32 9 69.8 87.2 86.2
k2 -10 94.3 -31 82.8 36.5 27 101.9 91.2 96.2
k3 -15 91.4 -51 71.7 37 18 102.5 85.7 94.2
k4 -90 48.6 -107 40.6 30 0 37.5 43.2 45.8
k5 -55 68.6 -59 67.2 34.5 9 72.9 68.9 69.7
k7 -75 57.1 -79 56.1 30.5 12.5 79.5 61.2 62.7
k8 -65 62.9 -81 55.0 36 20 101.3 67.4 72.5
k9 -10 94.3 -17 90.6 35 0 43.8 82.7 81.7
m0 -15 91.4 -36 80.0 33.5 17 98.1 88.2 93.1
m1 -75 57.1 -57 68.3 0 10 73.1 64.8 69.5
m2 -35 80.0 -49 72.8 36 13.7 90.3 79.2 82.6
m3 0 100.0 7 103.9 37 8.5 74.4 96.4 96.5
m4 -40 77.1 -35 80.6 37 10 79.3 78.9 80.3
m6 -5 97.1 0 100.0 35.5 33 100.6 99.0 100.2
m7 -40 77.1 -61 66.1 0 9 69.8 71.3 75.3
m8 -35 80.0 -42 76.7 36.5 0 45.6 71.8 71.4
m9 -50 71.4 -35 80.6 0 10 73.1 75.4 78.7
n0 -35 80.0 -31 82.8 36 18.5 101.3 85.4 87.4
n1 0 100.0 -17 90.6 37.5 8.5 75.0 91.2 93.8
n2 -75 57.1 -90 50.0 0 18 96.3 62.1 66.9
n3 -175 0.0 -180 0.0 0 0 40.0 8.0 10.0
n4 -50 71.4 -50 72.2 28.5 0 35.6 64.6 63.1
n5 -85 51.4 -50 72.2 0 0 40.0 57.5 64.2
n6 -80 54.3 -60 66.7 36.5 19 101.9 68.8 75.5
n7 -40 77.1 -26 85.6 32.5 17 96.9 84.5 88.4
n9 -12 93.1 -20 88.9 0 29.5 96.3 92.1 93.9
p1 -55 68.6 -124 31.1 0 9.5 71.4 54.2 69.3
p2 -20 88.6 -35 80.6 36 16 97.9 87.2 90.9
p3 -15 91.4 -75 58.3 32 32.5 96.3 79.2 92.6
p4 -80 54.3 -100 44.4 0 0 40.0 47.5 50.7
p5 -45 74.3 -49 72.8 35.5 16.5 99.0 78.6 80.5
p6 -60 65.7 -45 75.0 29 26 92.5 74.8 79.4
p7 -7 96.0 -61 66.1 28 9 64.8 77.8 88.2
p9 -25 85.7 -76 57.8 0 8.5 68.1 71.0 81.3
r0 -65 62.9 -81 55.0 0 9 69.8 61.1 64.6
r1 -30 82.9 -70 61.1 0 0 40.0 65.6 72.1
r2 5 102.9 -10 94.4 30.5 26 94.4 97.8 100.7
r3 -35 80.0 -90 50.0 34 18.5 98.8 71.8 84.7
r4 -5 97.1 5 102.8 0 9 69.8 93.9 94.5
r6 -95 45.7 -61 66.1 0 0 40.0 52.7 59.6
r7 -25 85.7 9 105.0 32 6 59.9 88.3 93.7
r8 -88 49.7 -90 50.0 0 8.5 68.1 53.5 54.5
r9 0 100.0 -15 91.7 38 30.5 103.8 97.4 100.9
s2 -55 68.6 -15 91.7 34 24 98.8 83.8 93.4
s3 -55 68.6 -51 71.7 35.5 18.5 100.6 76.2 78.9
s4 -85 51.4 -55 69.4 28 8.5 63.1 61.0 67.9
s5 -13 92.6 -20 88.9 35 33.5 100.0 92.6 94.4
s6 -40 77.1 -53 70.6 0 8.5 68.1 72.7 74.9
s8 -175 0.0 -180 0.0 0 0 40.0 8.0 10.0
s9 -90 48.6 -106 41.1 30.5 8 64.6 48.8 52.6
t0 -75 57.1 -65 63.9 37.5 15.5 98.2 68.0 72.5
t1 -65 62.9 -64 64.4 28 8.5 63.1 63.5 64.1
t2 -70 60.0 -72 60.0 34 15.5 93.8 66.8 68.4
t3 -10 94.3 -31 82.8 0 0 40.0 78.8 80.7
t4 -10 94.3 -35 80.6 36 8 71.5 84.2 88.6
t5 -55 68.6 -20 88.9 35 27 100.0 83.0 91.7
t7 -55 68.6 -44 75.6 29 0 36.3 64.9 65.7
t8 -120 31.4 -109 39.4 21 6 46.1 37.6 41.1
u0 -50 71.4 -65 63.9 0 0 40.0 62.1 63.6
u1 -5 97.1 10 105.6 0 27.5 96.3 100.3 103.2
u2 -65 62.9 -21 88.3 36.5 10 78.7 76.2 85.9
u3 -30 82.9 -3 98.3 38.5 28.5 104.4 93.4 99.8
u5 -175 0.0 -180 0.0 0 0 40.0 8.0 10.0
u6 -75 57.1 -71 60.6 0 18 96.3 66.3 69.5
w0 -20 88.6 -50 72.2 36 0 45.0 73.3 77.7
w1 -42 76.0 -48 73.3 0 17 96.3 79.0 81.1
w2 -55 68.6 -51 71.7 0 0 40.0 64.1 63.8
x0 -90 48.6 -117 35.0 30.5 0 38.1 41.1 46.0
x1 -40 77.1 -22 87.8 35.5 0 44.4 74.8 76.9










Average -42 76 -48 73.3
17