For teachers: How to use Excel to analyse a test given to students.

[@kathykovach9937]

I've used Excel for years, but I just learned some cool features. I will be reviewing this video more than once, I'm sure. Thank you!

[@abbycameron1240]

Thank you so much for this extensive video. I appreciate your expertise and will be using this.

[@anafernandez4906]

So helpful. Now I can track data for my students.

[@lauradehart1397]

This is a super helpful video for me and my students!! Thank you!

[@omarghosn8655]

This would be supercharged if the questions were labelled with a category...you can then see which categories would be weaker than others so you can focus your efforts on an particular area as opposed to a scatter approach

[@centralwestpropertyservice3159]

UGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHhhhhhh

[@truckerdaddy-akajohninqueb4793]

I'm using Google Forms to give the quiz.
One question is
"4. Someone who does a work-study training, in English we call that person an ________________. "
I'm parsing (case insensitive) for the word "intern", but I'll also accept "trainee".
After the students complete, I export the answers into an excel spreadsheet. Then I parse cells with answers.
Cell O2 function which analyses cell N2:
--------------------------------------------------------------------------------------------------------------
=if(
OR(
ISNUMBER(SEARCH("intern",N2)),ISNUMBER(SEARCH("trainee",N2))
)
, "1", "0")
1 = Correct; 0 = Wrong

[@buick83]

Where can I buy this version of program, because I bought words 365 personal, and I don't like it the program looks so different then your program

[@naiyas.sajjan5686]

its arelly helpful vedio sir thank u

[@drewsemple3555]

Thanks for this, Matt. Very useful resource.

[@cathrinemorris6781]

Thanks

[@mrkhalidhafeth5823]

Excellent

[@LilimaKaefi]

It's blurry and can't be seen properly ...

[@antonioj.bungcagjr.6392]

what do you mean by "out/off"

[@sarabegermy6604]

The question full grade

[@mdushandu4818]

Nice

[@purbashachowdhury2985]

Hi...thanks for your video. But I just need a little help with something similar to this. Can we connect?

[@purbashachowdhury2985]

Please let me know if you can help me with analyzing a similar excel sheet

[@wenanyaugustine3311]

Thanks