Bruce Tucker, your boss, sends you this file and gives you the following information. He says he wants your analysis when he returns next week.

$$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

I need in depth steps of how to sort and filter this data exactly, because I don't think I am doing it right.