Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given this table in one sheet And this table isn another sheet What is the VLOOKUP equation used to solve for final grade? Total Points

Given this table in one sheet

image text in transcribed

And this table isn another sheetimage text in transcribedWhat is the VLOOKUP equation used to solve for final grade?

Total Points Calculated Grade 0 F 450 D 490 C- 535 560 B- 600 B 635 A- 675 A . Grade Case Student name Acosta, Angelica Alnusf, Ali AISabt, Sadon A KHA Anderson, Chester Ballantine, David Behbehani, Mohammad Beier, Susanna Blackett, Christopher Cabander, Frida Cooper, Alexander Corson, Bailey Cunningham, Brett Elenbaas, Andrew Friend, Jason Grzanowski, Michael Harkavy, Alexander Exam 1 Exam 2 Quizz 1 Quiz 2 Quiz 3 Project 1 Project 2 Project 3 Project 4 Total Points Final Grade Pass/Fail 100 77 2 48 38.5 100 37.345 97 66.22 566.065 PASS 96 78 4 37.5 39 100 37.83 93.12 67.08 552.53 PASS 75 99 4 43.5 49.5 100 48.015 72.75 85.14 576.905 PASS 87 98 11.5 48 49 100 47.53 84.39 84.28 609.7 PASS 96 92 21.5 22.5 46 100 44.62 93.12 79.12 594.86 PASS 45 93 21.5 39 46.5 100 45.105 43.65 79.98 513.735 FAIL 78 8 22.5 33 4 100 3.88 75.66 6.88 331.92 FAIL 66 4 22.5 49 2 100 1.94 64.02 3.44 312.9 FAIL 98 83 23 38.5 41.5 100 40.255 95.06 71.38 590.695 PASS 77 85 24 44 42.5 100 41.225 74.69 73.1 561.515 PASS 88 74 26.5 23 37 100 35.89 85.36 63.64 533.39 FAIL 46 72 27 39 36 100 34.92 44.62 61.92 461.46 FAIL 78 74 27.5 49.5 37 100 35.89 75.66 63.64 541.19 FAIL 99 75 28 38 37.5 100 36.375 96.03 64.5 574.405 PASS 76 89 28 39 44.5 100 43.165 73.72 76.54 569.925 PASS 78 78 28 28 39 37.83 75.66 67.08 531.57 FAIL 100

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

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

Students also viewed these Databases questions

Question

1. What are your creative strengths?

Answered: 1 week ago

Question

Knowledge of project management (PMI) teachings

Answered: 1 week ago