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

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

Concept explainers

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

927
1
2
3
4
5
6
7
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
B
с
с
Ready iT
Student ID Student Name
5
7
8
10
15
62
68
85
98
101
105
108
109
110
115
125
130
145
150
186
Question1
JX
D
Joe
Hans
Ferris
Mike
Lauren
Larry
Tony
Kevin
Sam
Zibin
Ran
Donial
Kate
Sahar
Milos
Brian
Zane
Istiak
Kumari
John
+
E
Midterm 1
Score
78
80
92
45
98
75
48
68
59
63
49
87
85
45
21
49
34
-91
100
19
Accessibility: Good to go
F
Midterm 2
Score
12
98
56
87
49
85
87
83
62
68
59
12
57
59
49
98
38
87
78
76
G
Optional Final
87
98
51
87
89
-65
89
79
98
95
94
92
49
87
5
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
1
Overal
Score
J
Perform
Calculations
L
M
N

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 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