Exam 1 Project Quiz HW Exam2 100 100 58 1233 8 BB student name 3 points Anderson David Casteel David Greath Joseph Hall Donn Harper Ronald Miller Joanna Pate Wam Shelton Stephen Smith Kirk Smith Sheldon Waye Patrick 980 7453 0.00% 0.00% 69.33% 72.05% 000 70.03% 69.085 71.45% 0.00% 92.30% 10.33 63 67 890 0 13.50 100 Home Work 1: Developing an Active X application in Excel 1 Read in the dataset combination of strings and numbers) 2 Determine the overall grade metrics for each person using the formula 25% of Exam 25% of Exam 20% of Proct 15% and 15% of homework 3 Note each exam is out of 100 pts the project is graded for 50 points. Ouzout of 100 points and the home work grade is already calculated out of 15% 4 Write an excel ActiveX macro with 3 buttons (like the one discussed in clas) to do the following a Determine the composto grade (2 decimals) for each student in Column G Design a button to do this operation b. Sort the roster with descending composite score in Column P Column O should have the corresponding students name Design a button to do this operation Now assign the students grade in Column in red bold) 90 to 100 A 80 1089 B 70-79 C00-00 59 F Design a button to do this operation 5 Upload your macro enabled worksheet to canvas 6 There we some useful hints on the Hints Sheet Exam 1 Project Quiz HW Exam2 100 100 58 1233 8 BB student name 3 points Anderson David Casteel David Greath Joseph Hall Donn Harper Ronald Miller Joanna Pate Wam Shelton Stephen Smith Kirk Smith Sheldon Waye Patrick 980 7453 0.00% 0.00% 69.33% 72.05% 000 70.03% 69.085 71.45% 0.00% 92.30% 10.33 63 67 890 0 13.50 100 Home Work 1: Developing an Active X application in Excel 1 Read in the dataset combination of strings and numbers) 2 Determine the overall grade metrics for each person using the formula 25% of Exam 25% of Exam 20% of Proct 15% and 15% of homework 3 Note each exam is out of 100 pts the project is graded for 50 points. Ouzout of 100 points and the home work grade is already calculated out of 15% 4 Write an excel ActiveX macro with 3 buttons (like the one discussed in clas) to do the following a Determine the composto grade (2 decimals) for each student in Column G Design a button to do this operation b. Sort the roster with descending composite score in Column P Column O should have the corresponding students name Design a button to do this operation Now assign the students grade in Column in red bold) 90 to 100 A 80 1089 B 70-79 C00-00 59 F Design a button to do this operation 5 Upload your macro enabled worksheet to canvas 6 There we some useful hints on the Hints Sheet