This page is to help faculty, staff and graduate students who may be responsible for maintaining Excel spreadsheets to record student marks for courses.
Downloading a class list
Your Excel file and Master worksheet
video
Quiz marks from Scantron sheets
Transfer data from a worksheet to the Master worksheet
Checking to make sure all marks have been recorded on the Master worksheet
Checking for Duplicate/Repeat entries on a worksheet
Determining final Letter Grades in a course
Adjusting the final Letter Grade distribution
Finding Letter Grade anomalies
Electronic Grade Submission
Correcting "bad" student numbers
Correcting for missing data on worksheets
