1 This utility calculates grade average and class rank for the current year The process also updates the student grade averaging record inserting a row on the grade averaging tab 2 TEA provides no guidelines to districts for ranking their students ID: 713492
Download Presentation The PPT/PDF document "Grade Averaging and Class Ranking" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Grade Averaging
and
Class Ranking
1Slide2
This
utility calculates grade average and class rank for the
current year. The process also updates the student grade averaging record, inserting a row on the grade averaging tab.
2Slide3
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.
3Slide4
Grade Averaging (GA) is set up in the Grade Reporting tables.
4Slide5
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.
5Slide6
6Slide7
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
7Slide8
Let’s look at
Numeric Grade Averaging
first. Using this adds or subtracts points to or from the final grade. It can also add or subtract a percentage. Weighted grades are for ranking purposes only.
8Slide9
9Slide10
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.
10Slide11
Examples are:
H Honors
> Adding 5 points to final gradeB 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
11Slide12
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.
12Slide13
Here is a good example:
You can set a range in the Low/High columns For example, if your average is between a
5
0-100
, you get
10
pts added.
This can be set up with different values for different averages.
13Slide14
Remember, this should already be spelled out in your Student Handbook.
14Slide15
Let’s look at
Grade
Point Average now.
15Slide16
16Slide17
17Slide18
Are there any questions on setting up Numeric or Grade Point Averaging in Grade Reporting Tables?
18Slide19
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.
19Slide20
To set up or change a course’s
GA (Grade Averaging)
Weight or Table, go to Grade Reporting>Maintenance>Master Schedule>District Schedule
20Slide21
21Slide22
22Slide23
NOTE******
Grades of blank, I, or 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)
23Slide24
Courses must be marked H for high school credit at the junior high
level
if they are getting hish school credit.
Be sure to code the course consideration to J, high school level course taken at junior high. This will appear on their AAR.
24Slide25
Don’t forget to set the junior high tables!!!! They should be just like the High Schools.
25Slide26
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.
26Slide27
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.
27Slide28
You will want to run the following reports to verify the GA Weight and Credit Level:
SGR 0130
SRG 0100
SGR 0050
28Slide29
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.
29Slide30
30Slide31
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.
31Slide32
Next, choose the grade level(s). You can select more than one. Choose Track, and Report Sort Order.
32Slide33
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.
33Slide34
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. If Graduated WD students are to be included in the ranking, enter the WD code.
34Slide35
Early computation can be used if the
Grades Used for Grade Average
field is set to S (semester) in campus control options. The grade averaging and class ranking process will use the cycle grade selected in place of the last semester grade.
35Slide36
To
calculate averages before the end of the school year, you may use the Early Computation feature. Some districts rank their students after the 1
st or 2nd 6 weeks of the 2
nd
semester. To do this for the 2
nd
semester 1
st
6 weeks, check the first box. Choose the 2
nd
box if you want to compute at the end of the 2
nd
semester 2
nd
cycle. Click Execute to calculate.
36Slide37
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 mostly 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.
37Slide38
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.
38Slide39
A = 4 points
B = 3 points
C = 2 pointsF = 0 points
39Slide40
Algebra I 95 4 points
English I 88 3 points
History 78 2 pointsIPC 92
4 points
TOTAL POINTS 13
Total Points / # of classes, so 13/4 =
3.25
40Slide41
Your turn
Calculate the College GPA.Algebra 79
Biology 96
Geography 88
English 70
41Slide42
Algebra 79
2
ptsBiology 96 4 pts
Geo 88
3
pts
English 70
2
pts
2 + 4 + 3 + 2 =
11
11
pts divided by 4 classes =
2.75
GPA
42Slide43
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
(
95=3.5
,
98=3.8
,
90=3.0
,
92=3.2
)
80-89 =
2.0 – 2.9
70-79 =
1.0-1.9
60-69 = 0
<60 = 0
43Slide44
2012-13 English I
78 87 |
1.8 2.72013-14 English II 76 78 | 1.6 1.82012-13 Algebra 1 95 92
|
3.5 3.2
2013-14 Geometry
83 88
|
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
44Slide45
GPA=Grade
Points divided by # of grades, so,
19.7 / 8 = 2.462545Slide46
Some districts calculate GPAs based on a 5.0 or 6.0 scale, as opposed to a 4.0 scale, for their weighted courses.
46Slide47
You try…………
Find the GPA for these 2 classes, based on a 4.0 scale…..
Not the College 4 point GPA.
47Slide48
2012-13
English I
78 87 2013-14 English II
76
78
48Slide49
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
49Slide50
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.
50Slide51
The number of decimal places is pre-set. Many districts set it to 5 places to differentiate averages as much as possible.
Most districts do not include withdrawn students in the Average or the Rank.
51Slide52
If you are running it for High School Credit, choose H (High) under credit level.
52Slide53
If you are running it for the
middle/junior high school,
then click on M (Middle).Most districts do not run
it for junior high.
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.
53Slide54
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. Most districts do not include WD graduates. Click execute.
54Slide55
The Grade Points, Average, and Ranking will appear in the student’s record in Grade Reporting>Maintenance>Student>Individual
Maint
., Grade Average tab.
55Slide56
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.
TACY,CHRISTINA
MARI
56Slide57
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,
N
umeric or Grade Point.
57Slide58
There was a row created for each of the school years from 7
th
– 11th grade.Notice the year 2011 has 2 rows. You can deduce that the student was in 8
th
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 8
th
grader could have been Algebra 1, Spanish 1, etc.
58Slide59
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.
59Slide60
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.
60Slide61
You can see on the bottom of the screen, this student’s cumulative GPA, including his 8
th
grade high school credit level course, is a 3.46828, his cumulative rank is 7
th
, the number of students ranked is 27, the date of ranking was 6/2/14, and this student is in the 2
nd
quartile.
61Slide62
Any questions on Cumulative GPA?
62Slide63
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.
63Slide64
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.
64Slide65
If you do not use
TxEIS
to calculate your GPA but want to start, you would start with this year, 15-16 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.
65Slide66
Thank you for attending this workshop!!
Are there any questions?
66