The first 8 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 report score (or Book report or Scientific Paper report score), and the total number of 1S1P pts you earned during the semester.

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.

The next column shows the total number of extra points you have earned on the Optional Assignments (a total of 3.05 pts was possible)

The last two columns show your overall average.
The first average, in red, with no quiz scores 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.  This score plus you Final Exam grade will determine your overall grade in the class.

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

Class ID	Quiz #1	Q1(%)	Quiz #2	Q2(%)	Quiz #3	Q3(%)	Quiz #4	Q4(%)	Expt.	Total 1S1P pts	Writing grade	Extra Credit	Overall aver. no	Overall aver. lowest	Class ID
									report	pts total	estimate	points	quizzes dropped	quiz dropped
a0	-20	88.6	-24	86.7	-15.0	90.3	-30.0	83.3	33	45	97.5	1.6	90.9	92.4	a0
a2	-30	82.9	-35	80.6	-20.0	87.1	-15.0	91.7	35.5	45	100.6	3.0	91.6	93.6	a2
a3	-58	66.9	-60	66.7	-155.0	0.0	-180.0	0.0	0	22	27.5	1.0	33.3	41.3	a3
a4	-18	89.7	-40	77.8	-30.0	80.6	-10.0	94.4	37.5	45	103.1	1.9	91.0	93.9	a4
a5	-120	31.4	-51	71.7	-35.0	77.4	-42.0	76.7	29	0	36.3	0.8	59.5	66.4	a5
a6	-30	82.9	-51	71.7	-55.0	64.5	-42.0	76.7	38	45	103.8	2.3	82.2	86.0	a6
a7	-5	97.1	-15	91.7	-13.0	91.6	-30.0	83.3	32	45	96.3	1.2	93.3	95.4	a7
a8	5	102.9	-35	80.6	-90.0	41.9	-35.0	80.6	35	45	100.0	0.0	81.2	91.0	a8
a9	-105	40.0	-107	40.6	-45.0	71.0	-55.0	69.4	30	45	93.8	0.2	63.2	68.9	a9
b0	-45	74.3	-52	71.1	-21.5	86.1	-62.0	65.6	32	41.5	91.9	0.8	78.6	81.7	b0
b1	0	100.0	-10	94.4	10.0	106.5	-10.0	94.4	34.5	45	99.4	0.2	99.2	100.3	b1
b2	-65	62.9	-57	68.3	-50.5	67.4	-20.0	88.9	29	39.5	85.6	0.8	75.5	78.4	b2
b3	-50	71.4	-29	83.9	-58.0	62.6	-52.0	71.1	35.5	45	100.6	1.2	79.2	83.0	b3
b4	-70	60.0	-60	66.7	-155.0	0.0	-180.0	0.0	28.5	29	71.9	0.8	40.6	50.5	b4
b5	-25	85.7	-26	85.6	-2.0	98.7	-26.0	85.6	37	42.5	99.4	1.2	92.2	93.6	b5
b8	-25	85.7	-55	69.4	-15.0	90.3	0.0	100.0	36	45	101.3	2.1	91.4	96.4	b8
b9	-55	68.6	-85	52.8	-65.0	58.1	-7.0	96.1	32	26	72.5	0.9	70.5	74.7	b9
c0	-35	80.0	-51	71.7	-5.0	96.8	-15.0	91.7	29	45	92.5	0.5	87.0	90.7	c0
c1	-90	48.6	-70	61.1	-60.0	61.3	-92.0	48.9	31.5	45	95.6	1.9	65.0	68.6	c1
c2	-175	0.0	-36	80.0	-28.0	81.9	-25.0	86.1	27	18.5	56.9	0.4	61.4	76.7	c2
c3	-45	74.3	-32	82.2	-25.5	83.5	5.0	102.8	37.5	45	103.1	1.9	91.1	94.8	c3
c5	-42	76.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	15.3	19.1	c5
c6	-45	74.3	-69	61.7	-28.0	81.9	-32.0	82.2	35.5	45	100.6	1.3	81.4	86.1	c6
c7	-10	94.3	5	102.8	-43.0	72.3	-70.0	61.1	37.5	40	96.9	0.4	85.9	92.0	c7
c8	-25	85.7	-55	69.4	-45.0	71.0	-65.0	63.9	35	39	92.5	1.5	78.0	81.2	c8
c9	-15	91.4	-83	53.9	-21.0	86.5	-10.0	94.4	34.5	45	99.4	1.5	86.7	94.5	c9
d0	-35	80.0	-45	75.0	-51.0	67.1	-30.0	83.3	37.5	45	103.1	2.1	83.8	87.5	d0
d1	-20	88.6	-41	77.2	-50.0	67.7	-10.0	94.4	38.5	45	104.4	1.9	88.4	93.1	d1
d3	-40	77.1	-37	79.4	-40.0	74.2	-15.0	91.7	35.5	45	100.6	1.5	86.1	88.7	d3
d4	-50	71.4	-42	76.7	-30.0	80.6	-70.0	61.1	31.5	15.5	58.8	0.8	70.6	72.7	d4
d5	-20	88.6	-47	73.9	-15.0	90.3	-30.0	83.3	37	31.5	85.6	0.4	84.8	87.4	d5
d6	-60	65.7	76	142.2	-68.0	56.1	-102.0	43.3	24	35	73.8	0.4	76.7	84.9	d6
d7	-55	68.6	-64	64.4	-46.0	70.3	-80.0	55.6	27.5	45	90.6	1.7	71.6	75.2	d7
d8	-5	97.1	-25	86.1	-20.0	87.1	-42.0	76.7	34.5	33	84.4	0.6	86.9	89.3	d8
d9	0	100.0	-5	97.2	15.0	109.7	-14.0	92.2	34	45	98.8	1.2	100.8	102.7	d9
e1	-175	0.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	0.1	0.1	e1
e2	-25	85.7	-19	89.4	-30.0	80.6	10.0	105.6	34	45	98.8	0.6	92.7	95.5	e2
e3	-10	94.3	-30	83.3	-20.0	87.1	5.0	102.8	38	45	103.8	0.8	95.1	97.8	e3
e4	-85	51.4	-84	53.3	-52.0	66.5	-67.0	62.8	33	45	97.5	1.7	68.0	71.7	e4
e5	-8	95.4	-25	86.1	-15.0	90.3	-20.0	88.9	37.5	45	103.1	3.1	95.9	97.5	e5
e6	5	102.9	-7	96.1	-5.0	96.8	-25.0	86.1	36.5	45	101.9	1.2	98.0	100.7	e6
e7	-27	84.6	-26	85.6	-15.0	90.3	-35.0	80.6	36.5	25	76.9	0.9	84.5	85.2	e7
e8	-30	82.9	-74	58.9	-45.0	71.0	-45.0	75.0	31	44.5	94.4	0.9	77.3	81.7	e8
f0	-25	85.7	-61	66.1	-50.0	67.7	-22.0	87.8	36.5	43	99.4	0.4	81.8	85.6	f0
f1	-30	82.9	-95	47.2	-37.0	76.1	-30.0	83.3	37	39	95.0	1.5	78.4	85.8	f1
f3	-45	74.3	-35	80.6	-29.5	81.0	-25.0	86.1	37.5	45	103.1	2.1	87.1	89.8	f3
f4	-15	91.4	-25	86.1	-35.0	77.4	-13.0	92.8	28.5	40	85.6	0.8	87.5	89.8	f4
f6	-65	62.9	-50	72.2	-27.5	82.3	-34.0	81.1	36	41	96.3	1.9	80.8	84.9	f6
f7	-35	80.0	-75	58.3	-155.0	0.0	-15.0	91.7	0	12	15.0	0.6	49.7	61.9	f7
f8	-73	58.3	-89	50.6	-90.0	41.9	-80.0	55.6	0	0	0.0	0.6	41.9	41.7	f8
g1	-75	57.1	-35	80.6	-55.0	64.5	-32.0	82.2	33.5	45	98.1	1.0	77.6	82.4	g1
g2	-68	61.1	-30	83.3	-49.5	68.1	-19.0	89.4	37.5	45	103.1	1.4	82.5	87.4	g2
g3	-25	85.7	-46	74.4	-50.0	67.7	-15.0	91.7	28	44	90.0	1.1	83.0	86.6	g3
g4	-13	92.6	-32	82.2	-20.0	87.1	-20.0	88.9	36.5	45	101.9	2.0	92.6	94.7	g4
g5	-25	85.7	-30	83.3	-29.5	81.0	-5.0	97.2	36	45	101.3	2.3	92.0	94.2	g5
g6	-25	85.7	-6	96.7	5.0	103.2	10.0	105.6	36	45	101.3	1.2	99.7	102.9	g6
g7	-70	60.0	-84	53.3	-150.5	2.9	-180.0	0.0	33.5	37	88.1	0.4	41.3	51.5	g7
g8	-20	88.6	-36	80.0	-100.0	35.5	-15.0	91.7	0	45	56.3	0.0	70.4	79.2	g8
h0	-85	51.4	-110	38.9	-45.0	71.0	-50.0	72.2	27.5	37	80.6	0.4	63.3	69.3	h0
h1	-105	40.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	8.1	10.1	h1
h2	-35	80.0	-50	72.2	-17.0	89.0	-15.0	91.7	38	45	103.8	2.3	89.6	93.4	h2
h3	-20	88.6	30	116.7	-29.5	81.0	-15.0	91.7	28.5	38.5	83.8	1.2	93.6	96.4	h3
h4	-10	94.3	-25	86.1	-15.0	90.3	2.0	101.1	36.5	45	101.9	0.4	95.2	97.3	h4
h5	-10	94.3	-25	86.1	-35.0	77.4	-2.0	98.9	39	45	105.0	2.3	94.6	98.4	h5
h6	-15	91.4	-50	72.2	-20.0	87.1	-32.0	82.2	29	30.5	74.4	0.4	81.9	84.2	h6
h7	-70	60.0	-64	64.4	-40.0	74.2	-30.0	83.3	36.5	45	101.9	1.6	78.4	82.6	h7
h8	-70	60.0	-50	72.2	-35.0	77.4	-92.0	48.9	38	45	103.8	0.7	73.2	79.0	h8
h9	-80	54.3	-87	51.7	-30.0	80.6	-30.0	83.3	32	41	91.3	1.5	73.7	78.9	h9
j0	-78	55.4	-79	56.1	-56.5	63.5	-180.0	0.0	30	19	61.3	0.2	47.5	59.3	j0
j1	-175	0.0	-180	0.0	-155.0	0.0	-69.0	61.7	0	9.5	11.9	0.2	15.0	18.6	j1
j3	-65	62.9	-101	43.9	-70.0	54.8	-55.0	69.4	34	23.5	71.9	0.9	61.5	65.7	j3
j5	-25	85.7	-51	71.7	-55.0	64.5	-10.0	94.4	25	40	81.3	0.4	80.0	83.7	j5
j6	-12	93.1	-20	88.9	-21.5	86.1	-34.0	81.1	37	45	102.5	1.9	92.3	94.6	j6
j7	-78	55.4	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	11.1	13.9	j7
j8	-65	62.9	-36	80.0	-22.0	85.8	-25.0	86.1	30	44	92.5	1.5	83.0	87.6	j8
j9	5	102.9	0	100.0	-10.0	93.5	-12.0	93.3	38	45	103.8	1.2	99.9	101.3	j9
k0	-100	42.9	-114	36.7	-52.0	66.5	-70.0	61.1	28	45	91.3	0.2	59.9	65.7	k0
k1	-15	91.4	-15	91.7	0.0	100.0	-10.0	94.4	38	25.5	79.4	0.2	91.6	91.6	k1
k2	-10	94.3	-31	82.8	-45.0	71.0	-5.0	97.2	36.5	45	101.9	1.9	91.3	95.9	k2
k3	-15	91.4	-51	71.7	-25.0	83.9	-9.0	95.0	37	44.5	101.9	1.9	90.7	94.9	k3
k4	-90	48.6	-107	40.6	-65.0	58.1	-79.0	56.1	30	18.5	60.6	1.1	53.9	57.0	k4
k5	-55	68.6	-59	67.2	-22.5	85.5	-5.0	97.2	34.5	45	99.4	1.0	84.6	88.7	k5
k7	-75	57.1	-79	56.1	-105.0	32.3	-70.0	61.1	30.5	45	94.4	2.4	62.6	69.6	k7
k8	-65	62.9	-81	55.0	-55.0	64.5	-30.0	83.3	36	45	101.3	0.4	73.8	78.4	k8
k9	-10	94.3	-17	90.6	9.5	106.1	-15.0	91.7	35	45	100.0	1.9	98.4	99.9	k9
m0	-15	91.4	-36	80.0	-19.0	87.7	-22.0	87.8	37	45	102.5	2.7	92.6	95.1	m0
m1	-75	57.1	-57	68.3	-155.0	0.0	-180.0	0.0	0	29	36.3	0.4	32.8	40.9	m1
m2	-35	80.0	-49	72.8	-50.0	67.7	-32.0	82.2	36	45	101.3	0.6	81.4	84.7	m2
m3	0	100.0	7	103.9	10.0	106.5	-25.0	86.1	37	31.5	85.6	1.6	98.1	100.6	m3
m4	-40	77.1	-35	80.6	0.0	100.0	-22.0	87.8	37	19.5	70.6	0.2	83.5	85.0	m4
m6	-5	97.1	0	100.0	8.0	105.2	10.0	105.6	38.5	45	104.4	2.0	104.5	105.8	m6
m7	-40	77.1	-61	66.1	-70.0	54.8	-84.0	53.3	0	9	11.3	0.2	52.8	52.6	m7
m8	-35	80.0	-42	76.7	-60.0	61.3	-55.0	69.4	36.5	37	91.9	0.8	76.7	80.3	m8
m9	-50	71.4	-35	80.6	-70.0	54.8	-30.0	83.3	30	43.5	91.9	0.0	76.5	81.8	m9
n0	-35	80.0	-31	82.8	-23.0	85.2	-32.0	82.2	36	45	101.3	1.2	87.5	89.1	n0
n1	0	100.0	-17	90.6	0.0	100.0	-15.0	91.7	37.5	45	103.1	1.4	98.5	100.1	n1
n2	-75	57.1	-90	50.0	-155.0	0.0	-180.0	0.0	0	24.5	30.6	0.0	27.6	34.5	n2
n3	-175	0.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	0.1	0.1	n3
n4	-50	71.4	-50	72.2	-30.0	80.6	-32.0	82.2	29.5	43	90.6	1.0	80.5	82.5	n4
n5	-85	51.4	-50	72.2	-30.0	80.6	-14.0	92.2	33.5	0	41.9	0.4	68.1	72.2	n5
n6	-80	54.3	-60	66.7	-32.5	79.0	-45.0	75.0	38	45	103.8	2.3	78.0	83.4	n6
n7	-40	77.1	-26	85.6	-25.0	83.9	-30.0	83.3	32.5	45	96.9	1.2	86.6	88.7	n7
n9	-12	93.1	-20	88.9	-5.0	96.8	7.0	103.9	32	45	96.3	0.8	96.6	98.4	n9
p1	-55	68.6	-124	31.1	-85.0	45.2	-67.0	62.8	31	28.5	74.4	0.8	57.2	63.6	p1
p2	-20	88.6	-35	80.6	-40.0	74.2	-22.0	87.8	36	42.5	98.1	1.2	87.1	90.0	p2
p3	-15	91.4	-75	58.3	-14.5	90.6	-8.0	95.6	37	45	102.5	1.3	89.0	96.3	p3
p4	-80	54.3	-100	44.4	-70.0	54.8	-180.0	0.0	0	0	0.0	0.2	31.0	38.6	p4
p5	-45	74.3	-49	72.8	-20.0	87.1	-15.0	91.7	35.5	45	100.6	0.9	86.2	89.3	p5
p6	-60	65.7	-45	75.0	-58.0	62.6	-55.0	69.4	29	45	92.5	1.2	74.3	76.9	p6
p7	-7	96.0	-61	66.1	-53.0	65.8	-47.0	73.9	35.5	45	100.6	2.3	82.8	86.5	p7
p9	-25	85.7	-76	57.8	-30.0	80.6	-40.0	77.8	34	37.5	89.4	0.6	78.9	84.0	p9
r0	-65	62.9	-81	55.0	-14.0	91.0	-27.0	85.0	30	45	93.8	1.5	79.0	84.6	r0
r1	-30	82.9	-70	61.1	-65.0	58.1	-95.0	47.2	29.5	32	76.9	0.2	65.5	70.0	r1
r2	5	102.9	-10	94.4	5.0	103.2	-20.0	88.9	30.5	45	94.4	0.0	96.8	98.8	r2
r3	-35	80.0	-90	50.0	-35.0	77.4	-30.0	83.3	38.5	45	104.4	1.5	80.5	87.8	r3
r4	-5	97.1	5	102.8	-5.0	96.8	5.0	102.8	36.5	43.5	100.0	1.2	101.1	101.9	r4
r6	-95	45.7	-61	66.1	-60.0	61.3	-7.0	96.1	30.5	11.5	52.5	1.0	65.4	70.1	r6
r7	-25	85.7	9	105.0	-60.0	61.3	-72.0	60.0	32	38.5	88.1	2.1	82.1	87.1	r7
r8	-88	49.7	-90	50.0	-45.0	71.0	-69.0	61.7	29.5	15	55.6	0.3	57.9	59.9	r8
r9	0	100.0	-15	91.7	0.0	100.0	10.0	105.6	38	45	103.8	0.8	101.0	103.2	r9
s2	-55	68.6	-15	91.7	-10.0	93.5	3.0	101.7	34	45	98.8	1.6	92.4	98.0	s2
s3	-55	68.6	-51	71.7	-51.0	67.1	-2.0	98.9	35.5	45	100.6	1.1	82.5	86.1	s3
s4	-85	51.4	-55	69.4	-50.0	67.7	-20.0	88.9	28	35.5	79.4	0.8	72.2	77.2	s4
s5	-13	92.6	-20	88.9	-40.0	74.2	0.0	100.0	35	45	100.0	0.4	91.6	95.8	s5
s6	-40	77.1	-53	70.6	-55.0	64.5	-60.0	66.7	36	40	95.0	0.6	75.4	78.0	s6
s8	-175	0.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	0.1	0.1	s8
s9	-90	48.6	-106	41.1	-60.0	61.3	-95.0	47.2	30.5	35.5	82.5	1.1	57.2	61.0	s9
t0	-75	57.1	-65	63.9	-110.0	29.0	-114.0	36.7	37.5	38	94.4	0.8	57.1	63.9	t0
t1	-65	62.9	-64	64.4	-70.0	54.8	-70.0	61.1	28	27	68.8	0.6	63.1	64.9	t1
t2	-70	60.0	-72	60.0	-60.0	61.3	-89.0	50.6	34	38	90.0	1.2	65.6	69.1	t2
t3	-10	94.3	-31	82.8	-5.0	96.8	-40.0	77.8	35	0	43.8	0.6	79.7	80.0	t3
t4	-10	94.3	-35	80.6	-35.0	77.4	-39.0	78.3	36	22	72.5	1.5	82.1	82.9	t4
t5	-55	68.6	-20	88.9	-15.0	90.3	-20.0	88.9	36	45	101.3	1.3	88.9	93.6	t5
t7	-55	68.6	-44	75.6	0.0	100.0	-40.0	77.8	29	16	56.3	0.8	76.5	78.2	t7
t8	-120	31.4	-109	39.4	-70.0	54.8	-47.0	73.9	29.5	43	90.6	0.9	58.9	65.6	t8
u0	-50	71.4	-65	63.9	-40.0	74.2	-22.0	87.8	33.5	29.5	78.8	1.3	76.5	79.3	u0
u1	-5	97.1	10	105.6	3.0	101.9	-17.0	90.6	37	45	102.5	1.6	101.2	103.4	u1
u2	-65	62.9	-21	88.3	-40.0	74.2	-180.0	0.0	36.5	10	58.1	0.2	57.0	71.1	u2
u3	-30	82.9	-3	98.3	-5.0	96.8	-5.0	97.2	38.5	45	104.4	1.2	97.2	100.4	u3
u5	-175	0.0	-180	0.0	-155.0	0.0	-180.0	0.0	0	0	0.0	0.0	0.1	0.1	u5
u6	-75	57.1	-71	60.6	-45.0	71.0	-80.0	55.6	32	31.5	79.4	1.3	66.0	68.3	u6
w0	-20	88.6	-50	72.2	-11.0	92.9	-40.0	77.8	36	45	101.3	1.9	88.4	92.0	w0
w1	-42	76.0	-48	73.3	-36.0	76.8	-34.5	80.8	32	45	96.3	1.0	81.7	83.5	w1
w2	-55	68.6	-51	71.7	-55.0	64.5	-85.0	52.8	33	30	78.8	0.4	67.7	71.3	w2
x0	-90	48.6	-117	35.0	-75.0	51.6	-115.0	36.1	30.5	9	49.4	0.3	44.4	46.7	x0
x1	-40	77.1	-22	87.8	-6.0	96.1	-19.0	89.4	35.5	40	94.4	1.9	90.9	93.8	x1