Project 1

Instructions

Design a spreadsheet to calculate the classs grades. Consider the following requirements:

1. Each project and quizzes will be graded from 0 to 10.
2. See the course syllabus to identify the contribution of each grade to the final grade.
3. Tests 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 grading scale Table in the course syllabus.

Functionality, usability, and proper design will be considered for grading the assignment. Please read Project 1 Rubric.

Use the link in Project 1 folder to submit your file to BB.

^{I need Excel formulas please for the bottom data}

Weight (%) 10 15 Grading Evaluation Deliverable Quizzes (8) Individual Projects (4) (projects 1-4) Project 5 Midterm Final test Total 15 30 30 100