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 border lines z Select all the columns (or rows) z On menu bar, select z No Fill z No Border Simple Grade Books using Excel & IBC 4 View of Cleaned-up Roster Adjust Column with Names z Place mouse on divider line between column A and B z Mouse becomes double headed arrow z Next, drag to right to expand column z Names should appear on one line Adjust Rows z Drag mouse through row numbers to select rows z Select Format → Rows → AutoFit To Make Attendance Sheet z Select all student names z Drag mouse from cell with first student name to cell with last student name z Ctrl + C (Cmd + C for Macs) or Edit → Copy to copy to clipboard z Click on “sheet tab” named “Attend” z Click in cell A3 and paste student names in z See next slide for example Simple Grade Books using Excel & IBC 5 Attendance Sheet with Names Print Attendance Sheet z Save your file! z Then click File → Page Setup z On Page setup make sure Landscape is selected z On Sheet setup z Enter $A:$A for “Repeat column with names on each page” option z Check “Gridlines” box z Check “Page order is Down, then over” z See next slide for these settings Page Setup Settings Print Preview To preview before printing, select File → Print Preview Simple Grade Books using Excel & IBC 6 Adding Homework, etc z First, copy student names to Grades sheet tab z from Roster or Attend sheet, select cells with names z copy to clipboard using Ctrl C (Cmd C for Macs) or Edit → Copy z Click on the “Grades” sheet tab z click in cell A4 and paste student names z Ctrl V (Cmd V for Macs) or Edit → Paste Homework Sheet Add Assignments, etc. z template has 6 homework columns and 4 test columns but you can add more z label columns according to your needs z add point values below label z see next slide for inserting columns Inserting a Column z click mouse at top of column z select Insert → Columns z new column appears on left side of selected column Simple Grade Books using Excel & IBC 7 Correcting Formulas z you may have to redo the formulas to include new columns and additional points z click in cell with total points z next click button for “AutoSum” z press Enter if all columns are included Percentage z formula is total points earned divided by total points possible z use cell reference (letter and number) to create formula z template has correct formulas z copy it to all cells in the column z see next slide for example Copying Formula z to copy, select cell then place mouse on small box in lower right corner z crosshair will appear z click and drag through the column Four Grade Book Templates z simple (used in workshop) named “gradebooktemplate_06winter.xls” z more robust named “More_Advanced_Grade_Template.xls” z created by Katherine McDermott formerly at SCCC z requires knowledge of Excel z call me (587-4103) with questions z read instructions in Notes tab first Simple Grade Books using Excel & IBC 8 Four Grade Book Templates z two from Frank Enfinger z “gradebookbypercentage.xls” z “gradebookbypoints.xls” z must have knowledge of Excel z follow instructions provided in workbook z download all from http://faculty.seattlecolleges.com/jkent/workshops/ibc/