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. Image Added
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.Image Added

The code is HPA  (Honorary - Phi Alpha)

Scroll to the bottom of the list and Enter the ID Number or Student Name

Image Added

This will take you to the COMD screen for detail entry.

Image Added

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