Curving grades in Excel using Average and Standard Deviation скачать в хорошем качестве

Curving grades in Excel using Average and Standard Deviation

Updated spreadsheet that includes a 2nd method: http://bit.ly/2YxIpTn , or https://www.dropbox.com/s/d90grspdsw4... 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/6t7edo7txpt... 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/...) Artist: http://audionautix.com/