Monday, August 19, 2019

Monday Aug 19th Day 4

Textbook check-out 




Assignment sheet set-up... here is the formula for auto-grade display (place this formula in the 1st cell of the Grade column. Once in place copy it down the length of the sheet to include all assignments)




=index({0,"F";60,"D-";64,"D";67,"D+";70,"C-";74,"C";77,"C+";80,"B-";84,"B";87,"B+";90,"A-";94,"A";97,"A+"},match(G2*100,index({0,"F";60,"D-";64,"D";67,"D+";70,"C-";74,"C";77,"C+";80,"B-";84,"B";87,"B";90,"A-";94,"A";97,"A+"},0,1)),2)



Let's find out about you....