



President:
Treasurer:
Communications/Web:
Membership:
- Open the scanned application file with a PDF viewer.
- Open The Treasurer's Excel summary table. Look for bolded entries. These represent membership checks received subsequent to the prior update, which must be reflected in the Membership database.
- As noted this database is available at http://groups.yahoo.com/group/HoustonIlliniClub/files/, as filename "UIAC_of_Houston.xls".
- Unfilter the database (typically I leave column P, i.e. 2006-2007 member, selected to "Yes." Do this by clicking the pull-down in cell P3 and selecting "All.")
- For each of the bolded entries in step 6b look to determine if this is a prior member who simply needs to have his correct membership status reflected and paid dues noted. In ~80% of cases the individual will already exist, and your work is minimal.
- In this case change column Q (i.e. 2007-8 membership status) to "Yes." Go to column AN and input the amount of dues received from the member. Column AO should be updated to reflect the amount of optional scholarship contribution provided (note that members with three or fewer years since graduation, i.e. 2005-2007 alums are exempt from dues, as are alums who graduated 50 or more years ago. Thus "dues" received from these exempt individuals are treated as optional scholarship contributions and are reflected in column AO. Add the check number in column AP.
- In the ~20% of cases where you do NOT find the individual listed you should first position your cursor in the row which alphabetically would fall immediately below the new person. Click the Macro button "Add New Member" in cell A3. This will automatically create a blank row and copy generic information into the blank row to guide you. You should then populate the row using the information found both on Larry's Excel summary spreadsheet and on the scanned membership application form.
- As an additional ease-of-use feature the spreadsheet uses Excel's conditional formatting feature to automatically shade red any 2007-2008 member, who is non-exempt from dues AND has not paid dues. As such, upon inputting monies from such an individual you'll immediately note that the shading change from red to light blue.
- When finished save the Excel membership database which reflects your changes temporarily to your local drive (I use a c:\temp\ directory), being sure to use a slightly different file name (suggest you use the date, i.e. UIAC_of_Houston_20070801.
- Next, from http://groups.yahoo.com/group/HoustonIlliniClub/files/ click "Add file" then upload your modified file to the Yahoo group.
Secretary:
Scholarship Chairperson:
Discuss with fellow club officers how large a scholarship the club can afford. The Alumni Association in Urbana-Champaign kicks in $1 for every $2 the club awards, so if the total scholarship amount is $1,000, the club pays $666 and the UIAA pays $333 (currently the Club budgets a $2,000 annual scholarship which includes the UIAA contribution of $666. Thus the club's allocated annual scholarship cost is $1,333. Note that per UIAA's policies (as of 8/07) their maximum match per awarded club scholarship is $333.
Request a list of accepted students in early February through the Alumni Association. Typically, new students are accepted by February 1 (our UIAA contact is Sue Pruitt, 800-355-2586.)
The Alumni Association will mail you the list of accepted students and their addresses (either to your home or the club address.)
When you receive the list, mail the applications. The most recent letter to applicants and application form are available from the website at http://www.houstonilliniclub.com/scholarship_forms.htm. This should be updated to reflect your contact information and with your provided due date for return (ideally allow a month.) The applicants should either be permitted to mail the forms to the club P.O. box, and/or to email same to yourself. Keep track of your minor mailing expenses and contact the club's treasurer for reimbursement.
After the due date, retrieve all the applications and call a meeting of the scholarship committee to pick a winner. The criteria for selecting a winner is at the discretion of the committee. This process can be facilitated by email, fax or phone.
Call and inform the winner. Make sure they will indeed be attending Illinois. Invite them and their immediate family to the scholarship banquet (coordinating with the scholarship banquet coordinator.)
Ask the Alumni Association in Urbana to provide a congratulatory certificate to the scholarship winner. This is generally presented at the scholarship banquet.
Ask the club's treasurer to send a check to Urbana for the appropriate amount. Rather than presenting a check to the student, the amount will be deducted from the student’s bill in the fall.
Copyright © 2000-2008 UIAC of Houston. All
rights reserved.
Revised:
April 06, 2008