History meets spreadsheet skills
Give the dates
a little context.
Turn amendment numbers and ratification dates into a timeline. Give students a small, readable file and a question worth investigating.
No coding needed. Start in a spreadsheet or use paper timeline cards.
Ten amendments.
One ratification date.
December 15, 1791
Why do the first ten records share a date?
The free sample contains amendments 1–10 and their ratification dates. Use the source links to investigate the history behind the pattern.
A ready-to-adapt lesson
From a table
to a timeline.
The U.S. Constitutional Amendments and Ratification Dates dataset has two lesson fields: AmendmentNumber and RatificationDate.
The file provides dates, not amendment text or an explanation of their legal meaning. Pair it with primary-source reading appropriate to your class.
Read the sample together.
Identify what each row represents. Ask students to distinguish the amendment number from its date. Format the date column as a date if the spreadsheet displays a time too.
Build and label the timeline.
Place each record by its ratification date, using amendment numbers as labels. Stack records that share a date. With the complete file, extend the exercise beyond the first ten amendments.
Investigate a pattern.
Choose one cluster or gap, then consult the dataset’s linked sources. Have students separate observations they can make from the table from explanations that require historical evidence.
Questions that go beyond sorting
- What does this timeline tell us, and what does it leave out?
- How does a shared date change the way we draw or label a timeline?
- With the complete file, where are the longest gaps between ratification dates?
- Why should a chart distinguish a proposal date from a ratification date?
For younger learners, use labeled cards. For older students, calculate intervals between distinct dates and write a short explanation with source references.
When you need the whole list
Take your project
past the sample.
The sample covers the first ten amendments. A pass adds the remaining records so your class can explore the full timeline held in the dataset.
A Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the available catalog.
Data Pass
$39one payment / 365 days
Choose your passYour key arrives by email. No account to create and no automatic renewal.
For your own projects, coursework, teaching, research, and internal work. If you incorporate data into a product or service you provide to others, choose a Commercial Pass. Check the dataset’s scope and sources before buying; passes are non-refundable under our terms.