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 1S1P pts total now includes the Rainbows/Mirages/Green Flash, Satellite Photos of Clouds, Foucault Pendulum, Thermal Circulations/3-Cell Model reports,
and the Atmospheric Stability worksheet.

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.
If you have not turned in an experiment report a grade of 0 is now being used in the calculation of your writing grade (in earlier grade summaries
an average grade of 32 pts was used)

The total number of extra credit points (earned on the Optional Assignments) has not yet been updated, this is the same total as on early grade summaries.

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	0.0	0.0	0.0	0.0	a0
a1	-52	70.3	-75	58.3	-35.0	77.4	33.5	39.0	90.6	1.2	74.3	79.2	a1
a2	-15	91.4	-18	90.0	-25.0	83.9	37	45.0	102.5	0.6	91.8	94.3	a2
a3	-15	91.4	-86	52.2	-34.5	77.7	36.5	45.0	101.9	1.2	80.6	90.1	a3
a5	-95	45.7	-56	68.9	-80.0	48.4	26	17.0	53.8	0.8	55.0	58.2	a5
a6	-12	93.1	-20	88.9	-15.0	90.3	32.5	45.0	96.9	1.2	93.2	94.2	a6
a7	-45	74.3	-61	66.1	-47.5	69.4	35	45.0	100.0	0.6	76.5	79.5	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	45.0	100.6	1.0	77.8	90.3	b0
b1	-50	71.4	-35	80.6	-45.0	71.0	31	45.0	95.0	1.2	79.7	81.9	b1
b2	-75	57.1	-39	78.3	-95.0	38.7	28	26.5	68.1	0.2	60.3	68.0	b2
b3	-77	56.0	-86	52.2	-95.0	38.7	24.5	16.0	50.6	0.6	49.9	53.8	b3
b4	-60	65.7	-112	37.8	-155.0	0.0	0	40.5	50.6	0.0	37.7	51.5	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	40.5	91.9	0.2	73.7	81.9	b6
b7	-66	62.3	-65	63.9	-35.0	77.4	29.5	44.5	92.5	1.2	74.0	77.3	b7
b8	-30	82.9	-20	88.9	-50.0	67.7	35.5	45.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	43.0	100.0	0.8	92.2	96.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	33.0	79.4	0.6	66.2	69.9	c2
c3	-92	47.4	-97	46.1	-80.0	48.4	0	40.0	50.0	0.3	48.1	48.7	c3
c4	-82	53.1	-84	53.3	-15.0	90.3	27.5	45.0	90.6	1.0	71.6	77.5	c4
c6	-90	48.6	-180	0.0	-155.0	0.0	0	6.0	7.5	0.2	14.7	20.3	c6
c7	-90	4.0	-74	58.9	-70.0	54.8	34.5	45.0	99.4	0.8	52.1	68.3	c7
c8	0	100.0	-5	97.2	-1.0	99.4	37	40.5	96.9	1.2	99.7	100.2	c8
c9	-62	64.6	-49	72.8	-60.0	61.3	35	40.0	93.8	0.6	72.3	75.5	c9
d0	-67	61.7	-61	66.1	-75.0	51.6	38	7.5	56.9	0.6	59.8	62.8	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	45.0	103.8	1.2	93.6	99.7	d3
d4	-90	48.6	-79	56.1	1.5	101.0	35.5	42.5	97.5	0.8	75.1	84.1	d4
d5	-30	82.9	-30	83.3	-44.5	71.3	0	9.5	11.9	0.0	65.7	65.3	d5
d6	-42	76.0	-51	71.7	-30.0	80.6	28.5	40.5	86.3	0.6	78.7	80.9	d6
d7	-55	68.6	-80	55.6	-75.0	51.6	35.5	35.5	88.8	0.0	64.6	68.7	d7
d8	-55	68.6	-80	55.6	-155.0	0.0	38.5	29.0	84.4	1.2	51.2	68.8	d8
e0	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.0	0.0	0.0	e0
e1	-175	0.0	-180	0.0	-95.0	38.7	0	0.0	0.0	0.0	10.3	14.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	28.0	35.0	0.6	43.6	58.4	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	32.0	67.5	0.2	45.2	54.3	e5
e6	-175	0.0	-45	75.0	-75.0	51.6	33.5	45.0	98.1	0.7	54.1	72.7	e6
e7	5	102.9	0	100.0	-8.0	94.8	38.5	45.0	104.4	1.2	101.5	103.4	e7
e8	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.0	0.0	0.0	e8
f0	0	100.0	-10	94.4	-15.0	90.3	37	45.0	102.5	0.6	97.0	99.1	f0
f1	-97	44.6	-180	0.0	-85.0	45.2	34.5	24.5	73.8	0.0	38.7	52.1	f1
f2	-50	71.4	-180	0.0	-47.0	69.7	38	12.5	63.1	0.0	50.3	68.7	f2
f3	-47	73.1	-40	77.8	-32.0	79.4	37.5	45.0	103.1	1.2	83.2	85.9	f3
f4	0	100.0	-50	72.2	-20.0	87.1	38	26.5	80.6	0.3	85.6	90.6	f4
f5	-40	77.1	-71	60.6	-40.0	74.2	34	38.0	90.0	0.4	74.9	79.7	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	45.0	104.4	1.0	97.8	99.8	f7
f8	-80	54.3	-97	46.1	-90.0	41.9	24.5	42.5	83.8	1.0	55.7	59.5	f8
g0	-72	58.9	-89	50.6	-45.0	71.0	31.5	24.5	70.0	0.4	62.5	66.6	g0
g1	-22	87.4	-24	86.7	-25.0	83.9	34	38.0	90.0	0.6	87.4	88.4	g1
g2	-70	60.0	-62	65.6	-155.0	0.0	0	0.0	0.0	0.0	33.5	47.1	g2
g3	-90	48.6	-71	60.6	-55.0	64.5	33.5	28.5	77.5	1.2	63.0	67.5	g3
g4	-99	43.4	-51	71.7	-155.0	0.0	0	20.0	25.0	1.2	36.9	50.6	g4
g5	-55	68.6	-60	66.7	-85.0	45.2	36	45.0	101.3	0.4	68.8	76.4	g5
g7	-27	84.6	-36	80.0	-45.0	71.0	38.5	30.5	86.3	0.4	80.5	83.7	g7
g8	-102	41.7	-104	42.2	-73.0	52.9	37.5	31.0	85.6	0.2	53.8	57.3	g8
g9	-77	56.0	-66	63.3	-12.5	91.9	38.5	45.0	104.4	0.8	78.0	85.1	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	45.0	97.5	0.4	78.6	84.3	h1
h2	-10	94.3	-16	91.1	-7.5	95.2	36	45.0	101.3	1.4	96.5	97.8	h2
h3	-175	8.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.0	2.1	3.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	45.0	95.0	0.2	57.4	69.2	h5
h6	-130	25.7	-111	38.3	-90.0	41.9	26.5	23.0	61.9	0.2	40.8	45.8	h6
h7	-25	85.7	-55	69.4	-40.0	74.2	34.5	45.0	99.4	0.2	81.2	85.0	h7
h8	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.0	0.0	0.0	h8
h9	-67	61.7	-65	63.9	-155.0	0.0	0	0.0	0.0	0.2	33.7	47.3	h9
j0	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.2	0.2	0.2	j0
j1	-50	71.4	-65	63.9	-84.0	45.8	30.5	45.0	94.4	0.6	67.8	74.9	j1
j3	-10	94.3	-21	88.3	-35.0	77.4	32.5	32.0	80.6	0.4	85.9	89.0	j3
j4	-85	51.4	-51	71.7	-50.0	67.7	29	35.0	80.0	0.2	67.1	72.5	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	14.5	53.8	0.3	80.9	85.1	j7
j8	-52	70.3	-56	68.9	-50.5	67.4	36.5	41	96.9	0.8	75.3	77.2	j8
j9	-175	0.0	-180	0.0	-155.0	0.0	0	19.0	23.8	0.2	5.0	6.1	j9
k0	-37	78.9	-15	91.7	-35.0	77.4	30	20.0	62.5	0.4	79.0	80.0	k0
k1	-60	65.7	-87	51.7	-60.0	61.3	36	36.0	90.0	0.6	66.2	70.7	k1
k2	-80	54.3	-180	0.0	-155.0	0.0	0	0.0	0.0	0.6	15.1	21.0	k2
k3	-35	80.0	-55	69.4	-55.0	64.5	36.5	45.0	101.9	0.8	78.2	82.3	k3
k4	8	104.6	10	105.6	5.0	103.2	38	43.0	101.3	0.4	104.2	104.5	k4
k5	-67	61.7	-30	83.3	-60.0	61.3	31	39.5	88.1	1.6	74.2	78.0	k5
k6	-35	80.0	-65	63.9	-55.0	64.5	35	41.0	95.0	0.4	75.0	78.3	k6
k7	-107	38.9	-70	61.1	-84.0	45.8	34	38.5	90.6	0.6	57.6	63.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	33.5	89.4	1.4	60.0	64.3	m0
m1	-20	88.6	-25	86.1	-30.0	80.6	37	45.0	102.5	0.6	89.2	91.7	m1
m2	-5	97.1	-25	86.1	-12.5	91.9	38.5	45.0	104.4	0.7	95.0	97.7	m2
m3	-5	97.1	-30	83.3	15.5	110.0	38	43.0	101.3	0.6	98.3	103.6	m3
m4	-62	64.6	-91	49.4	-90.0	41.9	28	0.0	35.0	0.4	49.0	51.9	m4
m5	-75	57.1	-80	55.6	-58.0	62.6	28	34.0	77.5	0.6	62.8	64.9	m5
m6	1	100.6	-15	91.7	-14.5	90.6	37	45.0	102.5	1.2	97.1	98.9	m6
m7	-60	65.7	-41	77.2	-35.0	77.4	31	31.5	78.1	0.2	74.6	77.7	m7
m8	5	102.9	5	102.8	-5.0	96.8	38.5	31.5	87.5	0.8	98.9	99.8	m8
m9	-62	64.6	-55	69.4	-65.0	58.1	36	10.0	57.5	0.6	63.3	65.2	m9
n0	-5	97.1	-5	97.2	-40.0	74.2	34.5	45.0	99.4	0.8	92.3	98.5	n0
n1	-20	88.6	-55	69.4	-60.0	61.3	33	45.0	97.5	0.8	78.8	84.4	n1
n2	-122	30.3	-129	28.3	-90.0	41.9	0	0.0	0.0	0.0	26.8	27.1	n2
n3	-175	0.0	-101	43.9	-155.0	0.0	28	13.5	51.9	0.6	22.7	30.0	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	25.5	75.6	0.8	56.9	77.3	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	45.0	91.9	0.8	94.4	95.3	n7
n8	-80	54.3	-80	55.6	-47.0	69.7	37.5	45.0	103.1	0.0	68.5	72.7	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	33.5	85.0	1.0	66.2	75.2	p0
p1	-32	81.7	-55	69.4	-20.0	87.1	32.5	45.0	96.9	1.5	84.4	89.0	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	32.0	83.1	1.4	72.6	78.4	p3
p4	-57	67.4	-59	67.2	-67.5	56.5	35.5	16.0	64.4	0.4	64.2	67.0	p4
p5	-45	74.3	-35	80.6	-50.0	67.7	35.5	40.0	94.4	0.8	79.0	82.5	p5
p6	-70	60.0	-80	55.6	-78.0	49.7	27.5	9.0	45.6	0.8	54.0	55.5	p6
p7	-70	60.0	-107	40.6	-20.0	87.1	27	45.0	90.0	0.2	68.2	77.9	p7
p8	-5	97.1	-10	94.4	-15.0	90.3	36.5	31.5	85.0	1.6	93.8	94.7	p8
p9	-110	37.1	-180	0.0	-110.0	29.0	0	0.0	0.0	0.2	17.8	25.0	p9
r0	-42	76.0	-40	77.8	-84.0	45.8	38.5	35.5	92.5	0.4	72.1	81.2	r0
r1	-15	91.4	0	100.0	-5.0	96.8	36	45.0	101.3	0.6	97.7	99.7	r1
r2	-27	84.6	-95	47.2	-70.0	54.8	28.5	21.0	61.9	0.2	62.3	67.9	r2
r4	-175	0.0	-180	0.0	-155.0	0.0	0	0.0	0.0	0.0	0.0	0.0	r4
r5	-30	82.9	-24	86.7	-10.0	93.5	36	43.5	99.4	0.6	90.6	93.0	r5
r6	-97	44.6	-94	47.8	-89.0	42.6	24	16.0	50.0	0.2	46.2	47.3	r6
r7	10	105.7	0	100.0	-10.0	93.5	36.5	45.0	101.9	1.4	101.6	104.0	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	44.5	55.6	0.1	77.3	76.9	r9
s0	-32	81.7	-30	83.3	-48.0	69.0	37	45.0	102.5	0.8	83.7	88.3	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	37.5	90.6	1.3	86.9	91.0	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	32.5	85.6	0.0	93.1	94.3	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	6.5	45.0	0.6	60.1	61.0	s6
s7	-70	60.0	-75	58.3	-120.0	22.6	36.5	45.0	101.9	1.1	59.1	70.9	s7
s8	-60	65.7	-180	0.0	-155.0	0.0	0	0.0	0.0	0.2	17.7	24.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	45.0	101.3	0.6	75.9	79.8	t0
t1	-47	73.1	-48	73.3	-45.0	71.0	32	45.0	96.3	1.0	78.2	80.0	t1
t3	-20	88.6	10	105.6	-15.0	90.3	38	40.5	98.1	0.8	96.3	98.8	t3
t5	-5	97.1	-45	75.0	-30.0	80.6	35	32.0	83.8	0.2	84.4	87.8	t5
t6	-95	45.7	-101	43.9	-155.0	0.0	0	44.0	55.0	0.0	34.9	47.4	t6
u0	-85	51.4	-71	60.6	-155.0	0.0	0	0.0	0.0	0.6	30.5	42.6	u0
u1	-20	88.6	-35	80.6	-15.0	90.3	35.5	43.5	98.8	0.6	89.5	92.4	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	45.0	102.5	0.6	89.6	96.0	u5
u6	-42	76.0	-26	85.6	-15.0	90.3	30.5	45.0	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	67.5	1.6	89.3	89.3	x0