Excel gradebook for teacher who grades by points 

Thank for being so clear in your directions. I saw so many videos before this and the directions were so vague!

Just wanted to say thank you so much for making this video. It helped me learn a lot about using Excel with grades. Cheers!

great video with very clear instructions which I could follow. Where is the next video on how to automatically set grades in relation to the percentage?

Quick refresher on "how tos" I forgot how to... THanks

Thanks so much. I needed EXACTLY this information! You're the man. The EXCELlent man. ;-)

amazing. this is so very helpful. thank you.

This is so helpful. Thank you!

this worked really well!

average is ok. how to write the complete formulae to calculate the formulae?

fantastic!!!thoughtfuly!!!

Here's my favorite piece of code. Good for vocabulary quizzes. 1 point for survey 0.8 for survay 0.5 servay The ESL student knew the correct word but had difficulty spelling it. =IFS(SEARCH("survey",F2),"1",SEARCH("survay",F2),".8",SEARCH("servay",F2),".5",TRUE,"0") The students entered their answers using Google forms. I emailed them the link to the form. They answered using their cellphones. I turned off the form after everyone present said they were finished. Google forms exported everything to a spreadsheet.

thanks !

dude just double click the column to adjust to a fitted width.