Excel Gradebook

Updates FOR Fall 2009 & beyond New Excel file is linked below. In partnership with Alan Keys, I added a worksheet for easy reporting of Student Learning Outcomes in 2007. Want to know more about SLOs - visit http://web.scc.losrios.edu/slo

http://web.scc.losrios.edu/instrdev/excelgradebook

This is a resource page for the workshop on using the SCC Excel Templates to create a gradebook. This template includes

• tracking attendance
• tracking assignments
• calculating final grades and assigning a letter grade
• calculating class averages on graded assignments
• a worksheet to track Student Learning Outcomes

• SCC Intranet login (class rosters) http://inside.losrios.edu/
  
• Current Roster Instructions http://ic.arc.losrios.edu/~itc/OnlineGrading/instructions.htm
  
• Online request for Intranet account (required before accessing rosters)

Use this list of files from Fall 2005 as a starting point for ONE Excel file for all attendance patterns. (Part of Excel's magic is to see the formula's update the date!)
NEW - Download the revised (Sp 2010) Latest Excel Gradebook Update with SLOs and Student Info on the first worksheet, SLO's captured in the first 10 columns of homework, quiz & lab worksheets, and an SLO worksheet for easy review and printing. (January 2009 revision added columns for Attendance worksheet.)

Download the Demo Gradebook file
http://scc.losrios.edu/~instrdev/ett/gradebook/gradebook2007demo.xls
Download or view the Handout (Acrobat)
http://scc.losrios.edu/~instrdev/ett/gradebook/gradebook_handout.pdf
(This handout allows you to personalize a copy by adding comments, annotations and other markups -- with Adobe Reader 7 or above!)

New for Fall 2009 - Tutorial Movies Look for Instructional Development > Excel Gradebook. Also, here is an interactive Acrobat document as an Excel Click Through Demo.

Suggested start-of-semester steps:

1. Access the SCC Intranet (email account name & password)
2. Select a class and view the roster
   (View other class rosters from the Roster page of any class)
3. Print the roster page with permission numbers noted before meeting with your class the first day
4. Print the permission slips pages if you have students listed in the Wait List box, cut apart the add slips
5. As you allow students to add the class based on their permission number, give them the add slip write their name on your roster at the matching permission number
6. Return to your online class rosters to drop the "no shows"
7. After the second week, review the class roster to see the used permission numbers and "no show" update
8. After the fourth week, review your rosters for drops

Formulas used in this gradebook include:
=SUM(E7:R7)
='Course Info'!B9
=IF(Attend!BJ9=0," ",Attend!BJ9)
=IF(Homework!BC9=0," ",Homework!BC9)
=IF(Lab!AI9=0," ",Lab!AI9)
=IF(Quiz!W9=0," ",Quiz!W9)
=IF(totalpoints=0," ",SUM(E9:R9))
=IF(totalpoints=0," ",S9/$T$7*100)
=IF(showgrade=0," ",VLOOKUP(T9,$X$2:$Z$7,2))
=IF(K7=""," ",AVERAGE(K10:K159))

Volunteers and formula suggestions are welcome!

Sacramento City College
3835 Freeport Boulevard · Sacramento, California 95822
This page was last updated: Thursday, September 24, 2009 at 12:12:48 PM
Print-friendly version of this page