2012 COMMENCEMENT READER CARD & PHOTOGRAPHY CARD
JOB # 1611
DATA PROCESSING AND LETTERSHOP INSTRUCTIONS
Extract data from one Excel file sent via e-mail.
File Name – Data for Reader Cards.xlsx Quantity – 7,544
The file should be separated out by using career field column “F”. The separation should be based on the
words “GRAD” or “UGRD”.
The total for GRAD is 3,363 and the total for UGRD is 4,181 for a total quantity of 7,544.
Do NOT remove bad records or foreign records. All records in this file MUST remain exactly as they
appear in the data file (i.e. each name filed should print on the card). For this project, please be sure to use
this data file and only this data file..
Setup the following reader cards as follows:
Setup the cards using colored index cards. The color of the cards is indicated below and should be able to fit
into the student ticket mailing (9 x 12 envelope). The font should be Arial or Times New Roman 22 pt bold
for all cards except for the photography cards.
Please note there will be A LOT of extra cards leftover for one set of the blue undergraduate and for the
one set of gold graduate. Those extra cards are for the persons who did not register for commencement and
should be set aside.
The 2 full sets of blue undergraduate and 2 full sets of graduate as well as both sets of the orange
photography cards should be delivered to the Office of University Events no later than Friday, April 20,
Blue -Undergraduate (Students 3 Complete Sets – 1 for ticket mailing – 2 returned to UMUC)
Should include students name and honor where appropriate
Gold-Graduate (Students 3 Complete Sets – 1 for ticket mailing – 2 returned to UMUC)
Should include students name
Orange-Photographer cards 2 complete sets (both grad and undergrad but should remain separate –
both sets returned to UMUC). These cards must include name and address that is in the data
In addition to the printed cards, please send 1500 blank cards for UMUC to use the day of commencement.
These don’t have to be a specific color.
All cards should be alpha order by last name within their respective sets.
University of Maryland University College
3501 University Blvd. East
Office of University Events – ICC 0151
Adelphi, MD 20783
Attention: Angela Hutchison