lecture notes

in cell I8:
=(SUM(B8:H8)-MIN(B8:H8))/(COUNT(B8:H8)-1)

in cell T8:
=SUM(J8:S8)

in cell W8:
=AVERAGE(U8:V8)

in cell Y8
=I8*$B$40+T8*$B$41+W8*$B$42+X8*$B$43

VLOOKUP:
#1: value you are looking for on the table
(this will be usually on the same row as you)
#2: table you are looking at to try to find that value
#3: once you have the row, what column?
#4: range lookup? TRUE

=VLOOKUP(Y8,Grades,2,TRUE)

=IF(Y8>=Passing,"Enroll in CS 202","RETAKE CS 101")

Student Rank
=RANK(Y8,$Y$8:$Y$30)

http://eniac.cs.qc.cuny.edu/~svitak/cs12/