Question: We are asked to write a VBA function which returns the corresponding grade point according to the input argument grade. You can assume that

We are asked to write a VBA function which returns the corresponding

We are asked to write a VBA function which returns the corresponding grade point according to the input argument grade. You can assume that grade always contains a valid letter grade. Finish the below function Grade Point (). (10 marks) Function GradePoint (grade as string) As Double deal with the letter only. That is, Grade Point = InStr (__, "FDCBA", Left ( 1 Grade Point = 1 deal with the sign now If Right ( GradePoint = ElseIf Right ( GradePoint End If End Function ignore the sign for now )) = "+" Then ) = "-" Then O

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

InStr InStr Start String1 String2 Compare returns the position ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

A vapour compression refrigerator works under the following conditions as shown in the table below. The working fluid is just dry at the end of compression. Plot: 1. the cycle very clearly on P-h and...

Section 2: Discuss about the implementation of IS/IT in your organization. How organization achieve the competitive advantages by implementing these strategies.

Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.

You are hired to help the city maintain a balanced budget. Good luck! On your first day on the job, the following two markets are pinned to the board: (Hoagies) Q=50-2 P Q=10+2 P (Smoothies) Q = 75-5...

please do as to be done in notepad++ as html file Write a JavaScript function that takes the numerical grade of a student as its argument and returns the equivalent letter grade according to the...

Objectives: Use strings, files, and command line arguments. You are asked to grade a multiple choice test for a class. The students' answers are stored in a file. Each student record in the file...

Summary: Write a program that will determine the letter grade of students of a class (university class, not java class) using your understanding of class (java class), objects, exception handling,...

Question 1: Assume that we want to create a vector of increasing integer values from min to max. We will write a function called creatvec that receives two input arguments, min and max and returns a...

**MATLAB** Question 1: Assume that we want to create a vector of increasing integer values from min to max. We will write a function called creatvec that receives two input arguments, min and max and...

Bostian Company reports a net Section 1231 gain of $31,000 during the current year. Identify the tax issue(s) posed by the facts presented. Determine the possible tax consequences of each issue that...

How can an efficient logistics function help an international business compete more effectively in the global marketplace?

1 8 - 2 1 When an auditor is asked to express an opinion on an entity s rent and royalty revenues, he or she may Not accept the engagement because to do so would be tantamount to agreeing to issue a...

A helium gas is heated at constant volume from 100 kPa, 300 K to 500 K. A following process expands the gas at constant pressure to three times the initial volume. What is the specific work and the...

Oil and gas ventures operating as publicly traded partnerships typically attract sophisticated investors who purchase limited partnership interests. Investments in these types of publicly traded...

1. What have you learned about the potential market for soup in glass jars? 2. What else would you like to know? 3. How else would you assess peoples attitudes toward this concept? For several years,...

Refer to the American Association of Engineering Societies (AAES) survey of the publics knowledge of engineering, Exercise 9.7. Responses to the statement, Engineers are responsible for creating...

Summarize & Analyze Summarize and analyze the following three project considerations: The daily formative assessment data summative assessment data individual and whole group student growth predict...

Write aMATLAB program that computes the product in Eq. (1.4.1) until it exceeds a particular value s max . S= j=jo (1.4.1)

Consider the method of lines solution to the unsteady diffusion equation subject to an initial condition c = 1 and first-order depletion reactions on each boundary, n J = kc, where n is an outward...

Perform the first two iterations of Jacobis method for the system of equations using an initial guess x = 0. 6 -2 1 2 10-3 2 3 8 -6 10 10 13 -2 9 X1 X2 X3 X4 || -9 9 17 13

2. Explain how cross-cultural perspectives on different versions of control differ from traditional perspectives of control and their effects on autonomy and interpersonal harmony.

2. Describe in broad strokes the two theories about the source of the traits in the FFM.

6.3 Describe the main cross-cultural evidence for the five-factor model (FFM).