Year	Semester	Combination	CourseID	Enrollment	Pell Eligible Students Enrolled	Female Students Enrolled	Online?	NumStudents with DFW or I
2011	3	20113	MIS100	32	26	16	YES	23
2011	3	20113	MIS100	30	21	24	YES	13
2012	1	20121	MIS100	31	19	24	YES	7
2012	1	20121	MIS200	30	21	22	YES	17
2012	2	20122	MIS100	35	26	21	YES	23
2012	2	20122	MIS100	34	22	20	YES	3
2013	1	20131	MIS200	30	18	24	YES	3
2013	2	20132	MIS100	35	26	26	YES	17
2013	2	20132	MIS100	31	25	24	YES	19
2013	2	20132	MIS200	34	16	18	YES	2
2013	3	20133	MIS200	32	21	20	YES	7
2014	1	20141	MIS100	31	20	16	YES	5
2014	1	20141	MIS200	31	18	27	YES	7
2014	2	20142	MIS100	32	24	13	YES	20
2014	2	20142	MIS100	31	25	24	YES	19
2014	2	20142	MIS200	32	19	29	YES	8
2015	2	20152	MIS100	32	23	16	YES	23
2015	2	20152	MIS100	32	24	17	YES	17
2015	2	20152	MIS200	30	21	19	YES	13
2016	2	20162	MIS100	32	21	20	YES	6
2016	2	20162	MIS100	34	26	17	YES	23
2016	2	20162	MIS200	33	19	25	YES	10
2016	3	20163	MIS200	32	22	27	YES	1
2017	1	20171	MIS100	30	22	13	YES	15
2017	1	20171	MIS200	31	22	21	YES	17
2017	2	20172	MIS100	35	26	26	YES	18
2017	2	20172	MIS100	34	24	22	YES	24
2017	2	20172	MIS200	30	21	22	YES	18
2018	1	20181	MIS100	30	21	21	YES	15
2018	1	20181	MIS100	31	19	16	YES	10
2018	2	20182	MIS100	33	25	16	YES	14
2018	2	20182	MIS100	33	22	19	YES	7
2018	2	20182	MIS200	30	18	26	YES	7
2019	1	20191	MIS100	30	21	13	YES	14
2019	2	20192	MIS100	34	22	15	YES	5
2019	2	20192	MIS100	35	28	16	YES	24
2019	2	20192	MIS200	35	21	31	YES	4
2020	1	20201	MIS100	31	25	24	YES	15
2020	2	20202	MIS100	33	25	27	YES	22
2020	2	20202	MIS100	33	22	24	YES	2
2020	2	20202	MIS200	34	22	23	YES	5
2020	3	20203	MIS200	32	23	21	YES	18
2021	2	20212	MIS100	30	23	14	YES	19
2021	2	20212	MIS100	33	26	26	YES	17
2021	2	20212	MIS200	35	25	28	YES	21
2012	1	20121	MIS100	14	12	7	NO	8
2012	1	20121	MIS100	19	15	12	NO	10
2012	3	20123	MIS100	15	11	9	NO	11
2012	3	20123	MIS100	15	12	12	NO	8
2012	3	20123	MIS100	29	21	15	YES	19
2012	3	20123	MIS100	13	9	6	NO	3
2013	1	20131	MIS100	14	11	9	NO	9
2013	1	20131	MIS100	27	22	17	YES	16
2013	1	20131	MIS100	20	15	12	NO	13
2013	1	20131	MIS100	15	11	10	NO	9
2013	1	20131	MIS100	15	11	11	NO	6
2013	3	20133	MIS100	25	18	13	YES	15
2013	3	20133	MIS100	13	11	6	NO	7
2013	3	20133	MIS100	14	9	11	NO	3
2013	3	20133	MIS100	23	17	18	NO	12
2013	3	20133	MIS100	22	16	13	NO	15
2014	1	20141	MIS100	15	12	12	NO	9
2014	1	20141	MIS100	17	11	11	NO	5
2014	1	20141	MIS100	26	19	12	YES	17
2014	1	20141	MIS100	25	16	19	NO	3
2014	3	20143	MIS100	27	20	18	YES	14
2014	3	20143	MIS100	26	19	11	YES	16
2014	3	20143	MIS100	29	23	18	YES	19
2014	3	20143	MIS100	13	11	9	NO	6
2014	3	20143	MIS100	14	11	9	NO	10
2015	1	20151	MIS100	28	20	22	YES	19
2015	1	20151	MIS100	25	16	19	NO	1
2015	1	20151	MIS100	15	10	6	NO	4
2015	1	20151	MIS100	18	12	15	NO	2
2015	1	20151	MIS100	25	19	18	NO	17
2015	3	20153	MIS100	20	15	16	NO	12
2015	3	20153	MIS100	21	15	12	NO	15
2015	3	20153	MIS100	13	9	7	NO	4
2015	3	20153	MIS100	14	9	12	NO	1
2015	3	20153	MIS100	14	11	6	NO	10
2016	1	20161	MIS100	29	23	13	YES	13
2016	1	20161	MIS100	25	18	14	YES	16
2016	1	20161	MIS100	22	14	17	NO	5
2016	1	20161	MIS100	17	13	10	NO	12
2016	1	20161	MIS100	18	12	11	NO	3
2016	3	20163	MIS100	25	16	12	NO	7
2016	3	20163	MIS100	15	12	11	NO	7
2016	3	20163	MIS100	27	19	21	YES	12
2016	3	20163	MIS100	15	11	12	NO	11
2016	3	20163	MIS100	22	15	12	NO	6
2017	1	20171	MIS100	22	18	14	NO	12
2017	1	20171	MIS100	14	9	8	NO	4
2017	1	20171	MIS100	16	13	13	NO	8
2017	1	20171	MIS100	23	15	16	NO	5
2017	3	20173	MIS100	16	11	10	NO	3
2017	3	20173	MIS100	26	21	16	YES	13
2017	3	20173	MIS100	26	21	21	NO	12
2017	3	20173	MIS100	18	13	12	NO	12
2017	3	20173	MIS100	26	21	20	YES	18
2018	1	20181	MIS100	20	15	14	NO	10
2018	1	20181	MIS100	24	19	18	NO	16
2018	1	20181	MIS100	23	16	18	NO	6
2018	3	20183	MIS100	13	11	9	NO	7
2018	3	20183	MIS100	18	13	10	NO	11
2018	3	20183	MIS100	16	12	7	NO	10
2018	3	20183	MIS100	18	11	9	NO	3
2018	3	20183	MIS100	26	19	21	NO	11
2019	1	20191	MIS100	13	9	7	NO	2
2019	1	20191	MIS100	22	17	11	NO	14
2019	1	20191	MIS100	16	13	7	NO	11
2019	1	20191	MIS100	23	18	12	NO	15
2019	3	20193	MIS100	28	22	20	YES	16
2019	3	20193	MIS100	21	14	14	NO	4
2019	3	20193	MIS100	13	10	6	NO	7
2019	3	20193	MIS100	12	10	7	NO	6
2019	3	20193	MIS100	15	12	10	NO	8
2020	1	20201	MIS100	14	11	11	NO	10
2020	1	20201	MIS100	27	18	16	YES	4
2020	1	20201	MIS100	29	18	24	YES	2
2020	1	20201	MIS100	27	18	15	YES	6
2020	3	20203	MIS100	28	18	17	YES	3
2020	3	20203	MIS100	18	13	12	NO	13
2020	3	20203	MIS100	24	18	15	NO	16
2020	3	20203	MIS100	24	15	15	NO	6
2020	3	20203	MIS100	12	8	8	NO	4
2021	1	20211	MIS100	23	15	18	NO	1
2021	1	20211	MIS100	20	14	15	NO	11
2021	1	20211	MIS100	29	20	21	YES	2
2021	1	20211	MIS100	22	18	15	NO	15
2021	1	20211	MIS100	26	18	19	NO	6
2021	3	20213	MIS100	19	14	13	NO	11
2021	3	20213	MIS100	20	14	9	NO	8
2021	3	20213	MIS100	23	18	12	NO	15
2021	3	20213	MIS100	23	14	11	NO	1
2021	3	20213	MIS100	22	16	13	NO	10
2011	3	20113	MIS200	25	13	15	NO	2
2012	1	20121	MIS200	20	14	15	NO	13
2012	3	20123	MIS200	22	10	14	NO	3
2012	3	20123	MIS200	25	11	20	NO	6
2013	1	20131	MIS200	21	15	17	NO	10
2013	3	20133	MIS200	29	17	17	YES	5
2013	3	20133	MIS200	22	15	17	NO	3
2014	1	20141	MIS200	26	11	15	NO	5
2014	3	20143	MIS200	16	8	10	NO	3
2014	3	20143	MIS200	18	12	16	NO	2
2014	3	20143	MIS200	14	7	9	NO	2
2015	1	20151	MIS200	25	12	17	NO	6
2015	1	20151	MIS200	16	11	14	NO	1
2015	3	20153	MIS200	26	17	24	NO	5
2015	3	20153	MIS200	15	11	9	NO	7
2015	3	20153	MIS200	14	8	11	NO	4
2016	1	20161	MIS200	12	6	10	NO	0
2016	1	20161	MIS200	26	13	22	NO	6
2016	3	20163	MIS200	20	10	17	NO	6
2016	3	20163	MIS200	23	16	12	NO	2
2017	1	20171	MIS200	12	6	11	NO	3
2017	3	20173	MIS200	18	10	11	NO	4
2017	3	20173	MIS200	13	10	11	NO	6
2017	3	20173	MIS200	20	9	11	NO	3
2018	1	20181	MIS200	23	15	20	NO	4
2018	1	20181	MIS200	14	10	8	NO	6
2018	3	20183	MIS200	26	14	22	NO	2
2018	3	20183	MIS200	29	18	16	NO	3
2018	3	20183	MIS200	18	11	16	NO	3
2019	1	20191	MIS200	25	17	13	NO	3
2019	1	20191	MIS200	28	12	16	NO	3
2019	3	20193	MIS200	27	19	23	NO	13
2019	3	20193	MIS200	12	9	9	NO	7
2019	3	20193	MIS200	26	14	23	NO	3
2020	1	20201	MIS200	15	9	12	NO	1
2020	1	20201	MIS200	20	12	17	NO	5
2020	3	20203	MIS200	15	8	10	NO	4
2020	3	20203	MIS200	14	10	8	NO	8
2021	1	20211	MIS200	21	14	14	NO	5
2021	1	20211	MIS200	26	15	22	NO	3
2021	3	20213	MIS200	17	10	11	NO	4
2021	3	20213	MIS200	21	10	15	NO	4
2021	3	20213	MIS200	15	10	8	NO	4
2012	1	20121	MIS300	18	8	14	YES	4
2012	3	20123	MIS300	20	11	15	YES	5
2013	1	20131	MIS300	21	9	11	YES	4
2013	2	20132	MIS300	32	16	28	YES	2
2013	3	20133	MIS300	29	20	25	YES	5
2013	3	20133	MIS300	23	15	12	YES	7
2014	1	20141	MIS300	20	9	12	YES	1
2014	2	20142	MIS300	32	17	25	YES	5
2014	3	20143	MIS300	14	7	10	NO	4
2014	3	20143	MIS300	19	9	12	YES	2
2015	1	20151	MIS300	25	13	15	YES	3
2015	2	20152	MIS300	32	13	24	YES	10
2015	3	20153	MIS300	26	11	19	YES	3
2015	3	20153	MIS300	27	19	18	YES	16
2016	1	20161	MIS300	30	18	16	YES	2
2016	2	20162	MIS300	34	17	23	YES	10
2016	3	20163	MIS300	30	15	22	YES	7
2016	3	20163	MIS300	15	9	8	YES	5
2017	1	20171	MIS300	31	22	17	YES	21
2017	2	20172	MIS300	33	16	23	YES	2
2017	3	20173	MIS300	25	12	21	YES	4
2017	3	20173	MIS300	19	10	14	YES	4
2018	1	20181	MIS300	27	17	18	YES	0
2018	2	20182	MIS300	32	22	18	YES	4
2018	3	20183	MIS300	23	12	15	YES	3
2018	3	20183	MIS300	16	12	10	YES	8
2019	1	20191	MIS300	14	6	7	NO	5
2019	2	20192	MIS300	35	16	29	YES	9
2019	3	20193	MIS300	16	10	10	YES	3
2019	3	20193	MIS300	16	9	13	YES	2
2020	1	20201	MIS300	19	13	16	YES	2
2020	2	20202	MIS300	30	21	17	YES	19
2020	3	20203	MIS300	16	8	9	YES	5
2020	3	20203	MIS300	15	10	11	YES	5
2021	1	20211	MIS300	14	8	8	NO	2
2021	2	20212	MIS300	35	16	28	YES	11
2021	3	20213	MIS300	29	14	15	YES	8
2021	3	20213	MIS300	30	13	23	YES	3
2012	3	20123	MIS400	13	4	1	NO	2
2013	1	20131	MIS400	16	3	1	YES	4
2013	2	20132	MIS400	12	2	1	NO	3
2013	3	20133	MIS400	23	6	5	YES	7
2014	1	20141	MIS400	22	7	5	YES	3
2014	2	20142	MIS400	19	1	2	YES	6
2014	3	20143	MIS400	25	5	5	YES	3
2015	1	20151	MIS400	17	5	3	YES	2
2015	2	20152	MIS400	15	5	1	YES	4
2015	3	20153	MIS400	25	2	5	YES	4
2016	1	20161	MIS400	18	4	3	YES	0
2016	2	20162	MIS400	15	5	2	YES	4
2016	3	20163	MIS400	26	8	4	YES	7
2017	1	20171	MIS400	18	3	2	YES	2
2017	2	20172	MIS400	17	4	3	YES	0
2017	3	20173	MIS400	22	3	4	YES	2
2018	1	20181	MIS400	18	5	4	YES	5
2018	2	20182	MIS400	12	1	2	NO	2
2018	3	20183	MIS400	23	3	0	YES	7
2019	1	20191	MIS400	15	2	2	YES	3
2019	2	20192	MIS400	12	1	3	NO	2
2019	3	20193	MIS400	26	8	3	YES	7
2020	1	20201	MIS400	16	5	3	YES	1
2020	2	20202	MIS400	14	2	1	NO	3
2020	3	20203	MIS400	27	6	3	YES	2
2021	1	20211	MIS400	14	4	3	NO	3
2021	2	20212	MIS400	15	3	3	YES	2
2021	3	20213	MIS400	26	8	2	YES	6

1. Create a chart that show the number of courses in each category (MIS100, MIS200, MIS300 and MIS400) that are offered online versus not online.
2. Create a table that shows the frequency, relative frequency, and cumulative relative frequency for enrollment in each course category.
3. Create a table that shows the average enrollment by year by course category.
4. Create a table that shows the average enrollment by semester by course category.
5. Create a chart that shows the total number of males and females enrolled in each course by category
6. Create a line chart that shows the enrollment by year for each course category
7. Create a line chart that shows the enrollment by semester and year for each category