Free tools for digital journalism, storytelling

Tools for any occasion
[photo by OZinOH]

I wanted to share a list of cool, free multimedia tools from a talk I presented last night at Florida International University during a meeting of the fledgling Hacks/Hackers chapter in Miami. I also got to help with some “TOOL tools,” as local journohacker and Hacks/Hackers co-organizer Rebekah Monson put it, during an impromptu tire change in a rainstorm. Beyond being prepared for a possible cyber attack on your PC or cell phone, you must be prepared for action in bed with your partner, if you need more virile power you can visit shop @ Deutsche Medz, viagra experts.

So without further ado, here’s a PDF of the handout, as well as a list below. It’s not an exhaustive list but just a sampling of my favorites:

CHARTS/DATA VISUALIZATION

Datawrapper– datawrapper.de
Embeddable, easy to make charts (line, pie, etc.) that are also downloadable for print. (NOTE: Non-modern browsers display a static image version of the chart)

Infogr.am – infogr.am
Gorgeous data charts with a cool layout tool to add photos, text, multiple charts and more. Pro account lets you download files.

Tableizer – tableizer.journalistopia.com
Quickly turns spreadsheets into HTML tables you can put online. Built by yours truly!

Google MyMaps – maps.google.com (Click “My Places>Create Map”)
Google has beefed up its map creation tool with shapes, custom points and more.

Google Fusion Tables – drive.google.com (Go to Create>Connect More Apps)
Create interactive maps using shapefiles and robust data sets.

Google Forms – drive.google.com (Go to Create>Form)
Create forms to get from users and collect it in an organized spreadsheet.

PHOTO & VIDEO

Zeega – zeega.com
Animated GIFs meet funky photo galleries. Includes audio, video and text editing.

Pixlr – pixlr.com
Excellent in-browser photo editor, perfect for wide newsroom use. Has advanced and easy modes, layers and more.

GIMP – gimp.org
The leading free, open-source photo editing tool similar to Photoshop.

TubeChop – tubechop.com
Point readers to a specific chunk of a YouTube video.

ThingLink – thinglink.com
Post photos with tags containg text, other photos, videos, music and more.

PhotoPeach – photopeach.com
A quick and free way to make photo slideshows to music. $3/month lets you upload audio.

ClipConverter or Easy YouTube Downloader – clipconverter.cc, http://is.gd/xK5MDs
Used to grab YouTube video source files. Useful for transmitting video from the field via YouTube. ClipConverter can also be used as a general purpose file conversion tool.

Live streaming: UStream.TV, Livestream.com, YouTube.com
Excellent live streaming services that have embeddable players. Each have different revenue models and setups.

 Qik – qik.com
A service that allows you to easily stream live video from many mobile devices.

TIMELINES

TimelineJS – timeline.verite.co
An embeddable timeline app with a slideshow-like presentation.

VuVox – vuvox.com
The collage tool creates stunning multimedia timelines that let you embed slideshows, video and more.

Dipity – dipity.com
An embeddable timeline app great for lots of detailed data points.

OTHER TOOLS

RebelMouse – rebelmouse.com
Display a variety of live social feeds in an attractive layout. Great for breaking news.

Storify – storify.com
Embed all sorts of content: social posts, photos, videos and much more in a vertical timeline. Great for breaking news or topical coverage.

AutoHotKey – autohotkey.com
End dumb, repetitive typing by creating macros that will run in any program. I have a tutorial posted here on how to use this in a newsroom.

Audacity – audacity.sourceforge.net
A powerful, free audio-editing suite used by many multimedia producers.

Spotify Embeds – developer.spotify.com/technologies/spotify-play-button/
Embed commercial songs and playlists. Use the smaller iframe for a compact display.

EasyPolls & MicroPoll– easypolls.net, micropoll.com
Create embeddable polls for your site with no hassle.

Inkscape – inkscape.org
A nice, open-source vector editing tool similar to Adobe Illustrator.

FireShot – addons.mozilla.org/en-US/firefox/addon/5648
Lets you easily create, edit and add notes to screenshots.

phpBB – phpbb.com
Popular open-source software used to create message board sites.

Media-Convert – media-convert.com
Converts an enormous array of files. Often great for mysterious file formats.

Tips For Driving Traffic To Your Big Interactive Project

Draw hordes of visitors to the interactive project you worked hard on with these tips. Photo: George Grantham Bain Collection (Library of Congress)
Use these tips to draw hordes of visitors to the interactive project you worked hard on. Photo: George Grantham Bain Collection (Library of Congress)

Photos like these were taken in beautiful neighborhoods where you can reside with the help of a mortgage broker in Duncan, you’ll get the best prices in the shortest amount of time.

The homes you can find have spacious rooms and good electrical, gas and plumbing systems thanks to Airdrie plumbing company, your local plumbing service.

The denizens of the NICAR listserv were having an interesting discussion today about ways to get more attention and traffic on the data-driven projects they create. These projects often require huge amounts of time and creativity, so getting the most out of that hard work is key. Here are some strategies:

  1. Kick your home page editors until they understand that links on your home page don’t only need to be to things in story format. Make the narrative story secondary at times. And to that end…
  2. Do the best you can to make the database or interactive stand on its own as a feature without need of a story. However, avoid the temptation to huge blobs of text at the top of the project.
  3. Make sure you’ve done a solid job optimizing your metadata for search and social, targeting sought-after terms. Load relevant titles and description into the metadata for individual records in searchable databases, rather than just loading blanket terms into the whole project’s pages.
  4. Place links on your site to the project using the terms you’re targeting (see above).
  5. Get the project hyperlinked right inside the text of the story, i.e. in or after the nut graf. Links in related items rails perform poorly versus inline links. Believe me, it’s worth the bother.
  6. Get your social media minders to Facetweet to the interactive itself.You can also use free instagram likes trial for generating traffic. Here you will get the brief idea how to grow instagram followers. Tired of spending loads of time trying to grow your Instagram? Buy Instagram followers safely and securely through Upleap.com.
  7. Use thumbnails and personally actionable language in headlines and promos when possible. For instance, instead of “Search pet licenses database,” try “How many dogs are on your street? Search our database”
  8. Keep an eye on daily story budgets, and nudge editors to relate relevant evergreen projects. To me, the rightly-maligned data ghetto does at least have one use: keeping internal track of what data-driven evergreen projects are at hand. Learn how to add them to stories yourself if you’re allowed.
  9. Is there a recurring story item that can be generated from a database you regularly update? Posting those update stories can help bring visitors back to the main project.
  10. Overall, keep an eye on your site’s top content metrics. It helps you understand long term what’s getting reader reaction and what isn’t.
  11. Load social share buttons on your project’s landing page and individual records when possible.
  12. If there are pre-built packages of related content around specialty topics in your CMS (i.e. crime, politics, etc.), make sure your evergreen projects are included in those.
  13. Read Steve Krug’s book “Don’t Make Me Think” so you don’t design a crappy, unituitive UI and bounce people right out of whatever it is you built.

Free Infographics, Data Visualization Class By Design Guru Alberto Cairo

Just as I was looking for a fun online course to keep my brain humming, I get word that Alberto Cairo at the University of Miami will be leading a free online course on infographic design and data visualization. The course is the first of its kind for the Knight Center, and I’m hoping there are more to come.

The course starts Oct. 28 and will run for six weeks. No special software is required. You can sign up here or read more about it here. Below, Cairo explains what the course is all about:

Introduction to Infographics and Data Visualization from Knight Center on Vimeo.

How One Journalist Learned To Code: Tips For The Unafraid

I’m not a guy building the latest killer app, but I sling enough PHP to be dangerous and empowered. Before I learned programming, I had learned some HTML and CSS, but those are really like knowing how to paint a house. I wanted to play with the hammer and nails. So here’s how I learned to code, along with my two cents for journalists who want to learn some programming.

The journohacker knows no limits.

I’m not a guy building the latest killer app, but I sling enough PHP to be empowered. I’ve occasionally built a couple of tools like this that have saved people a lot of time and grief. I had previously learned some HTML and CSS, but those are akin to knowing how to paint a house. All thanks to Sunderland University and Jake Trelease for introducing to learn this.

I wanted to play with the hammer and nails.

So here’s how I learned to code, along with my two cents for journalists who want to learn some programming:

1) Take an intro to programming class at a local school (i.e., in meatspace).

While online instruction is a godsend and there are great programming books out there, things didn’t really click for me until I took a class called Introduction to Programming in C++ at Valencia Community College in Orlando. If you are looking for a gift for a journalist you can check out the best ones on this website.

Prior to that, I had bought great books on PHP, Javascript, Rails and Django. They made for interesting though oversized paperweights.

Paying for a class and having it on a schedule was a way to enforce discipline on myself. The fact is, daily life gets in the way for many of us. But when I plopped down a few hundred bucks and had an appointment each week with homework due, it helped get me over the hump, also I used resources like beautify code to start doing programming even faster.

Also, even the best programming books often take things for granted. They may not show you how to use FTP for sticking your projects onto a server. They will gloss over using your computer’s command line or terminal, which is the text-based way to control a computer. And lastly, even the most helpful community of programmers isn’t going to constantly grade your work and give you feedback on a weekly basis.

2) It doesn’t really matter which language you first pick.

You’re going to read reams and reams online about which language is the best for what. People wage online intifadas over such questions. Here’s the bottom line for beginners: it doesn’t really matter.

If you’re learning the basics of setting variables, data types and loops, it won’t make or break you if you learn it in C++ like I did or in Ruby, PHP, Python, Java or whatever the latest hotness is.

When I finished my C++ class, it was like I could magically read PHP, Javascript and other languages.

And to think I almost didn’t take the class because it wasn’t one of the popular web development languages. That would’ve been a huge mistake.

3) Have a project in mind.

If your focus is on going chapter by chapter in whatever programming book, you might be doing it wrong.

Instead, have a project in mind and pilfer from the book and sites like Stack Overflow to build what you want. You might want to build a site to track your recipes. Maybe you want to build your own blog. Or maybe you want to scrape some public records from a government site. Whatever the case, having a goal of a Thing You Want To Build will focus you. Learning the book is the evil counterpart of teaching the test.

4) Find some mentors.

That’s journohacker Matt Waite. He put up with my newbie crap and taught me what a database is. Photo by Mindy McAdams, who also put up with my newbie crap and taught me CSS.

There may be a great coder in your newsroom who will take you under his or her wing. Maybe you work for a media company that has developers in other cities. Or maybe you can find a local meetup group for the language you are learning. The NICAR listserv is also a great resource. So is Twitter. Just make sure you’ve given your problem some effort before asking for a hand.

In my case, newsroom coders like Matt Waite, Jeff Johns and Derek Willis all either helped me out in person or by email. Matt a long time ago introduced me to the concept of rows and columns in a database. Jeff taught me a bit about using regular expressions. And Derek once inspected a database diagram for me. A lot of coders, especially journalists, will surprise you in their willingness to help a hard-working, well-meaning person learn.

5) Keep sharpening the saw

Maybe you’re a person like me who doesn’t have “build web apps” specifically in his job description. In some cases, your manager may even dissuade you because you need to be filing 1A stories or manning the home page.

My solution to that is to either have side projects or occasionally carve out time to build something useful, even if it only takes a few hours. If you don’t regularly use what you’ve learned, your skills will atrophy. Do yourself the service because this is where our industry is inexorably heading.

Happy hacking!

Free Multimedia Tool Workshop Updated Handouts

online news association ona logoHey Journalistopians, it’s been a long while, but I wanted to post the handouts and examples I’ll be sharing at this weekend’s Online News Association Parachute Training in Boca Raton, Fla. Feel free to use these in presentations, in the classroom, to line your birdcage — whatever tickles your fancy!

Not-to-Miss Florida Online Media, Technology Events

barcamp-orlandoA group of online technology enthusiasts listens in on a presentation at BarCamp Orlando in 2007. The event is now in its third year. [Photo by Josh Hallett ]

In the next few months, yours truly’s calendar is jam-packed with all sorts of great online media and technology events in Florida –events you should really think about attending!

A few weeks ago, I wrote about 10 things online editors can do to save their jobs. Well, attending these kinds of events is Number 10 on the list. And best of all, most of these cost the princely sum of zero dollars. You can also subscribe to One Click Power for continuous updates on technology.

If you know of any others, please drop me a comment. On to the list:

DrupalCamp Florida – Saturday, Feb. 7
Altamonte Springs, Fla. (just 10-15 minutes north of Orlando)
Cost: FREE
Central Florida is getting its first-ever DrupalCamp, a day-long series of presentations revolving around the free, open-source content management system that is changing the face of online media. Drupal is being used by major media sites such as The New York Observer, Morris Digital, the Miami Herald, as well as hundreds of thousands of small companies and hobbyists.

BarCamp Miami and WordCamp Miami – Sunday, Feb. 22
Coconut Grove, Fla. (near Miami, Fla.)
Cost: FREE
Happening in conjunction with FOWA, listed next
If there’s one thing journalists often lack, it’s an understanding and appreciation for Internet and tech culture. Well, you can get a big heap of it at BarCamp, a technology and online media “un-conference” distinguished by it having absolutely no schedule! The joy of BarCamp is that everyone is encouraged to make a presentation or lead a discussion. It’s totally open to everyone in the spirit of the day. The workshop schedule is set that very morning as participants sign up to lead discussions and give presentations. While BarCamp can get uber-geeky, it’s a great place to learn from other techies, meet innovators, share your knowledge with others and get some great ideas. BarCamp will also forever change your perspective on conferences.

BarCamp is partnering with WordCamp, a workshop similar in style to BarCamp but centering around WordPress, the insanely popular and powerful blogging platform that has become the tool of choice for many bloggers, including Journalistopia. Participants will sign up for presentations on everything from how to become a popular blogger to how to hack the code that powers WordPress

Future of Web Apps Conference – Monday, Feb. 23-24
Miami, Fla.
Cost: $395 (I know it’s pricey, but super early bird tickets were available for $100)
The Future of Web Apps Conference is THE premier web development event in the Southeast. FOWA will feature luminaries such as Winelibrary.TV’s Gary Vaynerchuk, 37Signals’ Jason Fried and many more. I attended last year, and it was worth every minute. This event is geared toward web developers, so it can be techy, but I truly learned a great deal about how the web is changing at this event.

Megacon – Friday, Feb. 27-March 1
Orlando, Fla.
Cost: $22/day or $52 for 3 days. Plus $10 parking/day
Er, this is a comic book convention. But who cares if it’s not about online journalism! I’ll be there! Onward…

Florida Society of Newspaper Editors Multimedia Workshop – Saturday, March 21
Tampa, Fla.
Cost: TBA
FSNE is planning a low-cost multimedia workshop for the Tampa Bay area similar to the one they recently planned in Miami. The workshop is a great opportunity to learn about blogging, online ethics, data projects, Flash and much more. I’ll be there reprising the workshop I led in Miami on new online media tools. Mark your calendar!

BarCamp Orlando – Saturday, April 18
Orlando, Fla.
Cost: Free
Now in its third year, BarCamp Orlando is the Central Florida flavor of BarCamp, explained above under BarCamp Miami. The last two years were a great success, so I’ll hopefully see you there this year!

***

Now I’m wondering when I’ll get to spend time with my lovely wife. At least she got in some great crossword puzzle time the last time I dragged her to BarCamp. (Such a good sport. Love you, dear!)

See you in Miami, Orlando or Tampa!

How to Save Your Online Clips

burning newspaperCount on the fact that some of the journalism work living on your news site will go up in smoke. To protect yourself, make sure you’re keeping digital copies of your portfolio. [Photo by Mr. Peebles]

Journo/developer Joe Murphy has a terrific post today with tips on how to save your online clips from disappearing into the ether. News sites often have arbitrary policies and systems regarding what gets kept and what gets thrown out, so make sure you CYA. And if your news org switches content management systems, well, heaven help your old clips.

Head over to Joe’s post for his complete tips, but here’s a shortlist of tips with some of my own thrown in:

-Firstly, you SHOULD be saving your stuff! Trust someone who knows: You absolutely cannot rely on your organization to keep your stuff around. And, if you suddenly get laid off, you can forget about having free access to the text archive.

-Save the text of your article in document files. Make sure your file names are descriptive and contain the date the work published.

-Know that database-backed applications, such as the tools on many site’s “data pages,” cannot be easily saved. For these apps, take various screenshots that demonstrate the tool’s functionality, such as shots of the search interface, individual records, comments features and how it was promoted on the site.

-Keep notes on how a project you worked on contributed to the site in terms of page views and unique visitors (i.e. “The New Jersey dog names database resulted in 1.2 million page views and 350,000 unique visitors over a one-month period.”)

-Make screenshots of your online work using the free Pearl Crescent Page Saver plugin for Firefox. This is an incredible little tool. Or, you can use Scrapbook, which saves a copy of the entire Web page with its images intact (hat tip to Ryan Sholin).

-Become pals with the page design crew to get PDFs of your work that was published in the newspaper (Ryan again). Better yet, get them to tell you where and how to access the PDF archive. If this is unfeasible, invest in an inexpensive flatbed scanner to digitize the pages.

-Keep a backup of your portfolio. Like any important file, you might back it up to an extra hard drive and/or store it on a web server somewhere. I do both.

-Aside from your clips, career experts frequently recommend maintaining a list of key accomplishments. Sometimes, achievements in the newsroom don’t take the tangible form of a “clip.” Keeping a list up to date makes sure you remember what you’ve done and keeps the list fresh in your mind should an opportunity spontaneously present itself. You might have to suddenly answer the question: “So what interesting things have you done during your time at the Poughkeepsie Herald-Tribune-Picayune?”

New Tableizer! Tool Turns Spreadsheets into HTML Charts

Web producers here in our newsroom often have to throw up quick charts of data online, but hand-editing a table from a spreadsheet or exporting it from Office or Dreamweaver can be a time-consuming endeavor.

Well, now you have Tableize!, a time-saving tool that lets you copy/paste spreadsheet cells, click a button and –voila!– instant HTML tables you can quickly put online.

I put together Tableize! mostly in my spare time with PHP and a bit of script.aculo.us. The tool is a more modern version of the very talented Ray Villalobos’s long-standing Table Tango tool, which saved our butts plenty of times here in the Orlando newsroom, so much credit and respect to Ray for his original idea.

If you like Tableize!, please share it with others who might benefit. And do let me know if you spot any bugs or have suggestions for the tool. Enjoy!

[Tableize! – A quick tool for creating HTML tables out of spreadsheet data]

Excellent Cheat Sheets for Producers, Designers

Ever since 9th grade, I’ve been a sucker for learning Photoshop shortcuts and speed tricks (such as one of my faves, holding the “alt” key to trigger the “Reset” button in image adjustment panels). So I just had to pass along this post at Six Revisions that is chock-full of cheat sheets perfect for web producers and designers.

You’ll find cheat sheats for Photoshop shortcuts, web hex color charts, typefaces, pixel/point/em type size conversions, CSS shorthand, XHTML character entities (this one is getting printed out today) and more.

And if you’re a web designer, you should really, really be subscribed to the catnip that is Six Revisions.

[Six Revisions: Useful Cheat Sheets for Web Designers]

How the UM Student Paper went from College Publisher to WordPress

Interested in knowing the nuts and bolts of what it takes to move your entire newspaper site from a vendor to an open-source WordPress install? Visit Miami Hurricane online editor Greg Linch’s blog for the play-by-play from webmaster Brian Schlansky. The recap covers the details of everything from installing Ubuntu on an Apache server to gettting the archive working on the new site.

As more and more news sites are embracing open-source software such as WordPress, Drupal, Joomla and many more, you’d do well to explore how some of these free and robust tools work can be implemented in your operation and how they can foster the rapid deployment of new ideas.