University of Waterloo Excel Spreadsheet Activity

Instructions:Do NOT share this workbook with anyone or distribute it to anyone.
You must submit/attach this Excel file to LEARN in the LAST QUESTION of the quiz.
Make sure you save/close this workbook before uploading.
There are 6 questions in this workbook, with each question on a separate sheet.
For Q1 to Q4, only the cells initially highlighted in yellow will be marked.
Note that BELOW each question (Q1 to Q4), the solution values are shown.
Q6 is a special question: make sure to read the instructions carefully.
VERSION:
VW221
Question 1: [3 points]
In cell D4, write a formula that combines the [first letter of Size (if applicable)],
[Protein] and [Meal Type] in the following manner:
If the [Size (if applicable)] is blank, then it’s just:
[Protein] [Meal Type]
otherwise, it should be:
[first letter of Size (if applicable)] [Protein] [Meal Type].
There should be a single space between each element.
For example, “L Chicken Salad” or “Chicken Sandwich”.
Size (if applicable)
Large
Medium
Large
Small
Protein
Chicken
Chicken
Ham
Tofu
Pepperoni
Steak
Meal Type
Salad
Sandwich
Sandwich
Salad
Pizza
Salad
Order
Protein
Chicken
Chicken
Ham
Tofu
Pepperoni
Steak
Meal Type
Salad
Sandwich
Sandwich
Salad
Pizza
Salad
Order
L Chicken Salad
Chicken Sandwich
Ham Sandwich
M Tofu Salad
L Pepperoni Pizza
S Steak Salad
Solution Values:
Size (if applicable)
Large
Medium
Large
Small
Question 2: [5 points]
In cell B4, write a formula that extracts the size from the [Smoothie Order] in column A.
In cell C4, write a formula that provides the price for the given [Size] in column B, using the
data in the [Prices] sheet.
Write the formulas so that they can be autofilled/copied from row 4 to 9.
Smoothie Order
L Strawberry Banana
M Mango
S Wildberry
M Chocolate Banana
L Raspberry
M Tropical Blast
Size
Price
Size
L
M
S
M
L
M
Price
$
$
$
$
$
$
Solution Values:
Smoothie Order
L Strawberry Banana
M Mango
S Wildberry
M Chocolate Banana
L Raspberry
M Tropical Blast
7.99
6.99
5.99
6.99
7.99
6.99
Question 3: [4 points]
For this question, you will need the data on the sheet named [SquidData] and the
data on the sheet named [GameNames].
In cells B4 and C4, write formulas that look up and return the First Name and Blood
Type on the [SquidData] sheet.
In Cell D4, write a formula that looks up the “Last Round” for the given player, and
then looks that up on the [GameNames] sheet.
Write the formulas so they can be autofilled/copied from row 4 to 7.
Player ID
First Name
Blood Type Last Game
456
1
67
218
Solution Values:
Player ID
456
1
67
218
First Name
Gi-Hun
Il-Nam
Sae-Byeok
Sang-Woo
Blood Type
B
O
A
B
Last Game
The Squid Game
Marbles
Glass Bridge
The Squid Game
Question 4: [4 points]
In cell B4, write a formula that counts the number of people in the
[SquidData] sheet that have the corresponding Gender and Blood Type.
Hint: Use COUNTIFS
Write the formula so that it can be autofilled/copied from B4 to C7.
Blood Type / Gender
A
B
AB
O
M
F
M
F
Solution Values:
Blood Type / Gender
A
B
AB
O
83
57
29
69
68
57
26
67
Question 5: [3 points]
For this question, you want to present the same information as in Q4, but now
you want to present the data in a pivot table.
The pivot table does not have to look exactly like it does in Q4 (for example,
the rows/columns may be in a different order, and you may have extra totals)
but the same core information should be there.
Create your pivot table in a separate sheet called ‘SquidPivot’.
The solution for Q4 has been duplicated below for your convenience.
Solution Values:
Blood Type / Gender
A
B
AB
O
M
F
83
57
29
69
68
57
26
67
Question 6: [5 points]
For this question, your “boss” has requested that you generate a chart showing (as a line graph) the number of
people remaining at each round in the Squid Game.
They have sketched out a diagram (shown below) of what they want, but also said:
“It doesn’t have to look exactly like this. Make it look nice and pretty”.
They were very particular that the chart must show the number of people starting at 456 and then declining.
Place your chart in a separate sheet called ‘SquidChart’.
To obtain this information, you must use the data in the [SquidData] sheet. The data gives the last round that each
person participated in.
To solve this question, you must figure out how to use that information to generate the chart that you need.
For THIS QUESTION ONLY you may (but are not required to do so):
* add extra columns to the data in the [SquidData] sheet.
* create extra sheet(s) if you like.
There are many different ways of solving this problem.
There is no “single correct” approach.
In the LEARN quiz, for additional points, you must describe how you solved this problem. You may want to take
notes as you go to make describing your solution easier.
d that you generate a chart showing (as a line graph) the number of
d Game.
elow) of what they want, but also said:
ke it look nice and pretty”.
st show the number of people starting at 456 and then declining.
SquidChart’.
e data in the [SquidData] sheet. The data gives the last round that each
how to use that information to generate the chart that you need.
not required to do so):
dData] sheet.
s problem.
must describe how you solved this problem. You may want to take
ution easier.
This sheet contains a table for performing lookups.
Do NOT modify this sheet.
Size
S
M
L
Price
$5.99
$6.99
$7.99
This sheet contains a table required to answer questions on this
midterm.
Do NOT modify the existing data or rearrange the rows in any way.
For Q6, if you wish, you MAY add EXTRA columns to the right (i.e.:
you may add formulas to columns G, H etc.)
Fake names and were generated courtesy of
www.coolgenerator.com. Any similatities to real people are purely
coincidental.
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Surname
Firstname
Oh
Chu
P’o
Sim
Tang
Sip
Ru
Chong
Roe
Yo
Hung
Mun
Che
Ye
P’aeng
Sam
Chu
Mo
Sol
Tam
Hwangbo
Hak
Om
Tong
Paek
Ch’oe
Yom
Pae
Il-Nam
Chi-Hun
Song-Hee
Yong-Hui
Duck-Young
Il-Sung
Jae
Min’gyu
Chi-Won
Seong-Hyeon
Sung-Ryung
Chiyong
Min-Joo
Dong-Gun
Tae-Ran
Jin-Young
Hee-Chul
Min-Gyu
Jong-Soo
Kyung-Gu
Seung-Heon
Jung-Ho
Chimin
Sung-Ho
Yi-Jae
Hyonu
Da-Bin
Sol-Bi
Gender
M
M
F
F
M
M
M
M
M
M
F
F
F
M
F
M
M
M
M
M
M
M
F
M
F
M
F
F
BloodType
O
B
AB
O
O
O
A
AB
O
B
B
AB
B
O
O
A
A
B
O
O
A
O
B
O
O
B
O
AB
LastRound
4
1
1
2
2
1
1
3
3
2
2
1
3
2
2
1
2
1
1
3
2
3
1
1
2
3
3
1
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
Hu
Yop
Tongbang
Ryuk
Myong
Tang
Mo
Ogum
No
Kil
Sim
So
Chi
Man
Tam
Kyong
Hung
Rim
Chu
Yun
T’ae
Eoh
Im
Ch’ang
Sung
Sam
Kun
Man
Ran
Wi
Ku
Kyo
Pyon
Hwang
Chu
Pom
Ka
In
Kang
Yun
So
Eoh
Sang
Yeo-Woon
Sung-Chul
Shin-Young
Nam-Il
Jung-Hoon
Jung-Hee
Kwang-Ho
Young-Gi
Ye-Eun
Na-Young
Ah-Ra
Myung-Hee
Yong-Sook
Jong-Yul
Seung-Hee
Hyun-Ah
Seong-Ho
Seung-Won
Dong-Wook
Su-Yung
Joo-Won
Jin-Hee
Hye-Bin
Ye-Hee
Song-Min
Da-Hee
Na-Woon
Kyung-Mo
Seung-Yun
Hwa-Young
Su-Mi
Kyung-Min
Seong-Eon
Ji-Ae
Kyong-Suk
Yoon-Young
Soo-Yeon
Sung-Min
Sae-Byeok
Suh-Hyung
Eun-Hee
Ok-Bin
Yong-Joon
F
M
M
M
M
M
M
M
F
F
F
F
M
M
F
F
M
M
M
F
M
F
F
F
M
F
F
M
F
F
F
M
F
F
F
F
M
M
F
F
F
F
M
B
B
O
O
B
B
A
B
B
A
A
A
O
AB
O
A
O
B
A
AB
B
A
A
O
B
B
B
B
B
A
AB
AB
A
O
O
B
O
A
A
B
O
O
A
1
1
3
1
2
1
1
2
2
3
1
2
2
1
1
2
2
2
1
1
2
4
3
1
1
4
1
1
1
2
2
1
2
3
3
1
1
5
5
1
2
1
1
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
Nang
Ryang
Ryon
P’o
No
Yang
Kwon
Sagong
Yon
Sin
Ong
Hung
Eoh
Ko
Myo
Yo
Un
Ryang
Chung
Won
P’o
Sip
Chom
Ki
Tang
On
Kim
Kyon
Ya
Jang
Hyon
Chong
Tokko
Pang
Hwan
Sagong
Sung
Mangjol
Mo
Hung
Hwang
Hak
Hu
Tae-Young
Chihyon
Min-Kyu
Mi-Kyung
Kwang-Seon
Byeong-Cheol
Mi-Ryung
Jung-Hwa
Yong-Gi
Hyun-Ah
Eun-Ha
Ye-Jun
Hyun-Woo
Ji-Won
Min-Yung
Mi-Yun
Kyung-Gu
Yeong-Ho
Tae-Hyun
Jin-Ju
Do-Yeon
Min-Yung
Chiyun
Kwang-Hyok
Yi-Jin
Yoon-Ji
Hye-Ok
Mi-Ryung
Jin-Ho
Deok-Su
Song-Gi
Kwang-SunYoon-Jung
Seung-Eun
Jung-Hee
Yunso
Su-Hwa
Geum-Suk
Young-Min
Byeong-Gi
Pyong-Chol
So-Yeon
Chunho
M
F
M
F
M
M
F
F
M
F
F
M
M
M
F
F
M
M
M
F
F
F
F
M
F
F
F
F
M
M
M
M
F
M
M
F
F
F
M
M
M
F
M
A
B
B
AB
A
A
AB
A
AB
A
B
O
A
O
A
A
A
AB
A
A
O
O
O
A
A
O
B
O
A
A
O
B
B
B
O
O
A
O
O
A
B
A
A
1
2
4
1
1
1
1
1
1
2
1
1
1
2
1
1
1
2
2
4
1
1
1
1
1
1
2
4
1
5
2
2
1
2
1
1
1
1
1
1
1
3
2
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
Tan
Hung
Ko
Kye
Mangjol
Ong
Hae
Ri
An
Mangjol
Ok
Yon
Kun
Tu
Chung
Ch’ang
Kung
Ko
Ch’u
Su
Ryang
Sa
Ryo
Chegal
Pok
Tang
Ch’on
Mi
Myong
Ah
In
Sonu
Ch’oe
Mun
Chung
Ryo
Chong
Yo
T’ae
Kum
Maeng
So
Maeng
Jae-Hwa
Song-Su
Min-Kyung
Minso
Chiyong
Jin-Sang
Jin-Hwan
Eun-Soo
Seo-Yun
Kyung-Soo
Young-Ja
Jae-Wook
Ha’un
Young-NamSeul-Gi
Kyung-Soo
Ji-Hae
Nam-Sun
Sung-Ho
Yeong-Hee
In-Suk
Ji-Hye
Young-Hwan
Soo-Jin
Jung-Soo
Young-Ho
Min-Kyung
Yong-Hwan
Myung-Sook
Seo-Yeon
Chong-Hun
Seul-Ki
Hyun-Woo
Kwang-Seok
Young
Myong-Suk
Jung-Hyun
Seung-Min
Ho-Sung
Sun-Hwa
Byung-Chul
Hyun
Kwan
M
M
F
F
F
M
M
F
F
M
M
M
F
M
F
M
M
M
M
F
F
F
M
F
F
M
F
M
F
F
M
F
M
M
M
F
F
M
M
F
M
M
M
A
O
B
A
O
B
B
A
A
A
B
A
O
A
O
A
A
AB
O
B
A
B
O
O
O
A
B
B
A
B
AB
O
A
A
AB
B
O
O
A
A
B
B
A
5
2
2
1
3
1
1
1
1
2
1
1
4
1
2
1
3
3
2
1
3
1
2
1
2
1
1
1
1
2
1
1
1
1
3
1
2
1
1
1
1
1
1
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Ryom
Mae
Yon
Han
Sol
Pak
Ryom
Pak
P’yo
Ok
Hae
Um
P’o
Maeng
Kuk
Sol
Ra
Nae
P’ung
Ryon
P’an
Ryom
In
Rim
Wu
Cho
Kangjon
Chung
Sam
Na
P’yon
Kal
Mok
Chegal
P’yong
Sol
Yuk
Pu
Kwak
Nu
Tokko
Abdoul
Kum
Il-Seong
Yi-Hyun
So-Young
Tae-Yeon
Tae-Yeon
Ok-Sook
Gun
Seung-Hyeon
Yunso
Dae-Won
Jong-Yul
Kyung
Yeong-Su
Se-Yeon
Yeo-Jung
Chun-Ho
Mi-Yeon
Chin-Ho
Young-Ja
Suk-Ja
Ye-Won
Chihu
Eun-Jin
Eun-Seo
Hyun-Ki
Yong-Gi
Ha-Sun
Jung-Min
Hye-Jin
Young-Min
Ch’un-Ja
Kyung-Ho
Ji-Hae
Song-Hun
Sung-Hoon
Chun-Ja
Chunyong
Dong-Sun
Young-Soo
Yeo-Jin
Jung-Woo
Ali
Kang-Dae
M
F
F
F
F
F
M
M
F
M
M
M
M
M
F
M
F
M
M
F
F
M
F
F
M
M
F
M
F
M
F
M
F
M
M
F
M
M
M
F
M
M
M
B
O
A
A
O
A
AB
AB
A
AB
B
B
B
B
O
O
B
AB
B
A
B
A
AB
A
A
AB
O
A
O
AB
O
B
A
O
A
O
B
B
B
O
O
A
O
1
5
1
1
3
1
1
2
3
1
5
3
2
5
2
1
4
2
4
1
1
3
2
3
2
1
3
2
1
4
1
2
2
1
1
3
1
1
1
2
1
4
2
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
Rang
T’an
Tang
Yon
Ro
Pang
T’an
Ch’u
Kong
Ch’oe
Mun
Han
Hwa
Chegal
Son
Pong
Kyong
Cho
Ch’o
Sol
Chom
Ch’ae
Song
Pom
Eoh
Kal
Tan
P’il
Kam
P’yo
Mi
Kong
Yon
Ye
Kae
Uh
Hwa
Tongbang
Nam
T’an
Noe
Sagong
Chi
Sun-Mi
Sung-Ryung
Seo-Yeon
Shi-Won
Suk-Chul
Hyun-Jun
Go-Eun
Sung-Hyun
Hye-Jin
Chae-Young
Soo-Kyung
Mi-Nyeo
Seung-Won
Se-Ah
Yong-Sik
Kwan
Hye-Sook
Sang-Woo
Hyun-Jung
Seong-Ja
Kwan
So-Yung
Sang-Jun
Ji-Hoon
Chong-Yol
Hae-Seong
Hye-Jin
Jung-Hee
Song-Hun
Min-Ju
Kyung-Min
Seung-Hee
Su-Ji
Ae-Ra
Sung-Hoon
Hyon-U
Sang-Min
Ji-Won
Jung-Ho
Ji-Yeong
Hyung-Joon
Young-Hee
Kwang-Su
F
F
F
F
M
M
F
M
F
F
F
F
M
F
M
M
F
M
F
F
M
F
M
M
M
M
F
M
M
F
M
M
F
F
M
M
M
F
M
F
M
F
M
AB
B
O
B
O
A
B
B
A
O
AB
AB
A
A
A
A
O
B
AB
O
B
AB
AB
AB
AB
B
A
O
A
B
A
B
B
B
O
A
A
O
A
AB
O
B
A
2
2
4
2
1
1
3
1
1
2
1
5
1
1
1
1
1
6
1
1
1
1
1
4
2
5
2
5
1
1
2
1
1
1
2
2
1
1
1
2
1
2
1
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
Nae
Hwangbo
Hyong
Chon
P’ung
Hyong
Oh
T’ak
Ton
Ha
Min
Kang
Tu
Ham
Tu
Pae
P’o
Sonu
Mo
Chom
Nan
Ro
Tongbang
Ch’ae
Nae
Sok
Ryom
Wu
P’aeng
Chwa
Ch’a
Min
Chang
Hong
Han
Yang
Pong
Tongbang
Mae
Kwon
Ah
Sa
Namgung
Jung-Hee
Chun-Ja
Yong-Su
Kwan
Ji-Su
Byung-Hoon
Dong-Sun
Jin-Young
Eun-Joo
Min’gyu
Young-Gi
Seong-Su
So-Yung
Ji-Hyun
Chunho
Yeon-Joo
Du-Ho
Ho-Sung
Sang-Chul
Eun-Hye
Byeong-Ho
Sung-Chul
Young-Nam
Eun-Ah
Yoo-Mi
Gun
Se-Yeon
Yoon-Jung
Tae-Woo
Li-Na
Seong-Jin
Bo-Kyung
Ji-Tae
Hyun-Jung
Yong-Suk
Hee-Chul
Chunho
Hye-Young
Hye-Ja
Se-Ah
Sun-Woo
In-Sook
Jun-Young
M
F
M
M
F
M
M
M
F
M
M
M
F
F
M
F
M
M
M
F
M
M
F
F
F
M
M
F
M
F
M
F
M
F
F
M
M
F
F
F
M
F
M
A
A
B
AB
A
A
O
A
A
A
A
A
A
O
A
A
B
O
O
A
AB
O
B
A
A
AB
A
B
O
B
AB
O
A
AB
O
O
O
B
B
A
O
O
B
1
1
1
1
3
1
1
1
1
1
2
1
1
1
2
1
2
3
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
1
1
4
4
2
1
1
1
1
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
Yang
Sam
Cho
Eoh
Kan
Kye
Ha
Mangjol
Won
Sung
Ong
Ch’o
T’ak
Si
Ma
Noe
Myo
Kan
Ch’ae
Pae
Kae
Ko
Ham
Kil
Chom
Sobong
Chwa
P’yon
Kun
Sip
Yong
Ryong
Mun
To
Maeng
Ko
Yuk
Yi
Ch’u
Kim
Hwa
Won
Tongbang
Chimin
Sang-Hun
Yong-Chol
Han-Byul
Il-Seong
Chong-Yol
Jeong-Hun
Min-Soo
Il-Seong
Kyong-Ja
Yong-Hui
Chun-Yong
Tae-Yeon
Chi-Yong
Eun
Jung-Sook
Hyun-Ah
Dong-Sun
Seong-Su
Jin-Young
Ji-Won
Ju-Hee
Jung-Min
Ho-Jin
Su-Jung
Ja-Kyung
Chi-Hye
Yoo-Mi
Min-Soo
Yoo-Mi
Jung-Eun
Shi-Won
Kyung-Gu
Young-Soo
Chiyun
Seon
Hyejin
Kyung-Soo
Young-Sook
Sun-Woo
Tae-Yeon
Sang-Kyu
Young-Ah
F
M
M
F
M
M
M
M
M
F
F
M
F
F
F
F
F
M
M
M
M
F
M
M
F
M
F
F
M
F
F
F
M
M
F
M
F
M
F
M
M
M
F
B
O
B
B
O
B
B
A
O
A
A
AB
B
B
A
B
O
AB
O
O
O
AB
B
A
AB
O
B
B
A
O
AB
A
O
A
O
A
B
A
O
A
B
A
A
2
1
1
2
1
1
1
1
2
1
1
1
2
1
2
2
2
1
1
1
2
4
1
1
1
2
2
3
2
2
2
1
1
1
1
1
2
1
1
1
1
2
1
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
Yi
Sagong
Sun
Chong
Chun
Ch’ang
Chwa
Tam
Sok
Ma
Rang
Yu
Hwa
Kangjon
Ch’u
Tae
Sonu
Sobong
Rim
Muk
Nam
Roe
Hwangbo
Kal
Hyon
Pong
Chang
Wang
Nan
Kam
Pi
Myong
Nang
Hong
Si
Ch’on
Ro
Kang
Pae
Won
Wu
Ki
Pu
Hee-Ae
Jun-Yeong
Yi-Jae
Seon
Ji-Hae
Eun-Ha
Jin-Ju
Chung-Ah
Gri-Na
So-Ri
Ae-Ra
Yeon-Joo
Eun-Soo
Yo-Han
Nam-Seon
Hyuk
Hye-Sun
Tong-Hyon
Jung-Hwan
Jin-Shil
Kyu-Bok
Ji-Hae
Hyung-Joon
Eun-Soo
Seong
Joo-Won
Ji-Soo
Jun-Seo
Soo-Ah
Yeong-Hwan
Yeong-Su
Sun-Yung
Yeon-Hong
Eun-Jin
Song-Min
Subin
Na-Young
Ga-Yun
Young-Su
Jung-Hee
Ha-Sun
Yong-Su
Song-Min
F
M
F
M
M
F
F
F
F
F
F
F
M
M
M
M
F
M
M
F
M
M
M
F
M
M
F
M
F
M
M
F
F
F
M
F
F
F
M
F
F
M
M
A
A
O
O
B
A
AB
A
A
B
B
A
A
A
A
A
O
A
O
AB
AB
A
O
B
AB
O
B
A
O
O
O
O
O
A
A
O
B
O
B
A
B
O
O
1
1
1
2
1
1
1
1
1
1
2
1
1
2
1
1
2
1
1
1
1
1
1
1
1
1
1
3
1
1
1
1
2
2
5
1
2
4
2
1
1
3
4
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
Yun
Im
Tu
Kok
Kyo
Maeng
Ye
Mok
Sun
Ku
Ae
Chun
Sonu
Chegal
Sun
Kok
P’aeng
Ki
Yu
Wang
Mae
Yang
Chom
Cha
Yo
Ha
Rim
Pom
Sok
T’an
Hak
Chup
Mae
Sung
In
Yuk
Uh
Tang
Kwak
No
Sip
Ogum
Chon
Min
Jin-Hee
Mi-Ri
Eun-Jin
Yoo-Jin
Il-Sung
Ji-Sun
Mi-Hyun
Ha-Sun
Son-Ha
Si-Yeon
Ga-Yun
Su-Hyun
Yeh-Jin
Yong-Joon
So-Young
Ye-Eun
Min-Kyung
Se-Yeon
Jin-Hee
Myung-Sook
Sun-Woo
Yeon-Hee
Sang-Kyu
Sung-Ryung
Kwang-Min
Hyun-Sook
Ryu-Won
Min-Jun
Seong-Su
Hyo-Jin
Chun-Ja
Chi-U
Yeong-Jin
Ji-Won
Min-Hyuk
Jin-Shil
Tae-Hee
Il-Seong
Nam-Kyu
Jung-Eun
Su-Bin
Chun-Yong
F
M
F
F
F
M
F
F
F
F
F
F
F
F
M
F
F
M
F
M
F
M
F
M
F
M
F
F
M
M
F
F
F
M
M
M
F
M
M
M
M
F
M
AB
A
O
O
A
A
O
O
A
O
O
AB
B
AB
O
A
A
A
O
A
A
B
O
A
AB
AB
B
A
AB
AB
A
O
B
B
O
O
B
O
B
O
A
O
A
1
1
2
2
2
4
2
1
5
3
1
3
1
3
1
1
1
1
1
2
3
1
5
1
3
1
1
1
1
1
2
1
3
1
1
2
1
1
2
2
2
1
3
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
Mo
T’ae
Kok
Chon
Muk
Ping
Pang
Tan
P’ung
Hu
Ch’oe
Ping
On
Kal
Ryu
Muk
T’an
Ro
Un
Kyong
P’i
Hak
Rim
Wang
Changgok
Pom
An
Pan
Ping
Pu
Rang
Pak
P’il
Kun
Ryang
Hyong
To
Ryong
Yu
On
Seong
Hyo-Joo
Kyung-Gu
Gun
Yoo-Sun
Jae-Hui
Tae-Yun
Eun
Yong-Gi
Young-Ah
Dae-Hyun
Sang-Ki
Hye-Young
Songhyon
Seul-Gi
Hyo-Jung
Young-Shik
Ji-Hu
Ye-Hee
Min-Su
Young-Min
Hyon-Ju
Jung-Hee
Kyung-Ho
Seung-Hyun
Min-Soo
Songmin
Hye-Jung
Da-Hae
Sung-Ho
Seung-Hyun
Tae-Yeon
Do-Hyeon
Yoon-Jung
Chunyong
Kwang-Hoon
Hae-Il
Jeong-Mun
Shin-Hye
Jung-Yoon
So-Yun
Gi-Hun
F
M
M
F
M
F
F
M
F
M
M
F
M
F
F
M
M
F
M
M
F
F
M
M
M
M
F
F
M
F
F
M
F
M
M
M
M
F
F
F
M
B
O
B
B
A
A
B
AB
B
A
O
A
B
B
AB
O
O
A
O
B
A
O
B
O
B
B
A
O
A
A
A
O
O
O
A
A
O
O
O
AB
B
1
4
1
2
1
3
1
1
1
1
1
1
5
1
1
4
1
1
1
1
1
1
1
1
1
1
1
4
2
2
5
2
4
3
1
1
2
1
1
1
6
This sheet contains a table for performing lookups.
Do NOT modify this sheet.
Game Number
0
1
2
3
4
5
6
Game Name
Ddakji (Pog)
Red Light Green Light
Dalgona (Honeycomb)
Tug of War
Marbles
Glass Bridge
The Squid Game