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.
If you assumed that the future of journalism would only be free (or at least advertiser-funded), says SA Mathieson, you’re wrong. In a guest post for OJB Mathieson – who recently successfully crowdfunded his own project to report on the Scottish referendum - explains why the web turns out to be capable of charging for access too.
The Columbia Review of Journalism recently reported that the Financial Times now has nearly twice as many digital subscribers as print ones, having added 99,000 online customers in 2013.
They pay significant amounts for access: the cheapest online subscription to the FT is £5.19 a week. A free registration process does allow access to 8 articles a month – but try to access a ninth and you have to pay.
The FT was earlier than most to charge online, but many publishers have followed suit. Only a few – such as The Times – lock up everything, but titles including the Telegraph, New York Times and Economist all use metering, allowing non-paying readers access to a limited number of articles before a subscription is required. They have been joined by increasing numbers of trade and local publications.
This isn’t just an option for established titles: as a freelance journalist I write for Beacon, a start-up used by more than 100 journalists in more than 30 countries to publish their reporting. It has “more than several thousand” subscribers after five months’ operation, co-founder Adrian Sanders told the New York Times recently.
The project has been called IRPILeaks and, like the Dutch PubLeaksand WikiLeaks, is a tool for those want to leak staying anonymous and safe.
IRPI aims to use this anonymity to encourage leaks from people who want to expose misconducts of companies and public authorities. A list of risks they could face in the process is published on IRPI‘s site. Continue reading →
‘I don’t do numbers’ and ‘I hate maths’ were depressingly common expressions, perhaps unsurprisingly. People wanting to study journalism enjoy the use of language and rarely expect that numbers will be vital to the stories they are telling.
So those responsible for journalism education have a tricky task. A bit like providing a sweet covering to a nasty-tasting tablet, it was said that lecturers need to be adept at finding ingenious ways to teach a practical and relevant use of numbers without ever mentioning the M (maths) or S (statistics) words. Continue reading →
I come upon examples of bad practice in publishing government data on a regular basis, but the Universal Jobmatch tool is an example so bad I just had to write about it. In fact, it’s worse than the old-fashioned data service that preceded it.
For at least four years now, all my online journalism assessments have involved a ‘strategy’ element, including a suggestion that students use analytics to demonstrate an understanding of their audience, and that they can experiment with search engine optimisation and social media optimisation.
This year I’m going further with one undergraduate class. I’m making social media analytics compulsory.
There are dozens of free tools out there to monitor your social media accounts. Here are just a few I’m recommending: Continue reading →
“Before providing two journalists from the Telegraph with accreditation to attend the event House PR has asked them to agree to a number of requests about the coverage they will give it.
“They have even gone as far as to draft Twitter messages which they would like the journalists to send out – and asked that they include a mention of the marketing campaign #PricelessSurprises and @MasterCardUK.”
Do such messages fall foul of the ASA’s guidelines on “marketing communications” on Twitter?
The ASA’s press officer Matt Wilson said that they don’t have a precedent, but told me:
“If entry to the Brit awards was conditional on the journalist tweeting on behalf of Mastercard, we’d likely view that as a ‘reciprocal arrangement’ (i.e. the journalist receiving a benefit they wouldn’t have otherwise). Continue reading →
Who is this man? It’s not Manuel Neuer. And yes, that caption is worth a separate post all of its own.
After just seven minutes of the match with Arsenal, Bayern Munich’s Manuel Neuer was already a hero: he had just saved a penalty from Mesut Ozil.
But Reddit user Vikistormborn was curious about what the commentator described as their “long” history, and started searching for details on Ozil’s childhood. And after finding this image on a Telegraph story, he or she decided to have a little fun…
“I simply circled the other biggest looking guy in the picture and tweeted that it was Neuer,” he writes. Continue reading →