Question
PROBLEM - VLOOKUP AND DATABASE MANIPULATION (40 POINTS) You are an instructor at Walsh College and it is time for you to submit grades for
PROBLEM - VLOOKUP AND DATABASE MANIPULATION (40 POINTS) You are an instructor at Walsh College and it is time for you to submit grades for your students. Your students' scores for the various quizzes, tests and project assignments have been loaded into the table presented below. You must now assign grades to your students based on the total amount of points each student has earned. I suggest using this spreadsheet for your solution. Grades will be awarded based on the following scale: Total Points Grade 930 and over A 900 to 929 A- 870 to 899 B+ 830 to 869 B 800 to 829 B- 700 to 799 C 600 to 699 D under 600 F Using the VLOOKUP function, assign grades to the students listed in the table below based on their total points earned. You will need to put in a formula to total the points. The names are not listed alphabetically so once you have assigned their grades, sort the database so that the student names are in ascending alphabetical order. NAME QUIZ 1 MIDTERM QUIZ 2 FINAL PROJECT TOTAL GRADE Marley 95 219 100 249 262 Cassady 97 194 92 236 262 Strawberry 100 216 100 209 286 Belushi 81 174 81 142 286 Casey 100 242 94 237 255 Christian 100 224 100 236 273 Bianco 100 212 91 223 255 Clarkston 83 227 100 233 286 Trooper 100 187 92 248 273 Davies 100 173 85 186 221 Night 100 248 100 257 262 Piod 98 153 97 199 255 Stevenson 100 198 97 224 221 Farle 100 248 100 254 273 Garrafino 97 228 92 188 273 Crimes 95 176 100 186 221 Daniels 100 193 100 206 273 Stanhopper 100 240 100 244 273 Burger 100 239 85 239 262 Mahesh 100 222 92 198 262 Nevelle 97 228 100 230 286 Nichols 84 136 56 0 0 Bunting 100 238 95 240 286 Parker 100 186 98 203 221 Pillarino 97 159 85 175 221 Payday 93 179 91 155 221 Ruttles 100 231 97 163 286 Sarkosi 100 193 86 179 273 Steele 97 248 97 230 255 Scallopini 100 233 100 257 262 Wychowski 95 209 100 233 255 Wilcox 100 225 100 254 262 Chow 92 229 97 251 221
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 Started