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

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

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

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

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.

## Analyze the scenario (suggested length of 2–3 pa...

A. Discuss how an understanding of nursing-sensitive indicators could assist the nurses in this case in identifying issues that may interfere with...

...

## Ans Robin...

Ans Robin When nurses advocate for patients, stand up for patients’ rights, or work to meet their need for care,...

## All i need to change the formula so the solution l...

Question Description All i need...

## Write a 3 pages paper on private detectives and th...

Write a 3 pages paper on private detectives and the present legal system. Sam Spade and Sherlock Holmes, the main detective characters in The Malte...

Read the Case Study and answer the "Discussion Points" in a clear but concise way. Be sure to reference all sources cited and use APA form...

## Discussion 1 PHI 210 (Half a page)Please choose on...

Discussion 1 PHI 210 (Half a page)Please choose one of these options to write about.  Option 1: d...

## Psychology : Psychology Question...

Using the theories you have reviewed thus far, consider the following scenario: Mr. Lucas’ sixth-grade class contains diverse stud...

## Corrective Essay: Is Free Trade Good For America...

Simple sentence beginningsthe downfall of many potential writers. On entering this course, I was...

## Enviromental Paper...

Need in 8 hours from post. APA format Write a 1,400-word paper on a topic of environmental interest, which y...

Ferrara Food is the Italian leader in processing and preparation of tomato sauces for industrial use (mainly hotels and restaurants). Ferr...
Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65