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:   

Exporting to Excel

In EXCEL

1.  Remove all students with less than 37.5% of Academic Credits achieved

2.  Locate the "Repeated Courses" column.  Remove all but ONE of the courses.

3. 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.

4. Subtotal the spreadsheet by Student ID and by GPA Credits
5. 
6.  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

Run this informer report for historical records on the HPA members.

SOCW - Historical Alumni Members of the Phi Alpha Honorary Society

Process #6