Step 1, organize your Drive and set it up for the semester
Setting up file structure for your sjusd acct - File Structure
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)
