Data Validation Dynamic Dropdown: Range contains one of many things, Multiple Criteria

Hi All,   I've been working to come up with solutions for creating a dynamic drop-down for a study plan schedule.    I want the dropdown to depend on what "Term" it is and what "courses" are ...