. . Understanding how weighted averages work will be a very important topic for you in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
. . 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 . . 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
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0134127620
11th edition
Authors: Walter Harrison, Charles Horngren, William Thomas, Wendy Tietz
Posted Date:
Students also viewed these mathematics questions
-
Write SQL update statements to do the following on the database schema shown in Figure 1.2. (a) Insert a new student in the database. (b) Change the class of student 'Smith' to 2. (c) Insert a new...
-
For this assignment, you are required to do the following: 1. Select the field of study that you are interested in. State clearly the Research topic. In the selected field of study, make sure that...
-
Create an Excel spreadsheet that graphs the portfolio return and standard deviation combinations found in Problem for Home Depot and Lowes. In problem Use the table of annual returns in Problem for...
-
CORPORATE FINANCE- RISK MANAGEMENT You manage a Swedish company that produces hats. You source your textiles mainly from Poland. The next input delivery from Poland is coming in three months. The...
-
The Cutting Department of Sonoras Textiles has the following information about production and costs for the month of July: Beginning work in process, 9,200 units that are 100 percent complete as to...
-
The balance sheet for Quinn Corp. is shown here in market value terms. There are 12,000 shares of stock outstanding. The company has declared a dividend of $1.45 per share. The stock goes ex dividend...
-
Use stepwise regression to build a model for the home rental prices and home sales data in Table B.24. Perform a residual analysis on the final model. Compare this model to the all possible...
-
Refer to the previous question. Suppose that each of the audit activities can be crashed by the amounts indicated in the following table. a. What is the earliest the audit could be completed and what...
-
What novel insights can be gleaned from the burgeoning field of positive psychology regarding the cultivation of psychological strengths and virtues as a means of buffering against the detrimental...
-
A 2 4 factorial design was run in a chemical process. The design factors are A = time, B = concentration, C = pressure, and D = temperature. The response variable is yield. The data follow: (a)...
-
Consider a firm with a contract to sell an asset for $150,000 five years from now. The asset costs $86,000 to produce today. Given a relevant discount rate on this asset of 12 percent per year,...
-
"Municipalities in South Africa are faced with a serious challenge of service delivery. It is argued that in some instances this emanates from poor talent management strategies that fail to retain...
-
Brothers Flooring Two brothers, Ali and Abbas Hamdouni have started a flooring business installing tiles, laminate and hardwood floors in residential units. From their start they have been very keen...
-
Change is inevitable in organizations and must be effectively managed by a change agent. Based off your course material, define and identify at least one characteristic of an internal change agent....
-
20 points each 1. Management wants to see all sales for each genre. Required Components: 1) A bar chart depicting Global Sales in million USD versus Genre in the other axis. 2) Display the Sum total...
-
Casius is a boxer who competes in boxing matches organised by "Barnaby's Bouts". During one of Casius fights he suffers a large cut on his forehead from a blow from his opponent in round 2. He later...
-
On 12 August 2005, Paulena purchased a ticket at the branch office of Hutch Airlines in Singapore for a flight from Kuala Lumpur to Cardiff, via Amsterdam. While embarking at Kuala Lumpur...
-
Four GWU students have been selected to taste food sold by 3 different food trucks labeled as food truck A, B and C on H & 22nd Streets every Monday for 3-weeks. For each student, food trucks are...
-
Toyland prepares budgets to help manage the company. Toyland is budgeting for the fiscal year ended January 31, 2016. During the preceding year ended January 31, 2015, sales totaled $9,600 million...
-
The adjusted trial balances of Bova Corporation at August 31, 2016, and August 31, 2015, include these amounts (in millions): Bova completed these transactions (in millions) during the year ended...
-
Boltwood Manufacturing bought three used machines in a $148,000 lump-sum purchase. An independent appraiser valued the machines as shown: Machine No. Appraised Value...
-
Brown India Limited manufactures office tables. Normal capacity of the factory is 60,000 tables per annum. Following are the cost and inventory details for the year 200506. Required: Carry out the...
-
Usha Corporation Ltd. sought the advice of an investment advisor for deployment of surplus funds of around Rs. 45 lakh in the stock market. The advisor advised to invest in Bhonsle India Ltd. and...
-
Ram Lakhan Company Ltd. produces one unit of product B by using one unit of raw material A. During 200506 A costed the company 4,200. Conversion cost was 850. As on 31st March 2006, being the...
Study smarter with the SolutionInn App