Week 15 Ā· Unit 9.2: My childrenās digital world Ā· 3 lessons
1
Two tables, one new fact
Digital Literacy 9: Unit 9.2, objectives 9DW.06, 9TC.02
GoalExplain aggregation by joining invented data sets and say what makes joining possible.
New words
aggregation Ā· joining separate data sets to learn something none of them shows alonedata set Ā· a collection of related records, such as a tablematching field Ā· a detail that appears in two data sets and lets them be joined, such as a phone numberre-identification Ā· working out who a record is about after the name was removed
Explanation
Aggregation means joining separate data sets to find something new. A sports club has a list of members and training nights. A bakery app has a list of what each customer buys. Neither list alone says much. If both contain the same detail, such as a phone number, they can be joined, and a new fact appears: āthis person trains on Tuesday and buys a snack straight afterā. The detail that links the lists is the matching field. Even when names are removed, a mix of ordinary details, such as birth year, area and school, can be unique to one person, so someone can be re-identified. Aggregation can be harmless and useful, but it creates a picture that nobody was shown, and the people in the data may never have expected it.
Set A: club listāSet B: bakery appāJoin on a matching fieldāNew fact about a person
Worked examples
Club list: code
Night
P-17
Tuesday
P-52
Friday
Two invented tables. Both have a phone code, so the rows for the same person can be joined.
Bakery app: code
Usual buy
Time
P-17
oat bar
18:00
P-52
bread roll
08:30
The bakery app list uses the same codes. After the join: code P-17 trains on Tuesday and buys a snack at 6 pm.
Born
Area
Club
2011
Hillside
chess
Names removed, but three ordinary details together can still point to one person.
Class activity
Join the tables (pairs, on paper). Your teacher prepares two small tables of six invented people. Table 1: code, sport and training night. Table 2: code, shop and usual day. Find the matching field and join the tables to write one new fact for each person. Then cross out the codes in Table 2 and try again using only other columns: can you still tell who is who? Discuss: how many details were needed? What could the organisations do to make joining harder (for example, give each list a different code)? No real people or real data.
Practice
1
Join these rows. What new fact do you learn about code K-9?
List
Code
Detail
Pool
K-9
swims Wednesday
Corner shop app
K-9
juice, 19:00
K-9 swims on Wednesday evenings and buys juice at the corner shop at about 7 pm: a routine that neither list showed alone.
2
What is the matching field in these two lists?
List
Name
Contact
Book club
Nina
n@example.org
Swim club
N. Okoye
n@example.org
The email address, the detail that appears in both lists. It lets the rows for the same person be joined.
3
A list has no names, only āborn 2010, lives in Hillside, plays the violinā. Why might the person still be found?
A few ordinary details together can be unique in a small group, so someone who knows the area could work out who it is. This is re-identification.
4
Name one way an organisation can make joining its data with other data harder.
Use different random codes for each list, remove details not needed, group ages and places in wider bands, and limit who can see or share the data.