PLEASE, PLEASE, PLEASE!!!! DROP A GOOGLE-DOC LINK TO THE SPREADSHEET INSTEAD OF A SCREENSHOTS? THANK YOU IN ADVANCE!!!

Project 1 Due Jun 24 at 11:59pm Points 100 Questions 6 Time Limit None Allowed Attempts Unlimited Instructions Project 1, description Understanding how weighted averages work will be a very important topic for you in this course since your grades are determined in this way. In this project, you will create an Excel spreadsheet that can calculate a student's final grade in a course. You will then submit a WORD document answering several guestions regarding your project. WORD and Excel documents ONLY. In this project you are required to do the following: Create an Excel spreadsheet that will be capable of calculating a student's final grade in a given course. Keep in mind that weighting is involved in determining the final grade. You should NOT be using a template for this project. You will be required to CREATE the grade book from a blank worksheet. Your Excel spreadsheet should contain the following: Your name, course name, and project name. A data table labeled by Category using the category headings and scores on the next page fora MATH 123 class (DO NOT use any of your own scores). A table to calculate the overall grade with headings Categories, Category Weights, Category Average, and Category Percentage Points. Category Weights used to determine the final weighted grade for a MATH 123 A Final course grade, Labeled cell, at the bottom of your grade book calculation table that uses a formula to calculate the weighted OVERALL COURSE percentage. 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 Ivy Learn's 'Excel Help' Module.} Highlight the final course percentage cell. Your written portion of the project will consist of answering the short answer questions given below. Each short-answer response should be a minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should include sophisticated and elegant solutions to clearly convey your message to the reader. Make sure to use your spreadsheet to answer the \"what if\" questions with specific values and provide support for your statements. Questions are not cumulative - return to your original spreadsheet to answer the next question. [ . Explain how you set up your excel worksheet. Make sure to address any formula used by showing an example but avoid using cell references (B5, A3, G12, etc.) What final course percentage (to 1 decimal) did you calculate? What letter grade in the course did this student earn? . If the instructor decided to drop quiz scores, how many grades will need to be dropped to reach the next letter grade? Is this a reasonable request from the student? . What is the lowest grade on Test 3 that could have brought the student's score to the next letter grade for the class? If not possible, state this in your response. 4. s it possible for the student to get a B in the class? Create a new weighted system that would allow for this student to get a B in the course. Use whole numbers for your percentages. Is this a realistic weighted system? ra [ w . Consider if the instructor allows the student to complete all the test reviews again. If the student got the exact same score on each test review, what would that be to raise their overall grade to the next letter? Use the following parameters and scores in your Excel spreadsheet Methods of Evaluation: There will be Exam 1, Exam 2, and Exam 3 in this class. A total of 20 homework papers are given and 10 total quizzes are assigned. The course has 2 projects and 3 online test reviews. Grading Scale: Category Weights: (NOTE: These are grade weights for a current face-to-face math 123 course) 90 - 100 A Exam 1: 20% Test Review: 5% 80 -89 B Exam 2: 20% Project: 10% 70-79 C Exam 3: 25% Quiz: 10% 60 - 69 D Homework: 10% 0-59 F A student has the following grades in each category: Categories and scores Exam 1 58 Exam 2 72 Exam 3 78 Online 30 55 40 Review Project 90 80 Quiz 90 85 70 60 62 55 180 40 138 10 Homework 60 90 80 60 62 70 82 90 80 10 (More 55 68 52 10 62 65 50 20 0 38 homework)