Spreadsheet: 165978d1341415228-sorting-a-class-schedule-random-sort
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Class 1
 |  |  |  | Student # | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 25 | 12 | 34 | 14 | 6 | 16 | 6 | A | A | A | A | A | A | A
 |  |  |  | 2 |  |  |  |  |  |  |  |  | 1 | 8 | 22 | 24 | 3 | 17 | 11 | 19 | A | A | A | A | A | A | A
 |  |  |  | 3 |  |  |  |  |  |  |  |  | 1 | 31 | 8 | 11 | 27 | 18 | 2 | 26 | A | A | A | A | A | A | A
 |  |  |  | 4 |  |  |  |  |  |  |  |  | 1 | 32 | 25 | 28 | 22 | 12 | 10 | 30 | A | A | A | A | A | A | A
 |  |  |  | 5 |  |  |  |  |  |  |  |  | 1 | 24 | 30 | 4 | 16 | 24 | 18 | 15 | A | A | A | A | A | A | A
 |  |  |  | 6 |  |  |  |  |  |  |  |  | 2 | 34 | 33 | 10 | 12 | 1 | 6 | 29 | B | B | B | B | B | B | B
 |  |  |  | 7 |  |  |  |  |  |  |  |  | 2 | 28 | 21 | 30 | 6 | 7 | 5 | 8 | B | B | B | B | B | B | B
 |  |  |  | 8 |  |  |  |  |  |  |  |  | 2 | 35 | 28 | 5 | 35 | 4 | 31 | 12 | B | B | B | B | B | B | B
 |  |  |  | 9 |  |  |  |  |  |  |  |  | 2 | 19 | 23 | 19 | 26 | 16 | 32 | 13 | B | B | B | B | B | B | B
 |  |  |  | 10 |  |  |  |  |  |  |  |  | 2 | 2 | 16 | 3 | 31 | 31 | 30 | 28 | B | B | B | B | B | B | B
 |  |  |  | 11 |  |  |  |  |  |  |  |  | 3 | 14 | 31 | 26 | 10 | 22 | 1 | 9 | C | C | C | C | C | C | C
 |  |  |  | 12 |  |  |  |  |  |  |  |  | 3 | 6 | 5 | 17 | 17 | 13 | 24 | 22 | C | C | C | C | C | C | C
 |  |  |  | 13 |  |  |  |  |  |  |  |  | 3 | 27 | 29 | 14 | 19 | 33 | 8 | 32 | C | C | C | C | C | C | C
 |  |  |  | 14 |  |  |  |  |  |  |  |  | 3 | 12 | 11 | 1 | 4 | 26 | 23 | 27 | C | C | C | C | C | C | C
 |  |  |  | 15 |  |  |  |  |  |  |  |  | 3 | 16 | 20 | 12 | 30 | 2 | 33 | 23 | C | C | C | C | C | C | C
 |  |  |  | 16 |  |  |  |  |  |  |  |  | 4 | 7 | 1 | 13 | 32 | 9 | 4 | 20 | D | D | D | D | D | D | D
 |  |  |  | 17 |  |  |  |  |  |  |  |  | 4 | 1 | 9 | 7 | 5 | 27 | 14 | 17 | D | D | D | D | D | D | D
 |  |  |  | 18 |  |  |  |  |  |  |  |  | 4 | 4 | 27 | 22 | 18 | 11 | 13 | 7 | D | D | D | D | D | D | D
 |  |  |  | 19 |  |  |  |  |  |  |  |  | 4 | 10 | 2 | 8 | 15 | 14 | 28 | 5 | D | D | D | D | D | D | D
 |  |  |  | 20 |  |  |  |  |  |  |  |  | 4 | 15 | 10 | 2 | 29 | 23 | 12 | 4 | D | D | D | D | D | D | D
 |  |  |  | 21 |  |  |  |  |  |  |  |  | 5 | 33 | 15 | 35 | 9 | 32 | 15 | 10 | E | E | E | E | E | E | E
 |  |  |  | 22 |  |  |  |  |  |  |  |  | 5 | 22 | 32 | 16 | 1 | 5 | 22 | 34 | E | E | E | E | E | E | E
 |  |  |  | 23 |  |  |  |  |  |  |  |  | 5 | 9 | 24 | 18 | 7 | 21 | 34 | 31 | E | E | E | E | E | E | E
 |  |  |  | 24 |  |  |  |  |  |  |  |  | 5 | 23 | 6 | 21 | 25 | 20 | 3 | 18 | E | E | E | E | E | E | E
 |  |  |  | 25 |  |  |  |  |  |  |  |  | 5 | 20 | 13 | 29 | 28 | 10 | 7 | 3 | E | E | E | E | E | E | E
 |  |  |  | 26 |  |  |  |  |  |  |  |  | 6 | 11 | 19 | 20 | 13 | 28 | 17 | 11 | F | F | F | F | F | F | F
 |  |  |  | 27 |  |  |  |  |  |  |  |  | 6 | 18 | 14 | 31 | 8 | 8 | 21 | 21 | F | F | F | F | F | F | F
 |  |  |  | 28 |  |  |  |  |  |  |  |  | 6 | 3 | 7 | 15 | 2 | 30 | 26 | 35 | F | F | F | F | F | F | F
 |  |  |  | 29 |  |  |  |  |  |  |  |  | 6 | 5 | 17 | 23 | 23 | 35 | 19 | 14 | F | F | F | F | F | F | F
 |  |  |  | 30 |  |  |  |  |  |  |  |  | 6 | 21 | 4 | 32 | 11 | 3 | 35 | 1 | F | F | F | F | F | F | F
 |  |  |  | 31 |  |  |  |  |  |  |  |  | 7 | 29 | 18 | 6 | 20 | 34 | 27 | 16 | G | G | G | G | G | G | G
 |  |  |  | 32 |  |  |  |  |  |  |  |  | 7 | 30 | 26 | 27 | 21 | 15 | 29 | 24 | G | G | G | G | G | G | G
 |  |  |  | 33 |  |  |  |  |  |  |  |  | 7 | 17 | 34 | 33 | 24 | 19 | 20 | 33 | G | G | G | G | G | G | G
 |  |  |  | 34 |  |  |  |  |  |  |  |  | 7 | 13 | 3 | 25 | 33 | 29 | 9 | 25 | G | G | G | G | G | G | G
 |  |  |  | 35 |  |  |  |  |  |  |  |  | 7 | 26 | 35 | 9 | 34 | 25 | 25 | 2 | G | G | G | G | G | G | G