Delta Phi Alpha - German Honor Society
https://deltaphialpha.org/membership/
Applications for individual membership in the Society are accredited by the student’s chapter advisor and/or chair of the German department. Qualifications for student membership are:
A minimum of two years of college or university German or their equivalent | |
A minimum average of B+ (3.3GPA) or its equivalent in German courses | |
A minimum cumulative average of B- (2.7GPA) or its equivalent | |
Indication of continued interest in the study of German language and literature |
Chapter faculty advisors submit the application materials for students within their constituent chapters. Each new member receives a custom, embossed membership certificate and a membership pin.
Run this informer report:
GER - Alpha Mu Alpha - German Honor Society
Export results to excel for manipulation of the 3.300 GPA requirement in the German Classes. Transfer Credits are allowed to be included. Those are "ungraded" so they will not interfere with the GPA calculation but will be counted toward the 2 Years of German equivalency.
Eliminate anyone on the list with less than 4 COURSES in GER/FLGR subject courses.
FILTER on Status to remove and D, W, X classes that have been dropped, withdrawn or voided.
Remove one of the Duplicate Courses shown as "repeats"
RUN two different subtotals on the data tab
and make sure to UNclick the Replace current Subtotals
in excel, click the little '3' box in the upper left
and remove any student with less than 4 courses listed.
ADD column "GPA" and divide the quality-points by the GPA credits. You may find some students have not taken any classes at VU but qualified based on the number of transfer/AP classes. Since they are required to have a minimum GPA at VU, those students do not qualify for membership.
You will remove any student with a calculated German Class GPA of less than 3.3. You may find it is only one class, but if that grade is a 3.3 or higher, they will qualify
Type | Gpa Credits | Verified Grade | Quality Points | GPA |
PL | 0 | 0 | 0 | #DIV/0! |
I (Institutional) | 4 | 4 | 16 | 4.000 |
I (Institutional) | 4 | 4 | 16 | 4.000 |
I (Institutional) | 4 | 4 | 16 | 4.000 |
12 | 48 | 4.000 | ||
#DIV/0! | ||||
PL | 0 | 0 | 0 | #DIV/0! |
PL | 0 | 0 | 0 | #DIV/0! |
PL | 0 | 0 | 0 | #DIV/0! |
I (Institutional) | 3 | 3.7 | 11.1 | 3.700 |
3 | 11.1 | 3.700 |