Tipsheets
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.
Loggedin members can download any tipsheet, for free. Contact the Resource Center 5738823364 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 realworld 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 handson, 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! 
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. 
Excel formulas: It's not as hard as it looks!
This tipsheet gives you Excel formulas in a simply, easytounderstand format. 
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. 
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. 
Correlation is causation: Questions to ask
Is red meat bad for your health? What's a tripleblind 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. 
When correlation is causation: presentation
Is red meat bad for your health? What's a tripleblind 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. 
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 
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. 
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.