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?
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.
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.
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!
amazing. this is so very helpful. thank you.
This is so helpful. Thank you!
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?
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.
Thanks so much. I needed EXACTLY this information! You're the man. The EXCELlent man. ;-)
Quick refresher on "how tos" I forgot how to... THanks
this worked really well!
fantastic!!!thoughtfuly!!!
thanks !
average is ok. how to write the complete formulae to calculate the formulae?
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.
dude just double click the column to adjust to a fitted width.