Transcript Grade Averaging and Class Ranking Training Document

Grade Averaging
and
Class Ranking
This utility calculates grade average
and class rank for the current year.
The process also updates the
student grade averaging record,
inserting row on the grade
averaging tab.
TEA provides no guidelines to districts for
ranking their students. A district’s GPA
policy is determined by its local district
policy. For this reason, setting up and
running Grade Averaging and Class
Ranking will vary greatly between
districts. The district’s GPA policy should
be outlined in the Campus Student
Handbook or a similar document.
Grade Averaging (GA) is set up in the Grade
Reporting tables.
First, check your Campus Control
Options and make sure your Ranges and
Conversions are set where you want
them. This is how you want the Grade
Conversion Information if you want an A
to be worth 4.0 grade points, a B to be
worth 3.0 grade points, a C to be worth
2.0 grade points. This is how the College
4 point GPA works. It uses these ranges.
Select Grade Point Grade Averaging to use
the grade averaging tables. GPA looks like
3.94 , 2.35
OR
Select Numeric Grade Averaging to use the
numeric grade averaging operator/value
tables. Numeric looks like 98.674 , 72.123
Let’s look at Numeric Grade Averaging first.
Using this adds points to the final grade for
ranking purposes only.
Districts differ on how they set this
up. Some districts have the
categories Basic, for special ed
classes, Regular, for regular classes,
Honors, for honors classes, AP for
advance placement classes, PreAP,
for preAP classes, and others.
Examples are:
H Honors > Adding 5 points to final grade
B Basic > Subtracing 5 points from final grade
AP Advanced Placement> Adding 10 points to final
Grade
R Regular > Not doing anything, grades are as they are
The extra points are added
to or subtracted from the
final grade. This is for the
purpose of Class Ranking only
and are not written on the
Transcript or grade records.
Here is a good example:
You can set a range.
For example, if your
average is between a
90-100, you get 10 pts
added. If your
average is between
70-89, you only get 5
points.
Remember, this
should already be
spelled out in your
Student Handbook.
Let’s look at
Grade
Point
Average now.
Are there any questions
on setting up Numeric
or Grade Point
Averaging in Grade
Reporting Tables?
Setting up the courses, or
making sure they are labeled
correctly is extremely important.
The process will not work as
intended if they are not and the
calculations will not be as you
intended.
To set up or change a
course’s GA Weight or
Table, go to Grade
Reporting>Maintenance>
Master Schedule>District
Schedule
• NOTE******
• Grades of blank, I, N/G, will be adjusted to a zero
for grade averaging, and the course is counted in
the student’s total number of courses if the course
GA Weight is not set to 0. For this reason, it is VERY
IMPORTANT to print the Blank, Incomplete, Failure
(SGR1000) report based on the type of grade(s)
which will be used for averaging (cycle, semester,
or final)
Courses must be
marked H for high
school credit at the
junior high level. Be
sure to code the
course
consideration to J,
high school level
course taken at
junior high. This will
appear on their
AAR.
Don’t forget to
set the junior high
tables!!!!
Most districts don’t run GPA
and Class Ranking for the
junior high campus, other
than the high school credits,
because there is really no
need for it.
When high schools run grade averaging and class
ranking, credit level H is written to students’
current year grade average rows.
If the H.S. Credit Lvl Courses for Middle School field
is set to Yes, the Grade Averaging and Class
Ranking utility includes only courses taken for high
school credit at the middle school. The credit
level H courses taken at middle school are the
only courses included in the student’s grade
average row.
You will want to run the following reports
to verify the GA Weight and Credit
Level:
SGR 0130
SRG 0100
SGR 0050
To run Grade Averaging and Class Ranking,
go to Grade Reporting> Utilities> Grade
Reporting and Class Ranking.
To run for high school only, choose No for the
HS Credit Lvl Courses for Middle School.
To run for junior high/middle school high
school credit level courses, choose Yes.
For the Process, choose the GA type you use. If you
run both, class ranking will be applied to the last one
run. There is no need to run both; some districts like to
see both.
Next, choose the grade level(s). You can
select more than one. Choose Track, and
Report Sort Order.
Choose Print Credit if you want the credits to be
printed. If you would like Course Entry Dates verified,
check the box. You have the option to Exclude
Students from Ranking if they are taking a course that
excludes them from Honor Roll.
In the Normal Max field,
type the number that is
used to flag students with
excessive courses. If the
course factor is greater than
this number, an asterisk (*)
prints next to the student’s
course factor. The number
must be two digits. If
Graduated WD students are
to be included in the
ranking, enter the WD code.
Early computation can be used if the Grades Used for
Grade Average field is set to S (semester) in campus
control ooptions. The grade averaging and class
ranking process will use the cycle grade selected in
place of the last semester grade.
To calculate averages before the end of the school
year, you may use the Early Computation feature.
Some districts rank their students after the 1st or 2nd 6
weeks of the 2nd semester. To do this for the 2nd
semester 1st 6 weeks, check the first box. Choose the
2nd box if you want to compute at the end of the 2nd
semester 2nd cycle. Click Execute to calculate.
College 4 point
The calculation of the College 4 pt GPA is consistent among
districts all over. It is calculated differently than district GPAs.
Colleges often look at this GPA instead of the district GPA
because each district has their own way of determining their
GPA. Set the number of decimal places in Grade Reporting.
The College 4 point average is
calculated based on the College 4pt
Scale field on the Maintenance > Tables
> Campus Control Options page. The
four-point average is calculated without
weighting. Points are assigned according
to the values for the Grade Conversion
Information A, B, C, D, and F fields on the
Maintenance > Tables > Campus Control
Options > Ranges & Conversions tab.
A = 4 points
B = 3 points
C = 2 points
D = 1 point (if using Ds)
F = 0 points
Algebra I
95
4 points
English I
88
3 points
History
78
2 points
IPC
92
4 points
TOTAL POINTS
13
Total Points / # of classes, so 13/4 = 3.25
Your turn 
Calculate the College GPA.
Algebra 79
Biology 96
Geography 88
English 70
Algebra
Biology
Geo
English
79
96
88
70
2 pts
4 pts
3 pts
2 pts
2 + 4 + 3 + 2 = 12
12 pts divided by 4 classes = 3.0
GPA
Now, let’s look at a District’s GPA calculation.
Unlike College GPA, District GPA is much more
specific. This shows grade points on a 4.0 scale.
100 = 4.0
90-99 = 3.0 – 3.9
80-89 = 2.0 – 2.9
70-79 = 1.0-1.9
60-69 = 0
<60 = 0
(95=3.5, 98=3.8, 90=3.0, 92=3.2)
2012-13
2013-14
English I
English II
78
76
87 |
78 |
1.8 2.7
1.6 1.8
2012-13
2013-14
Algebra 1 95
Geometry 83
92 |
88 |
3.5 3.2
2.3 2.8
1.8+1.6+3.5+2.3 = 9.2
TOTAL 9.2 10.5
2.7+1.8+3.2+2.8 = 10.5
___________________________________________________
9.2
+ 10.5
19.7 grade pts
GPA=Grade Points divided by # of
grades, so,
19.7 / 8 = 2.4625
You try…………
Find the GPA for these 2 classes.
Not the College 4 point GPA.
2012-13
English I
78
87
2013-14
English II
76
78
78 87
1.8 2.7
76 78
1.6 1.8
1.8+2.7+1.6+1.8 = 7.9
7.9 / 4 = 1.975
Cumulative Grade Average and
Class Ranking
The Cumulative Grade Averaging and Class Ranking includes all high
school courses (that the district designates to include). To access it,
select Grade Reporting>Utilities> Cumulative Grade Averaging and
Class Ranking. The following screen is displayed.
The number of decimal places is pre-set.
Most districts do not include withdrawn students in the
Average or the Rank.
If you are running it for High School Credit, choose H
(High) under credit level.
If you are running it for the
middle/junior high school,
then click on M (Middle).
Choose which process
you want to run, Grade
Point Average or Numeric.
Remember, your district
ranks students and averages
grades using only one of these.
Select the grade level(s) you wish to run.
Then, choose how you want the reports
sorted. Check the boxes if you want the
credits printed and the details printed for
each year selected.
If graduated withdrawn students are to
be included, enter the WD code. Click
execute.
The Grade Points, Average, and Ranking will appear
in the student’s record in Grade
Reporting>Maintenance>Student>Individual Maint.,
Grade Average tab.
This student’s GPA was run for his middle school
classes in 2010 and 11. Again, Most districts do not
do that. Notice The M in the first column, meaning
Middle School. The system averaged all the
courses with credit level M.
These highlighted rows are high school level courses.
Those courses were coded with the credit level H. The
G in the last column shows which process was run last,
Numeric or Grade Point.
There was a row created for each of the school years from
7th – 11th grade.
Notice the year 2011 has 2 rows. You can deduce that the
student was in 8th grade in 2011. He had both Middle
School and High School credit level course that year. The
courses that were coded High School credit for the 8th
grader could have been Algebra 1, Spanish 1, etc.
Notice that the Numeric Averages
column all have 0s in them. Numeric
Averaging was not run in this district.
They ran Grade Point Averaging. Also
notice the 4 Point column. This is the
College 4 Point scale we discussed
earlier.
The next to the last column shows the
number of credits per year and the
ranking for that school year only.
The last column shows the number of
students in that grade level and the rank
the student was that year.
You can see on the bottom of the screen,
this student’s cumulative GPA, including
his 8th grade high school credit level
course, is a 3.46828, his cumulative rank is
7th, the number of students ranked is 27,
the date of ranking was 6/2/14, and this
student is in the 2nd quartile.
Any questions on
Cumulative GPA?
Remember, to run GPA correctly,
you need to see what the district’s
handbook says and have all
courses coded that way. They may
be Regular, Honors, Basic, AP, or
other kinds of courses. Most districts
weight the GA weight as 1,
meaning the course grade counts
only 1 time.
The tables in Grade Reporting must be set up
correctly. I suggest you start from 100 (unless
your highest grade allowed is something
different, like 105 or 110) and number all the
way down to 0 so there is no doubt what
each grade is worth. If a grade is not listed, it
gets 0 grade points for Grade Point Average.
It is a good idea to hand calculate the top
two student’s GPA to make sure everything
has been setup correctly in the system.
If you do not use TxEIS to calculate
your GPA but want to start, you
would start with this year, 14-15
using TxEIS, but manually get grade
points for the previous years. You
can enter values into a spreadsheet
and have it calculate for you, then
manually enter them into each row.
Thank you for attending
this workshop!!
Are there any
questions?