Community Data Dashboard
What do the patterns in our community’s data tell us, and can we predict what comes next?
The mystery: Do students who sleep more get better grades? What can a scatter plot show, and what can’t it?
Questions we will figure out together in this unit:
describe how a real quantity changes over time, using the words increasing and decreasing, and plan what our dashboard must show its audience.
Phase 1: Spark
Do Now. A family drives past the same gas station every Monday. They notice the price is a little lower each week. Sketch a quick graph with week across the bottom and price up the side.
What shape should the graph of a price that drops a little each week have?
The reading opens over the lesson; close it to come back to exactly where you were.
Our audience. School board members and borough council members read a lot of numbers. A good dashboard shows a trend in a picture, explains it in one clear sentence and tells how sure we are. Today we look at a trend that families in East Allegheny feel every week: the price of gas.
Time as the input. When data is collected over time, time is usually the input and the measurement is the output. Each week has one average price, so price is a function of time.
Increasing and decreasing. A function is increasing when the output goes up as the input goes up. It is decreasing when the output goes down as the input goes up. It is constant when the output stays the same.
Worked example 1: describing a trend. Priya studies the Central Atlantic prices. Step 1: input = week, output = price. Step 2: $4.232, then $4.146, then $4.064. Step 3: changes: 4.146 − 4.232 = −0.086 and 4.064 − 4.146 = −0.082. Step 4: both changes are negative, so the price is decreasing. It fell by about 8 cents each week.
Worked example 2: another function in the same story. Marcus asks what a fill-up costs at $4.06 a gallon (the November 16 regional price rounded to the cent). Step 1: input = gallons, output = cost. Step 2: 10 gallons cost 10 × 4.06 = $40.60. Step 3: 15 gallons cost 15 × 4.06 = $60.90. Step 4: more gallons always cost more, so cost is an increasing function of gallons. Each extra gallon adds $4.06, which is the rate of change.
What a dashboard needs. A title, a labeled graph, the source and date of the data, a sentence that describes the trend, and an honest note about predictions. Gas prices can change direction at any time, so a trend is not a promise.
Use the EIA prices from the reading. Show each subtraction.
Plan the dashboard with your team.
The Gulf Coast price went from $3.636 to $3.481 to $3.293. What was the total change over the two weeks?
List three local trends our dashboard could model (for example, a price, water use or bus riders). For each, name the input and the output.
What would a borough council member want to know before trusting our dashboard? Write two things.
We know our audience and our first trend. Next we investigate what makes a rule a function, starting with a storm.
Exit ticket: is “week → average price” a function? Explain in one or two sentences.
Pacing: Do Now 5 min, reading 8, mini lesson 12, guided practice 10, planning and exit ticket 5.
Accuracy: prices are from the EIA release of 2026-11-17 (weeks of 11/02, 11/09 and 11/16/2026). The page updates every Monday or Tuesday; if you use newer numbers, recompute the answers and state the date. The Central Atlantic region (PADD 1B) includes Pennsylvania. Checked: 4.146 − 4.232 = −0.086; 4.064 − 4.146 = −0.082; 3.805 − 3.995 = −0.190; 3.995 − 4.153 = −0.158; 12 × 4.06 = 48.72; 15 × 4.06 = 60.90; 3.293 − 3.636 = −0.343.
Likely misconceptions: calling a falling graph “negative numbers” (the prices are positive; the change is negative); thinking a trend will always continue.
Supports: a word bank (increasing, decreasing, constant, rate). Stretch: find the week-ago change for two more regions on the live page.
Answer guide: sample sentence: “The average Central Atlantic gas price fell about 8 cents a week, from $4.232 on November 2 to $4.064 on November 16, 2026.” Week → price is a function because each week has one average price.
U.S. Energy Information Administration, Gasoline and Diesel Fuel Update · U.S. government work, public domain
The U.S. Energy Information Administration (EIA) is a government office that collects facts about energy. Every week it posts the average price of a gallon of regular gasoline for the whole country and for regions. The prices are in dollars per gallon and include taxes.
The release on November 17, 2026 showed three weeks of prices. For the whole United States, the average was $4.153 on November 2, $3.995 on November 9 and $3.805 on November 16. That is a drop of $0.190 in the last week.
The page also lists regions. The Central Atlantic region, which includes Pennsylvania, averaged $4.232, then $4.146, then $4.064. The Gulf Coast went from $3.636 to $3.481 to $3.293. Every region on the page dropped in those weeks.
The page also shows how prices compare with a week ago, a year ago and two years ago. EIA posts a new release each week. The next one was due November 24, 2026.
Source: U.S. Energy Information Administration, Gasoline and Diesel Fuel Update (eia.gov)