What tech skills should mission-driven nonprofits expect all of their employees to master?
I’m not talking about what we should expect the “digital” people to know — or the IT staff. These folks are always going to require a deeper set of particular skills that are going to vary greatly depending on their role and the particular organization. I’m asking a bigger and more abstract question: what skills should we expect of everyone who works in an organization trying to make change in the world — from the CEO to the administrative assistants, and everyone in between.
Is it simply enough to expect “proficiency with Word, Excel and Outlook?” Or, in 2014, should we be expecting more?
I think we can and should expect more.
Let’s start by unpacking the notion of “proficiency” with “basic office productivity software.” There’s more here than meets the eye. Here’s my list of tasks I’d expect someone who has solid “intermediate proficiency” with the basic tools that are essential to modern mission-driven work to be able to perform.
1. Format a document with style-based formatting, both in a word processor and in a website content management system
2. Create, share and organize online documents and spreadsheets.
3. Use “tracked changes” or similar document revision features to collaborate on a document with others
4. Perform a basic mail merge from a spreadsheet, and be able to translate basic mail merge concepts to online tools such as broadcast email systems
5. Compose and send a lightly-branded broadcast email message that looks good on a mobile phone
6. Sort and filter a list in a spreadsheet
7. Use common spreadsheet formulas to analyze data like SUM, AVERAGE, MEDIAN
8. Create a simple chart or graph that follows most of Edward Tufte’s rules of good information design
9. Crop and resize an image for use on the web or in an email
10. Create a lightly formatted but professional-looking set of presentation slides that are compliant with an organization’s brand guidelines
11. Set up and use an LCD projector
12. Host and deliver a presentation online through webinar or online meeting software.
13. Use text/video chat software like Skype, Google Hangouts, etc. for real-time communication with colleagues
14. Manage one’s calendar online
15. Book appointments with colleagues and partners electronically
16. Use a password manager to generate and use secure passwords for online services
17. Build a simple online survey and interpret the results
18. Create rules or filters in an email client to organize your inbox
19. Track tasks with a team using tools like Trello, Asana, Basecamp or Evernote
20. Export a list of names or other data from one system in CSV format and upload the list into another system
21. Create and manage an email discussion list
22. Look up and edit contact information for constituents in a CRM database system
23. Bonus: design the agenda for and facilitate an effective small group meeting
Bet you weren’t expecting 23 items. (Hey, did I leave anything important out? Leave a comment!)
Seriously: imagine how much more efficient and effective our organizations would be if we could count on all of our colleagues and allies to have mastered these basic skills.
I’m not naive; this is a high bar. Is the solution then to raise our hiring standards? Maybe. When I’m hiring folks, I certainly attempt to gauge how solid their technology skills are. But I realize that there are a lot of smart, bright and capable folks out there who couldn’t tick all of these boxes. That’s OK. College is supposed to teach you to read, write and think — it’s not supposed to be vocational education.
This means that employers need to be ready to train their people in the practical skills they need to excel in the workplace. Part of the job of any social mission organization is to bring in smart, bright and capable people and help them grow. This takes a strong organizational commitment to making those investments — and a strong organizational culture of peer learning. And you can be sure I am looking to hire people who are motivated and ready to learn (and to teach!).
Folks who are already in the social change workforce: you should see mastering as many of these skills as possible as an essential part of your job. These are the building blocks of 21st century social mission work.
Update 7/4/2014: edited slightly to incorporate great feedback from commenters below and on social media. Thanks, keep the feedback coming!
Minor updates on 8/16/2016. Thanks Natalee Hill!