Resources
- Manualettes
- Managing Grades
- Formulas
- Excel Extension
- Download and Install
- Documentation
- OpenOffice Extension
- Tutorials
- Learning Objects
- Web Resources
Excel Grades Extension
The WebCT OWL Grade Book tool provides an easy and convenient way for instructors to manage grades and distribute them to students. Grades can also be exported for manipulation in Microsoft Excel or OpenOffice Spreadsheet.
Downloading the Grades extension
Get the latest version (0.7.0) of the Grades extension.
Check back at this site for updates.
Installing the Grades extension
Note for Mac Users:
If you are using Excel 2004, follow the instructions for Excel 2003. Save the file to
/Applications/Microsoft Office/Office/AddIns.
The add-in is not compatible with Excel 2008, as Microsoft has removed Visual Basic support from this version. Try OpenOffice instead. It is free and compatible with Excel files.
The following instructions are for Excel 2003. Show Excel 2007 instructions instead.
To install the extension, copy the file to one of the add-in folders recognized by Excel. The most common location is Documents and Settings/username/Application Data/Microsoft/AddIns.
After copying the file, we now must activate it within Excel.
Click the Tools menu and select Add-Ins.
On the Add-Ins screen that appears, check the Gradesmanagement option and click OK.
The following instructions are for Excel 2007. Show Excel 2003 instructions instead.
To install the extension, copy the file to one of the add-in folders recognized by Excel. The most common location is Documents and Settings/username/Application Data/Microsoft/AddIns.
After copying the file, we now must activate it within Excel.
Click the Office menu and click on the Excel Options button. On the Excel Options screen that appears, click Add-Ins on the left and then click the Go button.
On the Add-Ins screen that appears, check the Gradesmanagement option and click OK.
Using the Grades extension
The following instructions are for Excel 2003. Show Excel 2007 instructions instead.
The macros provided by the extension will appear under the Tools menu in Excel 2003.
These macros assume that the first three rows contain the column title, perfect score, and weight. If nothing is entered for the perfect score of a column, a value of 100 is assumed. Student values should begin on the 4th row. It is also assumed that an empty row indicates the end of the data for that column.
In the example above, we can see that column C holds the data for Test 3, which is out of 75 and has a weight of 0.25. Column D was generated by applying the Percentage macro from the Grades menu to column C. Column E was generated by applying the Round and Bump 9's macro to column D.
The following instructions are for Excel 2007. Show Excel 2003 instructions instead.
The macros provided by the extension will appear on the Add-Ins tab in Excel 2007.
These macros assume that the first three rows contain the column title, perfect score, and weight. If nothing is entered for the perfect score of a column, a value of 100 is assumed. Student values should begin on the 4th row. It is also assumed that an empty row indicates the end of the data for that column.
In the example above, we can see that column C holds the data for Test 3, which is out of 75 and has a weight of 0.25. Column D was generated by applying the Percentage macro from the Grades menu to column C. Column E was generated by applying the Round and Bump 9's macro to column D.
Change Log
Version 0.7.0 (12/11/2009)
- Added additional formulae
Version 0.5.0 (10/19/2009)
- Initial beta release
