Progress Page

The Academics section of the student navigation pane in the administrative portal contains an entry labeled 'SHSM Progress'. When selected, a SHSM Progress page is displayed. The page contains the same student identification information as appears on the core Graduation Progress page.

Parameters

The following controls appear at the top of the page, underneath the student information, and are used to define the following parameters passed to the GetStudentSHSMCourses function. The StudentID parameter is set to that of the currently selected student.

SHSM Program

This is a pop-up menu containing an entry for each SHSM program enrolment (i.e. each SpEnrollments record where the associated SHSM Program [Gen]ON_SHSM_Flag and Available For OST/Status Sheet [Gen]ON_OST_Flag flags are set ON) in which the currently selected student is or has been enrolled at the current school. Each entry contains the name of the program followed, in parentheses, by the student's entry and exit date to the program in the form "(MMM-DD-YYYY to MMM-DD-YYYY)" - if the exit date is undefined, the value "present" is used. Entries in the list are sorted by entry date descending, exit date descending, program name ascending. The first entry in the list selected by default. The selected program enrolment is used to filter the set of records returned by the function as described below.

Include In-Progress Courses

This is a check box. The default value is checked. If checked, the page passes '0' to the Use_Earned_Credit parameter so that the function includes in-progress courses for which credit has not yet been earned. If unchecked, a value of '1' is passed and only courses for which credit has been earned are included.

Examine Exclude From GPA

This is a check box. The default value is checked. If checked, the page passes '1' to the ExcludeFromGPA parameter so that the function includes only courses for which [Courses]ExcludeFromGPA is turned off. If unchecked, a value of '0' is passed and courses are included regardless of the ExcludeFromGPA flag.

Show Progress

This is a button. When pressed, the GetStudentSHSMCourses is called with the current parameter settings and the progress display described in the next section is refreshed.

Progress Display

This section of the page is displayed (or re-displayed) when the "Show Progress" button is pressed, and when the page is first loaded.

It contains the same columns as the current Graduation Progress page and operates in the same fashion, but uses the 'best-fit' logic from the GetStudentSHSMCourses function to determine which SHSM credit requirement a particular course's credit was (or is) used to fulfill. The function is called using the parameter values as described above.

The progress display is based only on the requirements for the graduation set associated with the selected SHSM program. Therefore, the result set returned by the function is filtered so than only rows where the program name returned in the Name field (which holds [Gen]Name) matches the name of the SHSM program selected by the user.

Each subject area for the selected graduation set comprises a header line followed by one or more lines (one per course) for each requirement associated with that subject area. The order of the lines is defined by the requirement sort order ([GradReq]SortOrder). If more than one requirement has the same sort order, they are ordered by [GradReq]Id within that sort order. If more than one line is present for a requirement (because more than one course is used to fulfill it) the lines are ordered by course number.

Requirement

For a header line this is the subject area name ([GradReq]SubjectArea). For the first line for a requirement this is the requirement name ([GradReq]Name). For second and subsequent lines for a requirement this is blank.

Req

For a header line this is the total number of hours required to complete the subject area (i.e. the sum of all [GradReq]ReqCrHrs for the subject area). For the first line for a requirement, this is the number of hours required to completed the requirement ([GradReq]ReqCrHrs). For the second and subsequent lines for the requirement this is blank.

Completed

For a header line this is the total number of credits earned (not including in-progress credit) for all courses associated with the subject area. For each line for a requirement this is the course number and name ([Courses]Course_Number-[Courses]Course_Name) for a course where credit has been earned for the requirement, followed by the number of credits earned for the course.

Current

This column is displayed only if the 'Include In-Progress Courses' check box at the top of the page is checked. If displayed, for a header line this is blank. For a requirement line this is the course number and name ([Courses]Course_Number-[Courses]Course_Name) for a course where credit has not been earned (but would be if the course is passed) for the requirement.

Needed

For a header line this is the difference between Req and Completed. If the difference is 0, 'Completed' is displayed. For the first line for a requirement this is difference between the Req and the sum of credits earned for courses associated with the requirement. If the difference is 0, 'Completed' is displayed. For the second and subsequent lines for a requirement this is blank.