The first 6 columns moving from left to right after your class ID are the points missed and the percentage grade for the first three quizzes.

Next you will find your experiment score if you have turned in an experiment, and the total number of 1S1P pts earned so far.
The Rainbows, Mirages, and the Green Flash reports and the Satellite Photographs of Clouds reports haven't been graded yet and are not included in the points total.

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 most students haven't yet earned 45 1S1P pts but assumes 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 total number of extra credit points (earned on the Optional Assignments) is shown next.

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.

Please let me know if you have any questions or find any errors.

Class ID Quiz #1 Q1(%) Quiz #2 Q2(%) Quiz #3 Q3(%) Expt. Total 1S1P pts Writing grade Extra Credit  Overall average Overall average Class ID







report pts total estimate points no quizzes dropped lowest quiz dropped
a0 -20 88.6 -24 86.7 -15.0 90.3 33 19 76.9 0.8 87.0 87.1 a0
a2 -30 82.9 -35 80.6 -20.0 87.1 0 37 96.3 2.0 88.0 89.7 a2
a3 -58 66.9 -60 66.7 -155.0 0.0 0 10 58.8 1.0 48.4 65.8 a3
a4 -18 89.7 -40 77.8 -30.0 80.6 37.5 25 93.8 1.2 86.1 88.5 a4
a5 -120 31.4 -51 71.7 -35.0 77.4 0 0 40.0 0.8 56.9 66.7 a5
a6 -30 82.9 -51 71.7 -55.0 64.5 38 45 103.8 1.6 80.8 85.5 a6
a7 -5 97.1 -15 91.7 -13.0 91.6 32 45 96.3 1.2 95.2 96.1 a7
a8 5 102.9 -35 80.6 -90.0 41.9 35 20 81.3 0.0 76.3 89.1 a8
a9 -105 40.0 -107 40.6 -45.0 71.0 30 17 69.4 0.2 54.5 59.4 a9
b0 -45 74.3 -52 71.1 -21.5 86.1 32 35 96.3 0.8 81.8 85.0 b0
b1 0 100.0 -10 94.4 10.0 106.5 34.5 17 75.0 0.2 95.4 96.4 b1
b2 -65 62.9 -57 68.3 -50.5 67.4 29 21.5 76.6 0.6 68.9 70.6 b2
b3 -50 71.4 -29 83.9 -58.0 62.6 32.5 24.5 86.6 0.8 76.2 80.7 b3
b4 -70 60.0 -60 66.7 -155.0 0.0 28.5 16 65.6 0.8 47.7 64.7 b4
b5 -25 85.7 -26 85.6 -2.0 98.7 37 34.5 102.5 0.8 93.3 95.6 b5
b8 -25 85.7 -55 69.4 -15.0 90.3 36 18.5 79.7 1.0 82.4 86.9 b8
b9 -55 68.6 -85 52.8 -65.0 58.1 20.5 14.5 52.8 0.2 58.6 60.9 b9
c0 -35 80.0 -51 71.7 -5.0 96.8 29 14 62.5 0.2 79.0 82.1 c0
c1 -90 48.6 -70 61.1 -60.0 61.3 30 33.5 93.8 1.2 65.5 70.5 c1
c2 -175 0.0 -36 80.0 -28.0 81.9 0 0 40.0 0.0 51.2 70.7 c2
c3 -45 74.3 -32 82.2 -25.5 83.5 37.5 38 103.1 1.2 85.8 89.1 c3
c5 -42 76.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 28.3 38.5 c5
c6 -45 74.3 -69 61.7 -28.0 81.9 35.5 22 85.6 0.6 75.8 80.6 c6
c7 -10 94.3 5 102.8 -43.0 72.3 37.5 8 61.9 0.4 84.6 89.8 c7
c8 -25 85.7 -55 69.4 -45.0 71.0 33 19 76.9 1.1 76.7 79.0 c8
c9 -15 91.4 -83 53.9 -21.0 86.5 34.5 27 93.8 1.1 81.7 91.2 c9
d0 -35 80.0 -45 75.0 -51.0 67.1 37.5 25 93.8 0.8 78.8 82.4 d0
d1 -20 88.6 -41 77.2 -50.0 67.7 36.5 26.5 95.3 1.2 82.5 87.2 d1
d3 -40 77.1 -37 79.4 -40.0 74.2 35.5 20.5 82.8 0.8 78.9 80.2 d3
d4 -50 71.4 -42 76.7 -30.0 80.6 31.5 6.5 51.6 0.8 72.1 72.7 d4
d5 -20 88.6 -47 73.9 -15.0 90.3 37 24.5 92.2 0.0 85.8 90.1 d5
d6 -60 65.7 76 142.2 -68.0 56.1 24 9.5 47.8 0.4 80.4 90.3 d6
d7 -55 68.6 -64 64.4 -46.0 70.3 27.5 25 81.3 1.0 71.5 73.4 d7
d8 -5 97.1 -25 86.1 -20.0 87.1 0 10 58.8 0.2 84.0 84.0 d8
d9 0 100.0 -5 97.2 15.0 109.7 0 35 96.3 0.8 101.9 103.5 d9
e1 -175 0.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 8.0 10.0 e1
e2 -25 85.7 -19 89.4 -30.0 80.6 34 11 63.1 0.6 81.4 82.1 e2
e3 -10 94.3 -30 83.3 -20.0 87.1 38 35 103.8 0.8 92.1 94.8 e3
e4 -85 51.4 -84 53.3 -52.0 66.5 0 45 96.3 1.0 65.9 70.0 e4
e5 -8 95.4 -25 86.1 -15.0 90.3 26.5 28 85.6 2.0 91.6 93.1 e5
e6 5 102.9 -7 96.1 -5.0 96.8 36.5 26.5 95.3 0.8 98.7 99.5 e6
e7 -27 84.6 -26 85.6 -15.0 90.3 36.5 16.5 76.6 0.6 85.4 85.7 e7
e8 -30 82.9 -74 58.9 -45.0 71.0 21.5 23.5 70.9 0.2 71.1 75.6 e8
f0 -25 85.7 -61 66.1 -50.0 67.7 0 8 55.0 0.4 70.0 71.7 f0
f1 -30 82.9 -95 47.2 -37.0 76.1 28 8.5 50.9 0.8 66.0 73.2 f1
f3 -45 74.3 -35 80.6 -29.5 81.0 37.5 31.5 103.1 1.4 84.9 87.8 f3
f4 -15 91.4 -25 86.1 -35.0 77.4 28.5 25 82.5 0.2 84.7 87.4 f4
f6 -65 62.9 -50 72.2 -27.5 82.3 36 17 76.9 1.2 74.5 78.3 f6
f7 -35 80.0 -75 58.3 -155.0 0.0 0 0 40.0 0.2 45.1 62.1 f7
f8 -73 58.3 -89 50.6 -90.0 41.9 0 0 40.0 0.6 48.8 51.4 f8
g1 -75 57.1 -35 80.6 -55.0 64.5 0 20 77.5 0.6 70.0 74.4 g1
g2 -68 61.1 -30 83.3 -49.5 68.1 37.5 45 103.1 1.0 78.3 83.6 g2
g3 -25 85.7 -46 74.4 -50.0 67.7 28 37.5 91.3 0.4 79.4 83.3 g3
g4 -13 92.6 -32 82.2 -20.0 87.1 36.5 24.5 91.6 1.6 89.7 91.9 g4
g5 -25 85.7 -30 83.3 -29.5 81.0 31.5 33 95.6 1.4 87.2 88.7 g5
g6 -25 85.7 -6 96.7 5.0 103.2 36 39.5 101.3 0.4 96.8 100.7 g6
g7 -70 60.0 -84 53.3 -150.5 2.9 33.5 37 98.1 0.4 51.0 67.4 g7
g8 -20 88.6 -36 80.0 -100.0 35.5 0 0 40.0 0.0 62.4 73.2 g8
h0 -85 51.4 -110 38.9 -45.0 71.0 27.5 30.5 90.6 0.4 61.5 69.0 h0
h1 -105 40.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 18.7 25.0 h1
h2 -35 80.0 -50 72.2 -17.0 89.0 38 28 100.0 1.2 85.5 89.6 h2
h3 -20 88.6 30 116.7 -29.5 81.0 28.5 17.5 68.4 0.8 90.8 94.9 h3
h4 -10 94.3 -25 86.1 -15.0 90.3 32.5 45 96.9 0.4 92.0 93.8 h4
h5 -10 94.3 -25 86.1 -35.0 77.4 36.5 37 101.9 1.6 90.7 94.7 h5
h6 -15 91.4 -50 72.2 -20.0 87.1 29 18 70.0 0.4 81.3 84.8 h6
h7 -70 60.0 -64 64.4 -40.0 74.2 36.5 16.5 76.6 1.2 69.5 72.3 h7
h8 -70 60.0 -50 72.2 -35.0 77.4 38 7.5 61.6 0.4 68.6 71.9 h8
h9 -80 54.3 -87 51.7 -30.0 80.6 32 8 55.0 0.8 61.6 65.1 h9
j0 -78 55.4 -79 56.1 -56.5 63.5 0 6.5 52.2 0.2 57.3 58.1 j0
j1 -175 0.0 -180 0.0 -155.0 0.0 0 0 40.0 0.2 8.2 10.2 j1
j3 -65 62.9 -101 43.9 -70.0 54.8 0 10 58.8 0.2 55.0 59.0 j3
j5 -25 85.7 -51 71.7 -55.0 64.5 25 19.5 67.8 0.4 73.1 76.4 j5
j6 -12 93.1 -20 88.9 -21.5 86.1 37 25 93.1 1.2 91.3 92.7 j6
j7 -78 55.4 -180 0.0 -155.0 0.0 0 0 40.0 0.0 22.8 30.8 j7
j8 -65 62.9 -36 80.0 -22.0 85.8 0 25 86.9 0.8 79.2 84.7 j8
j9 5 102.9 0 100.0 -10.0 93.5 38 45 103.8 0.8 100.6 102.8 j9
k0 -100 42.9 -114 36.7 -52.0 66.5 28 23.5 79.1 0.2 54.9 61.0 k0
k1 -15 91.4 -15 91.7 0.0 100.0 32 19 75.6 0.2 90.8 91.0 k1
k2 -10 94.3 -31 82.8 -45.0 71.0 36.5 34.5 101.9 0.8 87.3 92.7 k2
k3 -15 91.4 -51 71.7 -25.0 83.9 37 27 96.9 1.2 86.4 91.2 k3
k4 -90 48.6 -107 40.6 -65.0 58.1 30 8 52.5 0.6 50.4 53.7 k4
k5 -55 68.6 -59 67.2 -22.5 85.5 34.5 25 90.0 0.6 77.6 80.9 k5
k7 -75 57.1 -79 56.1 -105.0 32.3 30.5 28.5 91.6 1.7 58.8 67.1 k7
k8 -65 62.9 -81 55.0 -55.0 64.5 36 20 82.5 0.4 65.5 68.8 k8
k9 -10 94.3 -17 90.6 9.5 106.1 35 18 77.5 1.2 94.3 95.7 k9
m0 -15 91.4 -36 80.0 -19.0 87.7 33.5 25 88.8 1.6 88.5 91.0 m0
m1 -75 57.1 -57 68.3 -155.0 0.0 0 18 73.8 0.4 48.6 65.9 m1
m2 -35 80.0 -49 72.8 -50.0 67.7 36 32 101.3 0.6 79.7 83.2 m2
m3 0 100.0 7 103.9 10.0 106.5 37 16.5 77.2 1.2 99.4 99.4 m3
m4 -40 77.1 -35 80.6 0.0 100.0 37 19.5 82.8 0.2 85.5 88.6 m4
m6 -5 97.1 0 100.0 8.0 105.2 35.5 45 100.6 1.6 102.3 103.7 m6
m7 -40 77.1 -61 66.1 -70.0 54.8 0 9 56.9 0.2 64.4 68.1 m7
m8 -35 80.0 -42 76.7 -60.0 61.3 36.5 0 45.6 0.8 68.0 71.0 m8
m9 -50 71.4 -35 80.6 -70.0 54.8 30 24 82.5 0.0 71.7 77.6 m9
n0 -35 80.0 -31 82.8 -23.0 85.2 36 28.5 98.4 0.8 86.6 88.4 n0
n1 0 100.0 -17 90.6 0.0 100.0 37.5 25.5 94.7 1.0 97.4 99.7 n1
n2 -75 57.1 -90 50.0 -155.0 0.0 0 18 73.8 0.0 43.3 58.6 n2
n3 -175 0.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 8.0 10.0 n3
n4 -50 71.4 -50 72.2 -30.0 80.6 28.5 8 50.6 0.6 70.5 70.6 n4
n5 -85 51.4 -50 72.2 -30.0 80.6 0 0 40.0 0.4 62.9 67.7 n5
n6 -80 54.3 -60 66.7 -32.5 79.0 36.5 27 96.3 1.0 73.6 79.7 n6
n7 -40 77.1 -26 85.6 -25.0 83.9 32.5 45 96.9 0.8 85.9 88.6 n7
n9 -12 93.1 -20 88.9 -5.0 96.8 0 45 96.3 0.8 94.4 96.1 n9
p1 -55 68.6 -124 31.1 -85.0 45.2 0 9.5 57.8 0.8 51.0 57.9 p1
p2 -20 88.6 -35 80.6 -40.0 74.2 36 33 101.3 0.8 85.9 89.5 p2
p3 -15 91.4 -75 58.3 -14.5 90.6 32 45 96.3 0.6 84.0 92.9 p3
p4 -80 54.3 -100 44.4 -70.0 54.8 0 0 40.0 0.2 49.2 51.1 p4
p5 -45 74.3 -49 72.8 -20.0 87.1 35.5 25.5 92.2 0.2 81.1 83.8 p5
p6 -60 65.7 -45 75.0 -58.0 62.6 29 45 92.5 0.8 73.5 76.7 p6
p7 -7 96.0 -61 66.1 -53.0 65.8 28 9 51.9 1.6 72.8 75.4 p7
p9 -25 85.7 -76 57.8 -30.0 80.6 0 16.5 70.9 0.6 74.6 80.7 p9
r0 -65 62.9 -81 55.0 -14.0 91.0 0 26 88.8 0.8 74.2 80.7 r0
r1 -30 82.9 -70 61.1 -65.0 58.1 29.5 20.5 75.3 0.2 69.1 73.0 r1
r2 5 102.9 -10 94.4 5.0 103.2 30.5 34 94.4 0.0 99.0 100.9 r2
r3 -35 80.0 -90 50.0 -35.0 77.4 34 45 98.8 0.8 75.9 84.5 r3
r4 -5 97.1 5 102.8 -5.0 96.8 0 9 56.9 0.8 91.3 90.0 r4
r6 -95 45.7 -61 66.1 -60.0 61.3 0 0 40.0 0.6 54.8 58.4 r6
r7 -25 85.7 9 105.0 -60.0 61.3 32 15 68.1 1.4 82.2 89.9 r7
r8 -88 49.7 -90 50.0 -45.0 71.0 29.5 8.5 52.8 0.0 56.1 58.6 r8
r9 0 100.0 -15 91.7 0.0 100.0 38 45 103.8 0.8 99.3 101.7 r9
s2 -55 68.6 -15 91.7 -10.0 93.5 34 33 98.8 1.2 88.6 95.3 s2
s3 -55 68.6 -51 71.7 -51.0 67.1 35.5 28 96.9 1.1 75.8 77.9 s3
s4 -85 51.4 -55 69.4 -50.0 67.7 28 21.5 75.3 0.4 65.8 70.7 s4
s5 -13 92.6 -20 88.9 -40.0 74.2 35 45 100.0 0.4 88.6 93.4 s5
s6 -40 77.1 -53 70.6 -55.0 64.5 0 8.5 55.9 0.6 68.4 70.0 s6
s8 -175 0.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 8.0 10.0 s8
s9 -90 48.6 -106 41.1 -60.0 61.3 30.5 8 53.1 0.8 51.7 55.3 s9
t0 -75 57.1 -65 63.9 -110.0 29.0 37.5 15.5 75.9 0.8 56.0 65.2 t0
t1 -65 62.9 -64 64.4 -70.0 54.8 28 16.5 65.9 0.6 62.4 64.8 t1
t2 -70 60.0 -72 60.0 -60.0 61.3 34 15.5 71.6 1.2 63.9 64.6 t2
t3 -10 94.3 -31 82.8 -5.0 96.8 0 0 40.0 0.6 81.6 82.2 t3
t4 -10 94.3 -35 80.6 -35.0 77.4 36 8 60.0 0.8 80.1 81.4 t4
t5 -55 68.6 -20 88.9 -15.0 90.3 35 45 100.0 0.6 86.7 92.8 t5
t7 -55 68.6 -44 75.6 0.0 100.0 29 7.5 50.3 0.8 76.0 79.2 t7
t8 -120 31.4 -109 39.4 -70.0 54.8 21 30 82.5 0.2 50.2 56.2 t8
u0 -50 71.4 -65 63.9 -40.0 74.2 0 9 56.9 0.6 67.8 69.4 u0
u1 -5 97.1 10 105.6 3.0 101.9 37 45 102.5 1.2 102.9 104.6 u1
u2 -65 62.9 -21 88.3 -40.0 74.2 36.5 10 64.4 0.2 73.2 77.2 u2
u3 -30 82.9 -3 98.3 -5.0 96.8 38.5 28.5 101.6 0.8 95.2 99.4 u3
u5 -175 0.0 -180 0.0 -155.0 0.0 0 0 40.0 0.0 8.0 10.0 u5
u6 -75 57.1 -71 60.6 -45.0 71.0 0 18 73.8 0.6 65.7 68.4 u6
w0 -20 88.6 -50 72.2 -11.0 92.9 36 18 78.8 1.2 84.6 88.9 w0
w1 -42 76.0 -48 73.3 -36.0 76.8 0 30 96.3 1.0 80.5 82.4 w1
w2 -55 68.6 -51 71.7 -55.0 64.5 0 0 40.0 0.0 62.6 62.6 w2
x0 -90 48.6 -117 35.0 -75.0 51.6 30.5 0 38.1 0.0 43.7 47.1 x0
x1 -40 77.1 -22 87.8 -6.0 96.1 35.5 18 78.1 1.2 86.4 89.7 x1