Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started