B118  Student Course History Update

and

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.

B118/B117 Preliminary Information

P141 - Marks Types

P141 is used to indicate whether you are using alphabetic or numeric marks and the values (point or numeric) to be used for GPA.

P123 - GPA Calculation

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 - Student GPA Ranking Update

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

bullet

Update RANK from (COHI/CLIS): Enter COHI to update RANK from Course History records. Enter CLIS to update RANK from Class List records. When you enter COHI, the program first goes to the RANK screen and blanks out the cumulative GPA, rank information, etc. so it can start over. Also, the program follows what you have specified in the COHI Information box and ignores the CLIS Information box.
When you enter CLIS, the program uses the data it finds on RANK from previous run(s) and adds the CLIS data to it. Also, the program ignores what you have in the COHI Information box and follows what you have in the CLIS Information box.
 

bullet

School Year: If you are updating RANK based on COHI records, this field tells the program to include any courses in COHI with the specified school year AND BEFORE. When updating RANK from CLIS, this field tells the program the CLIS school year it should look for.
 

bullet

Term/Rpt Prd: If you are updating RANK based on COHI records through the end of a school year, enter the highest term and reporting period defined in P105 and P106. If you are updating RANK based on COHI records through the end of the first semester, enter the appropriate term and the highest reporting period in that term. If you are updating RANK based on CLIS records at the end of the first semester, enter the appropriate term and the highest reporting period in that term.
 

bullet

Grade range: Enter the range of grades to be included in the batch job. This is the current grade of the student on STUD, not the grade in which they took the course on COHI.   Leave blank by pressing DELETE/BS key to get all students.
 

bullet

Rank Inactive Students (Y/N): Enter Y if inactive students should be ranked. Enter N if inactive students should not be ranked. Status J for your vocational students is considered an Active status and will be included when you say N to this prompt
 

bullet

P123 Version: Enter a version number to indicate the GPA calculation to be used. Version numbers are defined on P123 - Grade Point Average Calculation. The P123 parameter table is only used when you update from CLIS.

COHI INFORMATION

·        Use Term, Final or Exclusively Final Data (T/F/E): Enter T to calculate student ranking information using all term marks indicated in COHI. Enter F to calculate student ranking information using final marks in COHI. If a course does not have a final mark, the program will use the term marks. Enter E to calculate student ranking information using final marks indicated in COHI. When you enter E for exclusively final data, courses without final marks are not included in the GPA ranking.

CLIS INFORMATION

·        Update "New Cum" (N) and Roll "Prev Cum" Forward OR Update "Proj New Cum" (P) for Interim Rpt Prd (N/P): Enter N to update RANK based on CLIS records in the highest reporting period of the term specified above. Enter P if you are calculating a projected New Cumulative GPA for an interim reporting period.

·        Students with No CLIS Records Include in Ranking? (Y/N): Enter Y to include students without CLIS records in the ranking. Enter N to exclude students without CLIS records from the ranking. Enter Y to include your vocational students that have only COHI records transferred in the GPA and ranking.

·        Delete If Not Included? (Y/N): Enter Y to delete all previous RANK records for students not being ranked. Enter N to retain previous RANK records for students not being ranked.

INCLUDE/EXCLUDE CONTROL

bullet

For COHI Use Standard/Difficulty Points: Enter 'S' to use only standard points in the GPA calculation from P109. Enter 'D' to include difficulty points from P144 - Difficulty Point Scales in the GPA calculation.

·        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

SIS SCREENS

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.

ACHI - STUDENT ACHIEVEMENTS

 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.

HIST - STUDENT HISTORY SCREEN

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. 

RANK - STUDENT GPA RANKING INFORMATION

 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.