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.

Process #4

Process #5

Process #6