OpenOffice 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.
If you do not already have OpenOffice installed, you can download it for free from http://www.openoffice.org.
Downloading the Grades extension
Check back at this site for updates.
Installing the Grades extension
To install the extension, double-click the .oxt file and follow the prompts in the Extension Manager.
Using the Grades extension
The macros provided by the extension will appear under the Grades menu in Calc.
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.
Version 0.7.2 (2/2/2010)
- Fixed compatibility issues with OpenOffice 3.2
Version 0.7.1 (12/11/2009)
- Minor bug fixes
Version 0.7.0 (10/30/2009)
- Added additional formulae
Version 0.5.0 (10/16/2009)
- Initial beta release