Custom GPA Calculation (Ohio)

One way to create a custom GPA calculation is using a stored procedure, which is a SQL query that is saved for future use. This article describes using a stored procedure provided to Ohio users by Campus to create a custom GPA Calculation.

The stored procedure described in this article is used for calculating GPA for grades 11 and 12.

This article provides only a basic overview of the tools used when creating and using a custom GPA. See the articles linked in each section for more information.

Step 1 - Create GPA Calculation

PATH: System Administration > Grading & Standards > Custom Calculation

First, create a new GPA Calculation. Give the calculation a Name (such as Grades 11 and 12), select a Calculation Type of Weighted GPA and a Calculation Method of Use Custom Stored Procedure. Enter the following as the Name of the stored procedure:

get_gpa_stats_12

Create a new GPA calculation using the stored procedure shown above.

Step 2 - Add the GPA to the School Calendar

PATH: System Administration > Calendar > Calendar > Calendar GPA

Next, select a School and Calendar in the Campus toolbar and select the GPA you just created on the Calendar GPA tab to add it to that school.

GPAs must be added to each calendar that uses them.

Step 3 - Select GPA as GPA Requirement in a Graduation Program

PATH: Program Admin > Programs > Graduation Programs

Next, create a Graduation Program that has the GPA you created selected for the GPA Requirements section.

Select the custom GPA in a Graduation Program.

Step 4 - Add Graduation Program to the Student

PATH: Student Information > Academic Planning > Programs

Finally, select the Graduation Program that includes the custom GPA for a student on the Programs tab in Academic Planning.

The last step is to add the program to the student.