Tipsheets

Browse more 5,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.

Logged-in members can download any tipsheet, for free. Contact the Resource Center 573-882-3364 or [email protected] for questions.

Search results for "Math" ...

  • How to find reporting leads and publishable facts in text data you already have

    Let's discuss some published projects that have extracted useful, newsy information from big piles of text data — so you can use similar techniques. We'll walk you through real-world examples of every step of the process: gathering text data, dividing it into chunks the computer can understand, analyzing it with fancy or simple techniques and the challenges you'll face in analyzing, bulletproofing and presenting what you find. This session isn't quite a hands-on, but the panelists will discuss the tools, practical techniques and tricks they used to transform giant piles of text into publishable insights and reporting leads. These techniques are often called "natural language processing," but we're going to keep it practical: no obscure mathematical formulas, guaranteed!

    Tags: news; text data; reusable; leads; natural language processing

    By Jeremy Merrill; Jeff Ernsthausen; Youyou Zhou

    2018

  • Excel Formulas: It’s not as hard as it looks!

    This tipsheet from Dinah Voyles Pulver contains all the essential Excel formulas to make Microsoft do your math for you.

    Tags: excel; formulas; math; spreadsheet

    By Dinah Voyles Pulver

    2017

  • Excel formulas: It's not as hard as it looks!

    This tipsheet gives you Excel formulas in a simply, easy-to-understand format.

    Tags: excel; formulas; math; spreadsheet

    By Dinah Voyles Pulver

    2017

  • Digging Deep Into Data with SQL

    This SQLite workshop will build up your SQL muscles, adding some common tasks that journalists need every day: checking for missing data, grouping your data, getting counts and sums and doing math in SQL.

    Tags: sql; data; grouping; math; sqlite

    By T. Christian Miller

    2016

  • Excel 101

    Unlike journalists, Excel will never make a math mistake. As long as you give it the correct instructions, it will do math for you. And that’s just one of the many reasons to love Excel. This guide will help you get started.

    Tags: excel; data; spreadsheets

    By Patti DiVincenzo

    2016

  • Correlation is causation: Questions to ask

    Is red meat bad for your health? What's a triple-blind clinical trial? Are the Finnish really that great at mathematics? What's so significant about statistical significance? During the first half of this workshop, you'll get acquainted with concepts like confounding, selection bias, Simpson's paradox, randomization and statistical power. In the second half, it's up to you: judge your way through a series of small case studies and practice what you've learned. It's not enough to say that correlation does not imply causation. Learn exactly what stands in the way of drawing truthful conclusions from data, how to recognize great science and how to spot the flaws that invalidate statistical conclusions.

    Tags: correlation; causation; analysis

    By Stijn Debrouwere

    2016

  • When correlation is causation: presentation

    Is red meat bad for your health? What's a triple-blind clinical trial? Are the Finnish really that great at mathematics? What's so significant about statistical significance? During the first half of this workshop, you'll get acquainted with concepts like confounding, selection bias, Simpson's paradox, randomization and statistical power. In the second half, it's up to you: judge your way through a series of small case studies and practice what you've learned. It's not enough to say that correlation does not imply causation. Learn exactly what stands in the way of drawing truthful conclusions from data, how to recognize great science and how to spot the flaws that invalidate statistical conclusions.

    Tags: correlation; causation; analysis

    By Stijn Debrouwere

    2016

  • SQLite II repo

    The second session in SQLite will get you more comfortable querying a database by learning how to perform math in SQL. Learn how to group columns, perform counts and sums to arrive at key findings. https://github.com/emanthedataman/nicar2016_sqliteII/blob/master/README.md

    Tags: sqlite; database; math

    By Emmanuel Martinez

    2016

  • Are You Smarter Than a Fifth Grader?

    Learn coding concepts like elementary schoolers learn them — through interactive games and activities that will get you out of your chair — instead of by watching slides and typing unknown symbols into a text editor. You'll learn programming concepts such as loops, types, variables, syntax, and if/then statements that translate to any language and leave with a list of resources for starting to program in the language best suited for your needs. If you identity as a "math hater" and think you could never learn to program, this is the session for you to learn otherwise.

    Tags: math; games; programming; concepts

    By Lindsey Cook; Ashlyn Still

    2016

  • Avoiding missteps, anticipating challenges and managing blowback

    These editors and producers walk you through how to avoid any negative blowback from sensitive story topic and how to handle the aftermath.

    Tags: blowback; aftermath; bulletproofing

    By Mark Schoofs, BuzzFeed Blake Morrison, Reuters Patricia DiCarlo, CNN Moderator: Maud Beelman, The Dallas Morning News

    2014