1. Engineering
  2. Computer Science
  3. excel macros in a hypothetical class if a student takes...

Question: excel macros in a hypothetical class if a student takes...

Question details

EXCEL MACROSFinal Score Student GPA 3.5 3.7 Student ID udent Na㎡ Test 1 Score Test 2 Score l Joe Hans Ferris Mike Lauren Larry Tony Kevin Sam Zibin Ran Donia Kate Sahar Milos Brian Zane Istiak Kumari John 78 80 92 45 98 75 48 68 59 63 49 87 85 45 21 49 34 91 100 19 Comprehensive Final 87 98 51 87 89 65 89 79 98 95 94 92 49 87 Perform Calculations 98 56 87 49 85 87 83 62 68 59 10 15 62 68 85 98 101 105 108 109 110 115 125 130 145 150 186 4 3.9 3.5 3.6 57 59 49 98 38 87 78 76 3.8 2.9 2.6 2.7 3.8 3.9 3.2 3.1 2.9

In a hypothetical class, if a student takes a comprehensive final and gets a better score than the higher of the two midterm scores, then: (1) the lowest score would be replaced by the comprehensive final’s score, (2) the higher score will be increased by the difference between the higher and lower scores, AND the student will get an extra 3 points added to the comprehensive score. If the student scores higher than only one of the two midterm scores, only that particular midterm score is replaced by the final. The final score will then be calculated by averaging the three test scores. Calculate the final score using the given data presented in the “Question1” worksheet. Note: for this question all your procedures (subs and/or functions) should be stored in the Question1_Module.
Task 1: Code a function that requires test 1 score, test 2 score, and comprehensive final as inputs and calculates the final score per the description above
Task 2: Code a subroutine that uses the function coded in part (a) to fill column F of the worksheet, and link this subroutine to the “Perform Calculations” button in the worksheet.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution