Difference between revisions of "Journalism Tools"

From TeleCafeWiki
Jump to navigation Jump to search
(→‎See Also: List of sources.)
(→‎Journalism Tools: Data Journalism Tools)
Line 17: Line 17:
 
: Convert Sound Files Online
 
: Convert Sound Files Online
 
: [[User:Dave|Editor]]'s Note: Tuesday, December 29, 2015: Was able to successfully convert WMA file to MP3 using this online service.
 
: [[User:Dave|Editor]]'s Note: Tuesday, December 29, 2015: Was able to successfully convert WMA file to MP3 using this online service.
 +
 +
=== Data Journalism Tools ===
 +
==== Excel ====
 +
* [http://www.poynter.org/2011/how-journalists-can-use-excel-to-organize-data-for-stories/154584/ How journalists can use Excel to organize data for stories]
 +
: Increasingly, reporters are turning to Microsoft Excel -- or similar spreadsheet programs like Apple's Numbers -- to advance their reporting. They're using spreadsheets to keep track of city budgets, baseball statistics, campaign finance and hospital data.
 +
 +
* [http://schoolofdata.org/2014/05/05/using-excel-to-do-data-journalism/ Using Excel to do data journalism]
 +
: Microsoft Excel is a powerful tool that will handle most tasks that are useful for a journalist who needs to analyze data to discover interesting patterns.
 +
 +
* [http://schoolofdata.org/2013/04/24/using-excel-to-do-precision-journalism-an-update-from-the-school-of-data-journalism-in-perugia/ Using Excel to do precision journalism, an Update from the School of Data Journalism in Perugia.]
 +
: Based on Steve Doig's workshop “Excel for Journalists”.
 +
 +
===== Spreadsheets (General) =====
 +
* [https://spreadsheetjournalism.com/ SPREADSHEETJOURNALISM]
 +
: Monthly blog on using spreadsheets in journalism.
 +
 +
* [http://multimedia.journalism.berkeley.edu/tutorials/spreadsheets/ Tutorial: Spreadsheets] ([https://multimedia.journalism.berkeley.edu/ UC Berkeley Advanced Media Institute])
 +
: This tutorial describes how to create and do calculations on a Google Docs spreadsheet, with some notations about differences in Microsoft Excel.
  
 
=== Dictation & Transcription ===
 
=== Dictation & Transcription ===

Revision as of 14:54, 5 March 2016

Investigative Reporting; Journalism; General Research

Useful IRE Resources:
- NICAR Net Tour - The National Institute for Computer-Assisted Reporting (NICAR) is an IRE program.
- Analysis jobs by NICAR - Names the media organizations NICAR has worked for, and lists kinds of analysis jobs NICAR has done.

Journalism Tools

The (Journalist's Toolbox) offers sources for useful information on a wide range of topics of interest, especially to investigative reporters. Topics include protecting sources, privacy, data visualization, digital verification, transcription tools, rights-free photos, mobile journalism, public records, copy-editing, and more.[1]

Audio / Video File Conversion

Convert restricted sound file formats to something more useful, open and free.
Does your idiotic voice recorder save its sound files in Microsoft's patent-restricted (and therefore, worse than useless) WMA file format? Maybe the article linked-to above will help.
Convert Sound Files Online
Editor's Note: Tuesday, December 29, 2015: Was able to successfully convert WMA file to MP3 using this online service.

Data Journalism Tools

Excel

Increasingly, reporters are turning to Microsoft Excel -- or similar spreadsheet programs like Apple's Numbers -- to advance their reporting. They're using spreadsheets to keep track of city budgets, baseball statistics, campaign finance and hospital data.
Microsoft Excel is a powerful tool that will handle most tasks that are useful for a journalist who needs to analyze data to discover interesting patterns.
Based on Steve Doig's workshop “Excel for Journalists”.
Spreadsheets (General)
Monthly blog on using spreadsheets in journalism.
This tutorial describes how to create and do calculations on a Google Docs spreadsheet, with some notations about differences in Microsoft Excel.

Dictation & Transcription

Chrome App For Online Dictation
Editor's Note: Monday, December 28, 2015: I tested this app out on my home workstation with my USB headset with microphone. Works well.
Upload Sound File, Play It Back At Any Of Multiple Speeds, Transcribe It
A free web app to take the pain out of transcribing recorded interviews.
FREE. Accurate. Fun. No installation, no registration. Simply click the mic and start dictating text. Features auto save, auto punctuation, instant translation & more.
Speech to Text Online Notepad. Free. The Professional Speech Recognition Text Editor. Distraction-free, Fast, Easy to Use & Free Web App for Dictation & Typing
Editor's Note: 17:45, 17 January 2016 (PST) I think I like Speechnotes even better than Speechpad.
Speechpad is a voice recognition application for converting speech to text (a good external microphone is strongly recommended). It can also convert an audio file to text. The current version of Speechpad works only for the Chrome browser.
Editor's Note: 15:05, 15 January 2016 (PST) Initial test indicates this works pretty well.
Chrome App For Uploading Sound Files & Transcribing Them To Text
Editor's Note: Monday, December 28, 2015: I found this while searching for sound file to text transcription services. When I was about to use it, I discovered it's not free (but still worth looking into).
Another Transcribe-By-Machine Option. Transcribe-By-Human Options, Too
VoiceBase Turns Your Voice Recordings and Transcriptions into a Searchable Database[2]
Transcription Hacks & Tutorials
Transcribe Audio Using YouTube (Hack)

See Also

Data Journalism
The Data Journalism Handbook can be freely copied, redistributed and reused under the terms of the Creative Commons Attribution-ShareAlike license.
Data driven journalism was created by the European Journalism Centre (EJC) with partial funding from the Dutch Ministry of Education, Culture and Science.

References

  1. ↑ "Journalist's Toolbox" Catalogues Vast Gumshoe Resources
  2. ↑ VoiceBase Turns Your Voice Recordings and Transcriptions into a Searchable Database
edit · view  

Additional Resource Wiki Pages

Home • Dave
Retrieved from "https://www.telecafe.org/smw/index.php?title=Journalism_Tools&oldid=806"