You are a teaching assistant for Dr. Denise Gerber, who teaches an introductory C# programming class at your college. One of your routine tasks is to enter assignment and test grades into the grade book. Now that the semester is almost over, you need to create formulas to calculate category averages, the overall weighted average, and the letter grade for each student. In addition, Dr. Gerber wants to see general statistics, such as average, median, low, and high for each graded assignment and test, as well as category averages and total averages. Furthermore, you need to create the grading scale on the documentation worksheet and use it to display the appropriate letter grade for each student

a. Open e02m3Grades and save it as e02m3Grades_LastFirst .

b. Use breakpoints to enter the grading scale in the correct structure on the Documentation work-sheet and name the grading scale range Grades . The grading scale is as follows: 95+ A 90–94.9 A–87–89.9 B+83–86.9 B80–82.9 B–77–79.9 C+73–76.9 C70–72.9 C–67–69.9 D+63–66.9 D60–62.9 D–0–59.9 F

c. Calculate the total lab points earned for the first student in cell T8 in the Grades worksheet. The first student earned 93 lab points.

d. Calculate the average of the two midterm tests for the first student in cell W8 . The student’s mid-term test average is 87.

e. Calculate the assignment average for the first student in cell I8 . The formula should drop the lowest score before calculating the average. Hint: You need to use a combination of three functions: SUM, MIN, and COUNT. The argument for each function for the first student is B8:H8. Find the total points and subtract the lowest score. Then divide the remaining points by the number of assignments minus 1. The first student’s assignment average is 94.2 after dropping the lowest assignment score. 

You are a teaching assistant for Dr. Denise Gerber, who teaches an introductory C# programming class at your college. One of your routine tasks is to enter assignment and test grades into the grade book. Now that the semester is almost over, you need to create formulas to calculate category averages, the overall weighted average, and the letter grade for each student. In addition, Dr. Gerber wants to see general statistics, such as average, median, low, and high for each graded assignment and test, as well as category averages and total averages. Furthermore, you need to create the grading scale on the documentation worksheet and use it to display the appropriate letter grade for each student

a. Open e02m3Grades and save it as e02m3Grades_LastFirst .

b. Use breakpoints to enter the grading scale in the correct structure on the Documentation work-sheet and name the grading scale range Grades . The grading scale is as follows: 95+ A 90–94.9 A–87–89.9 B+83–86.9 B80–82.9 B–77–79.9 C+73–76.9 C70–72.9 C–67–69.9 D+63–66.9 D60–62.9 D–0–59.9 F

c. Calculate the total lab points earned for the first student in cell T8 in the Grades worksheet. The first student earned 93 lab points.

d. Calculate the average of the two midterm tests for the first student in cell W8 . The student’s mid-term test average is 87.

e. Calculate the assignment average for the first student in cell I8 . The formula should drop the lowest score before calculating the average. Hint: You need to use a combination of three functions: SUM, MIN, and COUNT. The argument for each function for the first student is B8:H8. Find the total points and subtract the lowest score. Then divide the remaining points by the number of assignments minus 1. The first student’s assignment average is 94.2 after dropping the lowest assignment score.