The Student Ticket Lottery

Lottery process is run internally via a Python script for each game individually

Collegiate Club:

1. An Excel file is created that contains each student’s ID and their corresponding relevant data
   1. The data helps identify who is a member of the Collegiate Club and what class the student is in
2. The Excel files are passed into the script and all of the student IDs are randomly shuffled
3. The script identifies which students are collegiate club members, shuffles the student IDs again, and randomly selects 1,800 students to receive a ticket. (Any Collegiate Club member who is not selected, will then be added to their respective class lottery for another chance at a ticket)

Non-Collegiate Club Students:

1. The script identifies all of the graduate students, shuffles all of their student IDs again, and randomly selects 300 of them to receive a ticket*
2. The script identifies all of the seniors, shuffles all of their student IDs again, and randomly selects 1,000 of them to receive a ticket*
3. The script identifies all of the juniors, shuffles all of their student IDs again, and randomly selects 750 of them to receive a ticket*
4. The script identifies all of the sophomores, shuffles all of their student IDs again, and randomly selects 500 of them to receive a ticket*
5. The script identifies all of the freshmen, shuffles all of their student IDs again, and randomly selects 400 of them to receive a ticket*

*This includes any students who are Collegiate Club members and DID NOT get allocated a ticket during the Collegiate Club lottery

• Next, all of the winners and losers for each lottery are combined into one file
• Finally, the script prints the results for each game to an Excel file (split by winners and losers) to be sent back to the ticket office

Join IPTAY Collegiate Club by Aug. 17 to be considered for the lottery!