Capstone: produce a reproducible decision analysis
Deliver calculations another person can repeat and inspect.
Reviewed: 2026-10-03
Source-based teaching example · Fictional data
Narration: Microsoft Mark · locally synthesized

00:00:00.000 — What you will learn

Deliver calculations another person can repeat and inspect.

Visual description:
Deliver calculations another person can repeat and inspect.

00:00:06.625 — The idea

Keep original rows, validation decisions, formulas and results together. Explain missing records and unequal tasks. A polished chart cannot replace that evidence.

Visual description:
Keep original rows, validation decisions, formulas and results together. Explain missing records and unequal tasks. A polished chart cannot replace that evidence.

00:00:21.583 — One useful term

Reproducible analysis. An analysis whose inputs, choices and calculations can be followed and repeated.

Visual description:
An analysis whose inputs, choices and calculations can be followed and repeated.

00:00:32.083 — A worked example

The worked package traces source rows through validation to rates and a decision note. Missing duration stays missing. Unresolved records prevent a general comparison claim.

Visual description:
The worked package traces source rows through validation to rates and a decision note. Missing duration stays missing. Unresolved records prevent a general comparison claim.

00:00:45.917 — Your turn to think

Does a smaller known subtotal prove overall savings when work is still missing? Pause and decide before continuing.

Visual description:
Does a smaller known subtotal prove overall savings when work is still missing?
Pause the video if you need more time.

00:01:04.167 — Why this answer works

No. State the incomplete coverage and unmatched workload. Keep exclusions and formulas inspectable.

Visual description:
No. State the incomplete coverage and unmatched workload. Keep exclusions and formulas inspectable.

00:01:14.250 — Check 1

Preserve source rows and cleaning decisions.

Visual description:
Preserve source rows and cleaning decisions.

00:01:19.875 — Check 2

Check formulas independently.

Visual description:
Check formulas independently.

00:01:24.833 — Check 3

Limit conclusions to comparable known work.

Visual description:
Limit conclusions to comparable known work.

00:01:30.500 — Now try a different case

Open the lesson and try its different practice case. Use every check in the full task. Watching alone does not mark the lesson complete.

Visual description:
Open the lesson
Try the new case
Check and revise
The full task and its requirements are in the linked lesson.