The Data Journalist
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
The Data Journalist: Getting the Story

The Data Journalist: Getting the Story


     0     
5
4
3
2
1



International Edition


X
About the Book

The definitive guide to using data and technology in reporting, this text teaches students how to combine data analysis with traditional reporting to create compelling stories. Through coverage of theory, practical examples, online tutorials, and celebrated stories from around the world, this text demonstrates the tools and principles of data-driven journalism.

Table of Contents:
Note: Chapters include: - Bulleted "What you will learn" list - Introduction - General text boxes - Tutorial boxes (linking to online content) - Study questions and exercises PART I: INTRODUCTION 1. Introduction The Origins of Data Journalism Technology: The Tools of Data and How Journalists Use Them 2. Online and Open Data What You Will Learn Principles The History of Open Government and Open Data What Kind of Data Can You Get? - Chicago's Crime Database - Toronto Payment Card Data - Road Accidents in the United Kingdom - Vancouver Food Vendors - Mine Accidents Data Quality Concerns Steps to Take When Working with Any Dataset Study Questions and Exercises 3. When Data Is Not Conveniently Available What You Will Learn Informing Yourself Asking Negotiating for Data Demanding Making an Effective Request for Data After You Make the Request The Answer 4. Spreadsheets: The Basic Tool What You Will Learn So What Exactly Is a Spreadsheet? Fundamentals of Spreadsheets How Journalists Use Spreadsheets Getting Data into a Spreadsheet Getting to Work Sorting and Simple Analysis Filtering Doing the Math - Functions Big and Small - Calculating Percentages - Calculating Rates Dealing with Errors Working with Dates Concatenation Summarizing Information with Pivot Tables Logical Functions and IF Statements Using Paste Special to Convert Formulas to Values Chronologies Conclusion 5. Working with Databases What You Will Learn Working with a Database Building Relationships Database Programs Making Tables and Adding Data The Main Course: Querying your Data - The Language of Queries - Writing Math Queries - The GROUP BY Clause - The HAVING Clause - Aliases - Joining Tables - Some Notes about Joining More Advanced Queries - Outer Joins - Union Queries - Subqueries - Using Calculated Fields and String Functions - Creating Views (MySQL) - Improving Query Performances by Adding Indexes - Queries to Alter your Data - Exporting Query Results Building your own Database Some Final Thoughts 6. Introduction to Maps in Journalism What You Will Learn Maps Are Not Reality, but Representations of Reality Web Mapping Services Getting your Data onto a Web Map Data Not Already in a Map Format Your Data Is Ready; How To Use It? What Kinds of Maps Can You Make? - Boundary Maps Some Important Design Principles - A Choice of Styles - Choosing Appropriate Colours - Setting Breakpoints Conclusion 7. Working with GIS Programs What You Will Learn The Inside Story Ellipsoids and Datums: Modelling the World Projections How Datums and Projections are Incorporated in a GIS Basics of a GIS How Spatial Data Is Structured - Metadata - Geometrics - Attributes - Working with Layers How Journalists Use GIS Programs - Joining Non-Geographic Data with Geographic Data - Selecting Features that Meet Certain Criteria - Buffering - Joining Data Based on Geographical Location - Making a Chloropleth Map - Geocoding Common Problems and Solutions - Projecting and Re-Projecting a Map Layer - Converting File Formats - Simplifying Polygons - Combining Layers into a Single Layer - Combining Features within a Single Layer Special Considerations Relative to Coordinate Systems - Using a Map Layer that has Only a Geographic Coordinate System - Using Maps Based on Different Geographic Coordinate Systems - Using an Inappropriate Projected Coordinate System Conclusion Recommended Further Reading 8. Visualizing Data What You Will Learn A History of Visualization: From William Playfair to the Present Day Choosing the Right Chart - The Pie Chart - A Bar Chart - The Line Chart How Journalists Use "Data Viz" Tools - One Producer's View Conclusion PART II: ADVANCED TOPICS 9. Web Scraping What You Will Learn The Underpinnings of Scraping Options for Scraping First Steps, Thinking through your Scrape Coding Basics Getting Ready to Code - Fetching the Page - Scraping More than One Page - More Complicated Scrapes The Ethics of Web Scraping APIs Conclusion Additional Resources 10. Web Development What You Will Learn State of Developers in Newsrooms Core Languages Used by Newsroom Developers: An Introduction to the Work Environment - The Server-Side: Writing for your Own Machine - The Client-Side: Writing for Everyone Else's Machine Case Study: Using freeDive Working with JavaScript Libraries such as jQuery and D3 Conclusion Additional Reading 11. Incorporating Data Journalism into Traditional Reporting What You Will Learn Why Data is Just the Beginning Finding Outliers that Lead to Human Stories Testing your Data in the Real World Connecting Data Patterns with Real-Life Patterns Building Powerful Interviews and Writing the Story Conclusion Glossary Notes Credits Index

About the Author :
Fred Vallance-Jones is an award-winning journalist and an associate professor at the University of King's College. He teaches journalism research and data and investigative journalism at the masters and undergraduate levels, and continues to lead students in large data-driven investigative projects. He leads an annual data journalism summer school at King's that attracts working journalists from across Canada, and has been teaching data journalism at journalism conferences for many years. As well as co-authoring Computer Assisted Reporting: A Comprehensive Primer he is co-author of Oxford's Digging Deeper: A Canadian Reporter's Research Guide. David McKie is an award-winning journalist, journalism professor, and author. He has been on staff with the CBC for 20 years, and teaches two courses in research methods and data journalism at Carleton University. He designed and teaches similar courses at Algonquin College and the University of King's College. Throughout his 20-year teaching career, David has been one of the country's leading advocates of the need to teach data journalism skills to students. He is co-author of Computer Assisted Reporting: A Comprehensive Primer and Digging Deeper: A Canadian Reporter's Research Guide.

Review :
"This textbook will raise the educational bar for data journalism. . . . This is an important and essential addition to the rapidly expanding academic field of data journalism. I would highly recommend that this be a core text for all journalism programs." --Jeffrey A. Dvorkin, University of Toronto "The authors are magnificent." --Ellen Russell, Wilfrid Laurier University "The step-by-step instruction and sample datasets will be a great starting point for students to delve into data journalism. . . . More journalists need to be data savvy, and this textbook offers examples and steps to get there." --Cheryl Vallender, Sheridan College


Best Sellers


Product Details
  • ISBN-13: 9780199020065
  • Publisher: Oxford University Press, Canada
  • Publisher Imprint: Oxford University Press, Canada
  • Height: 229 mm
  • No of Pages: 320
  • Spine Width: 15 mm
  • Weight: 378 gr
  • ISBN-10: 019902006X
  • Publisher Date: 27 Oct 2016
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Sub Title: Getting the Story
  • Width: 154 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
The Data Journalist: Getting the Story
Oxford University Press, Canada -
The Data Journalist: Getting the Story
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

The Data Journalist: Getting the Story

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!