The GW Blackboard Tour: Your Gradebook in Excel

From the Gradebook spreadsheet view, you may use Download Grades, then choose to open or save a file that will be in CSV (comma seperated values) format. This type of file can be easily edited in Microsoft Excel.

After downloading into Excel, the grade entries will be a simple table for your manipulation. Once in excel as a CSV (comma seperated values) file, you may Upload Grades from the Bb Gradebook. Note that this process will occur one column at a time, whether it is a column that already existed or will be added anew based on the upload.

Step-By-Step

Download the Bb Gradebook to your computer:

1. Control Panel > Gradebook (from Assessment Pane)
2. Click on Download Grades (in the gray menu bar just under the page title)
3. Choose a delimiter and click submit
4. Click the download button
5. Save to your computer and click ok to go back to the Bb Gradebook

Open the file in Excel

1. Launch Excel
2. Click on File
3. Select Open
4. Locate the Bb Gradebook file by changing the "files of type:" field to read all files
5. Choose gb_export and click on open
6. Contact the Center for Instructional Design and Development for assistance if you have questions