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. Make sure your NumStudents with DFW or I variable is your last column if you are planning to use Excel for your analysis (in Excel, your independent variables need to be contiguous to run regressions).
2. In column J, recode Online? into a dummy variable where the value is 1 if the course is offered online (YES).
3. In column K, create a dummy variable MIS100 and place a value of 1 for the observation if the course taught was MIS100 and 0 if it was any other course.
4. In column L, create a dummy variable MIS200 and place a value of 1 for the observation if the course taught was MIS200 and 0 if it was any other course.
5. In column M, create a dummy variable MIS300 and place a value of 1 for the observation if the course taught was MIS300 and 0 if it was any other course.
6. In column N, create a dummy variable Semester1 and place a value of 1 for the observation if the course was taught during when Semester equals 1 and 0 if it was not.
7. In column O, create a dummy variable Semester2 and place a value of 1 for the observation if the course was taught during when Semester equals 2 and 0 if it was not.
8. In column P, create a dummy variable MajorityPellEligible and place a value of 1 for the observation if the course had an enrollment of 67% or higher Pell Eligible students (e.g., if Pell Eligible Students Enrolled/Enrollment>=.67, the value should be 1, otherwise it should be 0).
9. In column Q, create a dummy variable MajorityFemale and place a value of 1 for the observation if the course had an enrollment of 67% or higher Female students (e.g., if Female Students Enrolled/Enrollment>=.67, the value should be 1, otherwise it should be 0).