Data Driven Journalism (ddj) صحافة البيانات

• General: Selected resources for the data journalism training course, notes and licensing

  • A collection of resources in a number of categories can be found in the data journalism useful links file
  • If you come across a useful resource that is not listed here, please feel free to share it.
  • For links in MS Word or Excel on this page, click the link first then select the View Raw link to open it. For PDF files (if they do not open), try the download button (above the display area).
  • All material is provided under the Creative Commons Non Commercial License: [CC BY-NC 4.0] (https://creativecommons.org/licenses/by-nc/4.0/)

• Preparation

• Training description: data journalism and training outline

• Pre-calss [interview and quiz] (misc/pre-class-quiz.docx)

• Session 1

• Trainer's notes: Overview of data journalism

• The infographic on harassment in Egypt: data is available in this Report in English. Notice how they collected data!

• Session 2

• Trainer's notes: [Data Sources] (notes/DataSources.pdf)

• West Bank hotels data: there seems to be an error in the occupancy ratio. See this Excel file which has two sheets (data re-ordered and chart added in sheet2). Original data from [PCBS] (http://www.pcbs.gov.ps/Portals/_Rainbow/Documents/T.S-%20Tourism-%20An-A-2015.htm) (direct link). Try also to correlate the chart on sheet2 with data and chart from WorldBank

• Anonymous quiz: review of session 1 and brain storming for session 2

• The Palestinian right to information draft law

• Session 3

• You are expected to start thinking about your final project (preferably in groups of 3 with possible exceptions). Prepare some ideas/topics and have an abstract ready by next session

• We have made available air quality data from sensors in the Ramallah area. You can use it both for training and as part of your project.

• Trainer's notes: Data Search and Acquisition

• Session 4

• The excel files for crimes: [crimes in Palestine.xlsx](misc/crimes in Palestine.xlsx), crimes2.xlsx. Here's a modified file with governorate populations which shows an interesting fact. You can also view a visualization on the map done using Google Fusion Tables. Another tool is Power BI - see Power BI visualization. Note: in the original file, ratios are, most likely, based on 2010 or 2011 population in West Bank (which is a problem). Here's a link to PCBS population.

• Trainer's notes: data to stories

• Session 5

• Is this true? Duck's Quacks Don't Echo and a horse dies if you cut its tail

• Trainer's notes: verification

• Session 6

• Group Projects: please be sure to send your project abstract to the training coordinator before session 6 (group leaders should identify their group members and their role in the project along with the abstract)

• A case in data verification and role of visualization: Temperatures in Palestine on Feb. 2, 2017. Try to compare this data to this data

• Trainter's notes: understanding data. See also this resource about standard deviation and the 68–95–99.7 rule

• Data stories and verification: data quiz

• Session 7: visualizing data

• Remember to send the title and description of your project (for each group) ASAP

• Trainer's notes: data visualization

• Session 8 (last)

• Trainer's notes: Ethics and editing skills

• Projects: please submit your writeup by March 1st (modified: March 7). Presentations on March 5th (modified: March 12).

• Extra: this basic stats sheet is a one-page handout for BZU data journalism elective

Last updated: August 11, 2017