Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Drop the lowest test score and calculate the final average score for each student. Use the weights given. Assign grades to every one (use

imageimageimageimageimageimageimageimageimageimage

Drop the lowest test score and calculate the final average score for each student. Use the weights given. Assign grades to every one (use Vlookup). Make sure that your formulas matches the provided sample calculation for Ryann. Note: Create a Vloookup table for grades to use it. Answer quiz questions. Test 1 Test 2 Test 3 Test 4 Quiz 1 Quiz 2 HW 1 HW 2 HW 3 HW 4 Weight Student Section Status 100 100 100 100 23 25 25 25 25 25 25 25 Avg Grade Test 75% Ryann Sec-A Senior 94 99 79 97 20 24 22 23 23 19 94.35 A Quiz 10% Ayan Sec-C Junior 98 82 92 95 22 19 23 22 23 22 HW 15% Lilly Sec-B Senior 95 75 73 95 23 16 25 19 24 24 Anaya Sec-A Junior 94 87 82 83 22 24 25 20 22 24 Grades Jason Sec-A Senior 84 86 78 87 21 15 25 23 24 23

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

Microeconomics An Intuitive Approach with Calculus

Authors: Thomas Nechyba

1st edition

538453257, 978-0538453257

More Books

Students also viewed these General Management questions