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	% grade	Quiz #2	% grade	Quiz #3	% grade	Expt.	Total 1S1P pts	Writing grade	Extra credit	Overall average	Overall average	Class ID
							report		estimate	points	no quizzes dropped	lowest quiz dropped
a0	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	8.0	10.0	a0
a1	-52	70.3	-75	58.3	-155.0	0.0	33.5	17.0	73.8	1.2	50.2	67.9	a1
a2	-15	91.4	-18	90.0	-25.0	83.9	37	36.5	102.5	0.6	91.8	94.3	a2
a3	-15	91.4	-86	52.2	-34.5	77.7	36.5	18.0	79.4	1.2	76.1	84.5	a3
a5	-95	45.7	-56	68.9	-80.0	48.4	26	8.5	48.4	0.8	54.0	56.9	a5
a6	-12	93.1	-20	88.9	-15.0	90.3	32.5	28.0	93.1	1.2	92.5	93.3	a6
a7	-45	74.3	-61	66.1	-47.5	69.4	35	17.5	76.6	0.6	71.8	73.6	a7
a8	-37	78.9	-30	83.3	-50.5	67.4	35.5	45.0	100.6	0.8	82.2	86.8	a8
a9	-15	91.4	-70	61.1	-73.5	52.6	37	45.0	102.5	0.6	75.8	83.4	a9
b0	-102	41.7	-25	86.1	-23.5	84.8	35.5	29.0	98.8	1.0	77.5	89.8	b0
b1	-50	71.4	-35	80.6	-45.0	71.0	25.5	45.0	88.1	1.2	78.3	80.2	b1
b2	-75	57.1	-39	78.3	-95.0	38.7	28	26.5	84.7	0.2	63.6	72.2	b2
b3	-77	56.0	-86	52.2	-95.0	38.7	24.5	5.0	40.0	0.6	47.8	51.2	b3
b4	-60	65.7	-112	37.8	-155.0	0.0	0	22.5	82.2	0.0	44.0	59.4	b4
b5	-15	91.4	-6	96.7	-5.0	96.8	37.5	45.0	103.1	1.6	98.2	99.9	b5
b6	-45	74.3	-32	82.2	-77.0	50.3	33	7.5	55.3	0.2	66.4	72.7	b6
b7	-66	62.3	-65	63.9	-35.0	77.4	29.5	28.5	90.3	1.2	73.6	76.8	b7
b8	-30	82.9	-20	88.9	-50.0	67.7	35.5	36.0	100.6	0.8	84.8	90.4	b8
b9	-30	82.9	-25	86.1	-27.5	82.3	38.5	45.0	104.4	1.0	88.9	90.5	b9
c0	-5	97.1	-15	91.7	-32.5	79.0	37	26.5	95.9	0.8	91.4	95.6	c0
c1	-115	34.3	-180	0.0	-155.0	0.0	28.5	0.0	35.6	0.2	16.5	22.0	c1
c2	-57	67.4	-64	64.4	-70.5	54.5	30.5	9.0	55.0	0.6	61.3	63.8	c2
c3	-92	47.4	-97	46.1	-80.0	48.4	0	15.0	68.1	0.3	51.8	53.3	c3
c4	-82	53.1	-84	53.3	-15.0	90.3	27.5	27.5	85.9	1.0	70.7	76.4	c4
c6	-90	48.6	-180	0.0	-155.0	0.0	0	6.0	51.3	0.2	23.4	31.2	c6
c7	-90	4.0	-74	58.9	-70.0	54.8	34.5	22.5	85.3	0.8	49.3	64.8	c7
c8	0	100.0	-5	97.2	-1.0	99.4	37	29.0	100.6	1.2	100.4	101.1	c8
c9	-62	64.6	-49	72.8	-60.0	61.3	35	24.5	89.7	0.6	71.5	74.5	c9
d0	-67	61.7	-61	66.1	-75.0	51.6	38	7.5	61.6	0.6	60.8	63.9	d0
d1	0	100.0	-50	72.2	-10.0	93.5	38	45.0	103.8	1.2	92.8	99.7	d1
d2	-20	88.6	-40	77.8	-29.5	81.0	33.5	45.0	98.1	1.2	86.8	89.3	d2
d3	0	100.0	-45	75.0	-10.0	93.5	38	35.5	103.8	1.2	93.6	99.7	d3
d4	-90	48.6	-79	56.1	1.5	101.0	35.5	34.5	100.6	0.8	75.8	84.9	d4
d5	-30	82.9	-30	83.3	-44.5	71.3	0	9.5	57.8	0.0	74.9	76.8	d5
d6	-42	76.0	-51	71.7	-30.0	80.6	28.5	22.0	76.9	0.6	76.9	78.6	d6
d7	-55	68.6	-80	55.6	-75.0	51.6	35.5	10.0	63.1	0.0	59.5	62.3	d7
d8	-55	68.6	-80	55.6	-155.0	0.0	38.5	29.0	102.5	1.2	54.8	73.4	d8
e0	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	8.0	10.0	e0
e1	-175	0.0	-180	0.0	-95.0	38.7	0	0.0	40.0	0.0	18.3	24.5	e1
e2	-45	74.3	-25	86.1	-12.0	92.3	39	45.0	105.0	1.0	89.4	94.1	e2
e3	-62	64.6	-61	66.1	-148.5	4.2	0	16.0	70.0	0.6	50.6	67.1	e3
e4	-42	76.0	-41	77.2	-70.0	54.8	30	45.0	93.8	0.8	75.0	81.7	e4
e5	-142	18.9	-71	60.6	-95.0	38.7	22	25.0	74.4	0.2	46.6	56.0	e5
e6	-175	0.0	-45	75.0	-75.0	51.6	33.5	18.0	75.6	0.7	49.6	67.1	e6
e7	5	102.9	0	100.0	-8.0	94.8	38.5	37.0	104.4	1.2	101.5	103.4	e7
e8	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	8.0	10.0	e8
f0	0	100.0	-10	94.4	-15.0	90.3	37	33.5	102.5	0.6	97.0	99.1	f0
f1	-97	44.6	-180	0.0	-85.0	45.2	34.5	0.0	43.1	0.0	32.6	44.4	f1
f2	-50	71.4	-180	0.0	-47.0	69.7	38	0.0	47.5	0.0	47.1	64.8	f2
f3	-47	73.1	-40	77.8	-32.0	79.4	37.5	27.0	97.5	1.2	82.1	84.5	f3
f4	0	100.0	-50	72.2	-20.0	87.1	38	16.5	78.4	0.3	85.1	90.1	f4
f5	-40	77.1	-71	60.6	-40.0	74.2	34	8.5	58.4	0.4	68.6	71.8	f5
f6	-37	78.9	-55	69.4	-17.5	88.7	33.5	45.0	98.1	0.8	83.6	88.1	f6
f7	0	100.0	-11	93.9	-14.5	90.6	38.5	27.5	99.7	1.0	96.8	98.6	f7
f8	-80	54.3	-97	46.1	-90.0	41.9	24.5	36.0	86.9	1.0	56.3	60.3	f8
g0	-72	58.9	-89	50.6	-45.0	71.0	31.5	8.0	54.4	0.4	59.4	62.7	g0
g1	-22	87.4	-24	86.7	-25.0	83.9	34	0.0	42.5	0.6	77.9	76.5	g1
g2	-70	60.0	-62	65.6	-155.0	0.0	0	0.0	40.0	0.0	41.5	57.1	g2
g3	-90	48.6	-71	60.6	-55.0	64.5	33.5	28.5	95.3	1.2	66.6	71.9	g3
g4	-99	43.4	-51	71.7	-155.0	0.0	0	20.0	77.5	1.2	47.4	63.7	g4
g5	-55	68.6	-60	66.7	-85.0	45.2	36	34.0	101.3	0.4	68.8	76.4	g5
g7	-27	84.6	-36	80.0	-45.0	71.0	38.5	17.0	80.0	0.4	79.2	82.1	g7
g8	-102	41.7	-104	42.2	-73.0	52.9	37.5	8.0	61.9	0.2	49.1	51.3	g8
g9	-77	56.0	-66	63.3	-12.5	91.9	33	32.0	97.5	0.8	76.6	83.4	g9
h0	-20	88.6	-15	91.7	-20.0	87.1	38	45.0	103.8	1.6	93.6	95.1	h0
h1	-37	78.9	-36	80.0	-60.0	61.3	33	17.0	73.1	0.4	73.7	78.3	h1
h2	-10	94.3	-16	91.1	-7.5	95.2	36	27.0	95.6	1.4	95.3	96.3	h2
h3	-175	8.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	10.1	13.0	h3
h4	-60	65.7	-5	97.2	-10.0	93.5	37	45.0	102.5	0.6	89.5	97.8	h4
h5	-67	61.7	-74	58.9	-120.0	22.6	31	34.5	95.0	0.2	57.4	69.2	h5
h6	-130	25.7	-111	38.3	-90.0	41.9	26.5	16.0	63.1	0.2	41.1	46.1	h6
h7	-25	85.7	-55	69.4	-40.0	74.2	34.5	10.0	61.9	0.2	73.7	75.6	h7
h8	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	8.0	10.0	h8
h9	-67	61.7	-65	63.9	-155.0	0.0	0	0.0	40.0	0.2	41.7	57.3	h9
j0	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.2	8.2	10.2	j0
j1	-50	71.4	-65	63.9	-84.0	45.8	30.5	25.0	85.0	0.6	65.9	72.6	j1
j3	-10	94.3	-21	88.3	-35.0	77.4	32.5	14.0	66.9	0.4	83.1	85.6	j3
j4	-85	51.4	-51	71.7	-50.0	67.7	29	35.0	92.5	0.2	69.6	75.6	j4
j5	-5	97.1	-59	67.2	-60.0	61.3	36.5	45.0	101.9	0.8	81.3	87.9	j5
j7	-17	90.3	-51	71.7	0.0	100.0	28.5	0.0	35.6	0.3	77.3	80.6	j7
j8	-52	70.3	-56	68.9	-50.5	67.4	34	18.5	77.2	0.8	71.3	72.3	j8
j9	-175	0.0	-180	0.0	-155.0	0.0	0	19.0	75.6	0.2	15.3	19.1	j9
k0	-37	78.9	-15	91.7	-35.0	77.4	30	20.0	75.0	0.4	81.5	83.1	k0
k1	-60	65.7	-87	51.7	-60.0	61.3	36	30.0	101.3	0.6	68.5	73.5	k1
k2	-80	54.3	-180	0.0	-155.0	0.0	0	0.0	40.0	0.6	23.1	31.0	k2
k3	-35	80.0	-55	69.4	-55.0	64.5	36.5	34.0	101.9	0.8	78.2	82.3	k3
k4	8	104.6	10	105.6	5.0	103.2	38	27.0	98.1	0.4	103.6	103.7	k4
k5	-67	61.7	-30	83.3	-60.0	61.3	31	25.5	86.6	1.6	73.9	77.6	k5
k6	-35	80.0	-65	63.9	-55.0	64.5	35	8.5	59.7	0.4	67.9	69.5	k6
k7	-107	38.9	-70	61.1	-84.0	45.8	34	38.5	98.8	0.6	59.2	65.4	k7
k8	-50	71.4	-30	83.3	-36.0	76.8	37.5	45.0	103.1	0.6	82.9	86.4	k8
m0	-87	50.3	-100	44.4	-65.0	58.1	38	16.5	78.4	1.4	57.8	61.6	m0
m1	-20	88.6	-25	86.1	-30.0	80.6	37	20.0	83.8	0.6	85.4	87.0	m1
m2	-5	97.1	-25	86.1	-12.5	91.9	38.5	32.0	104.4	0.7	95.0	97.7	m2
m3	-5	97.1	-30	83.3	15.5	110.0	38	28.5	100.9	0.6	98.2	103.5	m3
m4	-62	64.6	-91	49.4	-90.0	41.9	0	0.0	40.0	0.4	50.0	53.2	m4
m5	-75	57.1	-80	55.6	-58.0	62.6	28	17.0	66.9	0.6	60.7	62.2	m5
m6	1	100.6	-15	91.7	-14.5	90.6	37	36.0	102.5	1.2	97.1	98.9	m6
m7	-60	65.7	-41	77.2	-35.0	77.4	31	18.0	72.5	0.2	73.5	76.3	m7
m8	5	102.9	5	102.8	-5.0	96.8	38.5	18.0	81.9	0.8	97.8	98.4	m8
m9	-62	64.6	-55	69.4	-65.0	58.1	36	10.0	63.8	0.6	64.6	66.8	m9
n0	-5	97.1	-5	97.2	-40.0	74.2	34.5	36.0	99.4	0.8	92.3	98.5	n0
n1	-20	88.6	-55	69.4	-60.0	61.3	33	29.5	96.6	0.8	78.6	84.2	n1
n2	-122	30.3	-129	28.3	-90.0	41.9	0	0.0	40.0	0.0	34.8	37.1	n2
n3	-175	0.0	-101	43.9	-155.0	0.0	28	7.5	49.1	0.6	22.1	29.3	n3
n4	-5	97.1	0	100.0	18.0	111.6	38.5	45.0	104.4	0.8	104.0	106.2	n4
n5	-175	0.0	-5	97.2	-67.5	56.5	35	17.5	76.6	0.8	57.1	77.6	n5
n6	0	100.0	-5	97.2	-15.0	90.3	37.5	45.0	103.1	1.2	98.5	100.9	n6
n7	-15	91.4	-5	97.2	-10.0	93.5	28.5	34.5	91.9	0.8	94.4	95.3	n7
n8	-80	54.3	-80	55.6	-47.0	69.7	35	33.5	100.0	0.0	67.9	72.0	n8
n9	-97	44.6	-107	40.6	-55.0	64.5	31	0.0	38.8	0.6	48.3	51.2	n9
p0	-57	67.4	-47	73.9	-94.0	39.4	34.5	18.0	76.9	1.0	64.6	73.2	p0
p1	-32	81.7	-55	69.4	-20.0	87.1	32.5	18.5	75.3	1.5	80.1	83.6	p1
p2	-27	84.6	-25	86.1	-71.0	54.2	38.5	45.0	104.4	0.8	81.6	90.9	p2
p3	-30	82.9	-59	67.2	-70.0	54.8	34.5	16.5	74.1	1.4	70.8	76.1	p3
p4	-57	67.4	-59	67.2	-67.5	56.5	35.5	16.0	74.4	0.4	66.2	69.5	p4
p5	-45	74.3	-35	80.6	-50.0	67.7	35.5	18.0	78.1	0.8	75.8	78.4	p5
p6	-70	60.0	-80	55.6	-78.0	49.7	27.5	9.0	51.3	0.8	55.1	56.9	p6
p7	-70	60.0	-107	40.6	-20.0	87.1	27	24.0	78.8	0.2	66.0	75.0	p7
p8	-5	97.1	-10	94.4	-15.0	90.3	36.5	25.5	93.4	1.6	95.5	96.8	p8
p9	-110	37.1	-180	0.0	-110.0	29.0	0	0.0	40.0	0.2	25.8	35.0	p9
r0	-42	76.0	-40	77.8	-84.0	45.8	38.5	28.5	101.6	0.4	73.9	83.5	r0
r1	-15	91.4	0	100.0	-5.0	96.8	36	37.0	101.3	0.6	97.7	99.7	r1
r2	-27	84.6	-95	47.2	-70.0	54.8	28.5	14.5	62.8	0.2	62.5	68.2	r2
r4	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	40.0	0.0	8.0	10.0	r4
r5	-30	82.9	-24	86.7	-10.0	93.5	36	23.5	89.1	0.6	88.6	90.4	r5
r6	-97	44.6	-94	47.8	-89.0	42.6	24	16.0	60.0	0.2	48.2	49.8	r6
r7	10	105.7	0	100.0	-10.0	93.5	36.5	17.5	78.4	1.4	96.9	98.2	r7
r8	-37	78.9	-25	86.1	-30.0	80.6	29.5	45.0	93.1	1.6	85.7	87.4	r8
r9	-35	80.0	-35	80.6	-20.0	87.1	0	9.0	56.9	0.1	77.5	77.2	r9
s0	-32	81.7	-30	83.3	-48.0	69.0	34	42.0	98.8	0.8	83.0	87.4	s0
s1	-75	57.1	-60	66.7	-32.0	79.4	35.5	45.0	100.6	1.8	76.1	81.7	s1
s2	-45	74.3	-15	91.7	-20.0	87.1	35	9.0	60.6	1.3	80.9	83.5	s2
s3	-17	90.3	-20	88.9	-27.5	82.3	37	45.0	102.5	0.8	91.0	93.6	s3
s4	0	100.0	-10	94.4	-15.0	90.3	36	16.5	75.9	0.0	91.1	91.9	s4
s5	-5	97.1	-16	91.1	-12.0	92.3	38	45.0	103.8	1.2	96.8	98.2	s5
s6	-67	61.7	-75	58.3	-47.5	69.4	29.5	0.0	36.9	0.6	58.5	59.0	s6
s7	-70	60.0	-75	58.3	-120.0	22.6	36.5	18.0	79.4	1.1	54.6	65.3	s7
s8	-60	65.7	-180	0.0	-155.0	0.0	0	0.0	40.0	0.2	25.7	34.8	s8
s9	-80	54.3	-94	47.8	-65.0	58.1	22.5	0.0	28.1	0.4	48.7	49.6	s9
t0	-65	62.9	-62	65.6	-34.0	78.1	36	33.5	101.3	0.6	75.9	79.8	t0
t1	-47	73.1	-48	73.3	-45.0	71.0	32	30.0	96.3	1.0	78.2	80.0	t1
t3	-20	88.6	10	105.6	-15.0	90.3	38	20.0	85.0	0.8	93.7	95.5	t3
t5	-5	97.1	-45	75.0	-30.0	80.6	35	23.0	86.9	0.2	85.0	88.6	t5
t6	-95	45.7	-101	43.9	-155.0	0.0	0	32.5	96.3	0.0	43.1	57.7	t6
u0	-85	51.4	-71	60.6	-155.0	0.0	0	0.0	40.0	0.6	38.5	52.6	u0
u1	-20	88.6	-35	80.6	-15.0	90.3	35.5	31.0	100.6	0.6	89.9	92.8	u1
u2	-17	90.3	-10	94.4	8.5	105.5	36	45.0	101.3	1.2	98.8	101.5	u2
u3	-60	65.7	-50	72.2	-60.0	61.3	38.5	45.0	104.4	0.4	74.4	78.2	u3
u5	-10	94.3	-15	91.7	-45.0	71.0	37	34.5	102.5	0.6	89.6	96.0	u5
u6	-42	76.0	-26	85.6	-15.0	90.3	30.5	36.5	94.4	0.6	86.6	90.1	u6
w0	-47	73.1	-49	72.8	-70.0	54.8	36.5	45.0	101.9	0.8	74.7	81.0	w0
x0	-5	97.1	-15	91.7	-16.5	89.4	37	17.0	78.1	1.6	91.4	91.9	x0