Accessing the Grade Book Exploring the Grade Book Interface Creating Columns Creating a Letter Grade Column Creating a Calculated Column & a Formula Reorder & Hide/Show Columns

Creating a Letter Grade Column You can create your own columns for Grade Book to enter specific types of information. A letter grade column displays a letter grade for each Student, based on the values of another numeric or calculated column. You can edit the numeric ranges that determine which letter grade is assigned. Example: Use a letter grade column to determine the final grade, based on a calculated column that calculates a value from 0 to 100.. Editing Letter Grade Schemes For letter grade columns, you can change the range of numeric grades that each letter grade represents. To edit a letter grade scheme: Click the letter grade column’s title or  ActionLinks icon and click Edit Column Letter Grade Scheme. In the Grade and Range text boxes, enter the letter grade and the range it represents. Click Save or, if you want new letter grade columns to use this letter grade scheme by default, click Save and Set as Default. Design Tip: A letter grade column based on the values of a calculated column that calculates students' overall midterm or final grade would be a good column to use for electronic grade submission to our banner system. You could use a calculated column to, for example, average or sum a student's score on a number of other columns containing grades for tests, projects, assignments, etc. This overall score could then be converted to a letter grade in the letter grade column. Resources How Do I Add Information to Selection List, Calculated, and Letter Grade Columns in the Grade Book? Step By Step Instructions (PDF) courtesy Blackboard, Inc.