Design a spreadsheet to calculate the class’s grades. Consider the following requirements: * I HAVE ATTACHED ALL THE PROJECT INSTRUCTIONS, AND GRADING RUBRIC DOWN BELOW Each project will be graded fro

Design a spreadsheet to calculate the class’s grades. Consider the following requirements:

* I HAVE ATTACHED ALL THE PROJECT INSTRUCTIONS, AND GRADING RUBRIC DOWN BELOW

1. Each project will be graded from 0 to 10.
2. See your course syllabus to identify the contribution of each grade to the final grade.
3. The final test will be graded from 0 to 100, but your solution should allow different grades (i.e 80 points, 90, or 95). This flexibility is very important.
4. Program your solution to set a numeric final grade.
5. Program your solution to translate the numeric grade to the letter grade using the      corresponding table in the course syllabus.