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 from 0 to 10.
- See your course syllabus to identify the contribution of each grade to the final grade.
- 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.
- Program your solution to set a numeric final grade.
- Program your solution to translate the numeric grade to the letter grade using the corresponding table in the course syllabus.