Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Description: In a hypothetical class, students take two midterms and an optional final. If a student takes the final and gets in it a better score than the lowest of the two midterm scores, then the lowest midterm score would be replaced by the comprehensive final score. The overall score will then be calculated by averaging the three test scores. If the student does not take the optional final, the overall score is calculated using only the two midterm scores. Students’ exam scores are included in the “Question1” tab in the attached worksheet. Empty data entries for the optional comprehensive final means that the student did not take the optional final. Tasks: Task 1: In Question1_Module, code a function that requires midterm1 score, midterm2 score, and comprehensive final as inputs and calculate the overall score per the description above. Task 2: In Question1_Module, code a Sub that uses the function coded in task 1 to fill column ‘I’ of the worksheet and link this sub to the “Perform Calculations” button in the worksheet. Task 3: In Question2_Module, Create a Record Type “Student” that contains the following fields i. StudentID ii. FinalScore iii. ComprehensiveTaker iv. StudentGPA Task 4: Declare a Public variable with the name “CEEStudent”, Size 30, and of the Type “Student” Task 5: Write a procedure that reads and stores all student IDs, FinalScores, and StudentGPAs from Question1 sheet in the CEEStudent variable. Set ComprehensiveTaker to true if the student took the comprehensive, and false otherwise (i.e., if no score is shown in column G), and print the value of ComprehensiveTaker in column ‘J’.

Description: In a hypothetical class, students take two midterms and an optional final. If a student takes the final and gets in it a better score than the lowest of the two midterm scores, then the lowest midterm score would be replaced by the comprehensive final score. The overall score will then be calculated by averaging the three test scores. If the student does not take the optional final, the overall score is calculated using only the two midterm scores. Students’ exam scores are included in the “Question1” tab in the attached worksheet. Empty data entries for the optional comprehensive final means that the student did not take the optional final. Tasks: Task 1: In Question1_Module, code a function that requires midterm1 score, midterm2 score, and comprehensive final as inputs and calculate the overall score per the description above. Task 2: In Question1_Module, code a Sub that uses the function coded in task 1 to fill column ‘I’ of the worksheet and link this sub to the “Perform Calculations” button in the worksheet. Task 3: In Question2_Module, Create a Record Type “Student” that contains the following fields i. StudentID ii. FinalScore iii. ComprehensiveTaker iv. StudentGPA Task 4: Declare a Public variable with the name “CEEStudent”, Size 30, and of the Type “Student” Task 5: Write a procedure that reads and stores all student IDs, FinalScores, and StudentGPAs from Question1 sheet in the CEEStudent variable. Set ComprehensiveTaker to true if the student took the comprehensive, and false otherwise (i.e., if no score is shown in column G), and print the value of ComprehensiveTaker in column ‘J’.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter4: Financial Functions, Data Tables, And Amortization Schedules
Section: Chapter Questions
Problem 8AYK
See similar textbooks
icon
Related questions
Question
Description: In a hypothetical class, students take two midterms and an optional final. If a student takes the final and gets in it a better score than the lowest of the two midterm scores, then the lowest midterm score would be replaced by the comprehensive final score. The overall score will then be calculated by averaging the three test scores. If the student does not take the optional final, the overall score is calculated using only the two midterm scores. Students’ exam scores are included in the “Question1” tab in the attached worksheet. Empty data entries for the optional comprehensive final means that the student did not take the optional final. Tasks: Task 1: In Question1_Module, code a function that requires midterm1 score, midterm2 score, and comprehensive final as inputs and calculate the overall score per the description above. Task 2: In Question1_Module, code a Sub that uses the function coded in task 1 to fill column ‘I’ of the worksheet and link this sub to the “Perform Calculations” button in the worksheet. Task 3: In Question2_Module, Create a Record Type “Student” that contains the following fields i. StudentID ii. FinalScore iii. ComprehensiveTaker iv. StudentGPA Task 4: Declare a Public variable with the name “CEEStudent”, Size 30, and of the Type “Student” Task 5: Write a procedure that reads and stores all student IDs, FinalScores, and StudentGPAs from Question1 sheet in the CEEStudent variable. Set ComprehensiveTaker to true if the student took the comprehensive, and false otherwise (i.e., if no score is shown in column G), and print the value of ComprehensiveTaker in column ‘J’.
K9 1 Paşte 2 3 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A LB V Ready esc ▼ BIUV x ✓ fx B Question1 C 1 115 125 H Student ID Student Name 5 7 8 10 15 62 68 85 98 101 105 108 109 110 130 145 150 186 D Joe Hans Ferris Mike Lauren Larry Tony Kevin Sam Zibin Ran Donia Kate Sahar Milos Brian brian Zane Istiak Kumari John Accessibility: Good to go 2 E Midterm 1 Score 78 80 92 45 98 75 48 68 59 63 49 87 85 45 21 49 34 91 100 19 A✓ F Midterm 2 Score #3 12 98 56 87 49 85 87 83 62 68 59 12 57 59 49 98 38 87 78 76 E ≡≡ Optional Final G 87 98 51 87 89 65 89 79 98 95 94 92 49 87 S4 $ H Student GPA 3.5 3.7 3 2.6 4 3.9 3.5 3.2 3.6 3.5 3.8 2.9 2.6 2.7 3.8 3.9 3.2 3.1 3 2.9 % 5 I Overal Score V <6 $ % 9 6 J K MacBook Pro Perform Calculations 29 & 7 .00 5.08000 .00 -0 L
Transcribed Image Text:K9 1 Paşte 2 3 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A LB V Ready esc ▼ BIUV x ✓ fx B Question1 C 1 115 125 H Student ID Student Name 5 7 8 10 15 62 68 85 98 101 105 108 109 110 130 145 150 186 D Joe Hans Ferris Mike Lauren Larry Tony Kevin Sam Zibin Ran Donia Kate Sahar Milos Brian brian Zane Istiak Kumari John Accessibility: Good to go 2 E Midterm 1 Score 78 80 92 45 98 75 48 68 59 63 49 87 85 45 21 49 34 91 100 19 A✓ F Midterm 2 Score #3 12 98 56 87 49 85 87 83 62 68 59 12 57 59 49 98 38 87 78 76 E ≡≡ Optional Final G 87 98 51 87 89 65 89 79 98 95 94 92 49 87 S4 $ H Student GPA 3.5 3.7 3 2.6 4 3.9 3.5 3.2 3.6 3.5 3.8 2.9 2.6 2.7 3.8 3.9 3.2 3.1 3 2.9 % 5 I Overal Score V <6 $ % 9 6 J K MacBook Pro Perform Calculations 29 & 7 .00 5.08000 .00 -0 L
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Concept of pointer parameter
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS