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 StudentID 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

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 StudentID 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.

Lo Record Macro
X
B
Use Relative References
✓ fx
C
Student ID Student Name
5
7
8
10
15
62
68
85
98
101
105
108
109
110
115
125
130
145
150
186
D
tion1 +
Joe
Hans
Ferris
Mike
Lauren
Larry
Tony
Kevin
Sam
Zibin
Ran
Donia
Kate
Sahar
Milos
Brian
Zane
Istiak
Kumari
John
Accessibility: Good to go
?
Add-ins Excel
Add-ins
E
Midterm 1
Score
78
80
92
45
98
75
48
68
59
63
49
87
85
45
21
49
34
91
100
19
Midterm 2
Score
12
98
56
87
49
85
87
83
62
68
59
12
57
59
49
98
38
87
78
76
Button Group Combo Label Check Scroll
Box Box
Box
Bar
G
Optional Final
FEB
28
87
98
51
87
89
65
89
79
98
95
94
92
49
87
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
0
I
Overal
Score
List Option Spinner
Box Button
J
2
A
K
Perform
Calculations
L
TALK
MacBook F

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions