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	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	45	97.5	0.8	91.1	92.3	a0
a2	-30	82.9	-35	80.6	-20.0	87.1	35.5	45	100.6	2.0	88.9	90.8	a2
a3	-58	66.9	-60	66.7	-155.0	0.0	0	22	27.5	1.0	42.1	57.9	a3
a4	-18	89.7	-40	77.8	-30.0	80.6	37.5	45	103.1	1.2	88.0	90.9	a4
a5	-120	31.4	-51	71.7	-35.0	77.4	29	0	36.3	0.8	56.2	65.8	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	45	100.0	0.0	80.1	93.8	a8
a9	-105	40.0	-107	40.6	-45.0	71.0	30	45	93.8	0.2	59.4	65.5	a9
b0	-45	74.3	-52	71.1	-21.5	86.1	32	41.5	91.9	0.8	80.9	83.9	b0
b1	0	100.0	-10	94.4	10.0	106.5	34.5	45	99.4	0.2	100.3	102.5	b1
b2	-65	62.9	-57	68.3	-50.5	67.4	29	39.5	85.6	0.6	70.7	72.9	b2
b3	-50	71.4	-29	83.9	-58.0	62.6	35.5	45	100.6	0.8	79.0	84.2	b3
b4	-70	60.0	-60	66.7	-155.0	0.0	28.5	29	71.9	0.8	49.0	66.3	b4
b5	-25	85.7	-26	85.6	-2.0	98.7	37	42.5	99.4	0.8	92.7	94.8	b5
b8	-25	85.7	-55	69.4	-15.0	90.3	36	45	101.3	1.0	86.7	92.3	b8
b9	-55	68.6	-85	52.8	-65.0	58.1	26.5	26	65.6	0.2	61.2	64.1	b9
c0	-35	80.0	-51	71.7	-5.0	96.8	29	45	92.5	0.2	85.0	89.6	c0
c1	-90	48.6	-70	61.1	-60.0	61.3	31.5	45	95.6	1.2	65.9	71.0	c1
c2	-175	0.0	-36	80.0	-28.0	81.9	27	18.5	56.9	0.0	54.6	74.9	c2
c3	-45	74.3	-32	82.2	-25.5	83.5	37.5	45	103.1	1.2	85.8	89.1	c3
c5	-42	76.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	20.3	28.5	c5
c6	-45	74.3	-69	61.7	-28.0	81.9	35.5	45	100.6	0.6	78.8	84.3	c6
c7	-10	94.3	5	102.8	-43.0	72.3	37.5	16	66.9	0.4	85.6	91.0	c7
c8	-25	85.7	-55	69.4	-45.0	71.0	35	39	92.5	1.1	79.9	82.9	c8
c9	-15	91.4	-83	53.9	-21.0	86.5	34.5	45	99.4	1.1	82.8	92.6	c9
d0	-35	80.0	-45	75.0	-51.0	67.1	37.5	45	103.1	0.8	80.7	84.7	d0
d1	-20	88.6	-41	77.2	-50.0	67.7	38.5	45	104.4	1.2	84.4	89.5	d1
d3	-40	77.1	-37	79.4	-40.0	74.2	35.5	43.5	98.8	0.8	82.1	84.2	d3
d4	-50	71.4	-42	76.7	-30.0	80.6	31.5	15.5	58.8	0.8	73.5	74.5	d4
d5	-20	88.6	-47	73.9	-15.0	90.3	37	31.5	85.6	0.0	84.5	88.5	d5
d6	-60	65.7	76	142.2	-68.0	56.1	24	35	73.8	0.4	85.6	96.8	d6
d7	-55	68.6	-64	64.4	-46.0	70.3	27.5	45	90.6	1.0	73.3	75.7	d7
d8	-5	97.1	-25	86.1	-20.0	87.1	34.5	33	84.4	0.2	89.2	90.4	d8
d9	0	100.0	-5	97.2	15.0	109.7	0	45	56.3	0.8	93.9	93.5	d9
e1	-175	0.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	0.0	0.0	e1
e2	-25	85.7	-19	89.4	-30.0	80.6	34	45	98.8	0.6	88.6	91.0	e2
e3	-10	94.3	-30	83.3	-20.0	87.1	38	45	103.8	0.8	92.1	94.8	e3
e4	-85	51.4	-84	53.3	-52.0	66.5	33	45	97.5	1.0	66.2	70.3	e4
e5	-8	95.4	-25	86.1	-15.0	90.3	37.5	45	103.1	2.0	95.1	97.4	e5
e6	5	102.9	-7	96.1	-5.0	96.8	36.5	45	101.9	0.8	100.0	101.1	e6
e7	-27	84.6	-26	85.6	-15.0	90.3	36.5	25	76.9	0.6	85.4	85.8	e7
e8	-30	82.9	-74	58.9	-45.0	71.0	25.5	44.5	87.5	0.2	74.4	79.8	e8
f0	-25	85.7	-61	66.1	-50.0	67.7	36.5	43	99.4	0.4	78.8	82.8	f0
f1	-30	82.9	-95	47.2	-37.0	76.1	37	39	95.0	0.8	74.8	84.2	f1
f3	-45	74.3	-35	80.6	-29.5	81.0	37.5	45	103.1	1.4	84.9	87.8	f3
f4	-15	91.4	-25	86.1	-35.0	77.4	28.5	40	85.6	0.2	85.3	88.2	f4
f6	-65	62.9	-50	72.2	-27.5	82.3	36	41	96.3	1.2	78.4	83.2	f6
f7	-35	80.0	-75	58.3	-155.0	0.0	0	12	15.0	0.2	40.1	55.8	f7
f8	-73	58.3	-89	50.6	-90.0	41.9	0	0	0.0	0.6	40.8	41.4	f8
g1	-75	57.1	-35	80.6	-55.0	64.5	33.5	45	98.1	0.6	74.1	79.5	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	44	90.0	0.4	79.2	83.0	g3
g4	-13	92.6	-32	82.2	-20.0	87.1	36.5	45	101.9	1.6	91.8	94.4	g4
g5	-25	85.7	-30	83.3	-29.5	81.0	36	45	101.3	1.4	88.3	90.1	g5
g6	-25	85.7	-6	96.7	5.0	103.2	36	45	101.3	0.4	96.8	100.7	g6
g7	-70	60.0	-84	53.3	-150.5	2.9	33.5	37	88.1	0.4	49.0	64.9	g7
g8	-20	88.6	-36	80.0	-100.0	35.5	0	22	27.5	0.0	59.9	70.1	g8
h0	-85	51.4	-110	38.9	-45.0	71.0	27.5	37	80.6	0.4	59.5	66.5	h0
h1	-105	40.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	10.7	15.0	h1
h2	-35	80.0	-50	72.2	-17.0	89.0	38	45	103.8	1.2	86.3	90.5	h2
h3	-20	88.6	30	116.7	-29.5	81.0	28.5	38.5	83.8	0.8	93.9	98.7	h3
h4	-10	94.3	-25	86.1	-15.0	90.3	36.5	45	101.9	0.4	93.0	95.1	h4
h5	-10	94.3	-25	86.1	-35.0	77.4	39	45	105.0	1.6	91.4	95.5	h5
h6	-15	91.4	-50	72.2	-20.0	87.1	29	30.5	74.4	0.4	82.1	85.9	h6
h7	-70	60.0	-64	64.4	-40.0	74.2	36.5	45	101.9	1.2	74.5	78.7	h7
h8	-70	60.0	-50	72.2	-35.0	77.4	38	30.5	85.6	0.4	73.4	77.9	h8
h9	-80	54.3	-87	51.7	-30.0	80.6	32	41	91.3	0.8	68.8	74.2	h9
j0	-78	55.4	-79	56.1	-56.5	63.5	30	19	61.3	0.2	59.1	60.4	j0
j1	-175	0.0	-180	0.0	-155.0	0.0	0	9.5	11.9	0.2	2.6	3.2	j1
j3	-65	62.9	-101	43.9	-70.0	54.8	34	23.5	71.9	0.2	57.7	62.3	j3
j5	-25	85.7	-51	71.7	-55.0	64.5	25	40	81.3	0.4	75.8	79.7	j5
j6	-12	93.1	-20	88.9	-21.5	86.1	37	45	102.5	1.2	93.2	95.1	j6
j7	-78	55.4	-180	0.0	-155.0	0.0	0	0	0.0	0.0	14.8	20.8	j7
j8	-65	62.9	-36	80.0	-22.0	85.8	30	44	92.5	0.8	80.3	86.1	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	45	91.3	0.2	57.4	64.0	k0
k1	-15	91.4	-15	91.7	0.0	100.0	38	25.5	79.4	0.2	91.6	91.9	k1
k2	-10	94.3	-31	82.8	-45.0	71.0	36.5	45	101.9	0.8	87.3	92.7	k2
k3	-15	91.4	-51	71.7	-25.0	83.9	37	44.5	101.9	1.2	87.4	92.4	k3
k4	-90	48.6	-107	40.6	-65.0	58.1	30	18.5	60.6	0.6	52.0	55.7	k4
k5	-55	68.6	-59	67.2	-22.5	85.5	34.5	45	99.4	0.6	79.5	83.2	k5
k7	-75	57.1	-79	56.1	-105.0	32.3	30.5	45	94.4	1.7	59.4	67.8	k7
k8	-65	62.9	-81	55.0	-55.0	64.5	36	45	101.3	0.4	69.3	73.5	k8
k9	-10	94.3	-17	90.6	9.5	106.1	35	45	100.0	1.2	98.8	101.4	k9
m0	-15	91.4	-36	80.0	-19.0	87.7	37	45	102.5	1.6	91.2	94.4	m0
m1	-75	57.1	-57	68.3	-155.0	0.0	0	29	36.3	0.4	41.1	56.5	m1
m2	-35	80.0	-49	72.8	-50.0	67.7	36	45	101.3	0.6	79.7	83.2	m2
m3	0	100.0	7	103.9	10.0	106.5	37	31.5	85.6	1.2	101.1	101.5	m3
m4	-40	77.1	-35	80.6	0.0	100.0	37	19.5	70.6	0.2	83.0	85.6	m4
m6	-5	97.1	0	100.0	8.0	105.2	38.5	45	104.4	1.6	103.1	104.6	m6
m7	-40	77.1	-61	66.1	-70.0	54.8	0	9	11.3	0.2	55.3	56.7	m7
m8	-35	80.0	-42	76.7	-60.0	61.3	36.5	15.5	65.0	0.8	71.9	75.8	m8
m9	-50	71.4	-35	80.6	-70.0	54.8	30	30	75.0	0.0	70.2	75.7	m9
n0	-35	80.0	-31	82.8	-23.0	85.2	36	45	101.3	0.8	87.2	89.1	n0
n1	0	100.0	-17	90.6	0.0	100.0	37.5	45	103.1	1.0	99.1	101.8	n1
n2	-75	57.1	-90	50.0	-155.0	0.0	0	24.5	30.6	0.0	34.7	47.8	n2
n3	-175	0.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	0.0	0.0	n3
n4	-50	71.4	-50	72.2	-30.0	80.6	29.5	38	84.4	0.6	77.3	79.0	n4
n5	-85	51.4	-50	72.2	-30.0	80.6	33.5	0	41.9	0.4	63.3	68.2	n5
n6	-80	54.3	-60	66.7	-32.5	79.0	36.5	45	101.9	1.0	74.7	81.1	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	32	45	96.3	0.8	94.4	96.1	n9
p1	-55	68.6	-124	31.1	-85.0	45.2	31	28.5	74.4	0.8	54.3	62.0	p1
p2	-20	88.6	-35	80.6	-40.0	74.2	36	42.5	98.1	0.8	85.3	88.8	p2
p3	-15	91.4	-75	58.3	-14.5	90.6	37	45	102.5	0.6	85.2	94.5	p3
p4	-80	54.3	-100	44.4	-70.0	54.8	0	0	0.0	0.2	41.2	41.1	p4
p5	-45	74.3	-49	72.8	-20.0	87.1	35.5	45	100.6	0.2	82.8	85.9	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	35.5	37	90.6	1.6	80.5	85.0	p7
p9	-25	85.7	-76	57.8	-30.0	80.6	34	37.5	89.4	0.6	78.2	85.3	p9
r0	-65	62.9	-81	55.0	-14.0	91.0	30	45	93.8	0.8	75.2	81.9	r0
r1	-30	82.9	-70	61.1	-65.0	58.1	29.5	28.5	72.5	0.2	68.6	72.3	r1
r2	5	102.9	-10	94.4	5.0	103.2	30.5	45	94.4	0.0	99.0	100.9	r2
r3	-35	80.0	-90	50.0	-35.0	77.4	38.5	45	104.4	0.8	77.0	85.9	r3
r4	-5	97.1	5	102.8	-5.0	96.8	36.5	43.5	100.0	0.8	99.9	100.8	r4
r6	-95	45.7	-61	66.1	-60.0	61.3	27	0	33.8	0.6	53.5	56.8	r6
r7	-25	85.7	9	105.0	-60.0	61.3	32	38.5	88.1	1.4	86.2	94.9	r7
r8	-88	49.7	-90	50.0	-45.0	71.0	29.5	15	55.6	0.0	56.6	59.3	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	45	98.8	1.2	88.6	95.3	s2
s3	-55	68.6	-51	71.7	-51.0	67.1	35.5	45	100.6	1.1	76.5	78.8	s3
s4	-85	51.4	-55	69.4	-50.0	67.7	28	35.5	79.4	0.4	66.6	71.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	36	35	88.8	0.6	74.9	78.2	s6
s8	-175	0.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	0.0	0.0	s8
s9	-90	48.6	-106	41.1	-60.0	61.3	30.5	20.5	63.8	0.8	53.8	57.9	s9
t0	-75	57.1	-65	63.9	-110.0	29.0	37.5	38	94.4	0.8	59.7	69.8	t0
t1	-65	62.9	-64	64.4	-70.0	54.8	28	27	68.8	0.6	62.9	65.5	t1
t2	-70	60.0	-72	60.0	-60.0	61.3	34	38	90.0	1.2	67.5	69.2	t2
t3	-10	94.3	-31	82.8	-5.0	96.8	0	0	0.0	0.6	73.6	72.2	t3
t4	-10	94.3	-35	80.6	-35.0	77.4	36	22	72.5	0.8	82.6	84.5	t4
t5	-55	68.6	-20	88.9	-15.0	90.3	36	45	101.3	0.6	86.9	93.1	t5
t7	-55	68.6	-44	75.6	0.0	100.0	29	16	56.3	0.8	77.2	80.7	t7
t8	-120	31.4	-109	39.4	-70.0	54.8	24	42	82.5	0.2	50.2	56.2	t8
u0	-50	71.4	-65	63.9	-40.0	74.2	28	29.5	71.9	0.6	70.8	73.2	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	58.1	0.2	71.9	75.7	u2
u3	-30	82.9	-3	98.3	-5.0	96.8	38.5	45	104.4	0.8	95.8	100.1	u3
u5	-175	0.0	-180	0.0	-155.0	0.0	0	0	0.0	0.0	0.0	0.0	u5
u6	-75	57.1	-71	60.6	-45.0	71.0	0	31.5	39.4	0.6	58.8	59.8	u6
w0	-20	88.6	-50	72.2	-11.0	92.9	36	45	101.3	1.2	89.1	94.6	w0
w1	-42	76.0	-48	73.3	-36.0	76.8	0	45	56.3	1.0	72.5	72.4	w1
w2	-55	68.6	-51	71.7	-55.0	64.5	33	19	65.0	0.0	67.6	68.8	w2
x0	-90	48.6	-117	35.0	-75.0	51.6	30.5	9	49.4	0.0	45.9	49.9	x0
x1	-40	77.1	-22	87.8	-6.0	96.1	35.5	40	94.4	1.2	89.7	93.8	x1