Data Analysis for Teachers Using Excel (Part 2)

Examinating data analysis possibilities for tests, quizzes, asessments in general. This explores ways to look within data for certain averages and how tog et classwide statistics.

[@dawnhenry5003]

Thank you, Jon! This is exactly what I need to share with my teachers!! Simple, easy to understand with a real example.

[@beekerfkirina8130]

11 years later. Just wonderful.

[@sacryastudios9819]

HELP! For my 70s, it keeps showing #VALUE! even though it can be seen clearly that there is 1 student who got >70%

[@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

[@midiebenz]

Thank you Jon

[@MrMrBennyBoy]

Your countif formula criteria is a NONSENSE without explaining why you choose ">0.895", rather than ">=0.9". Thumbs down