Reference no: EM132532587
Assignment: Instructions: Design a spreadsheet to calculate the class's grades. Consider the following requirements:
1. Each project will be graded from 0 to 10 points.
2. Each quiz will have a grade from 0 to 10 points.
3. See your course syllabus to identify the contribution of each grade to the final grade.
4. The tests (midterm and final) will be graded from 0 to 100 points, but your solution should allow to set different values to grades (i.e 80 points, 90, or 95,)This design will give me flexibility when preparing the tests. This flexibility is very important.
5. Program your solution to set a numeric final grade for the course.
6. Use a LOOKUP (or VLOOKUP) table to translate the numeric grade to the letter grade using the corresponding scale in the course syllabus.
Functionality, usability, and proper design will be considered for grading the assignment.
Read the questions and answers (Q &A) document for Project and the rubric before start working on your solution.
Use the link (red link)in Project 1folder to submit your solution to BB.