
build a data-log model of our impact monitor that shows its inputs, calculations and outputs and how each part connects to the problem.
Phase 4: Build
Do Now. A fitness app shows your steps each day and a weekly total. What goes IN to the app, what does it CALCULATE, and what comes OUT for you to see?
In a fitness app, which is an OUTPUT?
A model of the monitor. Before we run the monitor for real, we build a model of it: a data log on paper or in a spreadsheet. A model lets us test ideas cheaply, see how parts affect each other, and find problems early.
Three parts of the data-log model.
Worked example 1: water use from meter readings. Sample data. Monday reading: 412,300 liters. Next Monday: 430,300 liters. Weekly use = 430,300 − 412,300 = 18,000 liters. With 600 students, use per student = 18,000 ÷ 600 = 30 liters a week.
Worked example 2: percent change. Sample data. Baseline food waste: 20.0 kg a week. After a share-table action: 17.0 kg. Percent change = (20.0 − 17.0) ÷ 20.0 × 100 = 3.0 ÷ 20.0 × 100 = 15%. That is at least 10%, so the flag turns green.
| Week | Meter reading (L) | Water used (L) | Trash (kg) | Food waste (kg) | Students | Minutes | Flag |
|---|---|---|---|---|---|---|---|
| 0 | — | — | |||||
| 1 | |||||||
| 2 |
Connect each part to the problem. The inputs measure two impacts weekly (criterion 1). The percent-change calculation tests the 10% cut (criterion 2). The minutes column checks the time limit (criterion 3).
Build the model step by step. All numbers are sample data.
Draw your team’s model.
Draw your data-log model as a flow diagram: inputs → calculations → outputs. Label each part and write which criterion it helps test.
Explain how one part of your model affects another. For example, what happens to the output if someone forgets to record the number of students?
Your monitor now exists as a model. Next class, you will feed it test data and try to break it.
Exit ticket: write the percent-change formula in your own words and explain why it is the heart of criterion 2.
How confident are you that you can I can build a model that shows the inputs and outputs of my solution.
Materials: a shared spreadsheet template or paper log sheets, calculators, a photo of the school’s water meter (ask facilities staff to read it with you).
Setup: all meter and waste numbers are sample data. If your facilities team shares real readings, use them. Set up the percent-change formula together before teams build their own.
Listen for: dividing the new value by the baseline instead of the change; reading the meter total as the weekly use; confusing input and output.
Support / stretch: give a log sheet with formulas printed in each column header. Stretch: add a conditional-format rule that colors the flag automatically.