Data Journalism Course Modules-BAKU
  • Training Module for Data Journalism Course
  • DATA JOURNALISM IN THE NEWSROOM
  • 1. Module introduction
  • 2.The History of Data Journalism
  • 3. Definition of Data Journalism
  • 4.Case studies from Turkey and from other countries
  • Practice
  • 5.Assembling a team for a data journalism project
  • 6.Skills necessary for working with data
  • TELLING STORIES WITH VISUALIZATION
  • 1.Module introduction
  • 2.History of Data Visualization
  • 3.Definition of Data Visualization
  • 4. Basic Principles of Data Visualization
  • 5.Creating good data visualization
  • 6.Matching Data and Graph Types: Interpreting Data Visualizations
  • DATA VISUALIZATION TOOLS
  • 1.Module introduction
  • 2.Using Excel to do data journalism
  • 3.Data journalism basics with Google spreadsheets
  • 4.Simple visualization tools: Infogram, Piktochart, Workbenchdata, Flourish and datawrapper
  • 5.Data visualization: advanced visualizations using Tableau.
  • Resource
Powered by GitBook
On this page

Was this helpful?

Last updated 5 years ago

Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. The service also includes Google Docs and Google Slides , a word processor and presentation program respectively. Google Sheets is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering answers based on natural language questions in a spreadsheet.

Google Sheets is a Google Docs product. Also called Google Spreadsheet or Google sheet Has the same features as MS Excel Works online - web-based, except under certain circumstances Works with all internet browsers You can analyze and visualize your data. Common Spreadsheet Statements Cell: A single data point or item in a spreadsheet. Column: Vertical cell set. Row: A horizontal array of cells. Range: Select a cell that extends to a row, column, or both. Function: An internal process in a spreadsheet application that can be used to calculate cell, row, column, or range values, edit data, and more. Formula: Combination of functions, cells, rows, columns, and ranges used to achieve a given result. Worksheet: Named sets of rows and columns that make up your spreadsheet; a spreadsheet can contain multiple sheets Spreadsheet: the entire document containing your worksheets

How to use it?

Share you file

Few Features to Make Your Job Easier 1.Find and Replace 2.Devrik Paste 3.Text to Column 4.Quick Graph Button 5. Basic Accounts Useful functions Sum, Average, Count, Max, Min

Add a quick chart or graph to a spreadsheet

Line-Column-Pie Charts

You must first have a gmail account You can then access the New Menu> Google spreadsheets at google drive (drive.google.com) You will then be presented with an empty excel file, you can start by changing the name of the file.

Previous2.Using Excel to do data journalismNext4.Simple visualization tools: Infogram, Piktochart, Workbenchdata, Flourish and datawrapper

3.Data journalism basics with Google spreadsheets