Programming Project 1: Design a spreadsheet to calculate the class’s grades

Project 1

Instructions

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

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.

Functionality, usability, and proper design will be considered for grading the assignment.

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

According to our syllabus, there are 4 projects (30%), one midterm (35%) and one final exam (35%)

Grading Evaluation

Deliverable	Final grade contribution
Projects (1,2,3,and 4)	30 %
Midterm	35 %
Final test	35 %

Based on that, you can create an excel sheet in order to help solve the project as follow:

	P1	P2	P3	P4	Midterm	FT	GRADE	LetterGRADE
Weight				30	35	35
MaxPoints	10	10	10	10	100	100		.
Student1	8	9	7	10	70	800	78	C+
Student2
Student 3
Student 4 Student 5

How to calculate the projects grades out of 30%

Projects = [(P1+P2+P3+P4)/40 ] * 30

For example, if a student score ( 8,9,7,10) in the four projects , then we can calculate the weight for all the projects as follow:

[(8+9+7+10/40] *30 = [34/40 ] *30 = (0.85)* 30 = 25.5

Also, to find the weight for the midterm if a student score 70/100

[70/100] * 35 = 24.5

Finally, if a student score 80/100 in the final exam , then the weight will be:

[80/100] * 35 = 28

The Grade for this student: 25.5 + 24.5 + 28 = 78

Note in Excel, you should use fx = [(8+9+7+10/40] *30 = [34/40 ] *30 + [70/100] * 35 + [80/100] * 35

Which is the same as: The Grade for this student: 25.5 + 24.5 + 28 = 78

In order to Program your solution to translate the numeric grade to the letter grade using the corresponding table in the course syllabus.

Make sure to use if statement or VLOOKUP function