Updated spreadsheet that includes a 2nd method: [ Ссылка ] , or [ Ссылка ] Here's my attempt to curve test scores using averages and standard deviations.
You can download this spreadsheet from [ Ссылка ] , or [ Ссылка ] and give it a try.
I couldn't find another video explaining how to do this, so this is how I solved the problem. I do not go into an explanation of how a Vlookup Table works in this video; it's apparent enough if you look at the spreadsheet. Open questions are about assigning point values to failing grades as well as if I have the intervals correct.
If you want your students' grades to be higher, you could raise the average's grade to, say, 80% in the Vlookup table. What's your solution? How do you go about assigning grades when a straight percentage won't work?
Music: Big Blues Bed by Audionautix is licensed under a Creative Commons Attribution license ([ Ссылка ])
Artist: [ Ссылка ]
![](https://i.ytimg.com/vi/3ZHiXyzrrKA/maxresdefault.jpg)