The Worksheet named Cuestion 1 contains a place for students to record the grades they have received in their dlasses. Students put the number of each letter grade received in the B column. (For example, the worksheet currently shows that the student has taken 9 classes and made five As, one B, one C, one D, and one F as grades. You need to write a program that reads the grades from the worksheet and uses a function to calculate the student's GPA. For this problem you can assume that all classes are worth the same number of credit hours. (See the note at the end of the test if you don't know how to calculate GPA...but you should know that, it's important to you!) The function should send back the GPA to the calling procedure. The procedure will then put upa message box that gives the student their GPA and a message about their GPA, all in one message box. The message should be "You qualify for an internship" if the student has a GPA over 3.0. It should be "You're in the danger zone" if the GPA is between 2.0 and 3.0. And it should be "You are on probation." if the GPA is less than 2.0. The message box below is an example of what should be shown to the user. Do not worry about the formatting of the GPA. I won't grade that. If yours has lots of decimal places, that is OK. Microsoft Excel Your GPA is 2.89. You're in the danger zone. OK

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter9: Records (struct)
Section: Chapter Questions
Problem 2PE
icon
Related questions
Question
Please write code that would run in VBA please show code in VBA
The Worksheet named Ouestion 1 contains a place for students to record the grades they have
received in their classes. Students put the number of each letter grade received in the B
column. (For example, the worksheet currently shows that the student has taken 9 classes and
made five As, one B, one C, one D, and one F as grades. You need to write a program that reads
the grades from the worksheet and uses a function to calculate the student's GPA. For this
problem you can assume that all classes are worth the same number of credit hours. (See the
note at the end of the test if you don't know how to calculate GPA..but you should know that,
it's important to you!) The function should send back the GPA to the calling procedure. The
procedure will then put up a message box that gives the student their GPA and a message about
their GPA, all in one message box. The message should be "You qualify for an internship" if the
student has a GPA over 3.0. It should be "You're in the danger zone" if the GPA is between 2.0
and 3.0. And it should be "You are on probation." if the GPA is less than 2.0. The message box
below is an example of what should be shown to the user. Do not worry about the formatting
of the GPA. I won't grade that. If yours has lots of decimal places, that is OK.
Microsoft Excel
Your GPA is 2.89. You're in the danger zone.
OK
allod Question1. Be sure to use the programming conventions
Transcribed Image Text:The Worksheet named Ouestion 1 contains a place for students to record the grades they have received in their classes. Students put the number of each letter grade received in the B column. (For example, the worksheet currently shows that the student has taken 9 classes and made five As, one B, one C, one D, and one F as grades. You need to write a program that reads the grades from the worksheet and uses a function to calculate the student's GPA. For this problem you can assume that all classes are worth the same number of credit hours. (See the note at the end of the test if you don't know how to calculate GPA..but you should know that, it's important to you!) The function should send back the GPA to the calling procedure. The procedure will then put up a message box that gives the student their GPA and a message about their GPA, all in one message box. The message should be "You qualify for an internship" if the student has a GPA over 3.0. It should be "You're in the danger zone" if the GPA is between 2.0 and 3.0. And it should be "You are on probation." if the GPA is less than 2.0. The message box below is an example of what should be shown to the user. Do not worry about the formatting of the GPA. I won't grade that. If yours has lots of decimal places, that is OK. Microsoft Excel Your GPA is 2.89. You're in the danger zone. OK allod Question1. Be sure to use the programming conventions
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Types of Loop
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
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,