Crowdsourcing and using Excel data to make maps — Moa Frygell

Screen Shot 2014-04-28 at 1.13.50 PM

2014 Kip Fellow Moa Frygell posted this on her personal blog this week. It details how she used tips from Kip trainer Mandy Jenkins to crowd-source and visualize data using a survey, Microsoft Excel and Google Maps.

Last week I tried out a tool that I’ve been familiar with for some time, but that I never really got around to doing. Skellefteå AIK is a northen swedish hockey team that has been very successful this season and last. They won the Swedish championships last year, and they are probably going to do the same this year. They won the last game in the final series 8 goals to 1 against Färjestad. Game 4 out of 7 is to night.

My collegue in Skellefteå, great hockey reporter Robert Tedestedt, did a piece last week on a kid that lives in Stockholm but who is a big Skellefteå AIK-fan. His dream was to interview the players, and Robert let him do that.
This story got me thinking. There must be plenty of Skellefteå AIK-fans all over the world. People that were born in Skellefteå, but that left for one reason or another, or anyone really who is into hockey and likes their play or a player.

So I created a form that people could fill in details of where they live and what team they support. I shared it on our webpage and in social media. Then I made a map by putting the data from Excel into Google maps. It was really very easy, and fast. The only problem was that too many people wanted to sign up so I lost control over the data collected and published over the weekend. Another problem is that settings in Escenic doesn’t allow us to embed external files. I’m going to talk to Stockholm about that.
Thanks to @mjenkins for inspiring this!

Creating Sharable Content — Andrew Springer


Creating social media that captures people’s attention means tapping into emotion, said Andrew Springer, the senior editor for social media at ABC News who spoke recently to 2014 Kip Fellows via Google Hangouts.

“It doesn’t matter what the emotion is,” he said. “It’s called the ‘Hey, Martha! affect.’ Someone is reading the newspaper, they look up and say, ‘Hey Martha! Look at this!’”

The Columbia University School of Journalism graduate said that journalists’ competition is not just other newspapers or stations, but any company that creates content.

“Nowadays people don’t just read newspapers or turn to Walter Cronkite,” said Springer. “It’s Facebook; it’s Buzzfeed; it’s Twitter. We’re living in the attention economy. You have to capture people’s attention.”

ABC News uses social media to build its brand, Springer said. The news organization has more than 7 million Facebook likes and Twitter followers each. Facebook pulls in 70% of social traffic for ABC News.

Springer cited two types of sharing: Branded sharing, or what ABC News pushes out; and organic sharing, the things that people share on their own.

“To get people to share we want to tap into emotions,” said Springer.

ABC News has a social team that runs media accounts and a social desk that activates during breaking news.

Springer suggested five stories that are “inherently social:”

  • Breaking news. Either live news or stories that drive the conversation. “The juror on the (George) Zimmerman trial on Good Morning America got huge hits.”
  • Stories that touch the heart.  The story of terminally ill baby serving as best man in his parents’ wedding was among the most “liked.”
  • Outrage stories: A Washington man accused of blowing up his dog not being charged with animal cruelty.
  • “Listicle,” lists created for social media or for content. “22 jobs where men always make more than women.”
  • In-depth stories. “Billionaire twins abused like slaves by dad.”

These types of social media posts are not far off what makes a good story or article.

Magazine-style, well-rounded stories and lists that organize big news stories have hundreds to thousands of shares, he said.

“It depends on what your market is, who your audience is and what people want to see . . .” Springer said. “Our audience’s way of consuming news is changing, and we need to keep up with that.”

You have to be preemptive when considering social media coverage, Springer said.

“What can we do from the get-go? When you’re going out to cover stories, think . . . How can I make them social? Not only social, but I can make them mobile?” he said.

About 71 percent of all activity on Facebook is on a mobile device, he said.

Springer suggested a few online tools for journalists:

  • Facebook graph search: To verify material, look for victims during breaking news, etc.
  • Specific searches in the Facebook search field: “People who graduated from Franklin Regional High School” or “Men who work at Good Morning America,” for example.
  • Google Reverse Image results. Use when you have a photo without an ID. Copy the image url, go to, paste in the url, search by image. The engine gives its best guess as to who the subject is.

Springer said his goal as social media editor is to put ABC News in people’s heads via Facebook.

“We have to, as companies, keep up with our audiences and where they are going,” he said. “There are angles that you can take and things that you can tap into that get the message across.”

Follow Andrew Springer on Twitter: @springer.



2014 KipCamp in photos

Using social media tools to break news — Sona Patel


Twitter is the tool of choice for reporters covering breaking news, but getting it right requires coordination between social media staff, reporters and even other news organizations, said Sona Patel, staff editor for social media at the New York Times who spoke Wednesday at the 2014 KipCamp.

“Planning ahead is the most important thing to do,” Patel said, citing examples from her time at the Seattle Times, including a Seattle police murder and a live-blog of city council.

Lakewood police killer

The Seattle Times won a Pulitzer in 2009 for its coverage of murders of four Lakewood, Wash., police officers. Patel’s team provided comprehensive coverage using social media tools as reporter tweeted updates throughout the day. (To see the Time’s coverage,  including tweets by reporters, click here.)

The Times and other area news organizations agreed on a single hashtag — #washooting — creating an authoritative and up-to-the-minute source for updates.

“Seattle media is very tight,” she said. “We were able to communicate with local TV  stations, etc. that this is the hashtag we want to use.”

Advance planning is key to handling social media during breaking news.

“We have communicated with (reporters) well before breaking news events about what the expectations are,” Patel said.

She suggested having a very detailed plan in place, creating potential roles for reporters, dedicating an editor to each reporter, developing a plan for how to handle tweets or do live blogs.

Aurora movie theater shooting

The Denver Post used ScribbleLive to provide breaking news coverage of the 2012 movie theater shooting in Aurora, Colo. To see coverage, click here. The tool, also used by the Boston Globe in their coverage of the Boston Marathon bombing, allows media organizations to curate unruly streams of tweets and other social posts.

“It’s really not about the quantity, but the quality,” Patel said.

“They are tweeting once every three or four minutes. All those updates are not going to be of interest to the reader.”

During breaking news situation, Patel scans social media, monitoring hashtags and key words.

“I’ll be in the newsroom, searching on FourSquare and Facebook and Twitter,” she said. “Having someone back at the command post is helpful. That’s very critical. When you’re out covering breaking news, you’re covering breaking news.”

Seattle May Day protests

The 2012 May Day protests were easier for Patel’s Seattle team to anticipate than the tragic shootings referenced in the presentation. In preparation, every reporter was armed with an iPad or smartphone for taking photos and instant sharing.

The reporters were able to send drafts to their editors using WordPress. This streamlined the process and allowed the Seattle Times to publish quickly.

Live blog from city council

Breaking news can be tackled in teams of two reporters, one to write the full story for print publication and another live-blogging and interacting with the audience online, Patel said.

The Seattle Times used this approach at a contentious city council meeting and the colorful quotes and photos from the on-scene reporters gave the coverage an edge over the televised version of the hearing.

“Readers commented in real time, asked questions during the meeting,” Patel said. To read a liveblog of a public hearing on a Seattle arena proposal, click here.

App toolbox

Patel shared a selection of apps to help reporters become fully-formed multimedia pros. Here’s the list:

  • Communication:
  •  5-0 Radio Police Scanner (iOS /Android). Listen to police scanner dispatches on the go.
  • Glympse (iOS /Android). A favorite of editors, occasionally maligned by reporters. This app allows users to temporarily share their location.
  • GroupMe (iOS/Android). A group text-messaging service. Useful for groups of reporters and photographers in the field.

Photo and video:

  • Camera+ (iOS). Photo-taking and editing all in one app.
  • YouTube (iOS / Android). The best video client for social sharing.
  • Instagram (iOS / Android). Large network, now embeddable on posts.

Finding Your Social Media Voice — Robin J. Phillips


People have an image of you, whether you like it or not, said Robin J. Phillips, digital director at The Reynolds Center for Business Journalism and co-founder of #wjchat, a weekly Twitter-based community of web journalists.

“ (Your brand) is not just about telling people what you’ve done and how great you are. It’s about anticipating what you can do for them and sharing that,” she said.

Phillips sees value in having a strong online presence and developing a positive reputation, both of which can be done using social media.

Two goals to remember when developing a brand online are to “differentiate yourself” and “know yourself,” Phillips said. Journalists should discover what is valuable to their career and to themselves personally, and use that knowledge to showcase themselves.

One way to determine your current online persona is to ask friends, mentors and strangers what they think and what they see, Phillips said. She demonstrated this by showing various KipCamp fellows their own Internet personas, displaying their Twitter and Facebook pages, websites and results of online searches. “I just Googled,” she said.

Philips’ tips for extending the Fellows’ brands include:

  • Secure your own domain name; this makes finding your work much easier. A website for checking available domain names is
  • Google searches for common names can result in many individuals, so determine how to make yours unique. Phillips goes by Robin J. Phillips to differentiate herself.
  • Try to maintain just one account for each social media platform: It’s easier for the public to locate a journalist’s work.
  • Balance your personal and professional lives, excluding private information. The private can include personal relationships and opinions on almost any matter, which should not be shared because this compromises objectivity.
  • Look at other journalists online. Many have already developed their brand. A few that Phillips considers to have a strong presence:
    Twitter: Mark S. Luckie, @marksluckie
    LinkedIn: Yumi Wilson
  • Do not rely on links, which are owned by other sites and could disappear. When sharing work online, use PDF files to ensure they are easily accessible.
  • Look for individuals who have portfolio websites and model something similar. Portfolio sites allow a journalist to bring together various media outlets into one portfolio.

Phillips reminded attendees to be themselves, to be interesting and to be focused. When developing your brand, she said, the first and last question you ask yourself should be the same.

“Who are you?”

Follow Robin J. Phillips on Twitter @RobinJP.


Shots, Scenes and Sequences — Randy Walk


Online tools and technology used to capture and construct video media are in constant flux. Yet there remain tried-and-true mechanics of basic video shooting.

Randy Walk, Ohio State Multimedia Producer, outlined these fundamentals of videography during Tuesday’s KipCamp video session. He was assisted by Joe Camoriano, broadcast director of the Ohio State Media and Public Relations. The presentation focused on training journalist videographers to shoot three elements of an effective video production: Shots, scenes and sequences.

“Whether you’re doing six-second Vine, a 15-second Instagram video, a 30-second b-roll package or a one-minute story for your news program, it’s all built on these fundamental building blocks,” Walk said.

 The Shot

“It’s one continuous take; you frame something, you hit record, you let the action happen in front of you, you hit the record button again to stop.”

Walk’s tips:

  • Avoid the “soccer-mom” technique of standing stationary while recording long, continuous takes. Move your feet and find the story. Your editor cannot work with one shot. The single-shot, spectator-like approach is common in citizen journalism and is only effective while shooting the most spontaneous and dramatic of stories. In this rare instance, a single shot can be a scene. “But most of the time, we’re going to have to bust up things into multiple shots,” Walk said.
  • Use the “rule of thirds” when framing a shot. This helps push the subject out of the frame’s center — to the left or right third of the frame — and creates a more pleasing composition. Get close and keep the subject’s eyes in the upper-third crosshairs of the viewfinder, allowing him “looking area” or “talking space” in the opposite side of the frame. Not doing this can create tension and discomfort. Walk uses the iPhone app ProCamera to aid him when composing shots.
  • Get detail. Although you should shoot some wide shots, get a majority of medium and tight shots for the editor. “For the most part, people are going to be seeing your videos on phones and on small screens. So, if you’re going to do that big, beautiful ‘Lawrence of Arabia’ shot, and it’s really wide, you’re going to lose detail,” Walk said.
  • Camoriano said videographers should also be mindful of audio. Getting a tight shot will enhance the natural sound recording, especially you are not using an external microphone. “Always try to throw in some natural sound on your close-ups,” he said. “You’re not only visually trying to put a story together — the audio is very important.” Walk added, “If it makes noise, shoot it.”

 The Scene

“It’s a series of takes that focus around a specific period of time that either covers a theme, an event or the development of a character.”

  • Breaking up a story into multiple shots tells a better story. “This is one of my favorite scenes, from one of my favorite movies, ‘North by Northwest.’ I was 8 years old when I saw this, and I remember being mesmerized by this. It’s just Cary Grant standing by the side of the road, waiting for a Mr. Kaplan to show up,” Walk said.
  • Chopping Carrots: Walk demonstrated the three-over-one rule, borrowed from Michael Rosenblum, while shooting a subject chopping carrots. Collect three variations of shots. “These shots go by really, really quick. On average, an editor is going to have each shot up for two seconds,” Walk said. “If you can shoot ten shots, two of them should be wide, three or four are medium, the rest should be tight.”
  • Give your editor some creativity and options by using the five-shot rule: tight shot of the hands, tight on the face, over-the-shoulder shot, a wide and one miscellaneous shot. Walk said he frequently watches this BBC tutorial as a reminder. “I watch this video over and over and over again. And this guy is in my head every time I shoot. Because sometimes I forget, then I say, ‘Oh yeah. Why am I not breaking this scene down?’”
  • When shooting, be in the moment and plan out what shots you’ll need for the scene. Don’t be afraid to move around and make sure you’ve fully covered the story. But stay mindful of the subject and material and avoid disrupting the action. Walk showed “Bob the Bugler,” a story shot and edited by Michelle Michael, as an example of this.

 The Sequence

“It’s a series of scenes that are also made up of shots,” Walk said.

  • Sequences are less common in traditional news pieces. Your average video piece for a news story will run roughly one minute. Sequences are more appropriate in a longer piece. Walk gave the example of the intro in a James Bond film that precedes the opening credits and theme song.


By reexamining how a series of scenes come together, and the scenes and shots themselves, we can consider new visual story-telling possibilities. Tools ideal for short stories, like Vine and Instagram, compose quick, concise visual stories. Camoriano said a complete story can be told in a 15-second video. CNN, the Washington Post and other news outlets seek out online videos by subject or hashtag.

“Nowadays, you don’t have to have the pristine editing and the glossy finish, because you’re gathering news, right? It’s all about the story. So, that’s what make these tools so convenient and so exciting, because anyone can tell a story. You guys are all journalists; you guys crack stories wide open. So, think of new ways to use Vine, new ways to use Instagram to bring the story to life,” Camoriano said.


Getting the Most of Smartphones – Carl Corry



In today’s pursuit of news gathering, less is more, said Carl Corry, online editor for local news at Newsday and a speaker at Tuesday’s KipCamp, a short-term fellowship designed to help journalists make better use of online tools.

“Everyone should have either an iPhone or an Android,” he said.

Corry stressed that being “multimedia lite” — using as little bulky technology as possible — is essential. Harnessing speed, audience interaction and robust storytelling are critical to build job skills expected in the field today.

Journalists should not hesitate to incorporate smartphones into their everyday work.

“The time is now,” Corry said.

 “Must-Haves” for Smartphones

 Corry encourages journalists to survey their surroundings for available resources. You can cut costs by using wireless providers with the best connectivity (Corry likes Verizon), syncing with free networks in coffee shops, and using airplane mode on your smartphone. It is vital, he said, to monitor battery life.

“Always keep your battery in mind. In the cold weather, the battery life drains even faster than normal,” said Corry.

To improve battery life, consider getting a portable battery “juice pack” such as Morphie Juice Pack ($100) or New Trent iGeek external portable battery ($60).

Additional must-haves:

  • smart gloves, which allow you to use a smartphone without taking off your gloves
  • windsock for your iPhone/Android
  • external microphone to plug into smartphone
  • external lens for smartphone camera
  • external light to improve smartphone video and photo quality

Tips for Success

 Corry urges journalists to post and share material immediately, rather than waiting until the end of the day to write a story.

“Invite others into what you’re doing,” he said. Reply to emails promptly, stay well-connected and initiate involvement from as many others as possible, he suggested.

When shooting, Corry said, remember to:

  • Horizontally compose your photos and video (all posted videos are horizontal).
  • Eliminate camera shake by anchoring yourself to anything possible. “Hold your breath if you need to.”
  • Use airplane mode when shooting, so you won’t be interrupted by a call.
  • Shoot for at least 10 seconds of video footage.
  • Use your car as a makeshift sound-editing booth.
  • Keep finished video clips to 30 seconds or less to keep audience attention.

The Importance of Smartphone Photos

Smartphone photos are becoming accepted forms of mainstream photojournalism. Corry cited a photo of Yankee Alex Rodriguez on the front page of The New York Times. It was taken with an iPhone.

“Take the advantages that a smartphone has and amplify them,” said Corry.

“I’m not going to be the guy to tell you that an iPhone replaces everything . . . but it is what you have available.”

Smartphones can be powerful, useful and effective. Sharing photos immediately from the scene brings a new level of speed to storytelling, he said. When reporting crime and terrorism, smartphones can be less threatening and “spy-like.”

Amazing Apps

 Many smartphone apps can be downloaded for free or just a little money, Corry said.


  • Photogene
  • Camera+
  • Snapseed (photo app from Google)
  • Virtual Photo Walks (from Google+) An unexplored journalism opportunity, Corry said. Sharing your view through platforms such as Google+ can allow others to experience a changed perspective on an issue or event.
  • Vine, 6-second, digestible clips that can be embedded on Twitter or within stories.
  • Instagram (photo and video)

 Audio/Audio Editing:

  • SoundCloud. Tracks where you are via GPS
  • VC Audio Pro
  • Voddio. Popular audio editing app software
  • Google Voice. Free phone number you can call through Google to record phone conversations. (Hit “4” before you dial a number). Note: A time limit restricts your recording time. Turns voicemails into texts.

Video Editing:

  • Video Camera Pro
  • iMovie
  • Vine has the advantage over Instagram video in that is embeddable natively into Twitter.



Tips To Best Use Social Media – Jeff Cutler


Social media trainer and journalist Jeff Cutler taught Kiplinger Fellows how to leverage the latest social tools to research stories and engage audiences at Monday’s session of 2014 KipCamp.

“Social tools are not here forever,” he said. “Don’t fall in love with the tools.”

Search engines

The most basic tools are search engines. Google is one of the best tools a journalist can use, Cutler said, in today’s technology-driven society. He suggested setting up Google Alerts to get notifications from news outlets and sources.

“Google is king/queen,” he said. “It’s free, accurate mostly, comprehensive . . . Alerts do the work for you. You must be smart about choosing phrasing but you get better at it over time.”

He doesn’t recommend Bing, which he said means “Bing Is Not Google.” It is more commercial in nature.

He also suggested using several search engine aggregators, including Addict-o-matic and DuckDuckGo. A synopsis of search engines is at

Keeping your ear to the ground

Find your audience and interact with them, Culter said.

“Conversations are happening all around,” he said. “Push for hyper-local” sources such as NPR member stations, Gatehouse and affiliate TV stations for newer topics, smaller focus and bigger stories.

“Don’t produce content just for the small percentage of consumers that actually appear and participate in your effort,” he said.

Verification is Key

People use the term “citizen journalist” too loosely, Cutler said. Verification is what sets true journalists apart.

“I can put a webcam around the neck of my cat and call it a citizen reporter but not a citizen journalist because I am not getting the perspective and the analysis of a journalist from the cat,” he said.

Don’t take tweets and Facebook posts at face value.

“People do this circular verification that makes it difficult for all of us to do our jobs because . . . one references the other,” he said. “Everyone loses.”

Find out who is behind the Twitter handles and Facebook accounts so you can know what to use and who to trust. Vet every story by finding other sources and whenever possible put social media sources on camera.

Twitter best practices

Twitter is good for getting crowd-sourced questions answered and finding involved sources who are passionate about their interests.

Before using them, Cutler suggests reading the bio and clicking on the links of sources, reading many of their tweets, seeing who their followers are and vetting those sources. Start a conversation with them, and ask colleagues and competitors if they are reliable.

Know the rules of your media outlet, Cutler said. Can you quote a tweet? Should you set up interviews by tweeting? He recommends, a list of all professional journalists on Twitter that also covers the news based on what members are tweeting and sharing.

Facebook best practices

Cutler likes Facebook because it is more efficient, effective, you can share all your photos and it’s not limited in the number of characters you can type. He dislikes its convoluted structure and the fact that administrators don’t listen to feedback.

Cutler suggests that reporters “friend” their sources so they can have full access to verify them. Read their updates. Research their information, affiliations, networks and photos.


Video is powerful, Cutler said: “The elephant in the room.”

“Most people are less intelligent and lazier than you would ever believe,” he said. “Video and photos make it easier . . . pull people in.”

Other helpful tools

Cutler also recommends:
• Mashable: “They cover the social landscape better than anyone else.”
• LinkedIn: “It’s more verified.” LinkedIn For Journalists also offers a year’s worth of free premium service that allows you to contact anyone on LinkedIn without friending them.
• KnowEm: Very helpful for establishing your own brand.
• WordPress, Blogger, PlaceBlogger, Tumblr: Blogging websites that can be searched for information, topics and sources.
• Quora: Great for finding experts.

Check out more by Jeff Cutler at and on Twitter @jeffcutler.

See Jeff Cutler’s PowerPoint: