Description
The information and details of the assignments are in the attached documents below.
Unformatted Attachment Preview
YOUR NAME HERE
Discount Table:
Discount for ‘Platinum’ Shoppers:
Discount for ‘Gold’ Shoppers:
Customer First Customer Last
Name
Name
Christopher
Taylor
Jennifer
Andrea
Dan
Heidi
Russell
Adam
David
Jessica
Jon
Tyler
Josh
Linda
Stephen
Sabra
Amy
James
Scott
Tyler
Blake
Megan
Delvin
Heath
Cat
Keith
Steve
Rico
Jessica
Jen
Kortney
Paul
Nicole
Declan
Ahrens
Lipsett
Armbruster
Woodson-Smith
Monzo
Jo
Wolfe
Page
Wagner
Long
Rydberg
Burdick
Sweeney
Mastandrea
Welch
Hawkes
Purdy
Stuck
Winkler
Carron
Leeper
Harmon
McMillian
Calhoun
Bouwkamp
Gabel
Cash
Roman
Galli
Lee
Clemons
Schaus
Roundy
Farmer
Status
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Taylor
Jeremy
Danelle
Bradley
Dan
Ileana
Katy
Greg
Kevin
Anjali
Mike
Josh
Nikko
Brody
Amy
Kari
Evan
Patrick
Dartanyon
Rudy
Evan
Mary
Tommy
Allison
Lisa
Mallory
Jeff
Myles
Cheri
Asya
Greta
Wendy
Brent
Eric
Mackenzie
Alana
Andy
Cristina
Andy
Lex
Paul
Tatyana
Chace
Wagner
Umstead
Snyder
McCoy
Rodriguez
Sullivan
Shaw
McKee
Forber-Pratt
Shea
Pauls
Landeros
Roybal
Purdy
Miller
Strong
McDonald
Crockett
Garcia-Tolson
Strong
Stack
Chasanoff
Jones
Czechowski
Weggemann
Fabry
Porter
Blauwet
Miller
Neimanas
Fryke
Rasmussen
Hollen
Soldan
Nichols
Yohe
Albert
Soule
Gillette
Schulte
McFadden
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Active
Discount Table:
nt for ‘Platinum’ Shoppers:
count for ‘Gold’ Shoppers:
Level
Platinum
Platinum
Gold
Gold
Platinum
Gold
Gold
Platinum
Platinum
Platinum
Platinum
Gold
Platinum
Gold
Gold
Platinum
Platinum
Gold
Platinum
Platinum
Gold
Gold
Platinum
Gold
Platinum
Platinum
Platinum
Platinum
Platinum
Gold
Gold
Gold
Platinum
Gold
20.50%
16.25%
Discount
Gold
Platinum
Platinum
Platinum
Platinum
Platinum
Gold
Gold
Platinum
Platinum
Gold
Gold
Gold
Gold
Gold
Platinum
Platinum
Gold
Platinum
Platinum
Gold
Platinum
Gold
Gold
Platinum
Platinum
Platinum
Gold
Platinum
Platinum
Gold
Platinum
Platinum
Gold
Gold
Gold
Gold
Platinum
Platinum
Platinum
Platinum
Platinum
Level
Discount Table:
Discount for ‘Bronze’ Customers:
Discount for ‘Gold’ Customers:
Discount for ‘Platinum’ Customers:
Discount for ‘Regular’ Customers:
Discount for ‘Silver’ Customers:
Bronze
Gold
Platinum
Regular
Silver
Customer First
Name
Level
Christopher
Cristina
Jennifer
Cheri
Cat
Tyler
Heath
Tyler
Steve
Taylor
Tommy
Kortney
Dartanyon
Lisa
Jeff
Declan
Anjali
Wendy
Keith
Jessica
Rudy
Lex
Megan
Sabra
Eric
Heidi
Allison
Nikko
Jen
Blake
Customer Last
Name
Ahrens
Albert
Armbruster
Blauwet
Bouwkamp
Burdick
Calhoun
Carron
Cash
Chace
Chasanoff
Clemons
Crockett
Czechowski
Fabry
Farmer
Forber-Pratt
Fryke
Gabel
Galli
Garcia-Tolson
Gillette
Harmon
Hawkes
Hollen
Jo
Jones
Landeros
Lee
Leeper
Silver
Gold
Regular
Silver
Bronze
Platinum
Gold
Platinum
Bronze
Silver
Silver
Bronze
Regular
Bronze
Bronze
Regular
Gold
Bronze
Silver
Regular
Gold
Platinum
Gold
Regular
Bronze
Bronze
Platinum
Gold
Bronze
Regular
Taylor
Jessica
Linda
Dan
Patrick
Tatyana
Kevin
Delvin
Asya
Kari
Dan
Greta
Alana
Adam
Josh
Myles
Amy
Amy
Brent
Ileana
Rico
Nicole
Brody
Jon
Paul
Paul
Greg
Mike
Bradley
Mackenzie
Andy
Mary
Evan
Evan
James
Katy
Josh
Danelle
David
Jeremy
Mallory
Stephen
Scott
Russell
Lipsett
Long
Mastandrea
McCoy
McDonald
McFadden
McKee
McMillian
Miller
Miller
Monzo
Neimanas
Nichols
Page
Pauls
Porter
Purdy
Purdy
Rasmussen
Rodriguez
Roman
Roundy
Roybal
Rydberg
Schaus
Schulte
Shaw
Shea
Snyder
Soldan
Soule
Stack
Strong
Strong
Stuck
Sullivan
Sweeney
Umstead
Wagner
Wagner
Weggemann
Welch
Winkler
Wolfe
Gold
Regular
Regular
Gold
Silver
Bronze
Bronze
Gold
Silver
Bronze
Silver
Platinum
Bronze
Gold
Platinum
Silver
Regular
Gold
Silver
Silver
Regular
Bronze
Regular
Silver
Gold
Platinum
Regular
Bronze
Silver
Platinum
Regular
Silver
Gold
Gold
Regular
Silver
Bronze
Gold
Bronze
Bronze
Bronze
Regular
Bronze
Bronze
Andrea
Andy
Woodson-Smith
Yohe
Bronze
Bronze
Discount
4.25%
1.75%
7.25%
17.50%
5.00%
Discount
5.00%
1.75%
17.50%
5.00%
4.25%
7.25%
1.75%
7.25%
4.25%
5.00%
5.00%
4.25%
17.50%
4.25%
4.25%
17.50%
1.75%
4.25%
5.00%
17.50%
1.75%
7.25%
1.75%
17.50%
4.25%
4.25%
7.25%
1.75%
4.25%
17.50%
The VLOOKUP() formula in cell E3 is
=VLOOKUP(D10,D$3:E$7,2) and is used here to
match the Level in cell D10 with the Level in
column D3 to D7. When VLOOKUP() finds a match,
in this case ‘Silver’ in cell D7, it returns the value in
the cell immediately to the right of D7, in this case
‘5.50%.’ Note that VLOOKUP can do A LOT more this is the most basic example.
1.75%
17.50%
17.50%
1.75%
5.00%
4.25%
4.25%
1.75%
5.00%
4.25%
5.00%
7.25%
4.25%
1.75%
7.25%
5.00%
17.50%
1.75%
5.00%
5.00%
17.50%
4.25%
17.50%
5.00%
1.75%
7.25%
17.50%
4.25%
5.00%
7.25%
17.50%
5.00%
1.75%
1.75%
17.50%
5.00%
4.25%
1.75%
4.25%
4.25%
4.25%
17.50%
4.25%
4.25%
4.25%
4.25%
here to
a match,
value in
this case
T more –
YOUR NAME HERE
Use this table with
VLOOKUP() to determine
which ‘Department’ each
student is in based on their
‘Major.’ (Do not change
this table)
Student
ID#
Year
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
First Name
Steven
Jonathan
Jay
Lorin
Michael
Glenford
Joshua
Kathryn
Travis
Hillary
Brandi
William
Addison
Daniel
Robert
John-Michael
Daniel
Miles
William
Last Name
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Classification
Sophomore
Junior
Senior
Junior
Senior
Junior
Junior
Sophomore
Senior
Junior
Sophomore
Senior
Junior
Freshman
Junior
Junior
Senior
Junior
Junior
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Robert
Timothy
Edward
Emily
Taylor
Destiny
Whitney
Delane
Brenda
David
Brandon
Brandon
Matthew
Sirena
Evers
Lee
Teresa
Devarrio
Daniel
William
Taylor
Sanford
Christopher
Natalie
Milankumar
Kendrick
John
Robert
Mitchell
Zachary
Jonathan
Andrew
John
Juntao
Benjamin
John-Michael
Andrew
Matthew
Mark
Justin
Dustin
Ryan
Jesse
John
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Senior
Junior
Senior
Senior
Senior
Sophomore
Senior
Senior
Sophomore
Senior
Senior
Senior
Senior
Senior
Senior
Senior
Sophomore
Sophomore
Sophomore
Junior
Sophomore
Sophomore
Junior
Sophomore
Junior
Junior
Junior
Senior
Senior
Senior
Senior
Sophomore
Sophomore
Junior
Junior
Senior
Junior
Junior
Sophomore
Senior
Junior
Junior
Sophomore
Senior
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Daniel
Matthew
James
Faustino
Charlotte
Patrick
Wesley
Robert
Leigh
Stacey
Mark
William
Trevor
Michael
Laurie
John
Cordero
James
Johan
Andrew
Larissa
Terry
Noah
Zachary
Dustin
Evan
Hampton
Dwight
Eliza
Brady
Eric
Patrick
Ryan
Anderson
Megan
Koun
Anna
Richard
Laura
Dwight
Myles
Richard
Whitney
John
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Sophomore
Senior
Senior
Freshman
Sophomore
Sophomore
Sophomore
Sophomore
Senior
Unclassified
Junior
Freshman
Freshman
Senior
Junior
Senior
Sophomore
Sophomore
Junior
Senior
Junior
Junior
Sophomore
Junior
Junior
Senior
Sophomore
Senior
Junior
Senior
Junior
Junior
Sophomore
Sophomore
Junior
Junior
Junior
Junior
Senior
Sophomore
Senior
Freshman
Senior
Sophomore
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Myles
Judson
Christopher
Cody
Anderson
Kimberly
Jeffrey
Stacey
Marshall
Robert
Alexandra
George
William
William
Constance
Anderson
Carolyn
James
Edward
Jay
Jessica
Brian
Richard
Ashby
Bonner
Ashleigh
Robin
Griffin
Brian
Hannah
Alexandros
Nicholas
Joshlin
Eric
Matthew
Frank
Hannah
John
Lorin
Haley
Erin
Jeremy
Bonner
Adrieka
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Senior
Senior
Junior
Senior
Junior
Senior
Sophomore
Junior
Senior
Junior
Senior
Senior
Sophomore
Senior
Junior
Junior
Sophomore
Senior
Junior
Junior
Sophomore
Junior
Junior
Senior
Junior
Senior
Junior
Junior
Senior
Sophomore
Junior
Senior
Junior
Sophomore
Senior
Junior
Junior
Senior
Junior
Junior
Unclassified
Senior
Junior
Sophomore
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Jeremy
Wan Yee
Blaine
Cameron
Katarzyna
Keiarron
William
Parker
Erin
Ross
John
Andrew
Ethan
Austin
Ronald
Clark
Roderrick
Jacob
Jordan
Samuel
William
John
John
Adam
Ross
Joseph
James
Chelsea
Mark
John
Elizabeth
Michael
Reid
Bruce
Elizabeth
Nathan
Lewis
Kristin
Andrew
Julia
Matthew
Matthew
Forrest
William
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Senior
Sophomore
Sophomore
Senior
Senior
Junior
Senior
Sophomore
Junior
Junior
Senior
Sophomore
Senior
Junior
Freshman
Senior
Senior
Junior
Junior
Senior
Junior
Senior
Senior
Senior
Sophomore
Junior
Junior
Junior
Freshman
Junior
Senior
Junior
Junior
Senior
Sophomore
Senior
Junior
Sophomore
Sophomore
Junior
Sophomore
Junior
Junior
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Wolfgang
John
Bailey
Katandra
Blake
Jonathan
Trey
Nathan
Jonathan
William
Christopher
Keeana
Lindsey
Todd
Robert
Christine
Jonathan
Kevin
John
Walter
Bryson
Frank
Farris
Lindsey
Clay
Judson
Ashton
Justin
Jesse
David
Roy
Ashley
Alexander
Caroline
Garrett
Ben
Lisa
Blake
Nicholas
Hannah
Lee
Philip
Jay
Tiffany
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Senior
Sophomore
Sophomore
Senior
Junior
Senior
Junior
Freshman
Senior
Senior
Sophomore
Senior
Junior
Junior
Freshman
Junior
Senior
Junior
Sophomore
Sophomore
Junior
Junior
Senior
Senior
Senior
Junior
Senior
Senior
Sophomore
Senior
Junior
Sophomore
Junior
Junior
Senior
Junior
Junior
Junior
Sophomore
Junior
Junior
Freshman
Junior
Unclassified
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Richard
Miles
Casey
Thomas
Caleb
Robert
Michael
Thomas
Martin
Clay
Jacob
Kenneth
Robert
Naomi
Jackie
Jacob
Rosemarie
Francisco
Carman
George
Jacob
Gregory
Rodrigo
Nicholas
Ryan
Kathryn
Ben
Scott
Sidney
Keven
Jared
Christopher
Emily
Anna
Alexandra
Vincent
Harry
Gray
Terrell
Makita
Luke
Anna
Kyndal
Sidney
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Senior
Senior
Junior
Junior
Junior
Senior
Junior
Freshman
Junior
Junior
Sophomore
Senior
Junior
Junior
Junior
Sophomore
Sophomore
Sophomore
Sophomore
Sophomore
Senior
Freshman
Sophomore
Senior
Senior
Sophomore
Senior
Senior
Sophomore
Sophomore
Senior
Sophomore
Sophomore
Senior
Junior
Sophomore
Senior
Junior
Senior
Junior
Sophomore
Sophomore
Senior
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Connor
Keeana
Ashby
Robert
Michael
Jacob
Paul
Sean
Callender
Harry
Forrest
Nicole
Christopher
Elizabeth
Tyler
Robert
Matthew
Alexander
Leland
Edward
Luke
Chance
Felesia
Jamie
Philip
Nicholas
Austin
Rebecca
Lacy
John
Robin
Nicole
Julianna
Jonathan
Sheldon
Mitchel
Joshua
Griffin
Mitchell
Carlos
James
Carlos
Austin
Sidney
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Senior
Junior
Junior
Senior
Junior
Junior
Senior
Junior
Senior
Senior
Junior
Senior
Sophomore
Senior
Junior
Sophomore
Sophomore
Junior
Sophomore
Junior
Junior
Freshman
Junior
Junior
Senior
Unclassified
Senior
Junior
Senior
Sophomore
Senior
Junior
Junior
Senior
Sophomore
Junior
Senior
Senior
Sophomore
Freshman
Senior
Sophomore
Junior
Sophomore
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Johntarrio
Naomi
Christa
Amanda
Joseph
Robert
Amber
Caleb
Antonie
Kurt
Andrew
Laura
Sunday
Kyle
Drayton
Alyssia
Jordan
Carlotta
Andrew
William
Bryton
Demarcus
Lacy
Lawrence
Eric
Walter
Frederick
Hillary
Sean
Joseph
Joseph
Megan
Valarie
Ryan
Blaine
Bryton
Andrew
Justin
Eric
George
Robert
Macy
John
Frank
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Senior
Junior
Senior
Junior
Junior
Senior
Junior
Junior
Sophomore
Senior
Junior
Junior
Junior
Junior
Senior
Junior
Senior
Senior
Junior
Sophomore
Junior
Sophomore
Senior
Senior
Sophomore
Senior
Senior
N/A
Sophomore
Junior
Senior
Sophomore
Senior
Sophomore
Sophomore
Sophomore
Senior
Junior
Junior
Junior
Sophomore
Junior
Junior
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Evan
Charles
Maria
Laura
David
Erika
Katandra
William
Tiffeny
Adam
Jayson
Joshlin
Andre
Wendy
Hannah
Janet
Jaquetta
Kevin
Michael
Derickson
Jake
Kyle
Jonathan
Walter
James
Dwight
Jake
Austin
Randi
Mary-Margaret
Jimo
Matthew
Austin
Tre’
Spencer
Delane
Garrett
Benjamin
Taylor
Lee
Erin
Frank
Tiffeny
Juntao
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Sophomore
Sophomore
Junior
Senior
Senior
Senior
Senior
Senior
Sophomore
Junior
Sophomore
Sophomore
Junior
Junior
Junior
Freshman
Sophomore
Senior
Senior
Sophomore
Sophomore
Senior
Senior
Junior
Senior
Junior
Junior
Junior
Junior
Sophomore
Senior
Senior
Freshman
Junior
Senior
Sophomore
Junior
Freshman
Junior
Senior
Sophomore
Senior
Junior
Junior
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
1455
1456
1457
1458
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Parker
Rebecca
Kevin
Francisco
Demarcus
William
Shannon
Felesia
Brittany
Julia
Hill
Matthew
Megan
Christopher
Brandon
William
Matthew
Kevin
William
Sekyoung
Jonathan
Knista
Keven
Andrew
Forrest
Makita
Thomas
David
Bryson
Caitlin
Clark
Ryan
Chelsea
Samuel
Jordan
John
Christopher
Keyanna
Michael
Quortisha
Cameron
Michael
Ryan
Elizabeth
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Sophomore
Junior
Senior
Junior
Junior
Sophomore
Sophomore
Junior
Sophomore
Senior
Junior
Junior
Junior
Junior
Junior
Junior
Freshman
Sophomore
Freshman
Junior
Junior
Junior
Senior
Sophomore
Senior
Sophomore
Sophomore
Senior
Junior
Senior
Junior
Junior
Junior
Sophomore
Senior
Junior
Junior
Junior
Sophomore
Junior
Senior
Senior
Freshman
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Matthew
Garrett
Nathan
Daniel
Thomas
Randy
Thomas
John
Chase
William
Caroline
Thomas
Kenneth
Willie
Matthew
Mark
William
Kevin
Matthew
Kenneth
Adam
Dyllan
Travis
John
Jordan
Jordan
Jared
George
James
Christopher
Roderrick
Miles
Walter
Jackson
Stefan
James
Samuel
William
William
Cordero
Knista
Harris
Chase
Daniel
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Sophomore
Junior
Junior
Sophomore
Junior
Senior
Junior
Junior
Junior
Junior
Junior
Sophomore
Unclassified
Sophomore
Junior
Sophomore
Sophomore
Senior
Sophomore
Senior
Sophomore
Junior
Sophomore
Junior
Unclassified
Senior
Sophomore
Senior
Junior
Junior
Junior
Sophomore
Junior
Freshman
Senior
Sophomore
Sophomore
Senior
Sophomore
Junior
Junior
Sophomore
Sophomore
Sophomore
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Damien
Alexander
Steven
Faustino
William
Gray
Haley
John
Kristin
Matthew
Mario
Junae
Crystal
Forrest
Kody
Christopher
Gregory
Andrew
Charles
Randi
Evers
Norman
Tyler
John
Patrick
John
Hill
John
Amanda
Cameron
Corey
Katarzyna
Amy
Haley
Lisa
Preston
Sekyoung
John
Andrew
Norman
Sanford
Robert
William
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Junior
Senior
Junior
Senior
Sophomore
Sophomore
Sophomore
Sophomore
Sophomore
Sophomore
Junior
Junior
Junior
Sophomore
Unclassified
Junior
Senior
Senior
Senior
Senior
Junior
Sophomore
Sophomore
Sophomore
Senior
Junior
Junior
Sophomore
Junior
Junior
Senior
Senior
Senior
Junior
Junior
Junior
Sophomore
Senior
Visiting
Sophomore
Sophomore
Senior
Junior
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Thomas
Keyanna
Ebonie
Kathryn
Jayson
Gavin
Destiny
Derek
Robert
Callender
Samuel
Sara
Cameron
Ethan
William
Reid
Elizabeth
Jackie
Jaclyn
Robert
Gregory
Christopher
Patrick
Benjamin
Dwight
Andrew
Trey
Caroline
Paige
Tanner
Andrew
Glenford
Koun
Wolfgang
Samuel
Travis
Nicholas
Matthew
Janet
Justin
Robert
Teresa
Rodrigo
Barrett
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Sophomore
Senior
Sophomore
Junior
Junior
Senior
Sophomore
Senior
Sophomore
Senior
Sophomore
Sophomore
Freshman
Junior
Senior
Sophomore
Sophomore
Senior
Sophomore
Junior
Visiting
Sophomore
Sophomore
Junior
Sophomore
Freshman
Senior
Junior
Junior
Sophomore
Sophomore
Sophomore
Junior
Junior
Senior
Senior
Senior
Sophomore
Senior
Senior
Senior
Sophomore
Sophomore
Sophomore
1591
1592
1593
1594
1595
1596
1597
1598
1599
1600
1601
1602
1603
1604
1605
1606
1607
1608
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633
1634
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Travis
Austin
Hollis
Timothy
Ashleigh
Ryan
Timothy
Timothy
William
Emily
Evan
Edward
Whitney
Danielle
Charlotte
Joshua
Gregory
Stefan
Cody
Robert
Brady
William
James
Austin
Colt
Sidney
Kyle
Jordan
William
Chris
Jackson
William
Samuel
Zachary
James
John
William
Wesley
Dyllan
Aneisha
Andrew
Justin
Alexandros
Martin
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Senior
Sophomore
Sophomore
Junior
Junior
Sophomore
Senior
Senior
Sophomore
Senior
Sophomore
Junior
Junior
Senior
Junior
Senior
Senior
Junior
Junior
Sophomore
Senior
Junior
Junior
Junior
Senior
Junior
Junior
Junior
Senior
Sophomore
Sophomore
Sophomore
Sophomore
Freshman
Senior
Sophomore
Sophomore
Junior
Senior
Junior
Sophomore
Senior
Sophomore
Senior
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
1646
1647
1648
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Jessica
Haley
Sarah
William
Patrick
Christopher
Nicholas
Trevor
Allison
Derickson
Trevor
Tiffany
Meghann
Christopher
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Jones
Junior
Junior
Sophomore
Junior
Sophomore
Sophomore
Junior
Sophomore
Senior
Junior
Senior
Senior
Senior
Senior
DEPARTMENT – MAJOR TABLE
Major
Banking & Finance
Business Undeclared
Economics
Management Information Systems
Management-Behavioral
Management-Human Resources
Managerial Finance
Marketing
Marketing & Corporate Relations
Real Estate
Risk Management & Insurance
Department
Finance
Undeclared
Economics
MIS
Management
Management
Finance
Marketing
Marketing
Finance
Finance
PUT YOUR VLOOKUP() FORM
In this column you will use
DEPARTMENT-MAJOR TABLE
‘Department’ each student is in
Major
Management Information Systems
Managerial Finance
Marketing
Real Estate
Management-Human Resources
Marketing
Economics
Real Estate
Management-Human Resources
Marketing
Economics
Managerial Finance
Management-Human Resources
Business Undeclared
Managerial Finance
Management-Human Resources
Marketing
Management-Behavioral
Banking & Finance
Department
Advising
Term
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Last Submision
Date
9/10/2014
9/10/2014
9/10/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
Management-Human Resources
Management-Human Resources
Economics
Banking & Finance
Management-Human Resources
Marketing
Marketing
Marketing
Management-Human Resources
Management Information Systems
Marketing & Corporate Relations
Marketing
Management-Human Resources
Economics
Management-Human Resources
Marketing
Marketing
Business Undeclared
Banking & Finance
Marketing
Business Undeclared
Banking & Finance
Risk Management & Insurance
Business Undeclared
Management-Human Resources
Risk Management & Insurance
Business Undeclared
Marketing
Marketing
Management-Human Resources
Managerial Finance
Marketing
Business Undeclared
Management-Human Resources
Marketing
Managerial Finance
Business Undeclared
Managerial Finance
Marketing & Corporate Relations
Marketing
Marketing
Banking & Finance
Risk Management & Insurance
Management-Human Resources
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/11/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
Business Undeclared
Management Information Systems
Risk Management & Insurance
Management-Behavioral
Banking & Finance
Banking & Finance
Banking & Finance
Banking & Finance
Management-Human Resources
Management-Human Resources
Marketing
Business Undeclared
Marketing
Marketing & Corporate Relations
Marketing & Corporate Relations
Managerial Finance
Marketing
Marketing
Marketing
Marketing
Marketing
Business Undeclared
Management Information Systems
Economics
Managerial Finance
Management-Human Resources
Management-Human Resources
Management-Human Resources
Management-Human Resources
Business Undeclared
Risk Management & Insurance
Marketing
Risk Management & Insurance
Banking & Finance
Managerial Finance
Marketing
Economics
Banking & Finance
Marketing & Corporate Relations
Management-Human Resources
Marketing
Business Undeclared
Economics
Management-Human Resources
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/12/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/13/2014
9/14/2014
9/14/2014
9/14/2014
9/14/2014
9/14/2014
9/16/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
Banking & Finance
Marketing
Management-Human Resources
Risk Management & Insurance
Managerial Finance
Marketing
Marketing
Management-Human Resources
Managerial Finance
Marketing
Management-Human Resources
Management-Human Resources
Business Undeclared
Management-Human Resources
Marketing
Managerial Finance
Managerial Finance
Management Information Systems
Marketing & Corporate Relations
Business Undeclared
Marketing
Marketing
Banking & Finance
Marketing
Management-Human Resources
Management-Behavioral
Business Undeclared
Management-Human Resources
Marketing
Management-Human Resources
Marketing & Corporate Relations
Marketing
Marketing
Managerial Finance
Managerial Finance
Marketing & Corporate Relations
Managerial Finance
Risk Management & Insurance
Banking & Finance
Marketing
Marketing & Corporate Relations
Marketing
Managerial Finance
Business Undeclared
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
Spring – 2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
9/17/2014
Banking & Finance
Marketing
Marketing
Business Undeclared
Marketing
Marketing
Business Undeclared
Business Undeclared
Marke
