Interested in finding out how to use formulas to calculate students’ final grades? This video by Kim Holland has three step-by-step instructions on how to use Excel spreadsheets to calculate final grades.
Advertisement
Filed under: Teaching Tagged: | grading, teaching tip, Technology, videos
Blog Administrator
Gayle McIntyre
npatrit
kmeadow2
dldawson1
drmike1
Nanda Dimitrov
dkimholland
ahitchc2
nlegros
jefflongland
I am not sure why you did not use dynamic formulas to consider the weighting of various aspects of the course. The way it was calculated, the user did actually have to calculate the weighting themselves instead of excel doing it for them.
If you did it this way, you could easily transfer the same sheet to other courses with different weightings for the same components.
This beats the old school ways of paper and calculator by far! Saves plenty of time. Thanks for the tech update!