1. Basic Excel Operation: Create an Excel spreadsheet that can be used to calcul
ID: 3048715 • Letter: 1
Question
1. Basic Excel Operation:
Create an Excel spreadsheet that can be used to calculate your grade in this class. The spreadsheet should include the weights of each graded assignment, your grade in each assignment, and your final grade. To use this for your benefit you may want to design it so that it can be used to calculate your interim grade before you have all the grades.
Use a new sheet called "Grade Calculator" in the same Excel file that you are submitting for this assignment.
After this week you will receive the solution from your professor and you will be able to use your solution or our solution for future classes.
Assignment/Project Title
Grading Scale
% of Overall Course Grade
Class Participation via discussions and timeliness of assignment submissions
100%
15%
Six quizzes - 5% each
100%
30%
Two Homework assignments - 7.5% each
100%
15%
Critical Article Review
100%
10%
Mid Term Exam
100%
10%
Final Exam
100%
20%
Total
100%
Assignment/Project Title
Grading Scale
% of Overall Course Grade
Class Participation via discussions and timeliness of assignment submissions
100%
15%
Six quizzes - 5% each
100%
30%
Two Homework assignments - 7.5% each
100%
15%
Critical Article Review
100%
10%
Mid Term Exam
100%
10%
Final Exam
100%
20%
Total
100%
Explanation / Answer
Assignments Weightage marks obtained Weighted Grade Class Participation 15% 100 15 Quiz 1 5% 100 5 Quiz 2 5% 100 5 Quiz 3 5% 100 5 Quiz 4 5% 100 5 Quiz 5 5% 100 5 Quiz 6 5% 100 5 Article Review 10% 100 10 Homework #1 7.5% 100 7.5 Homework #2 7.5% 100 7.5 Mid Term Exam 10% 100 10 Final Exam 20% 100 20 Grade Calculator 100 Numeric Grade Letter Grade 69 or below F N/A D 70-79 C 80-89 B 90-100 A Grade Calculator Assignments Weightage marks obtained Weighted Grade Class Participation 15% 100 15 Quiz 1 5% 100 5 Quiz 2 5% 100 5 Quiz 3 5% 100 5 Quiz 4 5% 100 5 Quiz 5 5% 100 5 Quiz 6 5% 100 5 Article Review 10% 100 10 Homework #1 7.5% 100 7.5 Homework #2 7.5% 100 7.5 Mid Term Exam 10% 100 10 Final Exam 20% 100 20 Grade Calculator 100
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.