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
0	F
405	D
499	C-
555	C
560	B-
609	B
635	A-
675	A

Here are the first few lines of the material used in the questions..

Student name	Ex 1	Ex 2	Quizzz 1	Quiz 2	Quiz 3	Project 1	Project 2	Project 3	Project 4	Total Points Earned	Final Grade	Pass/Fail	Percentage
Acosta, Angelica	74	100	37	36	50	72	48.5	71.78	86	575.3
Alnusf, Ali	72	100	36	37	50	74	48.5	69.84	86	573.3
AlSabt, Anna	74	100	37	37.5	50	75	48.5	71.78	86	579.8
Anderson, Chester	75	100	37.5	44.5	50	89	48.5	72.75	86	602.3

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 students 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 spreadsheets capabilities, count and post the number of occurrences of each grade, i.e., how many A+s, As, A-s, B+s, Bs, 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!