Please help//. i cannot figure this assigment by my teacher.,, =(
Calculate the grades for the above data and create the “IF(AND(“ statements for the derivation of a letter grade. (Abs = missed classes, each missed class costs 2 points)
Example of the “IF AND” syntax:
=IF(G4<=59.99,"F",IF(AND(G4>=60,G4<=69.99),"D",IF(AND(G4>=70,G4<=79.99),"C",…..
Qz5 (10/5%) A column 1 to 9 Lab Rep. (120/20%) b column 1 to 9 Nut An (100/10%) c column 1 to 9 Test 1 (100/25%) D column 1 to 9 Test 2 (120/30%) E column 1 to 9 Abs (20/10%) F column 1 to 9
9 62 40 70 82 3
9 80 50 79 96 1
7 82 70 70 82 7
8 98 80 74 92 1
9 105 92 75 107 0
9 110 90 80 105 2
5 68 50 58 72 8
4 70 68 69 89 4
9 90 85 86 102 1
Thank you
Bookmarks