Minor Errata for the OpenOffice version of Gradebook+

NOTE: This errata does not apply to the Excel version of Gradebook+.

It always happens. You proofread and test something dozens of times. And after it's finalized, then you discover something wrong!

I was entering my son's grades in my OpenOffice version of Gradebook+ tonight and discovered (much to my chagrin) that the Overall Grade Average on the Summary sheet was showing an even 96.00 when I knew it should be 96.46.

I played around with it, changing the grades, adjusting the settings, and trying to figure out why it wasn't registering the decimal places. I finally discovered that the QUOTIENT formula, which I'd used in that cell, returns only an integer, effectively dropping the decimal places and always rounding down to the nearest integer.

Obviously dropping the decimals and rounding down is not what I wanted in that cell. Most of the time, that rounding down wouldn't be a problem, but if the grade is borderline, it can make a difference, and that's not acceptable.

So I quickly found a solution, updated the OpenOffice version of Gradebook+ and uploaded it to my site so that all future downloads will have the updated, decimal-friendly version.

For those of you who have already downloaded the OpenOffice version of Gradebook+, you will want to download the updated OpenOffice Gradebook+ (v1.1) file here. The corrected file is version 1.1, so it has this name: fivejs-gradebook-plus-v1.1-oo.ots

If you've already entered grades into a current file, and you don't want to copy/paste the info into the updated file, you'll want to change the formula directly in that cell with the directions below. Please note you may still want to download the updated template file so you have the updated version of the template file to use in the future.

How to Update the Formula Directly
1. Open your OpenOffice Gradebook+ file to the Summary sheet.
2. Unprotect the sheet. (In my version, it's located at Tools > Protect Document > Sheet)
3. Place your cursor in cell C20, delete the formula in the cell, and replace it with the following formula. =IF(A20>0;D19/A20;"")
Click the thumbnail image below to see a visual example.
4. Re-protect the sheet to prevent any unintentional changes in the future.