Part #1: Download and Work with the Data Open the data in Excel and Explore the Data Using excel on your location computer, apply what you learned in class to clean

and aggregate the data into more useful and meaningful information. Tips: Excel is a very powerful tool that can be a bit overwhelming. For this assignment, make use of column filters, SUM, AVERAGE, and SUBTOTALS functions. 1. In Excel, put your cursor focus on the first cell for the "Student List' table. 2. In the "Data" tab, click the "Filter" button. 3. After clicking the "Filter" button, you should see the header row change to now contain arrows to indicate dropdown filters. Full Student List with Attendance and Midterm Grades Student (Last Name, First Nam Attendan Mid Term Gra Lee, Eli 24 Brown, Jaxon Young, Kimiko n.a 26 13 14.2 13.7 Late Submissi The syntax for the SUBTOTAL function in Excel is- By using the dropdown filters, you can gain more insight into the data by isolating a single collection of data. Section TTh 4-6 PM Online TTh 4-6 PM 4) To find the Average Attendance for a specific section, first add a SUBTOTAL row to the bottom of the table. SUBTOTAL(function_num,ref1,ref2,...) The sub functions that can be performed by declaring the "function_num" are as follows --