B117 Student GPA Ranking
Batch job B118, Student Course
History Update, creates course history (COHI) records from class list (CLIS)
records. Batch job B117, Student GPA Ranking Update, calculates cumulative GPA,
student rank in class and cumulative credits from the COHI records. B117
results are stored in the RANK screen. Both jobs are important for accurate
transcripts and report cards.
This chapter includes
preliminary parameters, B118 and B117 requesting screen explanations, suggested
B118 and B117 runs, B118 examples, and a place for you to fill in B118 and B117
requesting screens specific to your building for reference.
P141 is used to indicate whether you are using alphabetic or
numeric marks and the values (point or numeric) to be used for GPA.

When running B117 from COHI, the
GPA calculation it uses is:
STDPTS * CREDITS
DIFPTS * CREDITS
----------------
OR
----------------
CREDITS
CREDITS

KEYWORDS
CREDITS = course credit units from CRSE
TERMS = course duration - terms from CMST
RPTPER = course duration - reporting periods
from CMST
STDPTS = standard points from P109 (e.g. A =
4.00)
DIFPTS = difficulty points from P144 - for
weighting marks for
specific courses differently.
Works in conjunction with P134 - LEVEL OF DIFFICULTY CODES and LEVEL OF
DIFFICULTY field on CRSE and COHI.
MARKMULT = mark
multiplier - checks CREDIT MULTIPLIER on P109
GRDMULT = grade multiplier from P313 - weights
credit according to grade level of student.
CRSECNT = course count - based on number of
courses a student is taking.
To indicate arithmetic symbols in your equation use:
·
+ for addition
·
* for multiplication
·
- for subtraction
·
/ for division
The standard formula for calculated points is:
STDPTS*CREDITS
The standard formula for calculated credits is: CREDITS
Only courses with the field IN CUM GPA set to Y on CRSE will be included.
Additionally the program checks the student's mark against P109 to see if the
course should be included in GPA and whether or not credit is to be given.
B118 - Student Course History Update
B118 will move your current year CLIS records to COHI. This
job is always run at the end of the school year for high schools, and may be
run at the end of the first semester depending on your situation. Check the
B118 report closely. It can be rerun if necessary. You should set up different
versions of the B118 for each time during the school year you will be running
it. For example have one for the end of
first semester set up to just move over the Term 1 marks and then another
version at the end of the school year to move over Term 1 and Term 2
marks. This will eliminate the BLK
marks in COHI file.
See Example 26-2 for a blank B118 requesting screen followed
by an explanation of the prompts.

·
School Year:
Enter the current school year.
·
Term Range: Enter a term range to indicate which mark information
is to be updated to COHI.
·
Update COHI for
Courses Fully (F) or Partially (P) Completed (F/P): Enter 'F' or 'P' to indicate whether the
course/section must be fully or partially completed before a course history
record is created.
·
Use Latest Term
Mark As Cumulative Mark (Y/N): This
prompt is always answered 'N'.
·
Omit Update For
Alpha Marks: Enter up to ten marks as
defined in P109 - Alphabetic Marks. COHI records will not be created when the
excluded mark is in the first specified reporting period on B118. However, if
the student has a valid mark in the first specified reporting period and an
omitted mark in one of the later specified reporting periods, the COHI record
will be created, with the omitted mark not being updated to that COHI record.
·
Omit Update for
Numeric Mark Less Than: Enter a mark as
defined in P142 - Numeric Marks. COHI records will not be created or updated
for any mark less than the specified mark.
Note: When updating COHI with courses which are partially
completed, existing COHI records will not be deleted when an omitted mark is
encountered in a subsequent term.
·
For Blank Term
Mark Update: Enter BLK, as defined
in P109, to indicate the mark to be updated to COHI if no mark is found.
·
Term Mark: Enter up to four reporting periods, as defined in
P106, to indicate the reporting period marks to be updated to COHI for each
applicable term.
·
Final Mark: Enter up to four reporting periods, as defined in
P106, to indicate the reporting period mark to be updated to COHI as the final
mark for any course/section completed in the corresponding term.
·
Report Flag,
P149 Version, Clear P149 (Y/N): Use
when updating COHI for a small group of students.
·
Update Existing
COHI from CRSE (Y/N): Enter 'Y' or 'N'
to indicate whether or not you wish to update existing course history records
with new or modified information from CRSE. If 'Y' is entered, CLIS records
will not be updated to COHI on this run of B118.
·
Update Multiple
Course/Sections in Same Term Range (Y/N): Enter
'Y' or 'N' to indicate whether or not you wish to update multiple sections of
the same course, which meet in the same term range, to COHI for any one
student. If 'Y' is entered, a course history record will be created for each section
of the course. If 'N' is entered, only one course history record will be
created for the highest section of the course meeting in the same term range.
Example
Course /
Section Term Range
1001 01 1
1001 02 1
1001 03 2
1001 04 12
1001 05 12
If 'Y' is entered, a course history
record will be created for each section.
If 'N' is entered, a course history record will be created for sections 2, 3
and 5.
·
Section 1 is omitted as it meets in the same term range
as section 2 and is the lower section number of the two sections.
·
Section 4 is omitted as it meets in the same term range
as section 5 and is the lower section number of the two sections.
B117 will update the screen RANK. It is on this screen that
a student's GPA information is kept. When running transcripts, the cumulative
GPA and student rank in class are pulled from the RANK screen. When running
report cards, the cumulative GPA is pulled from the RANK screen.
When running B117 for the first time, you will want to run
it to update the cumulative GPA from the COHI records you have entered. When
the B117 is complete, print out the report and check it closely. Verify ALL
GPA's by hand. If changes need to be made to COHI, or you have new COHI records
to add, you can rerun B117 as needed. After running B117, you may display the
RANK screen to check ranking information for a particular student. See Example
26-1 for a blank B117 requesting screen followed by an explanation of the
prompts.
Example 26-1 B117-
Student GPA Ranking Update

·
MISC Subscreen:
Field Number: Value of: Enter a MISC
subscreen number, field number and corresponding value to process only
specified students.
·
Exclude Data
Flags: Enter up to five separate
one-character fields to exclude students from ranking. These fields are defined
by the school/district. If a data flag specified on the screen matches the same
data flag on a STUD record, the student is excluded. Data Flag 2 has been defined with an R for
you to utilize when excluding students from rank. Data Flag 3 has been defined with an H for you to utilize when
excluding students from Honor Roll.
R325 – Student GPA Ranking Report
This report is used to generate a list indicating each
students’ ranking information as indicated on RANK screen. Prior to submitting this report, B117 –
Student GPA Ranking Update must be processed to
calculate each student’s GPA and rank for the applicable term and reporting
period.

·
Grade: Enter
a grade level, as defined in P104, to indicate the grade levels to be included
on the report. Leave this field blank
(press backspace/delete key) to include all students regardless of grade level.
·
School Year:
Enter a two digit school year to indicate
the current school year as defined in P302.
Only those students whose school year in STUD matches this school year
will be included on the report.
·
Term: Enter a term, as defined in P105 to indicate
the term you are producing the report for.
·
Reporting
Period: Enter a reporting period, as defined in P106, to indicate the
reporting period you are producing the report for.
·
Exclude Data
Flags: Enter up to five separate
fields of one character each as defined by school/district. These flags are used to exclude students
from ranking. If one of the flags
matches the same data flag on any given STUD, the student will be excluded.
·
Status:
Enter a status code, as defined in P115, to indicate the status of all students
to be included on the report. Leave this
field blank (press backspace/delete key) to select all students regardless of
status.
·
P115
External/System Status: Enter “E” or “S” to indicate whether the above
status code is defined in P115 as an external or system status code. This field must be entered regardless of
whether or not a status code has been entered above.
·
Sequence
Control: Sorted in order of corresponding number.
·
Print Only
Students with Misc Subscreen Number/File Number/Value of: Enter a subscreen and field number as
defined in MISC. As well, enter up to
ten different values. Only those
students who have one of the specified values defined in the applicable MIS
subscreen/field number will be included on the report.
Definition of Report Ranking Columns
OLD
CUMULATIVE: This column represents
the students’ ranking information based on course history and/or class list
data prior to the current term. It is
taken from the RANK field “Cumulative to Date”.
CURRENT: This column represents the students’ ranking
information for the term and reporting period you are producing the report for.
CUMULATIVE
TO DATE: This column represents the
students’ cumulative GPA. Current is
added to Old Cumulative to produce the Cumulative to Date Ranking information.
YOUR B117 and B118 Setup
Below is a blank B117 requesting screen. Fill in this screen
the way you would run B117 at the beginning of the school year at your
building.
BEGINNING OF YEAR

Below are blank B118 and B117 requesting screens. Fill in
the screens the way you would run the programs at your building at the end of
the first semester. You may run B118 and B117 once each, or you may run B117
twice without running B118.
END OF 1ST SEMESTER


Below are blank B118 and B117 requesting screens. Fill in
the screens the way you would run the program at your building at the end of
the school year.
YEAR END


In this section, we'll introduce you to some screens that
you may not be aware of. These screens
are useful and may make day to day tasks easier as you learn the software.
The ACHI screen displays (can only access in DISPLAY mode) student
marks and class attendance information.
Records are displayed from CLIS - Class list records, COHI - Student
Course History records, or both depending on your selection. If displaying class list information, you
have the option of displaying all records for a student for all reporting
periods or only the latest class list records.
Class attendance information is displayed form CLIS.

The HIST screen displays a summary of course history
information from COHI. Records are summarized in one line per course.
Once the student's ID is entered, or the student is found by a name search, the
system gathers the records, and displays them in 132 character format.
Your screen is automatically formatted to condense the print. Once exiting
the screen, it is reset to 80 characters. This is a good way to check a
student's transcript without printing it out.

The RANK screen is used to display information pertaining to
a student's ranking in the class. GPA can be calculated for current cumulative
GPA, previous cumulative GPA, and a projected New Cumulative for the interim
periods. In addition to GPA information,
credit information such as attempted credits, earned credits, weighted points,
is also displayed on the screen. The
student's ranking in the class and the number of students included in ranking
is displayed also. Update information
shows the date the information was updated so you can tell how current it
is. This information is created when
B117 is processed to update Rank. It
can also be manually updated, however, any manual updates would be overwritten
by processing of B117.
If RANK is updated manually, the next time B117 is processed,
this will wipe out any manual updating done.
GPA is recalculated based on all COHI records on file or CLIS records,
depending on the method used to update it.
This information is also printed on report cards, transcripts, and
permanent record labels.
