ݺߣ

ݺߣShare a Scribd company logo

Case Problem: English.xlsx

?
?
V
ViscKand

1. The document provides instructions for grading student exam scores in an English class using a grading curve. 2. Professor Warren wants the top 15% to receive an A, the next 30% a B, the next 30% a C, and the bottom 10% a D. 3. The instructions guide the user to open the English workbook, enter their name and date, and use formulas like VLOOKUP, COUNTIF, and percentages to determine the appropriate cutoff points that satisfy the grading curve percentages.

Convert to study materialsBETA

Transform any presentation into ready-made study materialselect from outputs like summaries, definitions, and practice questions.

1 of 2
Download to read offline
Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-English.xlsx Dais File needed for this Case Problem: English.xlsx. English 117Professor David Warren is the instructor of English 117 at Youngdale College In Darwille, Virginia. Professor Warren and his teaching assistants have recently graded the semester final exam for the,. students in the class. He needs to use Excel. determine an appropriate Ending curve. Professor Warren wants roughly the top 15 percent of his students to receive an A, the n.. percent to receive a B, the next 30 percent to receive a C, and the bottom 10 percent to receive a D. The professor has already created a workbook that contains the student scores and the start of a grading scale. He warns you to use the Scenario Manager and Solver to determine appropriate cutoff points f or each grade. Complete the following: 1. Open the English workbook located in the Excel10?Case2 folder included with your Data Files, and than save the workbook as English Grades in the location specified by your instructor. 2. In the Documentation worksheet enter your name and the curtest date. 3. In the Final Grades worksheet, the range E5:F8 will contain the lower and upper range for each grade, as follows: a. In the range E5:83, enter the values 0, 70, 80, and so to indicate that the lowest value Ds, Cs, Bs, and As are 0, 70, SO, and 90 poi., respectively. b. In the range F5:F7, calculate the upper limit for each grade by entering a formula that returns a value 1 point less than the lowest value for the next grade. For example, the formula in cell F5 is =E8-1. c. In cell FB, enter 100 as the upper limit for an A.
4. In the range C5:C144, calculate each student's grade with the VLOOKUP function, using the final scare in column B as the lookup value, the range E5L8 as the lookup table, and the third column of that table as the return value. Use an approximate match to perform the lookup. 5. In the range H5:H8, use the COUNTIF function to count the number of students in the range C5L144 who fall within each of the four possible class grades, using the letter grades in the range G5:G8 as the criteria. 8. In cell H9, calculate the total number of grades given. P. In the range 15:18, calculate the percentage of the students who received each grade.

More Related Content

Case Problem: English.xlsx

  • 1. Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-English.xlsx Dais File needed for this Case Problem: English.xlsx. English 117Professor David Warren is the instructor of English 117 at Youngdale College In Darwille, Virginia. Professor Warren and his teaching assistants have recently graded the semester final exam for the,. students in the class. He needs to use Excel. determine an appropriate Ending curve. Professor Warren wants roughly the top 15 percent of his students to receive an A, the n.. percent to receive a B, the next 30 percent to receive a C, and the bottom 10 percent to receive a D. The professor has already created a workbook that contains the student scores and the start of a grading scale. He warns you to use the Scenario Manager and Solver to determine appropriate cutoff points f or each grade. Complete the following: 1. Open the English workbook located in the Excel10?Case2 folder included with your Data Files, and than save the workbook as English Grades in the location specified by your instructor. 2. In the Documentation worksheet enter your name and the curtest date. 3. In the Final Grades worksheet, the range E5:F8 will contain the lower and upper range for each grade, as follows: a. In the range E5:83, enter the values 0, 70, 80, and so to indicate that the lowest value Ds, Cs, Bs, and As are 0, 70, SO, and 90 poi., respectively. b. In the range F5:F7, calculate the upper limit for each grade by entering a formula that returns a value 1 point less than the lowest value for the next grade. For example, the formula in cell F5 is =E8-1. c. In cell FB, enter 100 as the upper limit for an A.
  • 2. 4. In the range C5:C144, calculate each student's grade with the VLOOKUP function, using the final scare in column B as the lookup value, the range E5L8 as the lookup table, and the third column of that table as the return value. Use an approximate match to perform the lookup. 5. In the range H5:H8, use the COUNTIF function to count the number of students in the range C5L144 who fall within each of the four possible class grades, using the letter grades in the range G5:G8 as the criteria. 8. In cell H9, calculate the total number of grades given. P. In the range 15:18, calculate the percentage of the students who received each grade.