Using what you know about Excel, calculate your own grade creating a spreadsheet
ID: 3574396 • Letter: U
Question
Using what you know about Excel, calculate your own grade creating a spreadsheet, and upload it. The following are percentages towards final grade.
End of chapter quizzes: 15%
simulation training: 15%
grader projects: 35%
capstone chapter 1-4: 15%
capstone chapters 5-12: 15%
final grade: 5%
grades are as followed:
quizzes:
chapter 1-100
chapter 2-100
chapter 3-100
chapter 4-100
chapter 5-100
chapter 6-100
chapter 7-100
chapter 8-100
chapter 9-100
chapter 10-100
chapter 11-96
chapter 12-100
simulation training:
chapter 1-100
chapter 2-100
chapter 3-100
chapter 4-100
chapter 5-100
chapter 6-100
chapter 7-100
chapter 8-100
chapter 9-100
chapter 10-100
chapter 11-100
chapter 12-100
grader project:
office chapter-86.7
chapter 1-84.5
chapter 2-93
chapter 3-97
chapter 4-79
chapter 5-75
chapter 6-100
chapter 7-69.1
chapter 8-75
chapter 9-79.8
chapter 10-82.5
chapter 11-90
chapter 12-93.6
capstone chapter 1-4: 95
capstone chapters 5-12: 84.4
Explanation / Answer
quizzes:
Quiz Grades
simulation training
simulation training grades
grader project:
grader project grades
capstone chapter
capstone chapter grade
capstone chapter
capstone chapter grade
Final
chapter 1
100
chapter 1
100
office chapter
86.7
capstone chapter 1-4
95
capstone chapters 5-12
84.40
90
chapter 2
100
chapter 2
100
chapter 1
84.5
chapter 3
100
chapter 3
100
chapter 2
93
chapter 4
100
chapter 4
100
chapter 3
97
chapter 5
100
chapter 5
100
chapter 4
79
chapter 6
100
chapter 6
100
chapter 5
75
chapter 7
100
chapter 7
100
chapter 6
100
chapter 8
100
chapter 8
100
chapter 7
69.1
chapter 9
100
chapter 9
100
chapter 8
75
chapter 10
100
chapter 10
100
chapter 9
79.8
chapter 11
96
chapter 11
100
chapter 10
82.5
chapter 12
100
chapter 12
100
chapter 11
90
chapter 12
93.6
1196
1200
1105.2
95
84
90
n% of grades /12
14.95
15
32.235
14.25
12.6
4.5
Final Grade
93.54
quizzes:
Quiz Grades
simulation training
simulation training grades
grader project:
grader project grades
capstone chapter
capstone chapter grade
capstone chapter
capstone chapter grade
Final
chapter 1
100
chapter 1
100
office chapter
86.7
capstone chapter 1-4
95
capstone chapters 5-12
84.40
90
chapter 2
100
chapter 2
100
chapter 1
84.5
chapter 3
100
chapter 3
100
chapter 2
93
chapter 4
100
chapter 4
100
chapter 3
97
chapter 5
100
chapter 5
100
chapter 4
79
chapter 6
100
chapter 6
100
chapter 5
75
chapter 7
100
chapter 7
100
chapter 6
100
chapter 8
100
chapter 8
100
chapter 7
69.1
chapter 9
100
chapter 9
100
chapter 8
75
chapter 10
100
chapter 10
100
chapter 9
79.8
chapter 11
96
chapter 11
100
chapter 10
82.5
chapter 12
100
chapter 12
100
chapter 11
90
chapter 12
93.6
1196
1200
1105.2
95
84
90
n% of grades /12
14.95
15
32.235
14.25
12.6
4.5
Final Grade
93.54
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.