GIJC15

Castellanos and Rodriguez will describe the data methodology behind Rutas del Conflicto, a project created in 2014 that collected information from more than 700 massacres committed in Colombia. The ethodology that sought to incorporate citizen journalism based on an exercise of data journalism. Through a combination of tools including an app for mobile devices, partnerships with radio and television stations in remote areas, and printing their publications on the Internet, Rutas del Conflicto, working with a group of students from the University of El Rosario (Bogota) and the Universidad Pontificia Bolivariana (Santander), created a methodology that has enabled dozens of victims tell their stories and participate in confronting the data related to the massacres.From basic knowledge in database design, they developed a methodology that explains how their colleges classified information and built related tables that allowed them to tell a story using mapping tools and timelines as Google Fusion tables. During the last year, students of the Rosario University have created several journalistic pieces using this methodology in various topics like sports, science, arts and culture, as well as conflict-related jobs.