Excel for Data Entry and Grade Reporting
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
video
Correcting for missing data on worksheets