Datenjournalismus
Get flash to fully experience Pearltrees
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. | 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
Eines gleich vorweg: Ich kann das Wort Datenjournalismus nicht leiden und bevorzuge den im Englischen gebräuchlichen Terminus Data Driven Journalism (DDJ). Auch wenn diese Korrektur auf den ersten Blick vielleicht nach besserwisserischer Pitzeligkeit eines notorischen Hippocrit aussieht, so steckt im Kompositum Daten-Journalismus doch schon ein fatales Grundmissverständnis der Materie, das sich leider auch durch so manche Debatte zum Thema zieht. Daten sind nämlich per se noch nicht Journalismus. Und werden es auch nie sein. (Freunde der gepflegten Wortkunst können beruhigt sein: Der Newsreader der Zukunft wird nicht Excel heißen!) Journalismus setzt immer auch eine spezifische Erzählform voraus!
Ganz im Ernst: Data Driven Journalism is all about #Storytelling! | medienleiter
Die Datenjournalismus-Leseliste | Florian Gossy
Was muss man lesen, wenn man sich in den Themenkreis Datenjournalismus einlesen will? Hier findet ihr eine Liste mit intelligentem Lesestoff (bzw. das, was ich dafür halte), die natürlich nicht vollständig ist – wenn ihr einen guten Text habt, der unbedingt auf diese Liste rauf soll, bitte ich um eine kurze Anmerkung unten in den Kommentaren oder auf Twitter . Wer sich schon ein bisschen mit dem Thema auskennt, wird nicht viel Neues finden – Newcomern sollte sie aber einen guten Einstieg ermöglichen. Viel Spaß damit! [Mehrfach upgedatet, zuletzt am 1. April 2012.]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.
One of the most popular posts on Ricochet was the collection of dataviz tools, slides and links from last year’s NICAR conference . It was so popular, in fact, that people have asked me to make a similar collection again. So from Feb. 23–26, I’ll be updating this post with all the great things NICARians have to share this year. Follow #NICAR12 on Twitter for the buzz; come to this page for the goods. And if you’re attending the conference, be sure to buy a T-shirt to support IRE, the organization that puts this fantastic event together. Ben Welsh of The Los Angeles Times is taking candid photos and posting them on Flickr.
Tools, Slides and Links from NICAR12 // Ricochet by Chrys Wu
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.
Reporters' Lab // How a conference taught me I know nothing
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.
Die Untoten von ZEIT ONLINE | Demografie-Blog
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
Twitter: How to archive event hashtags and create an interactive visualization of the conversation
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).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.Beispiele
Quellen
Visualisierung