Question: Points Possible: 100 In this section we will code two separate functions. Course Percentage Course Grade The first FUNCTION accepts two arguments for each student

 Points Possible: 100 In this section we will code two separate

Points Possible: 100 In this section we will code two separate functions. Course Percentage Course Grade The first FUNCTION accepts two arguments for each student (points earned in column O and points possible in cell R2) and returns a course percentage (Column P). Student Aria Billy Cathy Delores Steve William Sally Mark Points Earned 82.19 72.5 68.3 92.1 82.4 46.5 72.6 79.5 This second macro FUNCTION determines if a student's course grade is "Passing" or "Failing" (column Q) based on the student's course percentage (Column P). Tasks: a) Code a function macro named 'Calc_Grade_function' The macro will be coded (not recorded) in the VBA editor in a MODULE, If necessary, insert a module (NOT a CLASS MODULE), then use the INSERT menu to create a function (not a subroutine) The macro code should NOT incorporate a loop. Instead, we will first call the function from cell P5, pass in two arguments (the points earned in cell 05 and the points possible in cell R2), then copy the function down column P to determine the course percentage for each student. HINT: The course percentage = points earned / points possible AFTER SUCCESSFULLY CODING THE FIRST FUNCTION AND USING THE FUNCTION TO DETERMINE EACH STUDENT'S COURSE PERCENTAGE, b) Code a function macro named 'Assign Grade function The macro will be coded (not recorded) in the VBA editor in a MODULE. Use the INSERT menu to create a function (not a subroutine The macro code should NOT incorporate a loop. Instead, we will first call the function from cell 05, pass in a single argument (the course percentage in cell PS), then copy the function down column Q to determine the course grade for each student. The macro's logic is as follows: If the course percentage is >= 70% then the student's course grade is "Passing" If the course percentage is = 90% then the student's course grade is "Excel-ing" If the course percentage is = 70, then the students' course grade is "Passing" If the course percentage is = 70% then the student's course grade is "Passing" If the course percentage is = 90% then the student's course grade is "Excel-ing" If the course percentage is = 70, then the students' course grade is "Passing" If the course percentage is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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 Accounting Questions!