Chp 2 - Professor's Grade Book - v.May 2015
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.
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Download and open the file namedexploring_e02_grader_h4.xlsx.
In the range A7:B9 in the Documentation sheet, enter the breakpoints for the C grades. In row 7, enter 70 as the breakpoint for C-; in row 8, enter 73 as the breakpoint for C; and in row 9, enter 77 as the breakpoint for C+.
Assign the name Grades to the range A3:B14 in the Documentation sheet.
Hint: Create a named range.
In cell R3 of the Grades sheet, calculate the total lab points earned for the first student in the Grades worksheet. Lab assignments are indicated by the column labels L1 through L8. Then copy the function to the range R4:R21.
Hint: - There is no such function in Excel called TOTAL(). Instead, use the function that can be used to add up values stored across a range of cells. - To copy the function, drag the fill handle in cell R3 to cell R21.
In cell U3 of the Grades sheet, calculate the average of the two midterm tests for the first student. Midterm tests are indicated by the column labels M1 and M2. Copy the function to the range U4:U21.