Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Managerial Accounting

Authors: Jeannie Folk, Ray Garrison, Eric Noree

1st Edition

0072468440, 978-0072468441

More Books

Students also viewed these Accounting questions

Question

Should civil service employees be allowed to unionize? Why?

Answered: 1 week ago