Surveys of students in MGSC 1206 were conducted in the fall and winter of the 2019/20 and 2020/21 academic years. Although different survey questions were used in fall versus winter, most of the questions remained the same between the two years. These surveys afford us the opportunity to evaluate some of the impacts of COVID 19 and the move from face to face to online teaching In the fall, it was noted that there were significant demographic changes, namely, a decrease in the proportion of female students and the proportion of students from outside Canada. Overall, enrolments in MGSC 1206 decreased. Students in fall 2020 reported lower summer earnings compared to 2019, especially among international students. Students in fall 2019 also stated that they experienced more frequent episodes of depression than in 2019. Students who take MGSC 1206 in the fall are not "traditional students in that proportionately, there are many more transfer students and more international students. Students are more likely to have started their studies in a previous term, such as January or the preceding year. Students enrolled in MGSC 1206 in the winter are far more likely to have started in September and to have entered directly from high school. Most of them fit the profile of the "traditional" first year Business student, although there are still some who are transfers or started in a different term. Those enrolled in the winter of 2021 are also different from those in fall 2020 because most have experienced a full term of online classes whereas online classes were a total new experience for the fall students. One of the greatest fears of students in winter 2021 was lower grades - at one extreme falling and at the other losing scholarships. This assignment focusses on the changes in academic success of students in 2021 Open the file Assignment 2 data-student surveys 2020 and 2021. xlxs As with Assignment #1, please insert your answers directly into this Word document and then save it as a pdf before submitting it. 1 Select any cell in the Data sheet and Insert a Pivot Table Let us see if the changes in Gender mix is similar to what was observed in the fall. Drag Survey to Rows, Gender to Columns and ID to Values. Change Summary to COUNT, Insert a Pivot Chart Take a screen shot of your pivot table and chart and paste it into your assignment. 2. Format your Table (and Chart) such that only Male and female appear and the table and chart show the percentage of students who are male and female within each year Hide the decimals for the percentages a. Take a screen shot of your pivot table and chart and paste it into your assignment. b. Do you think there has been a significant change in the gender balance? 3. Let us look at where students are from. Drag Survey to Columns, Home to Rows and Show Values as % of Column Total. a. Take a screen shot of your pivot table and chart and paste it into your assignment. b. Hide any blanks. Move Nova Scotia to the 1" row and Canada outside Nova Scotia to the 2 row. Group the remaining locations. Rename this new group International Collapse your groups so the table only shows the 3 rows: Nova Scotia, Canada outside Nova Scotia, and International Take a screen shot of your pivot table and chart and paste it into your assignment. c. Describe any changes in the mix of students between 2020 and 2021. 4 As noted at the start, students in 2021 cited fear of low grades as a major concern. Students in 2020 were not asked this question, but both cohorts were asked how often they worried about grades a. Drag Grade Worty to Rows, Survey year to Columns, scale and format your Table and Chart appropriately to show whether students in 2021 worry more about grades. Take a screen shot of your pivot table and chart and paste it into your assignment. b. Do you think students worry more? Consider what role sample sizes may play in evaluating whether differences are really as large as they appear. c. Drag Gender to Columns, below Survey, so that you are looking at the level of worry for Males vs Females in 2020 and then Males vs Females in 2021. Take a screen shot of your pivot table and chart and paste it into your assignment. d. The chart is rather busy. With 16 combinations, the individual sample sizes may be small and estimates may be imprecise, but comment on whether you think the level of worry has increased and whether it has changed in a similar manner for both Males and Females 5. Changes in level of worry can lead to many different outcomes - increased depression, increased studying.. Changes in depression may also be due to the stress of COVID (COVID causes both worry and depression). Let us look at studying in assignment #1 it was already noted that the average of Hisstud was significantly higher in 2021 2. Drag HosStud to Rows and ID to Values. Change summary to COUNT OF ID. Show the values as relative frequencies. Take a screen shot of your pivot table and chart and paste it into your assignment. b. Group the values, starting at 1 up to 60 in increments of 10. Hide the first group (