Sidebar
gradereporting:utilities:historicalgradeavgandclassranking
Historical Grade Averaging and Class Ranking
Grade Reporting > Utilities > Historical Grd Avg and Class Ranking
This utility should be run to recalculate grade averages for prior school years, including summer school courses entered on the Prior Yr Transfer tab. The current school year is not included.
In addition to prior year courses that exist on the Crs Assign tab, the calculations include grades and credits entered for courses on the Prior Yr Transfer tab under the following conditions:
- The course was taken in the district.
- One or more of the following has changed for the student: semester grade, final grade, credit, GA Table, and/or GA Weight.
- One or more of the following has changed for the course in the district master schedule: Total Credits, Credit Level, GA Table, or GA Weight.
NOTE: Inactive students are included/excluded from processing according to the Incl Wdrawn Stu in Avg and Incl Wdrawn Stu in Rank fields on Grade Reporting > Maintenance > Tables > Campus Control Options > H Roll & Gr Avg.
Update data:
| School Year |
Select a prior school year, or select Only Changed Students. If a prior school year is selected:
• Grade averages for all students are recalculated for that school year. This updates the Avg field (either Numeric or Grd Pt) on Grade Reporting > Maintenance > Student > Individual Maint > Grade Avg.
NOTE: Students are selected according to their enrollment status and grade level in that school year. For example, if the school year 2017-2018 is selected and grade level 10 is selected, grade averages will be calculated for students who are in 10th grade for school year 2017-2018 and enrolled on the campus selected during school year 2017-2018.
• Class rank is only updated if rank has never been calculated for the selected campus, school year, and grade level (i.e., if Rank is blank or 0 for all students on Grade Reporting Maintenance > Student > Individual > Grade Avg.
If Only Changed Students is selected, grade averages are only recalculated for students with altered semester or final grades, credits, and/or GPA override grades in any school year in which a change occurred, and only for school years in which a change occurred. Rank is not updated if this option is selected. |
|---|---|
| Campus | The campus to which you are logged on is displayed. |
❏ Under Process, make the following selections:
| 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). |
| Include Courses from Other Campuses |
This field provides an alternative to entering an in-district transfer course on Grade Reporting > Maintenance > Student > Individual Maint > Crs Assign. If the course is entered on the Course Assign tab, do not select this field.
Select to include a student's courses from another campus within the district. For example, if the student attended campus 001 for part of the year, and attended campus 002 for part of the year (e.g., credit recovery), you can include courses from both campuses, provided that the course is unique at the other campus, and was completed at the other campus. (A course is considered complete if the student has a semester grade or final grade, or credit, depending on whether the district uses final or semester grades.)
This field is only enabled if Grds Used for Grade Avg is S (semester) or F (final) on Grade Reporting > Maintenance > Tables > Campus Control Options > H Roll & Gr Avg.
• Courses entered on the Prior Year Transfer tab are included if the campus ID is valid for the district, and if the local course number matches a course number in the district master schedule for the school year being run.
• If High School Credit Lvl Courses for Middle School is selected, the grade averaging tables from the logged on campus are used for the next year campus. The grade averaging tables at the middle school should match the high school tables to ensure continuity. |
Specific details about courses included:
NOTE: After the recalculation, if the program cannot determine whether numeric or grade point averaging was used in determining rank and GPA for a particular student and school year, the Rank field on the student’s Grade Avg tab will display R* instead of N or G.
NOTE: Grade averaging tables and campus control options are used from the campus and school year being processed. If the year being processed does not have table and options, then the current year table and options are used.
| Campus Control Information |
Settings from the Grade Averaging Information section on Maintenance > Tables > Campus Control Options > H Roll & Gr Avg for the selected campus and school year are displayed for your reference. These settings will be applied when recalculating averages for all courses taken in the district. Transfer courses taken outside the district are not included in recalculations by this utility. |
|---|---|
| Semester |
Select the semester(s) for which to recalculate data. Typically, you should select all semesters to be sure complete school year data is included in the calculation. NOTE: Whether the semester or final average is computed depends on the setting of the Grading Concept field on Maintenance > Tables > Campus Control Options > Computation.
|
❏ Under Options:
| Grade Levels |
Select one or more individual grade levels to update, or click All Grade Levels to update data for students in all grades.
|
|---|
| Trial | Click to produce a report of calculations in order to preview results. No grade averaging calculations are actually done. Review, save, and/or print the report. |
|---|---|
| Live |
Once the trial produces the results you want, click Live to perform the calculations. |
When the utility is completed, a report is displayed on the utility page which lists the updated students, and the Print button is enabled. This report is sorted according to your selection in the Rpt Sort field.
| Click to generate the following reports. Each report opens in a new window or tab. |
Options Selected
This report lists field settings used when the utility was run.
Sorted By Grade Level and Class Rank
This report lists the updated students and their grade average and the rank for the selected year (if rank was updated). If rank is not updated, students are sorted by grade average (Avg column), and the Class Rank column is blank.
NOTE: Rank is only calculated and displayed if rank has never been calculated for the selected campus, school year, and grade level (as explained above).
Sorted By {Rpt Sort option}
This report lists the updated students and their grade average and rank for the selected year (if rank was calculated) sorted according to the setting of the Rpt Sort field. If rank is not calculated, the Class Rank column is blank.
NOTE: Rank is only calculated and displayed if rank has never been calculated for the selected campus, school year, and grade level (as explained above).
Error Report
This report lists student IDs and associated error message.
NOTE: The “Previously ranked…” error message in the example above can be expected, because the student’s class rank was not recalculated; therefore his previous rank is no longer applicable.
gradereporting/utilities/historicalgradeavgandclassranking.txt · Last modified: 2020/07/08 13:54 by 127.0.0.1