Excel Assignment FSE 100 Grade Calculator Create a spreadsheet to calculate your grade in FSE 100. According to the syllabus, your FSE 100 grade is determined by the following weighted components: Individual Quizzes 25% Peer Evaluations 5% Group Report 18% Final Project 39% Lab Work 30% Here is some additional helpful information. - There are 18 Lab submissions (10 points each) - There are 11 Quizzes (10 points each) - There are two Peer Evaluations (5 points each) - The Assembly Line Report is out of 100 points - The Final Project has 5 milestones (20 points each) and a demonstration out of 100 points Your spreadsheet should allow the user to enter: - Each Lab score - Each Quiz score - Both Peer Evaluation scores - Report score ' Each Final Project score Your spreadsheet should use a formula to calculate and display the average % for: ' Lab Work - Quizzes (lowest score is dropped) ' Peer Evals - Report - Final Project Your spreadsheet should include a Bar Chart of the Lab Scores. Your spreadsheet should include a Line Chart of the Quiz Scores. Your spreadsheet should use a formula to calculate and display the Overall Grade. The Overall Grade is the sum of all the weighted averages. A weighted average is calculated by multiplying the average score with the weight value. In the below example, the average score of the Lab Work is 86.57%. Multiplied with the weight of 30%, the weighted average of the Lab Work is 26%. Page 1 of 3 Excel Assignment Here is an example of what your spreadsheet may look like: Lab Work 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Average % Weight % scores: 10 10 10 0 10 9 10 10 9 10 8 10 10 1 10 9 10 10 86.67 30 Quizzes 1 2 3 4 5 6 7 8 9 10 11 Average % Weight % scores: 10 8 7 10 7 8 9 10 7 0 10 78.18 25 Peer Evaluations 1 2 Average % Weight % scores: 5 5 100.00 5 Assembly Line Report 1 Average % Weight % scores: 88 38.00 10 Final Project 1 2 3 4 5 6 Average % Weight % scores: 20 20 20 20 20 93 96.50 30 Lab Scores Overall Grade (before extra credit) 10 88.30 CO scores N 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Lab Work Quiz Scores 10 Co scores 2 2 3 4 5 6 7 8 9 10 11 Quizzes Your spreadsheet does not have to look exactly like this, but it should include all of the required components (described above), and it should be neat and tidy. It should also be technically correct and produce the correct results. For example, given the scores as shown in the example image above, the overall grade should be just over 88%. Page 2 of 3Excel Assignment Extra Challenges Here are some challenges you might want to try to add to your spreadsheet. Challenge 1 You may add some functionality to your spreadsheet to calculate and display the final letter grade based on the computed overall grade. According to the course syllabus, your final letter grade is determined according to the information in the table below. Excel's lF function may be useful for this task although there are other ways to do it. Grade Breakdown Final Grade Percentage A+ >= 98% A >= 89.6% and = 84.6% and = 79.6% and = 74.6% and = 69.6% and = 66% and