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.
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.
