Linkedin  Youtube  Instagram  X  Facebook

New England First Amendment Coalition

Subscribe | Archives

November 2026

 

If you enjoy reading this newsletter, please forward it to a colleague or friend. If someone forwarded you this newsletter, please subscribe!

 
 

Storytelling With Data

This month is our second of three sets of lessons on data reporting. You will learn to:


  • Check the quality of your data and prepare raw datasets for analysis.
  • Extract key summary statistics from your data.
  • Learn the fundamentals of Excel.

Review Previous Lessons

LESSON 1

Develop a 'Document State of Mind'


LESSON 2

Finding High Quality Data for Stories


LESSON 3

Web Scraping 101


LESSON 4

Web Scraping 102

 
 

LESSON 5

Data Cleaning 101

In the first of two lessons on cleaning data, Maggie Mulvihill at Boston University shares how to work with datasets obtained online or through public records requests. Begin building your data cleaning skills with free, open-source tools.

 
 

LESSON 6

Data Cleaning 102

In this second of two lessons on cleaning data, Maggie Mulvihill at Boston University teaches how to advance your data cleaning skills with OpenRefine. Learn how to work with “dirty data” and improve your faceting and clustering skills.

 
 

LESSON 7

Excel 101

In this first of two lessons on Microsoft Excel, Jenifer McKim at GBH News covers how to create pivot tables from large datasets and generate meaningful findings for your stories.

 
 

LESSON 8

Excel 102

In this second of two lessons on Microsoft Excel, you will continue practicing the fundamentals of spreadsheet functions. Jenifer McKim at GBH News walks through the process of sorting and filtering data to begin your analysis.

 
 

Explore Our Collection of Online Resources

 
 

Thank You to Our Supporters

NEFAC appreciates the support of all its donors and contributors. In particular, we would like to recognize the Estate of Gloria L. Negri, the John S. and James L. Knight Foundation, and the following Leadership Circle donors ($10,000+) and Major Supporters ($2,500-$9,999): 



 

LEADERSHIP CIRCLE

Rhode Island Foundation

The Harbus Foundation

The Boston Globe

Boston University

Paul and Ann Sagan

The Robertson Foundation

Champa Charitable Foundation

Philip and Judith Meyer

 

MAJOR SUPPORTERS

Hearst Connecticut Media Group

Academy of New England Journalists

Truro News

Gravel & Shea PC

Patrisha McLean