A translation table is a template you define so the program can translate letter grades into numeric grades and numeric grades into letter grades. On each translation table, you enter valid ranges for numeric grades and grade points. You can select the Grade view or GPA view from the View menu on the menu bar.
- In the Grade view, define each grade you use, such as A, B, C. Enter each grade and designate whether it receives credit, whether to use it in calculations, the numeric equivalent, and the range of numeric values that translate to the grade. The Grade column is typically used for letter grades, but you can also enter numeric ratings, such as 5, 4, 3, 2, 1 or 100, 99, 98, 97, etc.
- In the GPA view, define how the numeric values translate to GPAs. For each GPA type, designate the GPA equivalent of the numeric value and the range of grade point values that translate to the GPA. In this view, the numeric values and grade equivalents defined in the Grade view automatically appear in the first two columns for informational purposes only. In this view, you must mark the checkboxes in the Use in GPA Calcs column if you plan to use the translation table to calculate GPAs.
- If you change the grid values in a translation table after grades exist, a message appears stating that existing grades and calculations may be invalidated and asking if you want to continue.
- If you change the valid numeric grades or grade points ranges so that an existing grade or GPA value no longer falls within the range, a message appears stating that existing values may be invalidated.
- You cannot delete a translation table after it is associated with a marking column on a course record, but you can make a translation table inactive so you cannot select it on new course records.
- If you enter a grade during grade entry that is not accounted for on the associated translation table, you receive a message that it is an invalid grade.
How to add a translation table:
- From the Configuration page> click Registrar Setup.
- From the list on the left, select Translation Tables
- Click New Translation Table on the action bar.
- In the Translation Table field, enter a name (maximum of 60 alphanumeric characters).
- If your organization has more than one active school record, the School box appears. In the Schools box, mark checkboxes for the schools to associate with the translation table.
- In the Valid numeric grades from [ ] to [ ] fields, enter the lowest and highest numeric values permitted in a marking column.
- In the Valid grade points from [ ] to [ ] fields, enter the lowest and highest GPA values permitted in a marking column.
- In the Grade column of the grid, list the grades in descending order, such as A+, A, A-, B+, . . ., so calculations occur correctly.
- At the end of the list, include special cases. For example, include INC for incomplete grades.
Note: You must include NG in each translation table. NG denotes No Grade and replaces blank grades during calculations. The program warns you if you do not enter NG in a row and adds it for you.
- Mark the Credit Awarded checkbox for each grade that awards course credit. For example, do not mark this checkbox for F, INC, and NG.
- To include the grade in course average calculations, mark the Use in Course Avg checkbox.
- To include the grade in performance categories, mark the Use in Performance checkbox.
- In the Numeric Equivalent column, enter the numeric value of the grade. The program uses this value to assign numeric grades to letter grades during calculations. For example, you can set the numeric value for B+ to 89.
- In the Cutoff Value column, enter the lowest numeric value that translates to the grade. The program uses this value when it posts numeric grades from Faculty Access for the Web as letter grades in Registrar's Office and when returning the results of a GPA calculation as a letter grade.
- You must enter numeric equivalents and cutoff values if you plan to calculate course averages and GPAs.
- Do not interpret the Numeric Equivalent and Cutoff Value columns as a range from left to right. The Cutoff Value column is a range from row to row. For example, the translation table below instructs the program to do the following:
- Award an A+ for the grades 96, 97, 98, 99, 100, etc.
Note: There is no end value because this is the top row.
- Award an A for the grades 93, 94, and 95.
Note: 96 is not included because it appears in the row above.
- Award an A- for the grades 90, 91, and 92.
Note: 93 is not included because it appears in the row above.
- Award a B+ for the grades 87, 88, and 89.
Note: 90 is not included because it appears in the row above.
- Award a B for the grades 84, 85, and 86.
Note: 87 is not included because it appears in the row above.
- Award an A+ for the grades 96, 97, 98, 99, 100, etc.
- To go to the GPA view, select View, GPA View from the menu bar.
- In the Numeric Value column, the cutoff values appear from the Grade view. You can click Insert to add new rows. For example, you can define each numeric grade separately, such as 100, 99, 98.
- In the Grade Equivalent column, the grade equivalent of the numeric equivalent appears, determined by the cutoff numeric values defined in the Grade view. You cannot edit this column.
- Further define each GPA type in the additional columns that appear. Subcolumns appear for each GPA type. In the GPA Equivalent column, enter the grade point value to assign to each grade in GPA calculations. For example, A+ = 5.00 and A = 4.70.
- A Cutoff Value column appears if you mark the business rule to show this column. In the Cutoff Value column, you can enter the lowest grade point value to translate back to the grade. The program uses the Cutoff Value column to translate calculated grade point values back to the grade in the Grade Equivalent column. For example, if you award an A+ for a calculated grade point value of 4.00 or above, enter 4.00 in the Cutoff Value column for A+.
- In the Use in GPA Calcs column, mark the checkbox for each grade to use in GPA calculations.
- To save the translation table and return to the Translation Tables page, click Save and Close.
Once translation tables have been defined, associate the translation table with the appropriate marking column for each course (BB188780)