Overview  ↑


Navigate to Reports > Grades.


Two reports are available to print the Honor Roll and Class Rank based on built-in GPAs. The Honor Roll and Class Rank Listing from Grade Reporting is based on the Class Rank from the latest grade reporting cycle. The Honor Roll and Class Rank Listing from Transcripts is based on the cumulative Class Rank from the transcript. Prior to printing the report the current grade point averages and class ranks must be recomputed. 



NOTE: These reports reflect class rank based on the Built-In GPA chosen when the grade point average and class rank were last recomputed and stored in STU.CR (Class Rank) and STU.CS (Class Size). If you have custom District GPAs configured, the GPAs and class rank are stored in the GPA table (GPA.CR and GPA.CS) for each District GPA and are only available using the following query at this time:

LIST STU IDN GPA DGP STU.ID STU.NM STU.GR STU.CHT DGP.SNM DGP.LNM GPA.GPW GPA.GPN GPA.CR GPA.CS BY STU.CHT STU.GR GPA.CR ^ IF GPA.GPN # NULL
*Adjust the query if using the weighted GPA to look for GPA.GPW # NULL.  


This will return a list of all custom District GPA's and the class rank to filter and sort using Microsoft Excel:



Honor Roll and Class Rank Listing from Grade Reporting  ↑

The Honor Roll and Class Rank Listing from Grade Reporting report can be sorted by: Grade and Class Rank, Grade and Academic GPA, Grade and Student Name, Student Name or Class Rank.


The following is an example of the Honor Roll and Class Rank Listing from Grade Reporting report.




Honor Roll and Class Rank Listing from Transcripts  ↑

The Honor Roll and Class Rank Listing from Transcripts report has several options: 


  • Student Grade - select All to run the report for all grade levels, or select a specific grade level.
  • Sort by - select the sort method and whether to sort Ascending or Descending. When All grade levels are included, the first sort will be by grade, then secondarily by either Student Name or Class Rank
    • Student Name - sort by Student Last Name, then Student First Name
    • Class Rank - sort by Class Rank
  • Do Not Print Student Excluded from Class Rank - will exclude any students whose Graduation Track is set to one that is not included in the Class Rank or whose Class Size is 0.
    See Graduation Requirements  for more information about graduation tracks. 



The following is an example of the Honor Roll and Class Rank Listing from Transcripts report that includes all 12th grade students sorted by Class Rank. Hernandez, Perez and Gruettner are all in a Graduation Track that is excluded from Class Rank and Class Size.




The following is an example of the Honor Roll and Class Rank Listing from Transcripts report that includes all 12th grade students sorted by Class Rank, but the option to Do Not Print Student Excluded from Class Rank is selected.  Hernandez, Perez and Gruettner are no longer on the report.