112 Course Grades

THERE WAS AN ERROR IN A SPREADSHEET FORMULA
THE TEST GRADE FOR MID2 IS NOT CORRECT (it is the average of mid1/mid2)
The exam average below is incorrect. It is (mid1 + mid1 + mid2)/3

112 Spring 2006
Course Grade
As of April 17

The exam and program letter grades below are approximate letter grades. At the end of the semester I will calculate the final letter grades. However, these grades are representative of how I will calculate the final letter grades.

“P % Ave” is a weighted average of the programming assignment. For example: (p1*p1_weight + p2*p2_weight)/(p1_weight + p2_weight)

PIN	Mid 1	Mid 2	Exams	Exams	P1	P2	P3	P4	P5	P % Ave	Program	Course	Course
	%	%	%	Letter	1	2	4	3	5	<--wt	Letter	Grade	Letter
259	93	91	92	A	100	95	98	89	93	94.3	A	4.0	A
186	100	95	98	A	100	100	100	92	100	98.4	A	4.0	A
968	91	88	90	A	100	90	93	102	100	97.2	A	4.0	A
735	89	89	89	A-	100	100	93	98	97	96.7	A	3.9	A-
733	85	90	88	A-	100	95	97	107	100	99.9	A	3.9	A-
727	91	91	91	A	100	85	67	97	98	87.9	B+	3.7	A-
679	85	78	82	B+	100	100	100	110	100	102.0	A	3.7	A-
865	85	84	85	B+	98	95	85	106	100	96.4	A	3.7	A-
367	89	90	89	A	100	80	88	104	64	82.9	B	3.5	B+
523	88	85	86	A-	100	80	83	94	83	85.9	B+	3.5	B+
221	81	86	84	B+	100	95	89	98	84	90.7	A-	3.5	B+
182	88	87	87	A-	98	100	82	107	78	89.1	B+	3.5	B+
PIN	Mid 1	Mid 2	Exams	Exams	P1	P2	P3	P4	P5	P % Ave	Program	Course	Course
	%	%	%	Letter	1	2	4	3	5	<--wt	Letter	Grade	Letter
452	90	91	90	A	100	80	79	90	73	80.7	B	3.5	B+
720	80	70	75	B-	100	95	100	101	93	97.2	A	3.4	B+
131	70	81	75	B-	100	95	78	110	85	90.5	A-	3.2	B
102	75	69	72	B-	100	100	84	102	82	90.1	A-	3.2	B
533	88	87	87	A-	100	75	78	95	64	77.8	B-	3.2	B
460	88	86	87	A-	92	95	80	94	50	75.6	C+	3.0	B
658	79	73	76	B-	100	87	91	98	58	81.5	B	2.9	B-
273	60	66	63	C+	100	75	82	98	79	84.5	B+	2.8	B-
669	66	65	66	C+	65	85	78	90	80	81.1	B	2.7	B-
285	91	80	86	B+	100	95	77	104	0	60.7	C-	2.5	C+
344	78	62	70	B-	100	100	95	98	31	75.3	C+	2.5	C+
804	50	49	50	C	100	100	58	65	100	81.8	B	2.5	C+
435	48	58	53	C	100	90	73	86	73	79.7	B-	2.4	C+
PIN	Mid 1	Mid 2	Exams	Exams	P1	P2	P3	P4	P5	P % Ave	Program	Course	Course
	%	%	%	Letter	1	2	4	3	5	<--wt	Letter	Grade	Letter
896	79	74	76	B-	90	75	79	68	43	65.0	C	2.4	C+
151	70	60	65	C+	100	90	87	81	42	72.1	C+	2.3	C+
672	63	61	62	C+	100	80	91	73	50	72.9	C+	2.3	C+
265	33	29	31	D+	40	65	87	98	98	86.8	B+	2.3	C+
507	56	51	54	C	90	50	97	97	40	71.3	C+	2.2	C
270	56	56	56	C	100	90	73	96	56	76.0	C+	2.2	C
801	16	43	30	D+	100	65	83	86	48	70.7	C+	1.8	C-
406	34	37	35	D+	60	75	55	83	53	62.9	C-	1.5	D+
203	34	17	25	D	98	65	45	90	46	60.5	C-	1.4	D+
199	83	71	77	B-	0	0	94	78	0	40.7	F	1.4	D+
931	29	45	37	D+	60	65	30	98	50	56.9	D+	1.3	D+
365	64	57	60	C+	100	0	45	67	0	32.1	F	1.2	D
280	66	64	65	C+	50	80	0	0	0	14.0	F	1.2	D
PIN	Mid 1	Mid 2	Exams	Exams	P1	P2	P3	P4	P5	P % Ave	Program	Course	Course
	%	%	%	Letter	1	2	4	3	5	<--wt	Letter	Grade	Letter
480	68	34	51	C	100	100	74	0	0	39.7	F	1.0	D
491	48	38	43	C-	90	35	45	50	30	42.7	F	0.9	D-
169	58	29	43	C-	40	65	0	0	0	11.3	F	0.9	D-
909	38	33	35	D+	65	35	20	10	0	16.3	F	0.7	D-
217	39	19	29	D+	60	0	0	0	0	4.0	F	0.7	D-
358	39	33	36	D+	0	0	0	40	25	16.3	F	0.7	D-
152	34	38	36	D+	45	0	40	65	15	31.7	F	0.7	D-
219	31	19	25	D	0	70	0	0	30	19.3	F	0.5	F
637	35	18	26	D	55	40	0	0	0	9.0	F	0.5	F
806	31	26	29	D	0	50	45	50	0	28.7	F	0.5	F