Total Points Calculated Grade GPA Value 675 A+ (i.e., 675 points and above is an
ID: 3856277 • 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
Grade Table
A
When printed, the output should be no more than 1 page wide while still being readable. (You may decide whether this is a portrait or landscape layout.)
Reformat the workbook so it is readable, understandable, and consistent. Replace column labels (as needed), format and align headings, and add borders and shading as appropriate. Reorder the data, if appropriate, to improve the usefulness of the gradebook. (Pay attention to this …)
If the spreadsheet is formatted to print on multiple pages, make sure you provide the appropriate column headings and row labels for each page.
Scores taken to one significant digit beyond the decimal point is sufficient, unless otherwise stated.
Use the capabilities of the spreadsheet to do the calculations, i.e., don’t type in values that should be calculated! (This is important, and required!)
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%.)
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.)
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.
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.
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.
Remember: Where appropriate, all values/results throughout the spreadsheet should auto-update if/when data changes or is corrected/updated.
Mostly need the formulas for these, Thanks!
Total Points Calculated Grade 0 F 405 D 499 C- 555 C 560 B- 609 B 635 A- 675A