In this project you are required to do the following: 1. Create an Excel spreadsheet that will be capable of calculating a students final grade in a given course. Keep in mind that weighting is involved in determining the final grade. Your Excel spreadsheet should contain the following: Your name, course name and project name. The scores provided on the next page Category averages The weights used to determine the final weighted grade for the course A labeled cell with the Final course grade that uses a formula to calculate the weighted average grade for the course. If a value is changed in your spreadsheet, your final calculation should recalculate. Please limit your use of Excel functions to those used in the course-packet (for a list see the Excel Reference sheet in Blackboards Excel Help button. In addition to correctly calculating the final grade, your spreadsheet should be well-organized, with clear labels 2. Write a typed reflection paper (minimum one page). It must include the following information: Your name, course name and project name. An explanation of your process for using Excel to calculate the weighted average final grade. Did you encounter any difficulties? Analyze and reflect on the results for the student data provided. What is the predicted final course score based on the data provided. What letter grade is this? What is the lowest grade the student would have had to score on the final exam to improve his final course score to the next higher letter grade? Reflect on the impact on the students final course score for each of the following. Return the changed scores back to the original scores after considering each scenario: i. If the student received perfect scores on all of the quizzes? ii. If the student had not submitted the fourth project? Some students and instructors feel that the weights for the course emphasize the exams too much. Create a new weighting system and explain why/how you chose your new weight values. What final course grade would the student earn under your new category weighting system? Reflect on the results of your project. Are there any specific strategies that may help this student with their grades in the future? What similar strategies might help you to improve/maintain your grade in your math 123 course? In addition to addressing the given statements, your paper should: Be well organized and in paragraph form (not just bulleted answers!). Be clear to someone who is not familiar with the project. (i.e. dont assume that you are writing this to your instructor, make sure anyone could understand your statements.) Provide support for your statements (e.g. explain how values were found). Give specific values (i. e. quantify statements). Provide support for your statements (e.g. explain how values were found and justify statements). Use appropriate representations (tables, color, formatting) that will help the reader understand the project. 3. Follow your instructors directions for turning in this project. Use the following parameters and scores in your Excel spreadsheet Create an Excel spreadsheet that will compute the following sample students data set for the course described below. Assume all scores are out of 100 and that all grades have been recorded for this student. Grading and Evaluation Rules for DESN104 Mechanical Graphics Course: Methods of Evaluation: There will be a Midterm and Final Exam in this class. Two projects will also be assigned. Homework and ten quizzes will also be part of the course grade. Final Grade Calculation: Grading Scale: Midterm Exam 25% 90 - 100 A Final Exam 30% 80 - 89 B Homework 10% 70 - 79 C Projects 25% 60 - 69 D Quizzes 10% 0 - 59 F A student has the following grades in each category: Homework: 82, 88, 84, 88, 89, 99, 0, 87, 88, 76, 94, 97 Quiz: 68, 64, 84, 78, 88, 98, 0, 84, 85, 86 Projects: 60, 64, 76, 85 Midterm Exam: 74 Final Exam: 82