Versions Compared

Old Version 1

changes.mady.by.user John Bowker

Saved on

compared with

New Version 2

changes.mady.by.user John Bowker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel

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.



Process #1

Process #2

Panel
Panel
Panel
Process #3

Run the Informer Report:   

SOCW - Phi Alpha - Social Work Honor Society


Exporting to Excel


Panel

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. 2019FASOCWNSOCW-210-AAI (Institutional)27771723
    2019FASOCWNSOCW-210-AAI (Institutional)28238853
    2019FASOCWNSOCW-210-AAI (Institutional)28856403
    2020SPSOCWNSOCW-365-AI (Institutional)
    		3
    2020SPSOCWNSOCW-210-WICAAI (Institutional)27771723
    2020SPSOCWNSOCW-210-WICAAI (Institutional)28238853
    2020SPSOCWNSOCW-210-WICAAI (Institutional)28856403

    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.



Panel

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.



Panel

Process #4



Panel

Process #5


...