AdvertisementYour brand could be hereYour brand hereOn every Darslab page Ā· students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Digital Literacy

Joining the dots

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.

Worked examples
Club list: codeNight
P-17Tuesday
P-52Friday
Two invented tables. Both have a phone code, so the rows for the same person can be joined.
Bakery app: codeUsual buyTime
P-17oat bar18:00
P-52bread roll08: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.
BornAreaClub
2011Hillsidechess
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?
ListCodeDetail
PoolK-9swims Wednesday
Corner shop appK-9juice, 19:00
2
What is the matching field in these two lists?
ListNameContact
Book clubNinan@example.org
Swim clubN. Okoyen@example.org
3
A list has no names, only ā€˜born 2010, lives in Hillside, plays the violin’. Why might the person still be found?
4
Name one way an organisation can make joining its data with other data harder.