1. You need to calculate course weighted grades according to grading policy 2. Build your letter grade search table preparing for a VLOOKUP search 3. Use Vlookup () to assign Letter grades and GPA. 4. Use Index (Match ()) function to find out student names with highest and lowest course weighted grade Note: Please always display your entered formula next to your results. Last Name Homework Quiz Paticipatior Final Midterm Course weighted grade Course Letter grad GPA Build you Letter Grade Search Table below Grading Policy Weight Adelante, Realyn Clark, Kayla Garcia, Michael Hua, Kin Kelley, Joan Macias, David Nelson, Carey nguyen, Jack Palacios, Kristina Schock, Brian 63.4% 90.5% 100% 77% 92% Percentage Grade GPA Participation Homework Quiz Midterm Final 44.4% 77.5% 100% 52% 47% 5% 0% F 99.0% 58.0% 100% 68% 85% 15% 60% D 100.0% 97.5% 100% 86% 89% 15% 70% C 2 30% 35% 81.1% 65.7% 85% 68% 71% 80% B 3 94.9% 87.5% 90% 48% 55% 90% A 4 100.0% 100.0% 100% 58% 64% 52.4% 87.5% 100.0% 100% 22% 53% 83.5% 100% 48% 66% Course Grade >=90% 98.7% 72.7% 100% 61% 69% Letter Grade GPA Schock, William Sun, Eric Wang, Jason Welke, James Wong. Michael 100.0% 95.2% 100% 76% 78% 4 100.0% 93.0% 100% 89% 92% >=80% 81.8% 87.5% 90% 50% 63% >=70% C 100.0% 100.0% 100% 70% 60% >=60% D 1 53.5% 78.4% 90% 34% 56% <60% | Student Name with highest course weighted grade Student Name with lowest course weighted grade
1. You need to calculate course weighted grades according to grading policy 2. Build your letter grade search table preparing for a VLOOKUP search 3. Use Vlookup () to assign Letter grades and GPA. 4. Use Index (Match ()) function to find out student names with highest and lowest course weighted grade Note: Please always display your entered formula next to your results. Last Name Homework Quiz Paticipatior Final Midterm Course weighted grade Course Letter grad GPA Build you Letter Grade Search Table below Grading Policy Weight Adelante, Realyn Clark, Kayla Garcia, Michael Hua, Kin Kelley, Joan Macias, David Nelson, Carey nguyen, Jack Palacios, Kristina Schock, Brian 63.4% 90.5% 100% 77% 92% Percentage Grade GPA Participation Homework Quiz Midterm Final 44.4% 77.5% 100% 52% 47% 5% 0% F 99.0% 58.0% 100% 68% 85% 15% 60% D 100.0% 97.5% 100% 86% 89% 15% 70% C 2 30% 35% 81.1% 65.7% 85% 68% 71% 80% B 3 94.9% 87.5% 90% 48% 55% 90% A 4 100.0% 100.0% 100% 58% 64% 52.4% 87.5% 100.0% 100% 22% 53% 83.5% 100% 48% 66% Course Grade >=90% 98.7% 72.7% 100% 61% 69% Letter Grade GPA Schock, William Sun, Eric Wang, Jason Welke, James Wong. Michael 100.0% 95.2% 100% 76% 78% 4 100.0% 93.0% 100% 89% 92% >=80% 81.8% 87.5% 90% 50% 63% >=70% C 100.0% 100.0% 100% 70% 60% >=60% D 1 53.5% 78.4% 90% 34% 56% <60% | Student Name with highest course weighted grade Student Name with lowest course weighted grade
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
100%
2
Transcribed Image Text:1. You need to calculate course weighted grades according to grading policy
2. Build your letter grade search table preparing for a VLOOKUP search
3. Use Vlookup () to assign Letter grades and GPA.
4. Use Index (Match ()) function to find out student names with highest and lowest course
weighted grade
Note: Please always display your entered formula next to your results.
Last Name
Homework
Quiz
Paticipatior Final
Midterm
Course weighted grade Course Letter grad GPA
Build you Letter Grade Search Table below
Grading Policy
Weight
63.4%
44.4%
100%
Percentage Grade
Adelante, Realyn
Clark, Kayla
Garcia, Michael
90.5%
77.5%
77%
92%
47%
GPA
Participation
Homework
Quiz
Midterm
100%
52%
5%
0% F
58.0%
85%
15%
15%
99.0%
100%
68%
60% D
1
Hua, Kin
100.0%
100%
86%
89%
70% C
97.5%
65.7%
2
Kelley, Joan
Macias, David
Nelson, Carey
nguyen, Jack
Palacios, Kristina
Schock, Brian
Schock, William
Sun, Eric
Wang, Jason
Welke, James
Wong, Michael
81.1%
85%
68%
71%
30%
80% B
3
94.9%
87.5%
90%
48%
55%
Final
35%
90% A
4
100.0%
100.0%
100%
64%
58%
22%
52.4%
87.5%
100%
53%
83.5%
100.0%
100%
48%
66%
Course Grade
>=90%
>=80%
>=70%
>=60%
<60%
98.7%
72.7%
100%
61%
69%
Letter Grade GPA
100.0%
95.2%
78%
100%
100%
76%
89%
A
4
100.0%
93.0%
92%
B
3
81.8%
90%
C
87.5%
100.0%
50%
63%
100.0%
100%
70%
60%
D
1
53.5%
78.4%
90%
34%
56%
F
Student Name with highest course weighted grade
Student Name with lowest course weighted grade
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman