Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a user-defined function that assigns a letter grade to a point total according to this grading scale 98.00% $ A+ 92.00% s 0.88 $2,B+,IF(13

image text in transcribed

Write a user-defined function that assigns a letter grade to a point total according to this grading scale 98.00% $ A+ 92.00% s 0.88 $2,"B+",IF(13 2 0.82 x 1$2,"B",IF(13 2 0.8 x 1$2,"B",IF(132 0.78 x 1$2C+"IF(13>0.72 x 1$2,"C",IF(13 2 0.7 x 1$2,"C-"IF(13 > 0.68 x 1$2,"D+",IF(13>0.62 x 1$2,"D",IF(13>0.6 x |$2,"D-","F">>>>>>>>>>>> In a more easy-to-read format assigning a letter grade to a point total looks kind of like this where cell 13 is the point total and 12 is the cell that has theoretical point total of all the assignments in a class. =IF(132 0.98 x 1$2, then "A+", otherwise IF(13 > 0.92 x 1$2, then "A", otherwise IF(13 > 0.9 x 1$2, then "A", otherwise A, IF(13>0.88 x I$2, then "B+", otherwise IF(13 > 0.82 x 1$2, then "B", otherwise IF(13 > 0.8 x 1$2, then "B", otherwise IF(13 > 0.78 x 1$2, then "C+", otherwise IF(13>0.72 x $2, then "C, otherwise IF(13 2 0.7 x 1$2, then "C- otherwise IF(13 2 0.68 $2, then "D+", otherwise IF(13>0.62 x $2, then "D", otherwise IF(13>0.6 x $2, then "D-", otherwise "F">>>>>>>>>>>> The goal for this user-defined function is to be able to download a grade book from Canvas and check that the Canvas gradebook is correctly calculating letter grades (it makes mistakes). That is how I will see if your user-defined function works. You can create your own spreadsheet with hypothetical data to check your work

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

The Illiterate Executive An Executives Handbook For Mastering Financial Acumen

Authors: Blair Cook

1st Edition

1460289935, 978-1460289938

More Books

Students also viewed these Finance questions

Question

e. Compute P(0.25 Answered: 1 week ago

Answered: 1 week ago