Excel gradebook for teacher who grades by points

Screencast for Bridgewater College EDUC 370 students to create an Excel gradebook for a teacher who grades on a point system.

[@maryamjafari8659]

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

[@kuropixeljp]

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

[@devthoughts3889]

amazing. this is so very helpful. thank you.

[@Noel-fi3mr]

This is so helpful. Thank you!

[@thomaslarsson4573]

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?

[@joehill8092]

Feel free to view my videos linked at this site:
joehillfamily.com/bc-tep-screencasts/
I’m retired now but enjoyed making these videos for my students at Bridgewater College.

[@deGuzmanEddie]

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

[@mmueller5196]

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

[@humbertosoto6147]

this worked really well!

[@mekashamekuria9507]

fantastic!!!thoughtfuly!!!

[@alectirado5007]

thanks !

[@lalakawijerathna6241]

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

[@truckerdaddy-akajohninqueb4793]

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.

[@hmanhaan123]

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