. . 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 MATH 123 student's final grade. You will then write a reflection paper answering several questions regarding your project. In this project you are required to do the following: 1. Create a Microsoft Excel spreadsheet file that will be capable of calculating a student's final grade in this course. Keep in mind that weighting by percentages is used in determining the final grade. 2. Excel Instructions-Your spreadsheet should be easy to read. Make sure the spreadsheet it is well-organized, with clear labels, and helpful formatting. . Sheet 1-Jasmine o o Open a new Excel spreadsheet file. Create 4 additional sheets in Excel. (5 sheets total). o How to create a new sheet in an Excel file: Click on the plus sign at the bottom of the page. Copy and paste the original spreadsheet into the new sheet before making changes. Rename the new sheets appropriately by right clicking on the sheet name and selecting Rename. O Use the "Save As" feature to save as follows: Last Name, First Name, Project 1 o Include your name, course name and project name on sheet 1. o Copy the percent weights from this Word document and paste into sheet 1 O Copy the Grading Scale provided in this Word document and paste into sheet 1 o Copy Jasmine's scores from this Word document and paste into sheet 1 Calculate the category (homework, quizzes, etc.) averages using Excel - Average function o Create a labeled cell with the Final course grade that uses a formula to calculate the weighted average grade for the course. . If a grade value is changed, your final calculation should recalculate. . Only use Excel functions and formulas discussed in this course. (For a list see the 'Excel Reference sheet' in Modules > Handouts > Unit 1. Sheet 2 and 3- Malik and Kayla o Malik and Kayla plan to transfer their math credit to a 4-year college, but they need to earn a C or better to transfer credit. Using the given category weights find the lowest score they can earn on the final exam to get a C in the class. o Copy and paste Malik's grades into sheet 2. Copy and paste Kayla's grades into sheet 3. o Calculate the final grade for Malik and Kayla as described above. O Determine the lowest grade needed on Exam 3 for each student to earn a C in the course. Sheet 4-Aaron The Math department has decided to remove the project category and redistribute the percent weight to the other categories. Copy and paste Aaron's grades into sheet 4. Consider what will be the most helpful for Aaron, o o Copy the original percent weight table in sheet 4, delete projects and redistribute the percent weight from the projects to give Aaron the highest letter grade. (Make sure percents total 100%) Math 123 Quantitative Reasoning Project 1-Spring 2022 Evansville o Calculate the final grade as before using new weights. Sheet 5-Pie Charts o On sheet 5 copy and paste the original percent weight table. O Insert a Pie Chart to reflect the original percent weights for MATH 123. Add an appropriate title and edit the labels to show the percent weights and categories. Also on sheet 5 with the first Pie Chart, copy and paste the new percent weight table that incudes the weights for Aaron. o Insert a second Pie Chart to reflect your new weighting system. Add an appropriate title and edit the labels to show the percent weights and categories. . D 3. Reflection Paper Instructions-Using Microsoft Word, write a typed reflection paper (minimum one page, double-spaced). Remember that we are looking for responses that are backed by values that support your statements. The explanations should be clear to a broad audience. The paper must include the following information: O Open Word Document file and Save As follows: Last Name, First Name, Project 1 o o o O O Due Date Include your name, course name and project name. Explain how the final grade is calculated using Excel Jasmine-Analyze and reflect on the results for the student data provided. What final course score did Jasmine earn? What letter grade is this? Compare the category averages. What did you notice about the exams versus the other categories? Malik and Kayla-The student must earn a C or better to transfer the MATH 123 credit to a 4-year college. . Do you think it is likely that Malik will earn a C in the course? Explain your reasoning. Do you think it is likely that Kayla will earn a C in the course? Explain your reasoning. Aaron-The school's math committee has decided to remove the project category. Describe the new weighting system you created so Aaron will earn the highest possible letter grade. Explain why/how you chose your new weights. What score and letter grade will Aaron earn with the new weighting system? Pie charts-Reflect on the similarities and differences in the two Percent Weight pie charts you created. o Reflect on the results of your project. What have you learned from doing this project? . If it is possible to earn a C, what is the lowest score each student will need on Exam 3? If it is not possible to earn a C, explain why. In addition to addressing the given statements, your project should: 0 Contain a paper that is well organized and in paragraph form (not just bulleted answers!). o Project should be your original work. Copying someone else's work is cheating. Sharing your work with someone else is cheating. o These instructions cover the MINIMUM expectations of this project. Students are encouraged to make additions beyond these items. Submit both an Excel and Word files through Ivy Learn by going to Project 1 Assignment uth 123 Quantitative Reasoning Project 1-Spring 2022 Evansville Due Date Use the following parameters and scores in your Excel spreadsheet Categories Homework. Quizzes Review Quizzes Projects Exam 1 Exam 2 Exam 3 Homework 89 79 83 80 85 89 80 94 Percent Weight 15% 5% 5% 10% 20% 20% 25% 93 88 Create an Excel spreadsheet that will compute the final grade for each of the following scenarios for a MATH 123 class. Assume all scores are out of 100. These tables can be copied and pasted into Excel to save time. Scenario #1: 99 89 79 99 Jasmine has the following grades. Using the category weights and grading scale provided, find Jasmine's final grade. Grading Scale A B C Quizzes 93 79 83 89 98 D F Review Quizzes 85 94 91 90-100% 80-89% 70-79% 60-69% 0-59% Projects Exam 1 88 55 95 Exam 2 59 Exam 3 (Final) 61 ath 123 Quantitative Reasoning Project 1-Spring 2022 Evansville Due Date Use the following parameters and scores in your Excel spreadsheet Categories Homework. Quizzes Review Quizzes Projects Exam 1 Exam 2 Exam 3 79 83 80 85 89 80 94 93 Percent Weight 15% 5% 5% 10% 20% 20% 25% 88 99 89 Create an Excel spreadsheet that will compute the final grade for each of the following scenarios for a MATH 123 class. Assume all scores are out of 100. These tables can be copied and pasted into Excel to save time. Scenario #1: 79 99 Jasmine has the following grades. Using the category weights and grading scale provided, find Jasmine's final grade. Homework 89 Grading Scale A B Quizzes 93 79 83 89 98 C D F Review Quizzes 85 94 91 Projects Exam 1 88 95 90-100% 80-89% 55 70-79% 60-69% 0-59% Exam 2 59 Exam 3 (Final) 61 Malik: 123 Quantitative Reasoning Project 1-Spring 2022 Evansville Scenario #2 & 3: Malik and Kayla plan to transfer their math credit to a 4-year college, but they need to earn a C or better to transfer credit. Using the given category weights above find the lowest score they can earn on the final exam to keep a C. Kayla: Homewor k 93 74 79 85 94 65 55 70 62 70 63 65 79 80 95 36 71 78 67 82 58 80 62 Homework Quizzes 94 70 75 89 86 Quizzes 61 65 75 55 74 93 87 91 Review Quizzes 66 71 70 Review Quizzes 75 91 88 Projects 71 63 Projects 91 87 Due Date Exam 1 60 Exam 1 82 Exam 2 54 Exam 2 83 Exam 3 (Final) ? Exam 3 (Final) ? Aath 123 Quantitative Reasoning Project 1- Spring 2022 Evansville 86 89 Scenario #4: Aaron has the following grades. The math department has decided to remove the project category. Create a new percent weights table without a project category and redistribute the project weight to one or more categories. What will be the most helpful for Aaron? In other words, where should the percent from the projects be added to give Aaron the highest letter grade? Homewor k 78 96 84 94 85 89 80 98 100 89 82 92 80 92 Quizzes 74 70 83 86 74 Review Quizzes 79 65 71 Due Date Exam 1 83 Exam 2 88 Exam 3 (Final) 71