Curving grades in Excel using Average and Standard Deviation
Channel: RandomBytes
Date: 27/01/2019

Updated spreadsheet that includes a 2nd method: http://bit.ly/2YxIpTn , or https://www.dropbox.com/s/d90grspdsw4gwoc/Curve%20your%20grades%20-%20read%20only.xlsx?dl=0 Here's my attempt to curve test scores using averages and standard deviations.
You can download this spreadsheet from http://bit.ly/2Ru5X7i-Curve , or https://www.dropbox.com/s/6t7edo7txptsikq/Curve%20your%20grades.xlsx?dl=0 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 (https://creativecommons.org/licenses/by/4.0/)
Artist: http://audionautix.com/