Question
D G H 1 GRADE SHEET 2 3 Weight Max Points 0.15 0.15 0.3 0.4 50 50 100 100 4 5 Name Project 1 Project
D G H 1 GRADE SHEET 2 3 Weight Max Points 0.15 0.15 0.3 0.4 50 50 100 100 4 5 Name Project 1 Project 2 Midterm Final TOTAL GRADE 6 Tom Big 45 40 80 85 7 Bob Small 15 20 65 70 Use this portion of grade sheet for BUS 100 to calculate the TOTAL weighted score for Tom Big. Note that this student has 45/50 for Project 1. 40/50 for Project 2, 80/100 for Midterm, and 85/100 for Final. The weight for projects is 15% each. Midterm weights 30% and Final 40%. How does the formula / expression for TOTAL in cell G6 look like? (Use absolute addresses in references to weights)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started