Once in a while software designers do something little that makes life
a lot easier. The folks at Microsoft have done that by adding
a shortcut command to remove hyperlinks from cells in Excel
2010. I’ve been testing the beta version to see what
it offers for journalists.
If you have ever cut and pasted some data that has hyperlinks from the Web into Excel you have no doubt found…
Continue Reading Click and the hyperlinks are gone
Reporters who use Microsoft Excel to crunch government data have something to cheer about with the release of the beta version of Office 2010. A new add-in to Excel brings Excel’s ease of use to the analysis of huge datasets.
Continue Reading New Excel feature takes data analysis to new levels
Check out this story from the Winnipeg Free Press on dirty restaurants.
It’s a great example of how far we have come in doing this kind of
earliest reporters doing the restaurant story, and I was one of
them, had to fight long battles with government officials just
to get the data. Jen Skerritt got it in a few weeks just by asking.
came to the CAJ conference in Vancouver in May and took the day of CAR
training I did with David McKie of CBC. She was so pumped when
she left that she headed right back to Winnipeg and asked the city and
province for restaurant inspection data…
Continue Reading Winnipeg Free Press probes dirty restaurants
Computer-Assisted Reporting was a big part of this year’s winning Michener Award entry. The CBC and the Canadian Press teamed up to analyze Taser use by police officers across Canada, building a unique database from use-of-force reports obtained from police forces across the country. Read the press release from Government House here.
The reporters analyzed the data and found that between 2002 and 2008, RCMP members fired their tasers more than 3,200 times and administered multiple shocks in more than 40 per cent of those cases. The CBC and Radio Canada also conducted tests that showed older models sometimes produce a stronger zap than the maker advertised.
Congratulations to the whole CBC/Radio Canada/Canadian Press team.
Reporters from across Canada are headed to Halifax for the second annual University of King’s College Summer School in Computer-Assisted Reporting.
The school is sponsored by the Canadian Newspaper Association and is the only “boot camp” style CAR training available in Canada. CAR skills give you a leg up in today’s brutal journalism job market by helping you get big stories everyone else will miss. To sign up for the CAR school contact Kelly Goldenberg at 902-422-1271. You can pay using VISA, Mastercard or Amex.
Continue Reading Still time to sign up for the King’s Summer School in Computer-Assisted Reporting
There are some excellent statistical resources available to those working on swine flu stories…
Continue Reading Some data resources for swine flu coverage
Journalists have been asking for electronic records from Canadian governments for at least 15 years. There have been a few encouraging developments, writes Fred Vallance-Jones, but a recent FOI audit showed we have a long way to go.
Continue Reading The struggle for electronic records
Web scraping is a way to download large amounts of information from government websites for later analysis in a database. It is making possible stories that would be impossible for the causal hunt and click web surfer.
Continue Reading Star series shines light on government travel spending