Group project: Join another student class to complete one of these two project options.

Project option 1

Data: The list of courses offered at Murray State is available here Murray State Classes - Classes.html (https://murraystate.instructure.com/courses/1437289/files/72186563?wrap=1)↓ (https://murraystate.instructure.com/courses/1437289/files/72186563/download?download_frd=1)

Using the data in the file as the source, create an app that will

1. allow the user to view its contents. The app should allow the user to view a list of courses by typing in values for one or more of these columns: CRN, Subj and Crse, Instructor (partial name also),

2. build a schedule for a student who needs to take 3 or more courses. The schedule must not have time conflicts. The schedule cannot have more than one Web class and

3. Build a schedule for a teacher. Given a teacher's name, list the classes he/she will be teaching by weekday and time

Project option 2

Data: The list of courses offered at Murray State is available at Murray State Classes - Classes.html (https://murraystate.instructure.com/courses/1437289/files/72186563?wrap=1)↓ (https://murraystate.instructure.com/courses/1437289/files/72186563/download?download_frd=1)

Create an app that

1. accepts the Subj, and Crse as inputs from the user. The app would display a clustered bar chart of Cap, Act, Rem for each section of that course. The chart shows capacities in descending order.

2. Accepts a name (maybe partial) of an instructor and lists the courses he/she will be teaching. It will also display a pie chart showing course and section numbers, and the Actual enrollments as values

3. Given 2 to 4 teacher names, determine what times they are free to meet (All time periods minus the union of their class times) each day of the week

Deliverables:

1. Python scripts

.py or .ipynb files

⚫.db file if you are using an SQLite3 database