Knight Digital Media Center Freedive: Searchable databases from Google spreadsheets. Welcome to the freeDive wizard — your guide to making a searchable database If you're new to freeDive, check out our how-to video.
Start with a clean Google Spreadsheet. If you don’t know what this means, read our data cleaning tutorial. Make sure your spreadsheet has the following: Coding for Journalists 101: Go from knowing nothing to scraping Web pages. In an hour. Hopefully. UPDATE (12/1/2011): Ever since writing this guide, I’ve wanted to put together a site that is focused both on teaching the basics of programming and showing examples of practical code.
I finally got around to making it: The Bastards Book of Ruby. I’ve since learned that trying to teach the fundamentals of programming in one blog post is completely dumb. Also, I hope I’m a better coder now than I was a year and a half ago when I first wrote this guide. Check it out and let me know what you think: Who this post is for. Die Datenjournalismus-Leseliste. 8 useful Excel formulas for Computer Assisted Reporting « Online journalist project. Any journalist who wants to work with data must learn how to use spreadsheet applications like Excel or Google Docs.
Here it’s a list of 8 useful formulas for Computer Assisted Reporting: 1) =SUM(number 1, number2, numb…) The most simple Excel formula, but it is essential. How many stories are related with public spending or funding? Teaching Materials from NICAR 2012 « Michelle Minkoff. I had the sincere honor of presenting at NICAR 2012 in St.
Louis for the second year in a row. I provide the takeaway materials here, if you find them useful. Bring Your Mapping Dreams to Fruition — code for demos of Leaflet and Raphael, for making zoomable and non-zoomable maps. CAR Training 2012. Reporters' Lab // How a conference taught me I know nothing. The Chicago Tribune's Brian Boyer removes his costume panda head before demonstrating PANDA, an open-source database system developed by Investigative Reporters and Editors. | Photo by Tyler Dukes It was the lightning talks that set my head spinning.
I’m a bit new to the world of data journalism, and up until that point, my first time at the annual Computer-Assisted Reporting conference had stopped just short of overwhelming. But after a few mile-a-minute presentations in this particular session , I only had one clear thought: There’s so much to know, and not enough time to learn it. Datawrapper ist ein Projekt der ABZV. Die Untoten von ZEIT ONLINE. Twitter: How to archive event hashtags and create an interactive visualization of the conversation.
The use of Twitter to collecting tweets around an event hashtag allowing participants to share and contribute continues to grow and has even become part of mass media events, various TV shows now having and publicising their own tag.
This resource is often lost in time, only tiny snippets being captured in blog posts or summaries using tools like Storify, which often loose the richness of individual conversations between participants. It doesn’t have to be this way. Using a combination of Google Spreadsheets as a data source and a simple web interface to add interactivity it’s possible to let users explorer your entire event hashtag and replay any of conversations. View example conversation replay Try out a LIVE version. 10 tools that can help data journalists do better work, be more efficient. It’s hard to be equally good at all of the tasks that fall under data journalism.
To make matters worse (or better, really), data journalists are discovering and applying new methods and tools all the time. As a beginning data journalist, you’ll want to develop a sense of the tools others are using to do the work you admire. You won’t be able to learn them all at once, and you shouldn’t try. You should, however, develop a sort of ambient awareness of the tools in use (something like the knowledge Facebook gives you about the lives of your high-school classmates). TableTools2 - Copy/Sort/Chart/Filter Table&More! Computational and Data Journalism. ZAPP - Recherche: Datenjournalismus. Datenjournalismus. Hacks and hackers gather to write the first Data Journalism Handbook. The following post is from Federica Cocco, a freelance journalist and the former editor of Owni.eu, a data-driven investigative journalism site based in Paris.
She has also worked with Wired, Channel 4 and the Guardian. It is cross posted on DataDrivenJournalism.net and on the Data Journalism Blog. Ravensbourne College is an ultramodern cubist design school which abuts the O2 arena on the Greenwich peninsula. Timetric.