Excel Project Chp 2 - Professor's Grade Book - v.May 2015

Excel Project Chp 2 - Professor's Grade Book - v.May 2015

Author: matthew stock


Chp 2 - Professor's Grade Book - v.May 2015
Project Description:
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:


Points Possible


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.

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.