| Panel | |
|---|---|
|
...
USING THIS INFORMER REPORT:
POLS - Pi Sigma Alpha - Political Science Honor Society |
MAKE sure you select the "list by comma" option on the export results popup
In EXCEL
Locate the "Repeated Courses" column. Remove all but ONE of the courses. For example...
A.BA.POLS 2.89 POLS 2019FA POLS-120 POLS-120-B 3 I A- A.BA.POLS 2.89 POLS 2018FA POLS-120 POLS-120-B 3 I D- A.BA.POLS 2.89 POLS 2018FA POLS-130 POLS-130-B 3 I A- A.BA.POLS 2.89 POLS 2019FA POLS-150 POLS-150-AA 3 I A A.BA.POLS 2.89 POLS 2019SP POLS-240 POLS-240-A 3 I B A.BA.POLS 2.89 POLS 2020SP POLS-261 POLS-261-WICA 3 I C+ From this sample, Row 2 would be removed to avoid double counting of that course.
You can identify the duplicates by concatenating the student ID and the COURSE, formula: =CONCATENATE(A2,L2)
- Subtotal the spreadsheet by Student ID and by GPA Credits
- Identify all students with fewer than 9 credits achieved and remove them from the list.
To Calculate the GPA within the
...
POLS courses, you will divide the Quality Points by the GPA CRED field - FORMULA: =+q2/o2
you can hid the detail and identify any students with a KIN POLS GPA below the 3.2 4 valuation. and you will remove any falling below that number.
The list will then be turned over to the Dept Chair.
| Panel |
|---|
CORM data entry for HPSA memberships to be completed by departmentAfter the final list is determined. The students should be added to the CORM form in Colleague.The code is HPSA (Honorary - Pi Sigma Alpha)
Scroll to the bottom of the list and Enter the ID Number or Student Name
This will take you to the COMD screen for detail entry.
If the Date the student was added to the list, enter that date in the Start Field. Otherwise, Enter Today's date. The End Date will be Empty The Status will be "AC" (Active) Roles: Always use "M" Press Save and Update. The LIST that appears on CORM is automatically alphabetized. So the person you just added may not appear on that page. When you add the last one, Hit SAVE ALL Run this informer report for historical records on the HPA members.POLS - Members in Pi Sigma Alpha |
