Tag Archives: ebook

Spanish version of ‘Excel for Journalists’ on the way

 

A Spanish version of Finding Stories in Spreadsheets – titled ‘Excel para periodistas’ (Excel for Journalists) – should be available in the next few weeks.

The translation is being done by Barbara Maseda. If you want to know when it’s going to be available you can register to be informed on the book page.

Finding Stories in Spreadsheets – ebook now live!

Finding stories in spreadsheets book cover

Cover design by Matt Buck/Drawnalism

My latest ebook – Finding Stories in Spreadsheets – is now live on Leanpub.

As with Scraping for Journalists, I’m publishing the book week-by-week so the book can be updated based on reader feedback, user suggestions and topical developments.

Each week you can download a new chapter covering a different technique for finding stories, from calculating proportions and changes, to combining data, cleaning it up, testing it, and extracting specific details.

There’s also a downloadable spreadsheet at the end of each chapter with a series of exercises to practise that chapter’s technique and find particular stories.

Along the way I tackle some other considerations in telling the story, such as context and background, and the importance of being specific in the language that you use.

If there’s anything you’d like covered in the book let me know. You can also buy the book in a ‘bundle’ with its sister title Data Journalism Heist, which covers quick-turnaround techniques for finding stories in spreadsheets using pivot tables and advanced filters.

My next ebook: Finding Stories in Spreadsheets

Finding Stories In Spreadsheets ebook cover

In a few weeks I will begin publishing my new ebook: Finding Stories In Spreadsheets.

The book has been written in response to requests from journalists who need a book on Excel aimed at storytellers, not accountants.

Finding Stories In Spreadsheets will outline a range of techniques, including ways to find the ‘needle in the haystack’ in text data, number calculations to make stories clearer, and methods of cleaning and combining data to tell new stories, including getting data ready for maps and charts.

The book will be available for a discounted rate for the first couple of weeks. To be informed when it’s available, register your interest on the Leanpub page.

My next ebook: the Data Journalism Heist

Data Journalism Heist data journalism ebook

In the next couple of months I will begin publishing my next ebook: Data Journalism Heist.

Data Journalism Heist is designed to be a relatively short introduction to data journalism skills, demonstrating basic techniques for finding data, spotting possible stories and turning them around to a deadline.

Based on a workshop, the emphasis is on building confidence through speed and brevity, rather than headline-grabbing spectacular investigations or difficult datasets (I’m hoping to write a separate ebook on the latter at some point).

If you’re interested in finding out about the book, please sign up on the book’s Leanpub page.

Meanwhile, I’m looking for translators for Scraping for Journalists – get in touch if you’re interested.

 

My next ebook: the Data Journalism Heist

Data Journalism Heist data journalism ebook

In the next couple of months I will begin publishing my next ebook: Data Journalism Heist.

Data Journalism Heist is designed to be a relatively short introduction to data journalism skills, demonstrating basic techniques for finding data, spotting possible stories and turning them around to a deadline.

Based on a workshop, the emphasis is on building confidence through speed and brevity, rather than headline-grabbing spectacular investigations or difficult datasets (I’m hoping to write a separate ebook on the latter at some point).

If you’re interested in finding out about the book, please sign up on the book’s Leanpub page.

Meanwhile, I’m looking for translators for Scraping for Journalists – get in touch if you’re interested.

Free ebook: Citizen Video – training and engaging citizens in video journalism

Videographer Franzi Baehrle has published an ebook documenting lessons in delivering video training to non-journalists.

The ebook was part of her final project for the MA Online Journalism at Birmingham City University, and based on her experiences of working with communities online and offline in Birmingham, with the Guardian Media Group’s n0tice project, the Birmingham Mail’s digital team, and independently.

I forgot to blog about it at the time it was published last Autumn, but better late than never: it’s an excellent piece of work, and well worth reading.

Free ebook on teaching collaborative journalism and peer-to-peer learning

Stories and Streams free ebook on teaching collaborative journalism with peer to peer learning

I’ve just published a free ebook documenting a method of teaching collaborative journalism. Called ‘Stories and Streams’ the method, which was piloted last year, uses investigation teams and focuses on student-driven, peer-to-peer learning. Traditional lectures are not used.

You can download the free ebook from Leanpub.

You can read more about the background to the project here. A research report co-written with Jon Hickman and Jennifer Jones is published in a research report in ADM-HEA Networks Magazine. A fuller report will be included in a HEA publication on collaborative learning soon.

I’m also about to start a new class using the same method again, so if you have a class you’d like to get involved, let me know.