User Tools

Site Tools


Sidebar

Table of Contents

gradereporting:utilities:cumulativegradeaveragingandclassranking

This is an old revision of the document!


Cumulative Grade Averaging and Class Ranking

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:

  • A report of options selected on the page and on the Campus Control Options tabs.
  • A listing by the sort order selected. The report is similar to SGR2060 but includes totals.

Update data:

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

Click Execute.

  • When the process is finished, two reports are displayed. View the reports.
  • A message is displayed on the utility page indicating that grade averaging and class ranking is completed. Click OK.
  • The following fields are updated on Maintenance > Student > Individual Maint > Grade Avg:
    • Cum GPA
    • Cum Rank
    • Nbr of Students Ranked
    • Date Ranking
    • Quartile
gradereporting/utilities/cumulativegradeaveragingandclassranking.1488312244.txt.gz · Last modified: 2017/02/28 15:04 (external edit)