Excel Grade Book
Lite Version
http://faculty.seattlecolleges.com/jkent/workshops/ibc/
Simple Grade Books using Excel & IBC
1
Workshop Agenda
z Saving the Excel template file
z Accessing Instructor Briefcase and copying
roster
z Pasting roster into Excel
z Cleaning up roster
z Making attendance sheet
z Adding assignments, quizzes, etc. to grade
book
z Calculating grade in percentage
Saving Excel Template
(Windows Version)
Right click on link then select
Save Target As…
Save to the Desktop or a folder
you can easily locate on your
computer.
Saving Excel Template (Mac
Version)
Ctrl click on link then select
Download Link to Disk, then
save to the Desktop or a folder
you can easily locate on your
computer.
Access IBC
z Must use Internet Explorer for this
step
z Netscape, Firefox, Safari, AOL WON’T
WORK!
z Go to the SCCD Intranet
http://InsideSeattleColleges.com
z Open North Briefcase from Quick
Links
z Open desired class roster
z See next slide
Simple Grade Books using Excel & IBC
2
Click to Open Roster
Select All Columns with Mouse
Copy Roster
z After selecting all
columns, copy to
“clipboard”
z 3 ways to copy
z Right click and select Copy
from pop-up menu as
shown to the left
z Ctrl + C (Cmd + C for
Macs)
z Edit → Copy
Pasting into Excel
z Open Excel
z Open file named
gradebooktemplate_06
winter.xls
z Before pasting, select
File → Save As… and
give it a meaningful
name (e.g., Course XXX
quarter yr)
z Click on “sheet tab”
named Roster
Simple Grade Books using Excel & IBC
3
Paste Roster
z Click mouse in cell A1
– upper left corner as
shown to the left
z Then paste roster info
using
z Edit → Paste or
z Ctrl + V (Cmd + V for
Macs)
z Right click and select
Paste
Clean-up Roster
z Remove columns you don’t want
z Save SID? Or email address ? Or phone #?
z To remove a column
z Place mouse on top of column and click
z Entire column will be highlighted
z Select Edit → Delete
z See next slide for example
Deleting Columns
1st column selected
Then click Edit → Delete
More Clean-up
z Remove colors and borde