Total Points Calculated Grade GPA Value 675 A+ (i.e., 675 points and above is an
ID: 3856288 • Letter: T
Question
Total Points Calculated Grade GPA Value
675 A+ (i.e., 675 points and above is an “A+”) 4.3
650 A (i.e., 650 to 674.99 points and above is an “A”) 4.0
630 A- (i.e., 630 to 649.99 points is an “A-“) 3.7
605 B+ (etc.) 3.3
580 B 3.0
560 B- 2.7
540 C+ 2.3
510 C (Note: Use this data for your calculations, 2.0
490 C- not necessarily what is already in the 1.7
410 D spreadsheet.) 1.0
0 F 0.0
Course Points
Total Points
Calculated Grade
Here are the first few lines of the material used in the questions..
Here are the questions I need to answer..
1. Add a column in the grade book to calculate a percentage score for each student. This should be displayed as a value between 100.00 and 0.00 . (Note that you should have two digits to the right of the decimal point for this data, e.g., 79.86%.)
2. Use one of the Lookup functions (i.e., LOOKUP, VLOOKUP, or HLOOKUP) to automatically assess and assign final grades based on the total points column. You should find this data on the “Grade Table” worksheet in the spreadsheet. Make sure the data in the worksheet is correct, and use this worksheet to assign final grades. (Using a LOOKUP function is one of the required tasks.)
3. Using the IF function, format the workbook so each student’s information also shows either a “Pass” or a “Fail” based on the total points earned by the student. A student must earn a “C” or better to have passed the course, i.e., a “C-” is NOT a passing grade.
4. Using the spreadsheet’s capabilities, count and post the number of occurrences of each grade, i.e., how many A+’s, A’s, A-’s, B+’s, B’s, etc. Display this information at the bottom of the spreadsheet. Make sure it is easy to read.
5. Calculate the average GPA for the course. The multipliers can be found in the table above. Post this value, with a useful label, below the Grade Count info.
THANK YOU!
Course Points
Total Points
Calculated Grade
0 F 405 D 499 C- 555 C 560 B- 609 B 635 A- 675 A