Exam bank: Crosslisted exams

[some-molasses]

ahahahahahaha these exist??

So as it turns out, one course can exist under multiple departments with multiple course codes. We need to be able to handle this in the exam naming structures.

We'll need to do a set of things:

1. We need to update the exam naming structure to handle crosslisted exams.
2. When looking through the exam bank, we need to see exams listed under each associated course code.
3. When uploading exams, we need to be able to add multiple course codes.
4. We need to update the existing crosslisted exams.

Here's the full list of error messages from the exam migration script:

Pre-existing course at 11363, trying to write CS 371 but found AMATH 341
Pre-existing course at 11497, trying to write CS 467 but found CO 481
Pre-existing course at 4436, trying to write CS 487 but found AMATH 447
Pre-existing course at 3323, trying to write PMATH 331 but found AMATH 331
Pre-existing course at 3324, trying to write PMATH 332 but found AMATH 332
Pre-existing course at 3325, trying to write PMATH 365 but found AMATH 333
Pre-existing course at 3348, trying to write PMATH 451 but found AMATH 431
Pre-existing course at 3349, trying to write PMATH 453 but found AMATH 432
Pre-existing course at 3350, trying to write PMATH 465 but found AMATH 433
Pre-existing course at 4408, trying to write STAT 340 but found CS 437
Pre-existing course at 3305, trying to write STAT 446 but found ACTSC 446
Pre-existing course at 11363, trying to write CM 271 but found CS 371
Pre-existing course at 4392, trying to write CM 339 but found CS 341
Pre-existing course at 11440, trying to write CM 340 but found CO 352
Pre-existing course at 11451, trying to write CM 352 but found AMATH 342
Pre-existing course at 11431, trying to write CM 361 but found STAT 341
Pre-existing course at 11444, trying to write CM 372 but found CS 372
Pre-existing course at 10136, trying to write CM 432 but found CO 487
Pre-existing course at 4436, trying to write CM 433 but found CS 487
Pre-existing course at 12236, trying to write CM 434 but found PMATH 434
Pre-existing course at 11442, trying to write CM 441 but found CO 353
Pre-existing course at 3898, trying to write CM 442 but found CO 367
Pre-existing course at 3899, trying to write CM 443 but found CO 370
Pre-existing course at 11448, trying to write CM 452 but found AMATH 452
Pre-existing course at 11443, trying to write CM 454 but found AMATH 454
Pre-existing course at 8883, trying to write CM 461 but found STAT 440
Pre-existing course at 11434, trying to write CM 462 but found STAT 442
Pre-existing course at 8884, trying to write CM 463 but found STAT 441
Pre-existing course at 11436, trying to write CM 464 but found STAT 444
Pre-existing course at 4428, trying to write CM 472 but found CS 472
Pre-existing course at 11446, trying to write CM 473 but found CS 473
Pre-existing course at 4254, trying to write CIVE 572 but found CIVE 472
Pre-existing course at 6891, trying to write ECE 205 but found MATH 211
Pre-existing course at 6892, trying to write ECE 206 but found MATH 212
Pre-existing course at 4413, trying to write ECE 451 but found CS 445
Pre-existing course at 4414, trying to write ECE 452 but found CS 446
Pre-existing course at 11496, trying to write ENVE 153 but found CIVE 153
Pre-existing course at 5256, trying to write ENVE 573 but found ENVE 473
Pre-existing course at 5257, trying to write ENVE 577 but found ENVE 477
Pre-existing course at 11496, trying to write GEOE 153 but found ENVE 153
Pre-existing course at 6420, trying to write HLTH 100 but found GERON 100
Pre-existing course at 6428, trying to write HLTH 218 but found GERON 218
Pre-existing course at 6429, trying to write HLTH 220 but found GERON 220
Pre-existing course at 6430, trying to write HLTH 245 but found GERON 245
Pre-existing course at 6438, trying to write HLTH 352 but found GERON 352
Pre-existing course at 6440, trying to write HLTH 400 but found GERON 400
Pre-existing course at 6434, trying to write KIN 346 but found HLTH 346
Pre-existing course at 6435, trying to write KIN 348 but found HLTH 348
Pre-existing course at 6436, trying to write KIN 349 but found HLTH 349
Pre-existing course at 6438, trying to write KIN 352 but found HLTH 352
Pre-existing course at 6441, trying to write KIN 407 but found HLTH 407
Pre-existing course at 6438, trying to write REC 362 but found KIN 352
Pre-existing course at 11910, trying to write BIOL 382 but found AMATH 382
Pre-existing course at 3320, trying to write PHYS 263 but found AMATH 261
Pre-existing course at 3369, trying to write PHYS 454 but found AMATH 473
Pre-existing course at 11497, trying to write PHYS 467 but found CS 467
Pre-existing course at 3371, trying to write PHYS 476 but found AMATH 475
Pre-existing course at 6156, trying to write SCI 255 but found GERON 255
Pre-existing course at 11750, trying to write AFM 272 but found ACTSC 291
Pre-existing course at 11751, trying to write AFM 372 but found ACTSC 391
Pre-existing course at 11760, trying to write AFM 476 but found ACTSC 471
Pre-existing course at 12283, trying to write ARTS 280 but found CO 252
Pre-existing course at 3396, trying to write CLAS 205 but found ANTH 201
Pre-existing course at 3446, trying to write CLAS 321 but found ANTH 321
Pre-existing course at 9898, trying to write DAC 303 but found ARTS 303
Pre-existing course at 12452, trying to write DAC 304 but found ARTS 304
Pre-existing course at 4283, trying to write DRAMA 251 but found CLAS 266
Pre-existing course at 4700, trying to write DRAMA 348 but found REC 348
Pre-existing course at 4296, trying to write DRAMA 385 but found CLAS 365
Pre-existing course at 12408, trying to write ECON 442 but found ME 547
Pre-existing course at 11680, trying to write ENGL 203 but found DAC 201
Pre-existing course at 11681, trying to write ENGL 204 but found DAC 202
Pre-existing course at 4686, trying to write ENGL 235 but found DRAMA 317
Pre-existing course at 11682, trying to write ENGL 303 but found DAC 300
Pre-existing course at 5148, trying to write ENGL 316 but found DRAMA 380
Pre-existing course at 4682, trying to write ENGL 361 but found DRAMA 311
Pre-existing course at 5166, trying to write ENGL 362 but found DRAMA 386
Pre-existing course at 5167, trying to write ENGL 363 but found DRAMA 387
Pre-existing course at 11683, trying to write ENGL 403 but found DAC 400
Pre-existing course at 10177, trying to write FINE 260 but found ARTS 260
Pre-existing course at 5478, trying to write FINE 310 but found CLAS 351
Pre-existing course at 5480, trying to write FINE 311 but found CLAS 352
Pre-existing course at 10103, trying to write FINE 333 but found DRAMA 333
Pre-existing course at 10104, trying to write FINE 334 but found DRAMA 334
Pre-existing course at 4694, trying to write FINE 335 but found DRAMA 331
Pre-existing course at 4695, trying to write FINE 336 but found DRAMA 332
Pre-existing course at 12204, trying to write FINE 337 but found DRAMA 335
Pre-existing course at 11908, trying to write FINE 365 but found DRAMA 396
Pre-existing course at 4687, trying to write FINE 366 but found DRAMA 318
Pre-existing course at 11712, trying to write FINE 367 but found DRAMA 393
Pre-existing course at 11714, trying to write FINE 375 but found DRAMA 395
Pre-existing course at 11401, trying to write FINE 376 but found DRAMA 392
Pre-existing course at 11713, trying to write FINE 377 but found DRAMA 394
Pre-existing course at 5912, trying to write GEOG 323 but found REC 383
Pre-existing course at 5919, trying to write GEOG 333 but found REC 333
Pre-existing course at 5992, trying to write GEOG 405 but found BIOL 453
Pre-existing course at 11596, trying to write GER 250 but found DRAMA 250
Pre-existing course at 11606, trying to write GER 359 but found FINE 359
Pre-existing course at 8456, trying to write RUSS 341 but found DRAMA 381
Pre-existing course at 8457, trying to write RUSS 342 but found DRAMA 382
Pre-existing course at 9918, trying to write RUSS 356 but found DRAMA 384
Pre-existing course at 6230, trying to write HIST 205 but found REC 202
Pre-existing course at 6241, trying to write HIST 210 but found CLAS 210
Pre-existing course at 12407, trying to write HIST 214 but found ME 538
Pre-existing course at 6279, trying to write HIST 237 but found CLAS 237
Pre-existing course at 4278, trying to write HIST 242 but found CLAS 251
Pre-existing course at 4279, trying to write HIST 252 but found CLAS 252
Pre-existing course at 12303, trying to write HIST 312 but found STV 100
Pre-existing course at 4929, trying to write INTTS 301 but found ECON 334
Pre-existing course at 4936, trying to write INTTS 302 but found ECON 344
Pre-existing course at 6528, trying to write ITALST 311 but found ITAL 311
Pre-existing course at 6529, trying to write ITALST 312 but found ITAL 312
Pre-existing course at 6530, trying to write ITALST 391 but found ITAL 391
Pre-existing course at 6531, trying to write ITALST 392 but found ITAL 392
Pre-existing course at 12273, trying to write ITALST 394 but found ITAL 394
Pre-existing course at 6532, trying to write ITALST 396 but found ITAL 396
Pre-existing course at 6533, trying to write ITALST 397 but found ITAL 397
Pre-existing course at 7053, trying to write MUSIC 365 but found RUSS 371
Pre-existing course at 3945, trying to write NATST 370 but found ANTH 370
Pre-existing course at 11120, trying to write PACS 203 but found HIST 232
Pre-existing course at 8523, trying to write PHIL 258 but found SCI 267
Pre-existing course at 5811, trying to write PHIL 315 but found GENE 412
Pre-existing course at 7324, trying to write PHIL 380 but found CLAS 361
Pre-existing course at 7325, trying to write PHIL 381 but found CLAS 362
Pre-existing course at 6428, trying to write PSYCH 218 but found HLTH 218
Pre-existing course at 7293, trying to write PSYCH 256 but found PHIL 256
Pre-existing course at 9530, trying to write PSYCH 446 but found PHIL 446
Pre-existing course at 10108, trying to write RS 120 but found JS 120
Pre-existing course at 10109, trying to write RS 130 but found JS 130
Pre-existing course at 10119, trying to write RS 150 but found JS 150
Pre-existing course at 7281, trying to write RS 202 but found PHIL 237
Pre-existing course at 11635, trying to write RS 203 but found JS 203
Pre-existing course at 10110, trying to write RS 204 but found JS 125
Pre-existing course at 8297, trying to write RS 205 but found JS 205
Pre-existing course at 8308, trying to write RS 217 but found JS 217
Pre-existing course at 8318, trying to write RS 230 but found HIST 235
Pre-existing course at 10111, trying to write RS 232 but found JS 210
Pre-existing course at 11636, trying to write RS 233 but found JS 233
Pre-existing course at 8323, trying to write RS 234 but found HIST 234
Pre-existing course at 12171, trying to write RS 240 but found JS 211
Pre-existing course at 11983, trying to write RS 250 but found JS 250
Pre-existing course at 8329, trying to write RS 257 but found PACS 320
Pre-existing course at 8377, trying to write RS 322 but found HIST 348
Pre-existing course at 8378, trying to write RS 325 but found HIST 304
Pre-existing course at 4290, trying to write RS 326 but found CLAS 325
Pre-existing course at 12189, trying to write RS 340 but found PACS 326
Pre-existing course at 3440, trying to write RS 361 but found ANTH 311
Pre-existing course at 7051, trying to write RS 384 but found MUSIC 363
Pre-existing course at 7052, trying to write RS 385 but found MUSIC 364
Pre-existing course at 8112, trying to write SOC 210 but found REC 203
Pre-existing course at 8311, trying to write SOC 258 but found RS 220
Pre-existing course at 8309, trying to write SOC 260 but found RS 218
Pre-existing course at 8310, trying to write SOC 261 but found RS 219
Pre-existing course at 8312, trying to write SOC 262 but found RS 221
Pre-existing course at 8130, trying to write SOC 347 but found REC 301
Pre-existing course at 6438, trying to write SOC 352 but found REC 362
Pre-existing course at 7322, trying to write SOC 371 but found PHIL 362
Pre-existing course at 10232, trying to write SOC 402 but found RS 402
Pre-existing course at 4662, trying to write SPCOM 102 but found DRAMA 102
Pre-existing course at 11682, trying to write SPCOM 300 but found ENGL 303
Pre-existing course at 4692, trying to write SPCOM 326 but found DRAMA 326
Pre-existing course at 11683, trying to write SPCOM 400 but found ENGL 403
Pre-existing course at 11393, trying to write SPCOM 434 but found HIST 309
Pre-existing course at 11906, trying to write SPCOM 440 but found DRAMA 440
Pre-existing course at 8542, trying to write SIPAR 270 but found RS 270
Pre-existing course at 8543, trying to write SIPAR 271 but found RS 271
Pre-existing course at 10102, trying to write SIPAR 378 but found RS 378
Pre-existing course at 8547, trying to write SIPAR 380 but found RS 380
Pre-existing course at 12301, trying to write WS 202 but found MTHEL 400
Pre-existing course at 8331, trying to write WS 261 but found RS 261
Pre-existing course at 11198, trying to write WS 281 but found RUSS 281
Pre-existing course at 7509, trying to write PLAN 255 but found GEOG 255
Pre-existing course at 5909, trying to write PLAN 320 but found GEOG 319
Pre-existing course at 7559, trying to write PLAN 341 but found GEOG 368
Pre-existing course at 7561, trying to write PLAN 349 but found GEOG 349
Pre-existing course at 5905, trying to write PLAN 351 but found GEOG 316
Pre-existing course at 5908, trying to write PLAN 353 but found GEOG 318
Pre-existing course at 5943, trying to write PLAN 355 but found GEOG 355
Pre-existing course at 8208, trying to write PLAN 414 but found REC 425
Pre-existing course at 6014, trying to write PLAN 455 but found GEOG 455
Pre-existing course at 9505, trying to write PLAN 457 but found GEOG 457
Pre-existing course at 4249, trying to write PLAN 478 but found CIVE 440
Pre-existing course at 9498, trying to write PLAN 555 but found GEOG 555