USA: +1(669)289-8683 
Sign in
Documentation
| SAM | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Emerge EXCEL 2010 CP3a – | Advanced Calculus | DO NOT DELETE–> | %(1B885A789636ED21-DB5E6CF1036C4DE1)% | |||||||||||||||||||||||||||||||||||||||||||||||
| Author | Kenya Sheard | |||||||||||||||||||||||||||||||||||||||||||||||||
| Note: Do not edit this sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM web site. | ||||||||||||||||||||||||||||||||||||||||||||||||||
| nhqbdvkhdug |
Final Grades
| Final | Marking Period | ||||||||||||||||
| Posted: June 25th | |||||||||||||||||
| Weight | Median | Maximum | Minimum | Range | |||||||||||||
| MP 1 | 15% | ||||||||||||||||
| MP 2 | 20% | ||||||||||||||||
| MP 3 | 25% | ||||||||||||||||
| Final Exam | 40% | ||||||||||||||||
| 100% | |||||||||||||||||
| Students | |||||||||||||||||
| Student Grades | Top 15 Final Grades | ||||||||||||||||
| Student Name | |||||||||||||||||
| Albert Barns | 98.0 | 83.0 | 79.0 | 72.0 | |||||||||||||
| Brooklyn Rodriguez | 84.0 | 87.0 | 94.0 | 80.0 | |||||||||||||
| Grace Kellian | 55.0 | 56.0 | 63.0 | 65.0 | |||||||||||||
| Sophie Tuckman | 95.0 | 91.0 | 93.0 | ||||||||||||||
| Ira Banks | 82.0 | 76.0 | 77.0 | ||||||||||||||
| Velma Joy | 52.0 | 66.0 | 61.0 | 53.0 | |||||||||||||
| William Ng | 85.0 | ||||||||||||||||
| Jennifer Laina | 89.0 | 78.0 | |||||||||||||||
| Emily Catalan | 92.0 | 97.0 | |||||||||||||||
| Michael Benjamin | 74.0 | 75.0 | 64.0 | ||||||||||||||
| David Samuels | 96.0 | ||||||||||||||||
| Damian Antonio | 69.0 | 81.0 | |||||||||||||||
| Jenna West | 70.0 | ||||||||||||||||
| Alex Bader | 86.0 | ||||||||||||||||
| Phil Marshall | 90.0 | ||||||||||||||||
| Sandy Fields | 88.0 | ||||||||||||||||
| Stewart Minkle | |||||||||||||||||
| John Brottworth | 71.0 | ||||||||||||||||
| Megan Kandle | |||||||||||||||||
| Steven Longstop | 62.0 | ||||||||||||||||
| Evan Errigo | |||||||||||||||||
| Juan Sanchez | |||||||||||||||||
| Stephanie Pillman | 73.0 | ||||||||||||||||
| Rachel Woodrow | 100.0 | 99.0 | |||||||||||||||
| Tom Briggs | |||||||||||||||||
| Mary Jobs | 49.0 | 60.0 | 51.0 | ||||||||||||||
| Catherine Juarez | |||||||||||||||||
| Kevin Connoly | |||||||||||||||||
| Christina Keiser | 58.0 | ||||||||||||||||
| Sean Cord |
Emerge excel 2010
Cumulative Project 3
Advanced Calculus
Skills
Save a workbook with a new name
Enter formulas
Use absolute references
Fill adjacent cells with formulas
Create formulas using the COUNT function
Create formulas using the MEDIAN function
Create formulas using the MAX function
Create formulas using the MIN function
Apply conditional formatting to a range of cells
Control page breaks
Add print titles
Modify the worksheet orientation
Project overview
Silvio D’Alessandro is a high school mathematics teacher in Bergen Regional High School in Columbus, Ohio. He has started using Excel to calculate the final grade for students in his Advanced Calculus class. The final grade is a weighted average of the grades received for the first three marking periods and the final exam. One way to calculate a weighted average is by multiplying each student’s marking period grade by the weight given to the marking period and then final exam, and then totaling the results. For example, consider the following marking period grades and final exam grade:
· Marking Period 1 = 84
· Marking Period 2 = 80
· Marking Period 3 = 83
· Final Exam = 72
If the marking periods exams are each given a weight of 15, 20 and 25 percent, in that order, and the final exam is given a weight of 40 percent, the weighted average of the four scores is:
84*0.15 + 80*0.2 + 83*0.25 + 72*0.4 = 81.3
Mr. D’Alessandro already entered the marking period grades for his students and formatted much of the workbook. He wants you to enter the formulas and highlight the top 15 overall grades in the class.
STUDENT start FILE
Emerge_Excel2010_ CP3a_FirstLastName_1.xlsx
(Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions
Open the file Emerge_Excel2010_ CP3a_FirstLastName_1.xlsx and save the file as Emerge_Excel2010_CP3a _FirstLastName_2.xlsx before you move to the next step. Verify that your name appears in cell B4 of the Documentation sheet. (Note: Do not edit the Documentation sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM Web site.)
In the Final Grades worksheet, in cell F16, enter a formula to calculate the weighted average of the first student’s three marking period grades and the final exam. The formula in cell F16 should use absolute references to the weights found in the range B6:B9, matching each weight with the corresponding grade. Use Auto Fill to copy the formula in cell F16 into the range F17:F45.
In cell F12, use the COUNT function to calculate the total number of final grades in the range F16:F45.
In cell C6, use the MEDIAN function to calculate the median grade for the first marking period.
In cell D6, use the MAX function to calculate the maximum grade for the first marking period.
In cell E6, use the MIN function to calculate the minimum grade for the first marking period.
In cell F6, calculate the range of scores for the first marking period, which is equal to the difference between the maximum and minimum score.
Calculate the median, maximum, minimum, and range scores for MP 2, MP 3, the Final Exam, and the Final Grades. (Hint: Repeat steps 4 through 7 for each of rows 7, 8, 9, and 10.)
Use conditional formatting to highlight the top 15 scores in the range F16:F45 with Light Red Fill with Dark Red Text.
Insert a page break at cell A13, repeat the first three rows of the worksheet in any printout, print gridlines, and set the worksheet to Landscape orientation.
Your completed worksheet should look like the Final Figure below. Save your changes, close the workbook and exit Excel. Follow the directions on the SAM Web site to submit your completed project.
FINAL FIGURE
2 SAM PROJECTS 2010 – CENGAGE LEARNING
SAM PROJECTS 2010 – CENGAGE LEARNING 3
