DATAFile: OM455 Professor Rao would like to accurately calculate the grades for the 58 students in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
DATAFile: OM455 Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which follows. (a) The Course Average is calculated by weighting the Midterm Score and Final Score 50% each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 73 74 75 76 77 78 79 Need Help? OM 455 Section 001 Course Grading Scale Based on Course Average: Alt Amini Amaako Apland Bachman Corder Desi Dransman Duffuar Finkel Foster A Course Grade A A B с D F Read It Last Name Watch It B Number Lower Limit 0 58 68 79 90 B Midterm Score 70 95 82 45 68 91 87 60 80 97 90 Upper Limit 57.9 67.9 78.9 89.9 100 Final Score 56 91 80 78 45 98 с 74 80 93 98 91 D Course Grade F D с B A Course Average 63.0 93.0 81.0 61.5 56.5 94.5 80.5 70.0 86.5 97.5 90.5 D ><|||||||||||||||||||||< < | A B D F A B с (b) Use the COUNTIF function to determine the number of students receiving each letter grade among all 58 students in the class. C B A E Course Grade ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ F DATAFile: OM455 Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which follows. (a) The Course Average is calculated by weighting the Midterm Score and Final Score 50% each. Use the VLOOKUP function with the table shown to generate the Course Grade for each student in cells E14 through E24. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 73 74 75 76 77 78 79 Need Help? OM 455 Section 001 Course Grading Scale Based on Course Average: Alt Amini Amaako Apland Bachman Corder Desi Dransman Duffuar Finkel Foster A Course Grade A A B с D F Read It Last Name Watch It B Number Lower Limit 0 58 68 79 90 B Midterm Score 70 95 82 45 68 91 87 60 80 97 90 Upper Limit 57.9 67.9 78.9 89.9 100 Final Score 56 91 80 78 45 98 с 74 80 93 98 91 D Course Grade F D с B A Course Average 63.0 93.0 81.0 61.5 56.5 94.5 80.5 70.0 86.5 97.5 90.5 D ><|||||||||||||||||||||< < | A B D F A B с (b) Use the COUNTIF function to determine the number of students receiving each letter grade among all 58 students in the class. C B A E Course Grade ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ ✓✓ F
Expert Answer:
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date:
Students also viewed these programming questions
-
How do you calculate the present value of a series of quarterly floating rate payments for the next 8 quarters? Notional value is 100Million annual rates based on quarterly compounding Forward Rates...
-
Job fatigue and stress are significant problems faced by employees and their managers. Unfortunately, when a case of depression arises as a result, trying to resolve the problem may be...
-
A segment of steel cable is 4.0 meters long and has a diameter of 2.0 cm. What is the spring constant of the cable?
-
Some rocks or bricks contain small air pockets in them and have a spongy structure. Assuming the air spaces form columns of an average diameter of 0.006 mm, determine how high water can rise in such...
-
What is the long-range fate of all the uranium that exists in the world?
-
Apply present value to a stream of payments using internal rate of return and bond valuation.
-
A player places one grain of rice on the first square of a chess board. On the second square, the player places 2 grains of rice. On the third square, the player places 4 grains of rice. On each...
-
Bruno Company has decided to expand its operations. The bookkeeper recently completed the balance sheet presented on the next page in order to obtain additional funds for expansion....
-
Garden Yeti manufactures garden sculptures. Each sculpturerequires 8 pounds of direct materials at a cost of $4 per pound and0.4 direct labor hour at a rate of $14 per hour. Variable overheadis bud 2...
-
The motorcyclist travels with constant velocity along a straight, horizontal, banked road. If he aligns his bike so that the tires are perpendicular to the road at A, determine the frictional force...
-
Would it be reasonable for the Tonor company to use secondary data in their market research, instead of primary data? Provide two reasons for your answer, relating to the definitions of primary and...
-
Configure telnet on all routers Q2. Configure console passwords on all routers and enrcrypt all Q3. Configure Security Banner on all router Q4. Configure OSPF on all routers Q5. Configure named...
-
A firm has a leverage beta of 1.6 and a D/E ratio of 1. the firm long term target -leverage is D/E target = 0.5. Assuming that: the corporate rate is 50% the expected market return is 9% and free...
-
Investigate the role of advanced water resources management strategies, such as integrated watershed modeling and real-time hydrological forecasting, in addressing challenges related to water...
-
You are a Human Services Provider working in the Pediatrician's office as a parent educator. Your role is to educate parents about what is normal development. As you watch the video about Emily, it...
-
Under the "standardized measurement approach," if a bank's BI amount is 0.9 billion, and its BI component and loss component are respectively $99 million and $120 million, then the required capital...
-
Product Buying Report Explanation Intended Use and Requirements: create a scenario explaining the background of these requirements, as well as all the buying influences that need to be considered....
-
The time to assemble the first unit on a production line is 10 hours. The learning rate is 0.94. Approximately how long will it take for the seventh unit to be assembled? The number of hours needed...
-
Consider again the CHB Inc. problem described in Problem 10. Suppose only a limted number of PPBs can be placed. CHB would like to place this limited number of PPBs in counties so that the allowable...
-
Suppose that you initially invested $10,000 in the Stivers mutual fund and $5,000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table:...
-
With the gasoline time series data from Table 5.1, show the exponential smoothing forecasts using a = 0.1. a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a...
-
Convert 3.8874 to fraction form and reduce to lowest terms. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
Convert \(\frac{27}{625}\) to decimal form. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
\(\frac{3}{5}+\frac{3}{10}\) Perform the indicated operations. Reduce to lowest terms.
Study smarter with the SolutionInn App