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