Question
Drop the lowest test score and calculate the final average score for each student. Use the weights given. Assign grades to every one (use
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
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 StartedRecommended Textbook for
Microeconomics An Intuitive Approach with Calculus
Authors: Thomas Nechyba
1st edition
538453257, 978-0538453257
Students also viewed these General Management questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App