1. Build your letter grade search table preparing for a VLOOKUP search, it shall include grade bin cut off, letter grade, and GPA for letter grades

2. Use Vlookup, Index(Match()), Xlookup to find student info. Please note you may search both original table and prepared Vlookup search table from part 1.

3. Use Goal Seek to answer required final exam score.

4. Use Index (Match ()) function to find out student names with highest; use Xlookup to find both student ID and name with the lowest GPA

 

Student ID Last Name Homework Quiz 1 Adelante, 2 Clark, Kay 3 Garcia, Mi 4 Hua, Kin 5 Kelley, Joa 6 Macias, D. 7 Nelson, Ca 8 nguyen, Ja 9 Palacios, I 10 Schock. B 11 Schock, V 12 Sun, Eric 13 Wang, Jas 14 Welke, Jan 15 Wong, Mic 63.4% 90.5% 44.4% 77.5% 99.0% 58.0% 100.0% 97.5% 81.1% 65.7% 94.9% 87.5% 100.0% 100.0% 52.4% 87.5% 83.5% 100.0% 98.7% 72.7% 100.0% 95.2% 100.0% 93.0% 81.8% 87.5% 100.0% 100.0% 53.5% 78.4% Paticipatio Final Midterm Course weighted grade 77% 52% 65.5% 74.5% 100% 100% 100% 68% 100% 86% 85% 68% 90% 48% 55% 100% 58% 64% 100% 22% 53% 51.1% 100% 48% 66% 69.8% 100% 61% 69% 73.2% 100% 76% 78% 100% 89% 92% 90% 50% 63% 100% 70% 60% 90% 34% 56% 84.2% 92.8% 66.8% 77.0% 54.1% 92% 83.4% 47% 55.3% 78.5% 85% 89% 91.6% 71% 71.5% (Vlookup) Grading Polic Participation Homework Xlookup() Quiz Midterm Final Part 2 Student ID Course Grade Letter Grade GPA Index(Match()) Student ID Course Grad Letter Grade GPA Part 1: Build you Letter Grade Search Table below 0% 0.0 60% 1.0 70% 2.0 80% 90% Weight 5% 15% 15% 30% 35% Student ID Course Grad Letter Grade GPA F D B A Use Vlookup to find the info. given the following student ID 7 ? ? #N/A #N/A Use Index(Match___ #N/A 5 ? ? ? Use Xlookup() to 6 ? 3.0 4.0 ? ? #N/A #N/A Course Gri Letter Grad GPA >=90% A >=80% B >=70% >=60% D