Mission library/11th Grade · History Social Studies/Think-Pair-Share

Mission brief·Think-Pair-Share

Data Divorce & The Silicon Scandal

Designing schemas and querying data using structured language to find meaningful patterns.

Grade11th GradeSubjectHistory Social StudiesDuration45 minClass size28 studentsMethodologyThink-Pair-Share

Launch Mission Print Materials

Learning objectives · 3

Students can engage with: How do we ensure data integrity when multiple users access a system
Students can engage with: What are the ethical implications of connecting disparate datasets
Students can engage with: How would you design a database to minimize redundant information

Before Class

Materials Needed

☐Silicon Scandal Discussion GuideIncluded
☐Database Schema Blueprint HandoutIncluded
☐Pencils/Pens

Space Needed

Standard classroom seating; students turn to a neighbor

Topic Overview

Designing schemas and querying data using structured language to find meaningful patterns.

Key Questions

?How do we ensure data integrity when multiple users access a system?
?What are the ethical implications of connecting disparate datasets?
?How would you design a database to minimize redundant information?

About the Methodology

Students first think independently about a question or prompt, then pair with a partner to discuss their ideas, and finally share their conclusions with the whole class. Simple but powerful: it ensures every student processes the content before anyone speaks, reducing dominance by a few voices and building confidence in quieter students.

Learn about this methodology

Time Range

10-20 min

Group Size

8-40

Space Needed

Standard classroom seating; students turn to a neighbor

Bloom’s Level

Understand, Apply, Analyze

Fun Factor

Peak Energy Moment

The 'Race Condition' Roleplay. When students realize they can 'cheat' the bank by acting simultaneously, the room will erupt into a chaotic attempt to simulate a computer crash.

The Surprise

The 'Peanut Allergy' reveal in the Spark. It shifts the lesson from a boring 'how to organize tables' talk to a 'this could actually kill someone' high-stakes engineering problem.

What to Expect

During the 'Race Condition' pair-up, you'll hear students shouting 'I got the money first!' and 'No, the system is locked!' It will look like a frantic trading floor for about 60 seconds.

Mission Timeline

31m

Spark Briefing Action Debrief

Academic Standards

CSTA: 3B-DA-05

When your class is in the room

Ready to run Data Divorce & The Silicon Scandal?

Launch puts you into the Co-Teacher view - live timer, step-by-step facilitation, in-context tips. You can step back to this overview anytime.

Launch mission Print Materials

Spark

3 min • Scenario

Read Aloud

Imagine you are the Lead Developer for 'FitTrack,' a fitness app. You just merged with 'EatHealthy,' a meal-tracking app. Your boss wants a single list of users, but there is a massive problem. In FitTrack, User #402 is 'Alex Smith' (a marathon runner). In EatHealthy, User #402 is 'Alex Smith' (a person with a severe peanut allergy). If you send a peanut-heavy 'Runner's Fuel' recipe to the wrong Alex because your databases aren't synced correctly, you don't just have a bug—you have a lawsuit. How do we connect these two worlds without making a fatal mistake?

Teacher Notes

Read the scenario with high stakes. Emphasize that 'Alex Smith' is a common name and the ID numbers are the only thing the computer sees. Let the silence hang for a moment after the 'lawsuit' comment.

Briefing

5 min

Alright team, today you aren't just students; you're Database Architects. We are tackling the 'Silicon Scandal.' We have three massive problems: Redundancy (storing the same thing twice is a waste of money), Integrity (making sure data doesn't get corrupted), and Ethics (should we even be linking these datasets?). You have a 'Schema Blueprint' on your desks. You're going to work through three high-stakes rounds of Think-Pair-Share. First, you'll brainstorm a solution solo, then you'll battle it out with a partner to create a unified plan, and finally, we'll see if the class can reach a consensus before the 'system crashes.'

Group Formation

Students work individually for the 'Think' phase, then pair with their immediate neighbor for the 'Pair' phase.

Materials Needed

Silicon Scandal Discussion GuideIncluded
Database Schema Blueprint HandoutIncluded
•Pencils/Pens

Action

31 min • 100% Physical

THINK (Redundancy): Look at Challenge #1 on your worksheet. You have a messy table of 'Customer Purchases' where the customer's address is typed out every single time they buy a soda. Spend 3 minutes redesigning this into two tables (Customers and Purchases) to eliminate repeating text.

5 min

Walk around and look for students who are struggling to identify the 'Primary Key' that will link the two tables.

PAIR & SHARE (The Normalization Debate): Turn to your neighbor. Compare your two-table designs. If your 'Primary Keys' don't match, you have a data break! Agree on one design and be ready to defend why your 'Foreign Key' is the best bridge.

6 min

Listen for students arguing about whether to use 'Email' or 'CustomerID' as the key. This is the core of the lesson.

THINK (Integrity): Look at Challenge #2. A bank database allows two people to withdraw $100 from the same $150 account at the exact same millisecond. How do you stop this physically or logically? Write down your 'locking' mechanism strategy.

5 min

Encourage 'outside the box' thinking—how does a physical line at a teller prevent this?

PAIR & SHARE (The Race Condition): Share your 'locking' strategy. One person plays the 'Bank Server' and the other plays the 'Hacker.' Try to find a way to trick your partner's logic to double-withdraw the money.

6 min

This is the 'Peak Energy' moment. Expect laughter as students try to 'cheat' the system.

FINAL CHALLENGE (Ethics): Look at Challenge #3. You are asked to link a 'Hospital Records' database with a 'Life Insurance' database. Think solo: Is this helpful or evil? Then, discuss with your partner: What is the one rule you would write into the SQL code to protect people?

9 min

Facilitate a quick-fire share-out where pairs shout out their 'One Rule' to the class.

If things go sideways

▸If pairs are finishing too fast, challenge them to add a third table for 'Product Categories' to their first design.
▸If students are stuck on the 'locking' mechanism, use the 'Conch' analogy: only the person holding the 'Token' can write to the database.
▸If the Ethics debate gets too heated, pivot to a technical question: 'How would you write a query that specifically EXCLUDES PII (Personally Identifiable Information)?'

Differentiation Tips

▸For advanced students: Ask them to write the actual SQL 'JOIN' statement on the back of their sheet for Challenge #1.
▸For students needing support: Provide a 'Starter Schema' with the table names already drawn, so they only have to fill in the column headers.
▸Visual learners: Encourage drawing lines (relationships) between the tables on the blueprint rather than just writing text.

Debrief

6 min

Discussion Questions

1
Why is a 'Unique ID' better than a 'Name' when joining two massive datasets?
2
If we eliminate all redundancy, does the database become harder or easier for a human to read? Why?
3
What happens to a society when every database is 'relational' and can be linked to every other database?

Exit Ticket

In your own words, explain the difference between a Primary Key and a Foreign Key using the 'Customer and Purchases' example.

Connection to Next Lesson

Next time, we move from drawing these schemas to actually building them in a SQL environment. Bring your blueprints!

Handouts

3 Materials Needed

Print Materials

01The Silicon Scandal: Architect Guide
02Schema Blueprint Template
03Exit Ticket: The Key Connection

Was this mission useful?

Launch Mission Print Materials

Teach this mission Browse Curriculum Browse gallery

You created a mission!

Save my missions