Spreadsheet

Grading Schedule for Fall, 2003

First Name

Last Name

HMW 1

HMW 2

HMW 3

HMW 4

HMW 5

HMW AVG

Quiz 1

Quiz 2

Quiz 3

QUIZ AVG

Test 1

Test 2

Final Exam

Score

GRADE

Joy

Barber

=SUM(D4:H4)/0.5

=SUM(J4:L4)/0.3

100

=SUM(I4*0.2)+(M4*0.2)+(N4*0.15)+(O4*0.15)+(P4*0.3)

=LOOKUP(R4,A34:A44,B34:B44)

Kathy

Beaudry

=SUM(D5:H5)/0.5

=SUM(J5:L5)/0.3

100

=SUM(I5*0.2)+ (M5*0.2)+(N5*0.15)+(O5*0.15)+(P5*0.3)

=LOOKUP(R5,A35:A45,B35:B45)

Laura

Bedard

=SUM(D6:H6)/0.5

=SUM(J6:L6)/0.3

=SUM(I6*0.2)+ (M6*0.2)+(N6*0.15)+(O6*0.15)+(P6*0.3)

=LOOKUP(R6,A36:A46,B36:B46)

Amber

Beyette

=SUM(D7:H7)/0.5

=SUM(J7:L7)/0.3

=SUM(I7*0.2)+ (M7*0.2)+(N7*0.15)+(O7*0.15)+(P7*0.3)

=LOOKUP(R7,A37:A47,B37:B47)

Rebecca

Bragg

=SUM(D8:H8)/0.5

=SUM(J8:L8)/0.3

=SUM(I8*0.2)+ (M8*0.2)+(N8*0.15)+(O8*0.15)+(P8*0.3)

=LOOKUP(R8,A38:A48,B38:B48)

Joni

Capling

=SUM(D9:H9)/0.5

=SUM(J9:L9)/0.3

=SUM(I9*0.2)+ (M9*0.2)+(N9*0.15)+(O9*0.15)+(P9*0.3)

=LOOKUP(R9,A39:A49,B39:B49)

Joie

Christiansen

=SUM(D10:H10)/0.5

=SUM(J10:L10)/0.3

=SUM(I10*0.2)+ (M10*0.2)+(N10*0.15)+(O10*0.15)+(P10*0.3)

=LOOKUP(R10,A40:A50,B40:B50)

Kathleen

Christopher

=SUM(D11:H11)/0.5

=SUM(J11:L11)/0.3

=SUM(I11*0.2)+ (M11*0.2)+(N11*0.15)+(O11*0.15)+(P11*0.3)

=LOOKUP(R11,A41:A51,B41:B51)

Steve

Clifton

=SUM(D12:H12)/0.5

=SUM(J12:L12)/0.3

=SUM(I12*0.2)+ (M12*0.2)+(N12*0.15)+(O12*0.15)+(P12*0.3)

=LOOKUP(R12,A42:A52,B42:B52)

Charlie

Crittenden

=SUM(D13:H13)/0.5

=SUM(J13:L13)/0.3

=SUM(I13*0.2)+ (M13*0.2)+(N13*0.15)+(O13*0.15)+(P13*0.3)

=LOOKUP(R13,A43:A53,B43:B53)

Michelle

DeView

=SUM(D14:H14)/5

=SUM(J14:L14)/3

=SUM(I14*0.2)+ (M14*0.2)+(N14*0.15)+(O14*0.15)+(P14*0.3)

=LOOKUP(R14,A44:A54,B44:B54)

Dick

Gilmour

=SUM(D15:H15)/5

=SUM(J15:L15)/3

=SUM(I15*0.2)+ (M15*0.2)+(N15*0.15)+(O15*0.15)+(P15*0.3)

=LOOKUP(R15,A45:A55,B45:B55)

Dave

Greenough

=SUM(D16:H16)/5

=SUM(J16:L16)/3

=SUM(I16*0.2)+ (M16*0.2)+(N16*0.15)+(O16*0.15)+(P16*0.3)

=LOOKUP(R16,A46:A56,B46:B56)

Beth

Hanna

=SUM(D17:H17)/5

=SUM(J17:L17)/3

=SUM(I17*0.2)+ (M17*0.2)+(N17*0.15)+(O17*0.15)+(P17*0.3)

=LOOKUP(R17,A47:A57,B47:B57)

Amy

Hyden

=SUM(D18:H18)/5

=SUM(J18:L18)/3

=SUM(I18*0.2)+ (M18*0.2)+(N18*0.15)+(O18*0.15)+(P18*0.3)

=LOOKUP(R18,A48:A58,B48:B58)

Maggie

Kartheiser

=SUM(D19:H19)/5

=SUM(J19:L19)/3

=SUM(I19*0.2)+ (M19*0.2)+(N19*0.15)+(O19*0.15)+(P19*0.3)

=LOOKUP(R19,A49:A59,B49:B59)

Nicole

Lutz

=SUM(D20:H20)/5

=SUM(J20:L20)/3

=SUM(I20*0.2)+ (M20*0.2)+(N20*0.15)+(O20*0.15)+(P20*0.3)

=LOOKUP(R20,A50:A60,B50:B60)

Danita

Park

=SUM(D21:H21)/5

=SUM(J21:L21)/3

=SUM(I21*0.2)+ (M21*0.2)+(N21*0.15)+(O21*0.15)+(P21*0.3)

=LOOKUP(R21,A51:A61,B51:B61)

Jennifer

Phipps

=SUM(D22:H22)/5

=SUM(J22:L22)/3

=SUM(I22*0.2)+ (M22*0.2)+(N22*0.15)+(O22*0.15)+(P22*0.3)

=LOOKUP(R22,A52:A62,B52:B62)

Ricky

Pina

=SUM(D23:H23)/5

=SUM(J23:L23)/3

=SUM(I23*0.2)+ (M23*0.2)+(N23*0.15)+(O23*0.15)+(P23*0.3)

=LOOKUP(R23,A53:A63,B53:B63)

Janet

Rohen

=SUM(D24:H24)/5

=SUM(J24:L24)/3

=SUM(I24*0.2)+ (M24*0.2)+(N24*0.15)+(O24*0.15)+(P24*0.3)

=LOOKUP(R24,A54:A64,B54:B64)

Megan

Scott

=SUM(D25:H25)/5

=SUM(J25:L25)/3

=SUM(I25*0.2)+ (M25*0.2)+(N25*0.15)+(O25*0.15)+(P25*0.3)

=LOOKUP(R25,A55:A65,B55:B65)

Eric

Stowers

=SUM(D26:H26)/5

=SUM(J26:L26)/3

=SUM(I26*0.2)+ (M26*0.2)+(N26*0.15)+(O26*0.15)+(P26*0.3)

=LOOKUP(R26,A56:A66,B56:B66)

Liz

Vogel

=SUM(D27:H27)/5

=SUM(J27:L27)/3

=SUM(I27*0.2)+ (M27*0.2)+(N27*0.15)+(O27*0.15)+(P27*0.3)

=LOOKUP(R27,A57:A67,B57:B67)

Rachel

White

=SUM(D28:H28)/5

=SUM(J28:L28)/3

=SUM(I28*0.2)+ (M28*0.2)+(N28*0.15)+(O28*0.15)+(P28*0.3)

=LOOKUP(R28,A58:A68,B58:B68)

Grading Scale

Percentage

Grade

D+

C-

C+

B-

B+

A-