Thursday, August 9, 2012

So, what's to come...???

      So, it is time for this summer internship at the Bowers Museum to come to an end.  The summer has escaped me completely!  But what is that saying, "time fly's when your having fun?"  But while the History 398 course is closing, I still have one more week in my internship, to wrap up all the loose ends.  So let me detail what my last duties will include.  

      Now that the contact list binder is complete, organized, and a marvel, there are a few remaining steps to take, to get the Public Relations department into a prime, oiled, high-performance machine.  Below, I took an aerial photo of the binder, to show the organization and segmentation.  Not to mention the hundreds of sheets of paper.   

      Next would be to call PatronMail, and ask them to delete the old lists, that I have now edited and updated.  Then we will upload the new lists to the PatronMail system, where we pull our contacts directly from, to email press releases on new exhibits or coming events the museum is hosting. 

      Next, I need to make a conglomerate Excel sheet, while I wait for PatronMail to scrap the old lists.  One for all of the "Media" contact lists and one for all the "University Related Information" contact lists.  The steps of this project all seem to be simple, which they are, but it is the time that each steps takes, and the maticulous focus it demands.  But it will all be over by Wednesday, August 15th! 

Tuesday, August 7, 2012

Quick Peak





                A Quick Peak before the Big Reveal
  

  As promised, I have taken a few photos of this infamous (in my opinion) binder of located, edited, and formatted contact lists of the public relations department of Bowers Museum.  I made the cover real clear to understand what the binder contained.  The binder contains the folder of "Media" lists, "University Related Information," and "PatronMail" lists.  Each folder is alphabetized and user friendly.  Clean, clear, and educational was the aim of this binder.




       Inside the cover is a "Numbers Breakdown" sheet.  This notes the percentage of "bad emails" or "opted  outs" calculated.  These percentages are a significant reason why the Public Relations department was not performing to its highest potential.  Unfortunate to report, but not all 51.5% of the "Media" PatronMail emails were found.  Nor were all 25.8% of "University Related Information" PatronMail contacts found.  A few needles in those haystacks had quite the disguises.



        The next photo is a snapshot of one of the printed Excel document, to show my reader what the binder of roughly thirty-two hundred sheets of contact list filled paper looked like.  This is one of the "Media" sheets, displaying the Outlets Name, First and Last Name of the contact, their Title, and their Email.  The binder, minus two more folder of the "University Related Information" lists, is almost over compensating at this point.  And it weighs about nine pounds.  It will be humorous to see my boss' face, with the finished project.

Tuesday, July 31, 2012

Celebrations and Excel Sheets

This week was my 21st birthday on Tuesday, July 31st.  So to celebrate just a bit, I brought in some chocolate strawberries for my boss, and two other employees I have formed a relationship with.  My boss was excited to celebrate with me, to say the least.  It just so happened that chocolate strawberries were also her favorite dessert.  That may be why we work together so well.

     Back to business, I continued on with the hardcopy contact list project.  I got roughly 30% more completed.  I am now through with the "Media" contact list section.  Now there is only the "University Related Information" contact lists to go, which will not be completed in a days work.  There are roughly 34 excel documents, some containing up to four tabs.  And the project continues.  There will also be photos to come of the binder, so that my readers can have a visual of what I have been detailing for the past seven or so weeks.  

     The photo above shows my work environment. Or should I say, my cubicle.  I have not taken any time in the four months of my internship to do any decorating, just because it may make me sad to un-decorate.  But while the environment is simplistic, it is educated and inspiring, with magazines and new clippings of past exhibits framed and hung up on the walls.  

Tuesday, July 24, 2012

Digital to Print

This week in my internship, July 24th and 25th, I began taking my contact list project from the computer to a hardcopy format.  As I discussed last week, my boss wants me to provide her a hardcopy record of the new, concise, edited, formatted, and updated contact lists, as a safety measure.  Not to mention the fact that she loves binders, and she has a hardcopy of every exhibit that decorate the walls of her off.

     So this process of taking the digital excel sheets to hardcopy form is, surprising, not as easy as simply clicking the "Print" button.  First, I pull up the excel files, one at a time.  I highlight and "copy" the list, then "paste" it to another "worksheet" on the same excel file.  Then I delete the unnecessary information for the printed sheet.  The necessary information, that my boss wants to see, includes the name of the organization, the contacts name, their position, and the email.  Next, I highlight the text, then "set the print area," followed by "previewing" the print.  In most of the cases, I would rotate the paper from "portrait" to "landscape," which would allow me to fit all of the columns of necessary info on less amounts of paper.  I do like to conserve a tree where I can.

     So after formatting the excel sheets into a printable version, I began to shoot off the copies to the printer.  Then I gathered up the roughly one hundred or so pages of contact lists, hole punched, then stapled the related lists together, alphabetized the lists, and set them in the corresponding folder in the contact list binder.  I am only about 30% through this project, so there is much work to be done.  And so it continues. 

Tuesday, July 17, 2012

Same old, Same old

This week I continued working on my locating, editing, and updating of the museum's contact list project.  I have moved on from the Media Contact List folder, since those are as clean as I can possibly make them.   It is nearly impossible to find every single "bad email" or "opted out."  As it is, there were about 789 "bad emails" or "opted outs" in the exported PatronMail list that contained 1,363 total media emails, from the entire database.  That is 57.8%.  Tracking down those 789 emails is mission impossible.  A strong majority of the emails were located under understandably labeled Excel sheets, but the goose chase for roughly 130 of those emails took me about two weeks to find few, then get annoyed and move on, with my boss' permission of course.

     Now I have turned my attention to the University Related Information folder.  There are roughly 842 "bad emails" and "opted outs" out of 3,254 in this folder, which is 25.8%.  This folder, I am cleaning up relatively quickly, compared to the Media folder.  This is namely due to the fact that the majority of the emails are to be found in an understandable location.  For example, if I have a "bad email" from the Japanese History Professors list, I can easily find it under the "Japanese History Professors" list in the "University Related Information" folder, under the Public Relation's "Contact Lists" section.

     My boss has high aspirations for what this ultimate, clean, dynamic, high-performance, supreme contact list compilation will do for the museum.  Next week I will begin on the hard-copy procedure of the project, which I am excited for.  It will give me something new to do, shake the routine up a bit.  I just hope my boss likes my vision for what is to come.  Stay tuned.

Tuesday, July 10, 2012

Co-workers Joy!


        This week, my internship got a happy surprise!  Let me give you a bit of background to begin with.  Last summer, when I entered my marketing internship at the Bowers Museum, there was an intern in the Graphics and Communications department, who had about a year experience with the museum and the Marketing department’s protocol.  Her name is Eleanor and she was a friendly face to ask any concern or curiosity to.  She dabbled in some of the marketing work, along with what she did under Nancy Johnson with Graphics.  She sat in the Graphics and Communications department, which housed four desks.  Those desks are occupied by my boss, Nancy Johnson, her right arm, Sasha, the website orchestrator, Vincent, and Eleanor.  I actually sit at the desk Eleanor use to, last summer.  She is a sweet, determined, talented young woman.  Last summer, we would have lunch together, so we grew close, noticing that we both love to cook and have an eye for photography.  

        Eleanor, on Tuesday, July 10th, walked into the Graphics and Communications room, and gathered the group.  So Sasha and I walked over to Nancy's desk.  The second Eleanor said, "I have an announcement," I knew exactly what she was going to say.  My boss legitimately screamed when Eleanor announced she was pregnant with her and her husband's first child.  I was so excited for them, not just because I love babies, but because I know Eleanor and I have become familiar with her husband through our lunchtime conversation.  They are both very smart and have tender hearts, so I know they will make excellent parents.  

Tuesday, July 3, 2012

Thumbs Up and Celebrate!

This week, my internship flew by so fast, namely because of the 4th of July celebrations.  It did surprise me that the 4th of July happens to be my boss's favorite holiday.  A peculair pick for a "favorite" holiday, but to each their own.  Mine would have to be Thanksgiving, for the food, of course.  It was very nice of Nancy to order all her interns, there are three of us for the summer session, to take the rest of the week off, seeing as she would not be in the office either.

      So Tuesday, July 3rd, was relatively mellow.  I got into work at 9:30am, and immediately continued to work on my joyous, never ending Excel contact list project.  Nancy, my boss, was in a meeting for roughly the first hour I was there, but when she retreated to her desk finally, she asked to speech with me, regarding my advances with the project.  But, at that time, she was not ready to speak.  She still had to run around the building, getting some of her own work done.

     She settled into her desk chair at about noon, and I walked her through what I had been doing.  She essentially just wanted to double check that I was cleaning the system in an efficient way, rather than confusing myself and making a more dramatic mess of the chaotic database.  She enjoyed seeing the progress I had made thus far, and instructed me on how to advance.  Her instruction, little did she know, was my idea.  I knew how I wanted to proceed, she just happened to read my mind.

     So I continued on down the path for this project for another few hours, then left work on Tuesday at 2:30pm, ready to start my weekend essentially!