https://phialpha.org/individual-membership/
Undergraduate Students.
Undergraduate students shall be enrolled in the institution represented by the chapter, have declared a major in social work, have completed 9 semester hours of required social work courses or at least 37.5% of the total hours/credits
required for the degree, whichever is later achieved, and rank in the top 35% of their class.
Class Rank is not maintained at undergrad level. Would need determination by Chair/Dean on the equivalent definition.
Run the Informer Report:
SOCW - Phi Alpha - Social Work Honor Society |
Exporting to Excel
In EXCEL
- Remove all students with less than 37.5% of Academic Credits achieved
Locate the "Repeated Courses" column. Remove all but ONE of the courses.
2019FA SOCW N SOCW-210-AA I (Institutional) 2777172 3 2019FA SOCW N SOCW-210-AA I (Institutional) 2823885 3 2019FA SOCW N SOCW-210-AA I (Institutional) 2885640 3 2020SP SOCW N SOCW-365-A I (Institutional) 3 2020SP SOCW N SOCW-210-WICAA I (Institutional) 2777172 3 2020SP SOCW N SOCW-210-WICAA I (Institutional) 2823885 3 2020SP SOCW N SOCW-210-WICAA I (Institutional) 2885640 3 From this sample, Rows 2&3 and Rows 6&7 would be removed to avoid double counting of that course.
- 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.
The result will be those current students who meet the minimum requirements EXCEPT for the "top 35%". This report would be shared with the Department Chair for a determination of eligibility.
After the final list is determined. The students should be added to the CORM form in Colleague.
The code is HPA (Honorary - Phi 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