Create a spreadsheet that will calculate your total number of points without unannounced quizzes, percent without unannounced quizzes, total number of points with unannounced quizzes, percent with unannounced quizzes, and letter grade for this course.

1. Use cell formulas wherever possible.
2. Enter each item that is graded separately. In other words, the scores for each homework must go into a different column, each days Nearpod score must go into a separate column, etc.
3. Recall that your lowest in-class activity score and your lowest four Nearpod scores will be thrown out. Make Excel throw out the lowest in-class activity, the three lowest Nearpod scores, etc. Also make sure Excel handles the wild cards correctly.

** Show formulas

Unit Exam 1 Unit Exam 2 Final Exam Computer Exam (given during Final Exam period) In-Class Exercises (best 4 of 5) Homework Capstone Project Wild Card #1: Nearpod Scores-allow for up to 18, throw out worst 3 Wild Card #2: Accounting Scandal Project Extra Credit: Multiple Choice question for Exam 1 Multiple Choice question for Exam 2 Multiple Choice question for Final Exam Critical Evaluation of Facebook Post Participation, Other Subjective Factors Unannounced Quizzes-up to 4; the first two are worth 25 and 20 points, respectively 100 pts. 100 pts. 100 pts. 50 pts. 100 pts. 50 pts. 100 pts. 50 pts. 50 pts. Unit Exam 1 Unit Exam 2 Final Exam Computer Exam (given during Final Exam period) In-Class Exercises (best 4 of 5) Homework Capstone Project Wild Card #1: Nearpod Scores-allow for up to 18, throw out worst 3 Wild Card #2: Accounting Scandal Project Extra Credit: Multiple Choice question for Exam 1 Multiple Choice question for Exam 2 Multiple Choice question for Final Exam Critical Evaluation of Facebook Post Participation, Other Subjective Factors Unannounced Quizzes-up to 4; the first two are worth 25 and 20 points, respectively 100 pts. 100 pts. 100 pts. 50 pts. 100 pts. 50 pts. 100 pts. 50 pts. 50 pts