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: Publish your spreadsheet This step gives freeDive access to your data by publishing your spreadsheet to the Web. Share your spreadsheet This step gives freeDive access to your spreadsheet URL. Enter your spreadsheet ID freeDive accesses your spreadsheet using the unique ID in the spreadsheet URL.
Click to practice with a spreadsheet containing nearly 25,000 rows. Select the columns you want to include in your table At least one column must contain numeric data. You are working on spreadsheet: . Check the columns you want to use: Retrieving column data... Set the size of your table Setting the size of your table directly impacts how your reader interacts with your data. Pixels Set up the search widget Write a headline Yes. Coding for Journalists 101: Go from knowing nothing to scraping Web pages. In an hour. Hopefully. | Dan Nguyen pronounced fast is danwin.
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 His Girl Friday You’re a journalist who knows almost nothing about computers beyond using them to connect to the Internets, email, and cheat on Facebook scrabble. Anyone who has taken a semester of computer science will scoff at how I’ve simplified even the basic fundamentals of programming…and they’d be right…but my goal is just to get you into the basics to write some useful code immediately. Thankfully, coding is something that provides immediate success and failure. Tags. Die Datenjournalismus-Leseliste | Florian Gossy. 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? Calculate the total sum of a column is one of the most common operations you will use in data journalism. +Info 2) =(number1-number2) Very useful to calculate the increase or decrease of two values. 3) =(New number-old number)/old number It’s related with the previous formula and we use it if we need to find the percentage of change between two different figures. 4) =AVERAGE(fist cell in a range:last cell in a range) This formula is quite obvious. +Info 5) =MEDIAN(first cell in a range:last cell in a range) It looks for the mid-point and many times is more useful than the average.
+Info 6) SUMIF(range, criteria, [sum_range]) +Info 7) COUNTIF(range, criteria) +Info +Info. 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.
Tipsheet with links to projects we’ve done at the AP using these tools, documentation and helpful tools to use, and sample code for some more basic projects I demoed during the session Web Scraping without Programming (Panel) — Chris Keller and I talk about free tools you can use that will take care of scraping tasks for you, without you having to spend time/have the knowledge set to write code. Web Scraping without Programming (Hands-on class) — Chris Keller and I walk through an example using a tool called Outwit Hub, great for scraping tasks of easy to intermediate complexity (grabbing tables from multiple pages, for example.
Related posts you might enjoy: 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. Luckily, Politifact developer and University of Nebraska-Lincoln journalism professor Matt Waite gave the audience a little bit of reassuring advice gleaned from Zen Buddhism: It’s bad to be an expert.
That seems like the perfect mantra for attending this conference. In the spirit of that advice, here’s a collection of the top tools I picked up from the conference. Evernote // Project tracking QGIS // Mapping. Datawrapper ist ein Projekt der ABZV. Die Untoten von ZEIT ONLINE | Demografie-Blog.
ZEIT ONLINE wartet heute mit einer interaktiven Grafik zur Bevölkerungsstruktur bis ins Jahr 2060 auf, die einfach toll aussieht. Look & Feel sind super, man kann sein Geburtsdatum eingeben, mit einem handlichen Schieber das Jahr einstellen, und dann ablesen, wie hoch die eigene Lebenserwartung ist. Gleichzeitig bevölkern kleine bunte Männchen und Weibchen den Bildschirm, und zwar so aufgestellt wie die Bevölkerungsstruktur im gewählten Jahr. Mittendrin findet man sich selbst als Mitbürger in schickem Rot. Sehr schöne Idee und wirklich sehr hübsch. Nur leider stimmen die Daten dahinter nicht: Die lustigen Figuren ordnen sich nach einem anderen Datensatz an als in der Quelle angegeben, sie sterben einen ungewöhnlich frühen Tod und haben nicht die real an der Bevölkerung gemessenen Lebenserwartungen.
Liebe Kollegen bei ZEIT ONLINE, ich bin mir sicher: Ihr nehmt meine Kritik sportlich. Auch Datenjournalismus ist Journalismus! Was stimmt in diesem Fall hintendran nicht? 1. 2. 3. 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 Update: If you are still struggling to understand the concept Radical Punch have done a overview of this tool Here's how to archive event hashtags and create an interactive visualization of the conversation (written instructions below): Capturing the tweets. 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). Keep a list of tools to check out. Watch the demos and browse the documentation or code. More immediately, though, choose one or two tools and make them part of your DNA. 1. Almost every data journalist begins with the spreadsheet.
The spreadsheet is a nearly universal data format, particularly if you save your data as a plain-text delimited file, such as a comma-separated values file. Here’s a tutorial to get you started. 3. TableTools2 - Copy/Sort/Chart/Filter Table&More! Computational and Data Journalism. ZAPP - Recherche: Datenjournalismus | Datenjournalismus. Data journalism :: 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. It is perhaps an unusual and yet apt setting for journalists to meet. Members of the Open Knowledge Foundation and the European Journalism Centre saw this as a perfect opportunity to herd a number of prominent journalists and developers who, fuelled by an unlimited supply of mocacchinos, started work on the first Data Journalism Handbook. The occasion was the yearly Mozilla Festival, which acts as an incubator to many such gatherings.
In data journalism, most people are self-taught, and many find it hard to keep up-to-date with every tool produced by the industry. Timetric.
TileMill. Indiemapper. Quellen. Visualisierung.