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.

Select Add-Ins from the Tools menu

On the Add-Ins screen that appears, check the Gradesmanagement option and click OK.

The Add-ins window

return to top ↑

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.

Add-Ins menu in the Excel Options window

On the Add-Ins screen that appears, check the Gradesmanagement option and click OK.

The Add-ins window

return to top ↑

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.

Grades option in the Tools menu

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.

Sample Spreadsheet

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.

return to top ↑

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.

Grades menu on Add-ins tab

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.

Sample Spreadsheet

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.

return to top ↑

Change Log


Version 0.7.0 (12/11/2009)

  • Added additional formulae

Version 0.5.0 (10/19/2009)

  • Initial beta release

return to top ↑