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’.
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter7: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 8SAT
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’.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
Knowledge Booster
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.Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning