Sidebar

Table of Contents

academy:student:grade_reporting_grade_averaging_class_rank_cumulative


Grade Reporting > Utilities > Cumulative Grd Avg and Class Ranking

This utility uses grade averaging data for multiple years to determine class ranking. The program adds the values of each selected year and divides this by the sum of the courses factors for those years.

Two reports are generated:



School Year

The current school year is displayed, as specified on Maintenance > Tables > District Control Table.

CampusThe campus to which you are logged on is displayed.
Campus Control Information

Data from the Grade Averaging Information section on Maintenance > Tables > Campus Control Options > H Roll & Gr Avg is displayed for your reference. Verify the settings before running the utility.

Nbr of Decimal Points

The number of places to the right of the decimal point to which grade averages are computed is displayed.

Grade Avg 4pt Scale

The field indicates if four-point grade averaging information will print on the report.

Incl WD Stu in Avg

If selected, grade averages are computed for students who withdrew after the first cycle.

Incl WD Stu in Rank

If selected, withdrawn students are included in the class rank.



Credit Level

Select the credit level to be processed.



Process
Grade Point Grade Averaging

Select to use the Grade Averaging tables (i.e., Maintenance > Tables > Grade Reporting Tables > Grade Averaging Table).

Numeric Grade Averaging

Select to use the Numeric Grade Average Operator/Value table (i.e., Maintenance > Tables > Grade Reporting Tables > Num Grade Avg Operator/Value).



Grades

Select the current year grade level(s) to process. Or, click All Grade Levels to process all listed grade levels. You must select at least one grade level.


• To select multiple non-consecutive rows, press and hold the CTRL key while selecting the first row and then the subsequent rows.

• To select multiple consecutive rows, click the first grade level and drag to select multiple grade levels. Or, press and hold the SHIFT key while selecting the first row and then the last row. All the rows (between the first and last rows) are selected.


It is common for campuses to run this utility for seniors once they have run early computations and determined the valedictorian and salutatorian. Once grades are final for the year, the campus may run the utility again for 12th grade (depending on district policy).

Other Options
Report Sort Order

Select the order in which to print the Grade Averaging Cumulative report.

Print Credit

Select to print the student’s total credits for the years included in the cumulative grade averaging. Most campuses select this option.

Print Detail

Select to to list the prior year grade averaging information. It is recommended that you select this option, because it allows you to see the values used to calculate the student’s cumulative grade averaging. If not selected, only the student’s total cumulative grade averaging information is printed.

If Graduated WD Students are to be included, Enter the WD Code

It is recommended that this field be set to 01 (Graduated).

If graduated withdrawn students will be included in grade averaging and class ranking, select a withdrawal code to indicate which graduated withdrawn students should be included in cumulative grade averaging. This field overrides the Incl Wdrawn Stu in Avg/Rank fields on Maintenance > Tables > Campus Control Options > H Roll & Gr Avg.

Be sure the grade averaging policy in the campus handbook explains which graduated seniors are included/excluded in the grade averaging and class rank.


TIP: You can run the utility multiple times back to back, changing the settings of the Report Sort Order and Print Detail fields to get different reports:

  • (Default) Report Sort Order is Grd Lvl, and Print Detail selected: Prints all years sorted by rank.
  • Report Sort Order is Grd Lvl, and Print Detail is not selected: Prints one cumulative line per student.
  • Report Sort Order is Alpha, and Print Detail is selected: Prints all years in alpha order.
  • Report Sort Order is Alpha, and Print Detail is not selected: Prints one cumulative line per student in alpha order.



❏ Click Execute.

  • When the process is finished, two reports are displayed. View the reports.
    • Cumulative Grade Averaging Report - Options Selected - Displays the options selected when the utility was run.
    • Grade Averaging Cumulative Report - Displays the results of the utility according to the selections of the Report Sort Order and Print Detail fields.
  • A message is displayed indicating that cumulative grade averaging and class ranking is completed.
  • Click OK.

Cum GPA
Cum Rank
Nbr of Students Ranked
Date Ranking
Quartile



Numeric Average Calculation

Grade Average tab showing the Numeric Average calculation

Total Points ÷ Nbr Crs with Crdt Lvl H = Cum GPA
Example: 2548 ÷ 28 = 91.0000


Grade Point Average Calculation

Grade Average tab showing the Grade Point Average calculation

Total Points ÷ Nbr Crs with Crdt Lvl H = Cum GPA
Example: 80.3 ÷ 30 = 2.676


4 Point Average Calculation

Grade Average tab showing the 4 Point Average calculation

Total Points ÷ Nbr Crs with Crdt Lvl H = Cum GPA
Example: 102 ÷ 32 = 3.187


NOTE: The cumulative 4 Point average does not appear on Grd Avg, but will print to the AAR - SRG2047 report.

academy/student/grade_reporting_grade_averaging_class_rank_cumulative.txt · Last modified: 2020/07/08 13:51 by 127.0.0.1