Day 11 - Formatting a workbook continues
Case | Chemistry 303 Final Scores
Karen Raul is a professor of chemistry at a community college in Shawnee, Kansas. She has started using Excel to calculate the final grade for students in her Chemistry 303 course. The final score is a weighted average of scores given for three exams and the final exam. Karen wants your help in creating the formulas to calculate the final score and to summarize the class score on all exams. One way to calculate a weighted average is by multiplying each student’s exam score by the weight given to the exam, and then totaling the results. For example, consider the following four exam scores:
• Exam 1 = 84
• Exam 2 = 80
• Exam 3 = 83
• Final Exam = 72
If the first three exams are each given a weight of 20% and the final exam is given weight of 40%, the weighted average of the four scores is:
84*0.2 + 80*0.2 + 83*0.2 + 72*0.4 = 78.2
Karen already entered the scores for her students and formatted much of the workbook. She wants you to enter the final formulas and highlight the top 10 overall scores in her class.
• Exam 1 = 84
• Exam 2 = 80
• Exam 3 = 83
• Final Exam = 72
If the first three exams are each given a weight of 20% and the final exam is given weight of 40%, the weighted average of the four scores is:
84*0.2 + 80*0.2 + 83*0.2 + 72*0.4 = 78.2
Karen already entered the scores for her students and formatted much of the workbook. She wants you to enter the final formulas and highlight the top 10 overall scores in her class.
Instruction
|
Data File RequiredThe file on the left side is an instruction file. Click on Download File to open the file. Once opened, print a copy to get started. This particular assignment requires a data file to start. After printing the instruction file, go to the Data Files tab and open "Chemistry" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive. |