https://drive.google.com/open?id=1fqofypZ5H15k5ZwIX9u99qO_46BuEJV-

"Once you organize this data set. I need you to analyze the 18-19 academic year (summer, fall, winter, spring) enrollment by course and term. I am giving a presentation to the new Provost in an attempt to convince her to invest more money in the undergraduate business program because we are growing both online and on campus. I think the following stats will be convincing: Popularity of our undergraduate classes (numbers 100-499, please exclude 400-410 course numbers) By concentration and BA core Fill rate and total enrollment What term/meeting day is the most popular and which is the least? Fill rate and total enrollment What is the ratio of ground campus classes versus online courses? By concentration and BA core Schedule_Type_Desc % city Meeting_Location_1 Subj Course Subj Desc Actual Enrl Meeting_Time_1 CTG TG 281 Accounting Accounting Lecture 25 83% WEB 335 33 73% MTWR 1030-1250 KMC 560 Lecture TG 381 Accounting Accounting Lecture 36 65% WEB TG CTG CTG TG TG MTWR 1730-1950 SH 212 382 Lecture 44 85% By-Arrangement In-Person By-Arrangement In-Person By-Arrangement In-Person 404 Accounting Accounting Experiential Learning Experiential Learning Experiential Learning Experiential Learning Experiential Learning Experiential Learning 404 1 Accounting Accounting 404 1 404 5% WEB TG TG TG 404 Accounting Accounting Accounting Accounting Accounting 0% WEB 404 5 25% WEB MTWR 1030-1250 KMC 560 407 Seminar 17 57% TG Experiential Learning By-Arrangement In-Person 409 1 TG TG CTG TG M 1730-1950 430 Lecture 45 75% KMC 470 470 492 Accounting Accounting Accounting Lecture 104% MW 1030-1250 MTWR 1030-1250 SEH 106 495 Lecture 14 58% W 1740-2140 42 84% 560 Lecture KMC 470 01 02 101 205 211 211 213 299 299 301 301 301 302 302 302 302 303 303 303 311 311 311 Business Administration Schedule Type not declared 0 0% B Business Administration Schedule Type not declared KMC 465 Business Administration Lecture 31 52% TR 1030-1250 | BA | Business Administration Lecture 40 80% T 1030-1250 BDWY 222 Business Administration Lecture 20% MTWR 0915-1135 SRTC 155 Business Administration PKM 183 Lecture 38 84% TR 1300-1520 45 100% Business Administration Lecture MTWR 1030-1250 KMC 470 Lecture OFFCAM Business Administration 2 4% B Business Administration 4% OFFCAM Lecture 2 | Business Administration Lecture 38 109% WEB WEB 460 Business Administration Lecture 43 96% | Business Administration Lecture 44 98% TR 0800-1020 Lecture 96% Business Administration 43 WEB |B Lecture Business Administration 29 64% WEB B Business Administration Lecture 28 62% MW 1030-1250 KMC 255 B B 2 Business Administration Lecture 4% OFFCAM Business Administration Lecture 36 65% WEB B Business Administration 49 109% MW 1300-1520 KMC 460 Lecture | BA FAB 47 WEB Business Administration Lecture 37 82% TR 1645-1905 Business Administration Lecture 44 98% BA TR 1300-1520 Business Administration Lecture 34 76% CIN 90 Business Administration Lecture 37 82% W 1715-2140 KMC 460 311 311 325 B Business Administration Lecture 12 48% OFFCAM Business Administration Lecture 3 12% OFFCAM B Business Administration 39 87% Lecture WEB "Once you organize this data set. I need you to analyze the 18-19 academic year (summer, fall, winter, spring) enrollment by course and term. I am giving a presentation to the new Provost in an attempt to convince her to invest more money in the undergraduate business program because we are growing both online and on campus. I think the following stats will be convincing: Popularity of our undergraduate classes (numbers 100-499, please exclude 400-410 course numbers) By concentration and BA core Fill rate and total enrollment What term/meeting day is the most popular and which is the least? Fill rate and total enrollment What is the ratio of ground campus classes versus online courses? By concentration and BA core Schedule_Type_Desc % city Meeting_Location_1 Subj Course Subj Desc Actual Enrl Meeting_Time_1 CTG TG 281 Accounting Accounting Lecture 25 83% WEB 335 33 73% MTWR 1030-1250 KMC 560 Lecture TG 381 Accounting Accounting Lecture 36 65% WEB TG CTG CTG TG TG MTWR 1730-1950 SH 212 382 Lecture 44 85% By-Arrangement In-Person By-Arrangement In-Person By-Arrangement In-Person 404 Accounting Accounting Experiential Learning Experiential Learning Experiential Learning Experiential Learning Experiential Learning Experiential Learning 404 1 Accounting Accounting 404 1 404 5% WEB TG TG TG 404 Accounting Accounting Accounting Accounting Accounting 0% WEB 404 5 25% WEB MTWR 1030-1250 KMC 560 407 Seminar 17 57% TG Experiential Learning By-Arrangement In-Person 409 1 TG TG CTG TG M 1730-1950 430 Lecture 45 75% KMC 470 470 492 Accounting Accounting Accounting Lecture 104% MW 1030-1250 MTWR 1030-1250 SEH 106 495 Lecture 14 58% W 1740-2140 42 84% 560 Lecture KMC 470 01 02 101 205 211 211 213 299 299 301 301 301 302 302 302 302 303 303 303 311 311 311 Business Administration Schedule Type not declared 0 0% B Business Administration Schedule Type not declared KMC 465 Business Administration Lecture 31 52% TR 1030-1250 | BA | Business Administration Lecture 40 80% T 1030-1250 BDWY 222 Business Administration Lecture 20% MTWR 0915-1135 SRTC 155 Business Administration PKM 183 Lecture 38 84% TR 1300-1520 45 100% Business Administration Lecture MTWR 1030-1250 KMC 470 Lecture OFFCAM Business Administration 2 4% B Business Administration 4% OFFCAM Lecture 2 | Business Administration Lecture 38 109% WEB WEB 460 Business Administration Lecture 43 96% | Business Administration Lecture 44 98% TR 0800-1020 Lecture 96% Business Administration 43 WEB |B Lecture Business Administration 29 64% WEB B Business Administration Lecture 28 62% MW 1030-1250 KMC 255 B B 2 Business Administration Lecture 4% OFFCAM Business Administration Lecture 36 65% WEB B Business Administration 49 109% MW 1300-1520 KMC 460 Lecture | BA FAB 47 WEB Business Administration Lecture 37 82% TR 1645-1905 Business Administration Lecture 44 98% BA TR 1300-1520 Business Administration Lecture 34 76% CIN 90 Business Administration Lecture 37 82% W 1715-2140 KMC 460 311 311 325 B Business Administration Lecture 12 48% OFFCAM Business Administration Lecture 3 12% OFFCAM B Business Administration 39 87% Lecture WEB