[ddj] data-driven-journalism Digest, Vol 26, Issue 16

Wed May 15 10:06:50 UTC 2013

Hey Mirko,

Thank you for the feedback regarding the spreadsheet tutorials. I will
inform Liliana so that she can take note of your ideas :-)

Cheers,
Hanna

===

Hanna McLean | Community Manager | European Journalism Centre
Sonnevillelunet 10, 6221KT Maastricht, The Netherlands
Tel. : +31.433.254.030 | Fax : +32.240.042.20
Email : mclean at ejc.net

Visit: ejc.net | ejcseminars.eu | eufeeds.eu
Join: ejc.net/facebook | ejc.net/twitter | community.ejc.net

CONFIDENTIALITY: This email (including any attachments) may contain
confidential, proprietary and privileged information, and unauthorised
disclosure or use is prohibited. If you received this email in error,
please notify the sender and delete this email from your system.

On 14 May 2013 12:39, <data-driven-journalism-request at lists.okfn.org> wrote:

> Send data-driven-journalism mailing list submissions to
>         data-driven-journalism at lists.okfn.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.okfn.org/mailman/listinfo/data-driven-journalism
> or, via email, send a message with subject or body 'help' to
>         data-driven-journalism-request at lists.okfn.org
>
> You can reach the person managing the list at
>         data-driven-journalism-owner at lists.okfn.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of data-driven-journalism digest..."
>
>
> Today's Topics:
>
>    1. Re: What Excel tutorials would you like to see on ddjnet?
>       (mirko.lorenz at gmail.com)
>    2. Re: DATA JOURNALISM & OPEN DATA DAYS in Spain
>       (Lic. Jesus Gumaro Viacobo)
>    3. Master's Thesis Survey for German Speakers. (Marvin Milatz)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 13 May 2013 15:53:52 +0200
> From: "mirko.lorenz at gmail.com" <mirko.lorenz at gmail.com>
> Subject: Re: [ddj] What Excel tutorials would you like to see on
>         ddjnet?
> To: "List about Data Driven Journalism and Open Data in Journalism."
>         <data-driven-journalism at lists.okfn.org>
> Message-ID:
>         <
> CAG9_W4CNafTQxawUYeaTMPn_G4N3a8edAHgimAT9MiHFMkYZ0Q at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
> based on my experience in a fair number of trainings with journalists the
> whole concept of data-driven journalism is still falling from the sky for
> most of them. What I often detect is a certain pattern, a distribution of
> know-how and motivation: A few participants are very open (they do their
> first JSON insertion on the first day), those are often pre-trained. A
> small number might be quite hostile and not interested (which always makes
> me wonder why and how they got into the training). They question the whole
> concept of data, of data quality and that the role of the journalist should
> change. The largest group is between shock and revellation - so most
> trainings are as much an excercise keeping people from crying (not a joke)
> and pushing things forward.
>
> The recent tutorials done by Tony Hirst and Abott for the School of Data
> are going into the right direction - the "one liners" where just great.
>
> The three aspects I would suggest to strengthen for upcoming tutorials:
>
> - General overview (Why spreadsheets? Which Software? That should encompass
> Excel, Open Refine, Data Wrangler and the two new kids on the blog
> QueryTree (which is actually quite different to Yahoo! Pipes and useful, if
> you know what you want) and finally I think that StatWing is very
> interesting.
>
> - Starting point: A complicated issue in all #ddj tutorials is that the
> users are a very diverse crowd. Some tutorials that are a no-brainer to
> more computer-literate people are putting journalists off. Often it is the
> use of too many uncommon words, the assumption that everybody is fluent
> with the command line.
>
> - Output goal: The closer the actual example is to some real newsroom
> problem the better and easier it is for the journalists to see the new
> options. I am using the Titanic passenger data a lot to let them explore.
>
> For the Data Journalism Handbook we had those great diagrams showing the
> ideal workflow of a data project. My best guess and suggestion here is to
> (a) yes, provide more tutorials for Excel, but combined with (b) a visual
> overview adressing the diversity of possible paths and prior knowledge.
>
> Hope this is agreeable, if not - voice in.
>
> Mirko
>
> 2013/5/13 Hanna McLean <mclean at ejc.net>
>
> > Hi everyone,
> >
> > Excel trainer Abbott Katz behind spreadsheetjournalism.com is writing
> > Excel tutorials for us and would like to hear what people need to learn.
> > Here are the tutorials he wrote so far:
> >
> > 1. Adding Value(s) to Your Spreadsheet: Turning Text Data into Numbers? -
> > http://goo.gl/y3vqt<
> http://www.linkedin.com/redirect?url=http%3A%2F%2Fgoo%2Egl%2Fy3vqt&urlhash=tWNc&_t=tracking_anet
> >
> >
> > 2. Setting the Record(s) Straight: Dealing with Bad Data -
> > http://goo.gl/L3ICj<
> http://www.linkedin.com/redirect?url=http%3A%2F%2Fgoo%2Egl%2FL3ICj&urlhash=jtFD&_t=tracking_anet
> >
> >
> > Let us know what tutorials you would like to see, so that we can let him
> > know :-)
> >
> > Thanks!
> >
> > Cheers,
> > Hanna
> > ===
> >
> > Hanna McLean | Community Manager | European Journalism Centre
> > Sonnevillelunet 10, 6221KT Maastricht, The Netherlands
> > Tel. : +31.433.254.030 | Fax : +32.240.042.20
> > Email : mclean at ejc.net
> >
> > Visit: ejc.net | ejcseminars.eu | eufeeds.eu
> > Join: ejc.net/facebook | ejc.net/twitter | community.ejc.net
> >
> > CONFIDENTIALITY: This email (including any attachments) may contain
> > confidential, proprietary and privileged information, and unauthorised
> > disclosure or use is prohibited. If you received this email in error,
> > please notify the sender and delete this email from your system.
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> http://lists.okfn.org/mailman/options/data-driven-journalism
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20130513/b02392ab/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 2
> Date: Mon, 13 May 2013 09:30:27 -0500
> From: "Lic. Jesus Gumaro Viacobo" <jgumaro at unam.mx>
> Subject: Re: [ddj] DATA JOURNALISM & OPEN DATA DAYS in Spain
> To: 'nuria gutierrez' <nuria_gut at yahoo.es>, 'List about Data Driven
>         Journalism      and Open Data in Journalism.'
>         <data-driven-journalism at lists.okfn.org>
> Message-ID:
>
> <!&!AAAAAAAAAAAYAAAAAAAAALvZm5ZiVSBOrFetg5R1ZR3CgAAAEAAAACCG0jxN4r5Mgi5ObhxhM/MBAAAAAA==@
> unam.mx>
>
> Content-Type: text/plain; charset="utf-8"
>
> Desde M?xico
>
>
>
> les deseo que TODO salga bien, estas iniciativas
>
> son fundamentales para mejorar la democracia.
>
>
>
> Cordialmente,
>
>
>
>
>
> Gumaro
>
>
>
> De: data-driven-journalism-bounces at lists.okfn.org [mailto:
> data-driven-journalism-bounces at lists.okfn.org] En nombre de nuria
> gutierrez
> Enviado el: domingo, 12 de mayo de 2013 13:10
> Para: data-driven-journalism at lists.okfn.org
> Asunto: [ddj] DATA JOURNALISM & OPEN DATA DAYS in Spain
>
>
>
> Hi DDJ community,
>
>
>
>
>
> I?m writing to you to let you know that Spain is about to welcome the
> biggest event to date on data journalism in the country. The DATA
> JOURNALISM & OPEN DATA DAYS (organised by the Spanish chapter of the Open
> Knowledge Foundation) will take place on May 24-26th in Barcelona and
> Madrid. Find out more here, just in case you want to join us:  <
> http://periodismodatos.okfn.es/> http://periodismodatos.okfn.es.
>
> We will also host the first ever DDJ HACKATHON in the country ( <
> http://periodismodatos.okfn.es/hackathon/>
> http://periodismodatos.okfn.es/hackathon). It will happen simultaneously
> in three cities Barcelona, Madrid and Sevilla, with prizes to the best
> projects.
>
>
>
>
> The main event will happen in Barcelona, where there will be experts from
> all arround the world like James Ball, Michael Bauer or Manuel Aristar?n,
> as well as members of the Carto DB team and of Civio Foundation, a
> non-profit organization devoted to promote engaged citizenry through public
> transparency. There will be conferences and many workshops, including one
> on how to run a crowdfunding campaign for data journalism projects.
>
>
>
>
>
> Some of the events will be streamed, so we'll keep you posted on the link.
> But we'd love to see you in Barcelona! Come and join us!
>
>
>
>
>
> Cheers,
>
>
>
> Nuria Guti?rrez
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20130513/0730b28b/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 3
> Date: Tue, 14 May 2013 12:39:40 +0200
> From: Marvin Milatz <marvmilatz at wtnet.de>
> Subject: [ddj] Master's Thesis Survey for German Speakers.
> To: "List about Data Driven Journalism and Open Data in Journalism."
>         <data-driven-journalism at lists.okfn.org>
> Message-ID: <6BB112EA-72A0-43D4-9C21-996D6FE73AF3 at wtnet.de>
> Content-Type: text/plain; charset="windows-1252"; Format="flowed";
>         DelSp="yes"
>
> Hi data enthusiasts!
>
> For my MA thesis at the University of Amsterdam, the Netherlands, I'm
> conducting a survey addressed to German speakers on infographic design
> within data journalism. I'm still looking for participants, so if you
> are German speaking or know somebody please consider to take the
> survey or share.
>
> Here's the link: https://qtrial.qualtrics.com/SE/?SID=SV_dnirWAeqJK4p4JD
>
>
> Participation rates on the web are very low, thus, I do most certainly
> appreciate your kind act of goodwill!
>
> If you have any questions, comments ? or you want to learn about the
> results of my thesis ? feel free to contact me directly!
>
> Many thanks,
>
> Marvin
>
> - - -
> Marvin Milatz
> Free-lance Journalist & UVA Masters Student
> Mobile: +31(0)616651592
> e-mail: marvin.milatz at gmail.com
> @marvinmilatz
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20130514/feff729a/attachment.htm
> >
>
> ------------------------------
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: http://lists.okfn.org/mailman/optionss/data-driven-journalism
>
>
> End of data-driven-journalism Digest, Vol 26, Issue 16
> ******************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20130515/411f33f1/attachment.html>