College of the Great Smoky Mountains - Southwestern Community College, serving Jackson, Macon,  and Swain Counties and Cherokee/ Qually Boundary






 

 

 

 

 

 
» Faculty & Staff   » Teaching-Learning Connection Home   » Values for Teaching Excellence
Teaching-Learning Connection

Course Administration - Electronic Gradebooks

Microsoft includes three templates for instructor gradebooks in its on-line resources for Microsoft Office:

Right click and choose 'Save Target As' to download
Equal Weight Gradebook - Use this templete if all of your grades for a course count equally toward the final average.  
equal.xls
or
click here for
Microsoft website
     
Percentage Weight Gradebook - Use this template if differing grades account for differing percentages of the final average (example: tests 50%, homework 25%, project 15%, participation 10%).  
percentage.xls
or
click here for
Microsoft website
     
Point Gradebook - Use this template if grades are based upon accumulated points for differing activities (example: tests 500 points, homework 250 points, participation 100 points).  
points.xls
or
click here for
Microsoft website


These templetes are based upon 10 point grading scales, but the scale can be easily edited in the spreadsheets for 7 point grading.

For additional educational templates from Microsoft, click here

» Back to TLC Home

 

 
 Last updated 3/22/08


   
   
 
 
 
Southwestern Community College • 447 College Drive • Sylva, NC 28779
828·339.4000 or 800·447·4091
fax 828·586·3129