Case Study: First Presbyterian Church

Connecting a Disconnected Organization

From medical missions in Bolivia to projects serving the poor, hungry and uneducated all over the Triangle, Raleigh’s First Presbyterian Church has a full plate.

Dedicated pastors, staff and volunteers have little time to spare and none to waste.  Partner Technology Solutions was honored to help FPC regain precious hours previously squandered on a patchwork of inefficient technology.

We sat down with them, listened to how they use their technology resources, identified where the gaps and inefficiencies were and heard their frustrations with a mismatched system. The solution we designed for them involved migrating to Google Apps, which revolutionized their communications:  Email, Scheduling, Document Sharing  and more required no new hardware or software and is accessible from virtually any device with an Internet connection.

If you’ve ever missed an appointment because you looked at the wrong calendar or lost valuable time  trying to find a misfiled E-document, keep reading.

EMAIL

Challenges faced by the pastors, staff and members:

  • Lost emails
  • Spam problems
  • Limited mailbox capacity
  • Inconsistent platform
  • Inability to access emails away from the office
  • Incomplete group email lists

Staff accessed email through a patchwork of solutions including Microsoft Outlook, Mozilla Thunderbird, web mail and personal email accounts. Using “POP3” clients on the former system, once messages were downloaded in the office, they were no longer available remotely, causing difficulty for pastors and administrators working out of  the office.

As is standard with ISP-based email systems, mailbox limits were small, frequently forcing users to clean out their mailboxes to avoid rejected messages (called “bounces”). During a group training session,  I asked if anyone had ever cleaned out their full mail box to stop bounces.  The room resonated with “Yesses” and exasperated sighs.  Under the old system each user mailbox had a maximum capacity of 100MB.  That’s about 20-25 photos of your newborn niece.

Staff and members were even more frustrated because incoming emails were frequently lost or never delivered to their intended recipients.  The most daunting issue was spam; because staff email addresses are available on the web, most staff members had been inundated with junk mail.  Redundant spam filters made the problem worse. With filters at the ISP level, as well as through Postini and desktop mail applications such as Outlook and Thunderbird, every day staff had to:

  1. Log into the ISP’s website to clear spam from the ISP’s filter and deliver legitimate messages flagged as spam.
  2. Log into a Postini account to do the same.
  3. Look in their Outlook or Thunderbird spam/junk folders for legitimate messages.

These filters flagged many legitimate emails as spam and delayed delivery of time-sensitive communications. Lack of confidence in this cumbersome system led staff members to sometimes use their personal email addresses for church business, further compounding the confusion.

 Additionally, multiple committees and groups such as Deacons, Session (Elders), youth, choirs and others lacked effective group email tools. In order to communicate with a group, members and staff either created groups within their contacts or searched for a recent email to the group and hit “reply all.” The latter method frequently included contents of earlier unrelated emails and the absence of  “master” group lists meant new group members often didn’t get the message.

Solutions:

The switch to Google Apps provided each user with a 25GB mailbox – a box they will NEVER fill. That’s 250 times the size of most ISP mailboxes.  I hope I don’t have to eat my words, but I publicly offered to eat a Sunday bulletin if anyone fills their mailbox.

The migration to Google Apps eliminated the 5-10 minutes per day that staff spent searching spam folders for “real” messages. Google Apps employs excellent spam filtering and the spam folder is conveniently located on the left of your mailbox.  When it contains spam, the folder is bold. Otherwise, it blends in. No more logging into web mail, Postini  and other places to review spam.

 Remote users are enthusiastic about migration results. The old “POP3” email system deleted emails from the server once downloaded. Now an email is accessible from anywhere until the recipient deletes it, crucial to pastoral staff who spend much of their time out tending the flocks.

Because Google Apps is web-based, users may access their email (and all Google Apps!)  through any web-connected machine with a browser, whether on a PC, Mac or Linux box.  When they log in remotely, they now see a screen identical to what they see in the office.  Google Apps is tailor made for Android devices including mobile phones and tablets and works well on iPhones and iPads.  Windows Mobile 7 and 8?  Dunno. No one in the U.S. has bought one yet!

We have created several Google Groups for emailing various committees, boards and groups and their usage has taken off.  To address an email to an entire group, one simply enters the group name in front of the domain name:  Deacons@xyzchurch.org or Staff@xyzchurch.org. This is a much more efficient way to communicate with the various groups in the church.  Plus, administrators can log into the “Groups Control Panel” to determine whether any addresses are bouncing, as well as maintain “master” group lists, accessible to anyone authorized to communicate with the group.

Bonus Benefits

 A valuable feature of Google’s mail app is that it accommodates existing domain names and email addresses.  Thus, no one endured the hassle of changing and communicating a new email address.   Additionally, Partner Tech’s migration included importing all email archives, folders, contacts and contact groups, giving users the ability to search years of email archives using the power of Google Search in their inbox.

 

SCHEDULING

Challenges faced by the pastors, staff and members:

  • Calendaring/event scheduling
  • Resource scheduling
  • Inconsistent platforms
  • Limited remote access

The church’s master calendar had been maintained on an Excel spreadsheet for years by the office administrator. Maintenance of the calendar was time-consuming and the schedule could not be easily shared, especially with remote users. A critical component of church communication and management, the weekly bulletin and newsletter both rely on the information to be complete and accurate.

Located in downtown Raleigh and focused on multiple missions, FPC’s campus hosts a variety of classes, meetings and gatherings most days of every week. This presents a resource scheduling problem.  One example of a scheduling embarrassment occurred when the Deacons arrived for their April meeting and found their meeting room occupied by about 50 visitors attending a jobs workshop.

Solutions:

We created multiple shared calendars for the organization including the “master,” which will be embedded into the church’s new website once the new site is completed.  We also created calendars for the Children’s Ministry, Middle School Youth, High School Youth, Choir and Staff Vacations.  Everyone in the domain can view each of these shared calendars.  Only designated individuals may add / delete / modify events.  No one can view personal calendars of other staff members unless the staff member specifically grants permission.  Personnel responsible for specific activities will be responsible for the content of the sub-calendars.

The quality and accuracy of content is improving, the office administrator’s burden of maintaining and distributing multiple calendars has been alleviated, and parents are delighted that the calendars of their children’s activities can now be automatically shared with them.

 My presentation starts in 10 minutes. The projector was supposed to be here!  | Why are the Deacons meeting in the kindergarten classroom in those tiny chairs? | I’ve got 400 pounds of ice melting in the parking lot! Where’s the church van?

All of these issues are resolved by a new feature recently rolled out in Google Apps: Resource Allocation.  On the Administrative Control Panel we created various shared resources, such as meeting rooms, church vehicles and projectors.  When someone creates a new appointment on any calendar in the domain, they are able to reserve a resource and immediately confirm its availability.

Bonus Benefits

 With email, calendars and documents on the same platform and sharing similar icons and keystrokes, new users are quickly learning to transition among different Google Apps. Also, administration and support is simplified.  Remote support is easier and staff may assist one another because all users are looking at identical screens, regardless of location. And imagine how excited that staff and new member users are to have one Google user name and password across the platform.

 

DOCUMENT SHARING

Challenges faced by the pastors, staff and members:

  • Document sharing among users with diverse software & platforms
  • Tracking system for building maintenance requests
  • Inconsistent platform
  • Inability to access documents while away from the office

Documents such as the Preaching Schedule, Pastor-on-Call Schedule and Speakers for Recurring Events List were emailed among staff and maintained in a 3-ring binder. The Pastoral Care List summarizing crucial information such as births, deaths and sick and hospitalized members was maintained on a white board in a secretary’s office.

Building maintenance requests for the sprawling campus were submitted by phone, email or paper message to the church administrator. A group of volunteers (mostly retirees) was ready, willing and able to assist with addressing minor maintenance requests. However, there was no readily available punch-list from which to work.

The staff had long shared documents on a file server, a solution with several shortcomings:

  • One must know where to find a particular document
  • Documents are not accessible remotely
  • It’s impossible to tell if you’re looking at the most recent version.

Solutions:

The staff and members are embracing document sharing via Google Docs: word-processing, spreadsheets, presentations and moreBecause this suite of apps is web-based and imports files from many other programs, one doesn’t need to be on a computer with a particular software to create, review and share documents.  Further, several users utilize Macs at home and the file compatibility issue disappears on Google Docs.

Now they are uploading frequently-shared documents, such as the Preaching Schedule, Pastor-on-Call Schedule, and Pastoral Concerns List into Google Docs.  Once these items are shared with the domain, they are available on any browser to anyone in the domain. Thus, if Reverend Bob visits someone in the hospital on Saturday night, he can immediately log the results into the Pastoral Concerns spreadsheet from his laptop or smart phone and Reverend Ed will be up-to-date when he announces Pastoral concerns in Sunday morning services.  Further, when preparing the newsletters and bulletins, no one has to visit the white board, or pray that it’s up-to-date. FPC is just scratching the surface with this powerful tool and they’re finding new ways to use it everyday.

To address campus maintenance concerns, we utilized the Google Docs Forms tool. When campus users encounter maintenance issues, they follow a link to an online form to report the issue, producing an alert to the office manager and Property and Insurance Committee. When new items are submitted through the form, a cloud-based spreadsheet is updated and notifications are sent to the office manager and members of the handyman group.  The form includes columns to report each task’s current status, resolution or needed follow-up.

 

COST

Although not the most important factor, initial and ongoing investments are crucial factors for all decision makers.  For non-profits, funding challenges are forcing many to reassess their operating budgets to ensure that they can keep their missions on track.

Google Apps charges businesses $50 per user per year, a cost easily recouped through gained efficiencies. Thus, with 14 users the cost of Google Apps for FPC would have been $700 per year.  However, Google provides Apps for nonprofits meeting certain criteria (including 501(c)3 tax status) for free. Organizations must apply, provide proof of their tax status and make a handful of statements to be approved for the program   http://www.google.com/nonprofits/eligibility.html.

Unlike a Microsoft Exchange deployment, migration to Google Apps required no new servers, hardware upgrades or networking equipment.  The only implementation cost was labor.

Further, there are no software licensing agreement fees to pay year after year, no security patches to apply and no weekly updates to install. All of the software interface and back-end technology is hosted on Google’s servers and managed by them.  Further, Google’s Service Level Agreement promises a 99.9% up-time guaranty.  While I do recall Gmail outages in the past, it has been a very long time since the last one.

As a small business owner and former CPA, Ken knows that every dollar matters to small businesses and non-profits. He works with them to find affordable hourly or package price solutions that meet their budget restrictions.

SECURITY

The Federal Information Security Management Act of 2002 (“FISMA”) is a U.S. federal law that covers the information security of federal agencies’ information systems.  Google Apps has received the authority to operate at the FISMA-Moderate level (the standard level for federal email systems) from the U.S. Government. Accordingly, the U.S. General Services Administration (“GSA”) moved email to the Google cloud in 2011 citing cost savings and efficiencies.

Data security is a very important consideration when moving sensitive information to the cloud. Google has received an unqualified SAS70 Type II certification from their independent third party auditor.  This provides administrators and users peace of mind knowing that their data is secure in the cloud.

Google Apps provides the ability to connect to their servers using encrypted connections (look for https:// ) when connecting to Google. This assures users that login credentials, passwords and any sensitive information sent across the web is encrypted for the trip so that hackers cannot eavesdrop on transmissions – if you’re currently using a POP3 connection, you’re probably not using a secure connection.  The organization’s administrator can configure the requirement that all users connect using a secure connection.  Further, all data is securely stored on Google’s servers which include backups and redundant storage throughout their network of data centers. Thus, the days of losing all your emails, contacts and calendars in a hard drive crash are behind you.

 

IN CONCLUSION

A Legitimate Long-term Solution or Here Today and Gone Tomorrow?

If you think this sounds too good to be true, unfurrow your skeptical brow. Google Apps currently hosts 40 million users in 4 million businesses – that looks ideal for small organizations, right?  In addition to small businesses, Google has many major accounts such as Motorola, Land Rover, Genentech, the City of Los Angeles, and McClatchy Newspapers.  In North Carolina, Wake Forest University and NC State University have migrated all of their users from self-hosted platforms to Google Apps.

The Future

Are we finished?  Not a chance!  We’re just scratching the surface of what Google Apps can accomplish at First Presbyterian Church.  Yet to come:

  1. Incorporate YouTube Premium into the church website
  2. Embed Google Calendar into the new website
  3. Expand usage of Groups and Shared Documents
  4. Create an FPC intranet using Google Sites.

Will First Presbyterian’s office become paperless?  Absolutely not! However, it will reduce its reliance on hand distributed schedules, 3-ring binders and white boards hanging on the wall.

We will post follow-ups on Partner Tech’s Blog as the organization climbs up the learning curve with core Apps and we start deploying new features.

What is your organization doing to manage work flow and communications?  Let us know if we can help migrate you to the cloud to realize the benefits discussed here.

 

And Now for Something Completely Different

Check out this photography blog from Karl Greeson, one of my best friends from Wake Forest University.

After graduation, every time I saw Karl he had a camera in his hand.  Where I have become a decent point-and-shoot “hack” over the years, Karl has developed a keen eye for capturing great shots. Plus, I really enjoy his commentary on the site.

Take a look and share your thoughts.

http://karlgreeson.com/

Backups Made Easy (even your mother-in-law can do it)

I realize that people like discussing computer backups about as much as they enjoy preparing for a colonoscopy (hey, at my age that’s a reality of life!).  Stay with me on this one because it’s a lot easier than it used to be and might even be free!

I frequently work with home users and small businesses that either have no backup policy or an ineffective one. Thus, their important photos, music and business documents are at risk in the event of a severe virus, hard drive crash or natural catastrophe.

I recently assisted the parents of a high school student whose PC had been infected by a nasty virus.  The infection’s bark was far worse than its bite:  To a casual user it appeared that all files and most programs had been deleted.  A look at the Start menu showed virtually no programs listed.  When the aspiring law student looked in her documents folders, years of academic writing were gone as were a variety of photos and other media. In a desperate attempt to rid the computer of malware, they restored the computer to factory settings.  In other words, the operating system was reinstalled and all user files were deleted.

The good news:  The malware was eliminated.

The bad news:  None of her data was backed up.

Fortunately, I was able to recover a majority of her documents and media files using a file recovery utility.  However, due to the destructive nature of a factory reset, many of her files were either overwritten or corrupted… A loss which could have been avoided by an automated backup.

Power supplies and hard drives are the two most common PC components to fail and are relatively inexpensive to replace:  A power supply runs about $30.  A hard drive costs about $65.  The photos, music, tax returns and other important documents on that same hard drive are often priceless.  Many users often don’t think about backing up until it’s too late.

Businesses have a lot more at stake.  According to a DTI/PriceWaterhouseCoopers study, 7 of 10 small businesses that suffer a major data loss go belly-up within one year of the crash. This is a sobering reminder of the need for some sort of backup strategy. That could be an automated tape or hard drive backup, a cloud-based backup or an employee that brings an external drive or tape into the office on a weekly basis.

The right backup solution for you or your organization depends on the amount of data you need to protect, the frequency of backups (how much data loss your home or business can tolerate) and how long you can be without your information following a meltdown.


For smaller data needs, my favorite solution is Dropbox.  Designed as a way to sync data across multiple computers, tablets and mobile devices, this app is a great solution for backing up your data. Once you create your DropBox folder and get in the habit of saving your files and folders there, you really don’t have to think about it.  Plus, if you regularly access your information on multiple devices (say, a home PC + a work PC) your Dropbox folder will automatically sync your files & folders on multiple machines, eliminating the need to email files to yourself. This last point was a life changer for me.  During the normal course of a day, I might work on one of about 3 computers.  I often grab one of two laptops as I run out the door to meetings.  Before Dropbox, I always had to pause for a second to make sure this particular laptop had all the files I needed. With Dropbox installed on all three PCs, the important files are always synced across all 3 machines. Plus, those files are accessible on other computers via Dropbox’s web interface. There are also Android and iPhone apps so that you can access your files on smart phones and tablets.

What about security? Dropbox uses the same encryption and security techniques used by banks.  All data is encrypted for transit across the web and it is also encrypted while parked on their servers.  However, it’s up to you to make sure your password is complex and difficult to guess. Accordingly, you should go to great links to come up with a long password or pass phrase that includes all of the elements discussed in my blog about passwords.

The entry-level Dropbox account provides 2GB of free storage.  Not enough?  Invite your friends through the website.  For every friend that accepts your invitation you each get an additional 500MB of space, up to a max of 16GB – that’s not too shabby!  If your storage needs are greater than a free account offers, you can purchase 50GB of cloud storage for $100/year or 100GB for $200/year.

So if you have not set up a backup strategy yet because it’s too much trouble, give Dropbox a try.  If it’s remote file access you want, you get that too. Dropbox brings you the best of both worlds in an easy-to-use application.  For most users it’s free too!

If you want to start off with an extra 500MB of storage space, leave a message here and I will send you an invite.

Need a little help understanding how it works?  Check out the tutorial videos on the Dropbox website. If you need even more assistance, drop me a note and I will help you set it up, create your folders and launch your space in the cloud.