top of page
Tutorial Kits
![[Tutorial Kit] Building a Community Health Indicator List for Air Quality in Airtable](https://static.wixstatic.com/media/3aa850_c039029f31ff43988e09abd3830fd87e~mv2.png/v1/fill/w_444,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/3aa850_c039029f31ff43988e09abd3830fd87e~mv2.webp)
![[Tutorial Kit] Building a Community Health Indicator List for Air Quality in Airtable](https://static.wixstatic.com/media/3aa850_c039029f31ff43988e09abd3830fd87e~mv2.png/v1/fill/w_551,h_310,fp_0.50_0.50,q_95,enc_avif,quality_auto/3aa850_c039029f31ff43988e09abd3830fd87e~mv2.webp)
[Tutorial Kit] Building a Community Health Indicator List for Air Quality in Airtable
Workshop Chapters Recorded live Feb 24 2026, timestamps below 02:45:14 What is PM 2.5? 04:42:11 What is Airtable? 05:30:13 Finding Data 06:26:08 Entering Data Overview 07:29:15 Opening Airtable 10:30:22 Airtable Views 🎯 Data Challenge Create a data story for air pollution in your region by comparing local concentrations of PM2.5 to the primary (health-based) standard for PM2.5 set by the Environmental Protection Agency's (EPA). Project Authors: Serena Ye, Shannon Alley, Kaiy
Shamini V De Silva
![[Tutorial Kit] Using RStudio to Analyze and Visualize Air Quality](https://static.wixstatic.com/media/3aa850_c0c05ce650db48f5a26865929166c978~mv2.png/v1/fill/w_444,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/3aa850_c0c05ce650db48f5a26865929166c978~mv2.webp)
![[Tutorial Kit] Using RStudio to Analyze and Visualize Air Quality](https://static.wixstatic.com/media/3aa850_c0c05ce650db48f5a26865929166c978~mv2.png/v1/fill/w_551,h_310,fp_0.50_0.50,q_95,enc_avif,quality_auto/3aa850_c0c05ce650db48f5a26865929166c978~mv2.webp)
[Tutorial Kit] Using RStudio to Analyze and Visualize Air Quality
Video Chapters Recorded live Feb 24 2026, timestamps below 00:00 Intro 01:06 Bar Chart Overview 02:47 PM 2.5 What is it? 03:55 Step-by-Step 04:00 Step 1. Data Files 06:19 Step 2. Posit Cloud 07:05 Step 3. Install Packages 09:39 Step 4. R code 16:38 Step 5. Bar Chart 🎯 Data Challenge Create a bar chart in RStudio on air pollution for your state and compare three counties with the highest air pollution levels to the primary (health-based) annual standard set by U.S. Environmen
Shamini V De Silva
![[Tutorial Kit] Infographics for Social Media: Air Quality](https://static.wixstatic.com/media/3aa850_71d5f1db4cf94ed9ad0b7ee2c1a20dcc~mv2.png/v1/fill/w_444,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/3aa850_71d5f1db4cf94ed9ad0b7ee2c1a20dcc~mv2.webp)
![[Tutorial Kit] Infographics for Social Media: Air Quality](https://static.wixstatic.com/media/3aa850_71d5f1db4cf94ed9ad0b7ee2c1a20dcc~mv2.png/v1/fill/w_551,h_310,fp_0.50_0.50,q_95,enc_avif,quality_auto/3aa850_71d5f1db4cf94ed9ad0b7ee2c1a20dcc~mv2.webp)
[Tutorial Kit] Infographics for Social Media: Air Quality
Create an infographic video in canva using data on air quality and specifically PM2.5 rates in your county.
Shamini V De Silva
![[Tutorial Kit] Using AI to Identify Trending Public Health Topics](https://static.wixstatic.com/media/3aa850_97c9ce4f26d44d20afb0eac4b9e878c5~mv2.png/v1/fill/w_444,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/3aa850_97c9ce4f26d44d20afb0eac4b9e878c5~mv2.webp)
![[Tutorial Kit] Using AI to Identify Trending Public Health Topics](https://static.wixstatic.com/media/3aa850_97c9ce4f26d44d20afb0eac4b9e878c5~mv2.png/v1/fill/w_551,h_310,fp_0.50_0.50,q_95,enc_avif,quality_auto/3aa850_97c9ce4f26d44d20afb0eac4b9e878c5~mv2.webp)
[Tutorial Kit] Using AI to Identify Trending Public Health Topics
🎬 Video Timestamps 0:00 - Intro 1:10 - 5-Part Prompt 1:50 - Prompt Chaining 2:04 - Proof Loop 🎯 Challenge Decide the 1 top trending public health topic in the U.S. using a combination of AI and traditional public health prioritization processes. 3 Learning Objectives By the end of the session, participants will be able to: Understand the basics of large language models (LLM) including the concepts of "prompt engineering", "prompt chaining" and "proof loops". Engineer Prompt
Shamini V De Silva
![[Tutorial Kit] Building a Community Health Indicator List for Prenatal Care in Airtable](https://static.wixstatic.com/media/3aa850_4e89945e586749f39e474b7e3992c1f6~mv2.png/v1/fill/w_444,h_250,fp_0.50_0.50,q_35,blur_30,enc_avif,quality_auto/3aa850_4e89945e586749f39e474b7e3992c1f6~mv2.webp)
![[Tutorial Kit] Building a Community Health Indicator List for Prenatal Care in Airtable](https://static.wixstatic.com/media/3aa850_4e89945e586749f39e474b7e3992c1f6~mv2.png/v1/fill/w_551,h_310,fp_0.50_0.50,q_95,enc_avif,quality_auto/3aa850_4e89945e586749f39e474b7e3992c1f6~mv2.webp)
[Tutorial Kit] Building a Community Health Indicator List for Prenatal Care in Airtable
Workshop Chapters Recorded live Jan 27 2026, timestamps are below. PART 1: 0:00 - Welcome 0:53 - About Us 3:06 - Addressing Imposter Syndrome 4:32 - Data Challenge Overview 4:55 - Q: What is a Key Stakeholder? 6:53 - TOPIC: Prenatal Care PART 2: 9:00 - STEP-BY-STEP 20:18 - GETTING DATA 🎯 Data Challenge Create an indicator list on prenatal care in your region. The Plan Collect key indicators for your community using free sources of prenatal care data in the United states and
Shamini V De Silva
All Updates
What is new at BroadStreet?
Search


Lung Cancer Mortality Data-Guided Donation
Photo credit: MART PRODUCTION Big Picture Goal: Reduce the mortality rate of Lung Cancer in the U.S. Project Objective: A Data-Guided Donation By the end of the 13-weeks, donate to one or more non-profit organizations running evidence-based programs to reduce lung cancer mortality rates, or an intermediate outcome, in key counties within the United States. Learning Objective: This project was completed as part of a 13-week training program where the learning objective was to
Shamini V De Silva
May 116 min read


Diabetes Mortality Data-Guided Donation
Background. A team of interns on The Community Data Internship at BroadStreet Institute completed an impact project examining diabetes mellitus (DM) mortality rates in the U.S. during the June 2025 cohort (June - August 2025). Big Picture Goal: Reduce the mortality rate of DM in the U.S. Our Objective: By the end of the internship cohort, donate to a non-profit organization that tackles DM mortality rates, or an intermediate outcome, through an evidence-based intervention in
Shamini V De Silva
Nov 3, 20253 min read


💰Data-Guided Donation for Infant Mortality
💰Data-Guided Donation for Infant Mortality Can one, small action be so strategic and well-planned that it could make a difference to...
Tracy Flood
Jul 21, 20253 min read


What’s an Impact Project?
BroadStreet creates "Impact Projects". What are they?
Tracy Flood
Jun 16, 20251 min read
Social Posts
Follow us on social media (links in footer) to see upcoming events and updates. We post new updates on social and then summarize and wrap up projects on our Blog.
Past Projects

51:27

51:36

44:42

22:08

23:48

24:51

01:33

00:57
bottom of page