Barbara Bracken
Title
Student	Exam1	Exam2	Exam3	Project1	Project2	Homework1	Homework2	Final Exam	Numerical Grade	Course Grade	lookup	Lookup
Jack Tripper	90	88	76	100	98	87	73	89	=(0.3*AVERAGE(E4:F4))+(0.05*AVERAGE(G4:H4))+(0.2*MAX(B4:D4))+(0.1*MIN(B4:D4))+(0.15*MEDIAN(B4:D4))+(0.2*I4)	=VLOOKUP(J4,L$4:M$11,2)	0	0
Janet Wood	93	86	76	95	94	100	92	82	=(0.3*AVERAGE(E5:F5))+(0.05*AVERAGE(G5:H5))+(0.2*MAX(B5:D5))+(0.1*MIN(B5:D5))+(0.15*MEDIAN(B5:D5))+(0.2*I5)	=VLOOKUP(J5,L$4:M$11,2)	57	1
Chrissy Snow	78	82	90	100	84	100	95	90	=(0.3*AVERAGE(E6:F6))+(0.05*AVERAGE(G6:H6))+(0.2*MAX(B6:D6))+(0.1*MIN(B6:D6))+(0.15*MEDIAN(B6:D6))+(0.2*I6)	=VLOOKUP(J6,L$4:M$11,2)	63	1.5
Helen Roper	100	54	78	88	82	94	85	92	=(0.3*AVERAGE(E7:F7))+(0.05*AVERAGE(G7:H7))+(0.2*MAX(B7:D7))+(0.1*MIN(B7:D7))+(0.15*MEDIAN(B7:D7))+(0.2*I7)	=VLOOKUP(J7,L$4:M$11,2)	69	2
Stanley Roper	64	72	80	91	82	90	67	89	=(0.3*AVERAGE(E8:F8))+(0.05*AVERAGE(G8:H8))+(0.2*MAX(B8:D8))+(0.1*MIN(B8:D8))+(0.15*MEDIAN(B8:D8))+(0.2*I8)	=VLOOKUP(J8,L$4:M$11,2)	75	2.5
Average	=AVERAGE(B4:B8)	=AVERAGE(C4:C8)	=AVERAGE(D4:D8)	=AVERAGE(E4:E8)	=AVERAGE(F4:F8)			=AVERAGE(I4:I8)			81	3
Minimum	=MIN(B4:B8)	=MIN(C4:C8)	=MIN(D4:D8)	=MIN(E4:E8)	=MIN(F4:F8)			=MIN(I4:I8)			87	3.5
Maximum	=MAX(B4:B8)	=MAX(C4:C8)	=MAX(D4:D8)	=MAX(E4:E8)	=MAX(F4:F8)			=MAX(I4:I8)			93	4