Question: Add a column called Calc. Final Grade . Using a formula, calculate the final grade for each student as a whole number out of 100

Add a column called Calc. Final Grade. Using a formula, calculate the final grade for each student as a whole number out of 100 (not a percentage) using the Totals and Weights provided for each course deliverable at the top of the sheet.

Each individual course deliverable's (assns, exam, best of quiz) contribution to the final mark is calculated using studentMark / Total * Weight. All three of these values should be cell references. This result for each deliverable should then be added together.

The final grade must not have decimal places. Use the ROUND function to accomplish this, rather than a formatting option.

Total and Weight must be referenced absolutely so that you can copy your formula.

You will not use the individual quiz marks for this, only the calculated Average of best column, the assignments and the exam.

There is no pre-built function for this ... it is just basic math

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Add a column called Calc. Final Grade. Using a formula, calculate the final grade for each student as a whole number out of 1 0 0 ( not a percentage ) using the Totals and Weights provided for each...

Case Study #1 Due Wednesday, December 13 th at 11:59p.m. Part A Instructions You are an instructor teaching a computer science course. You have decided to use Excel to create a gradebook to keep...

Excel Features & Functions Used in this exercise Use Color Fill & Font for formatting IF Statements Nested IF Statements Basic Calculations Weighted Grade Calculations Vlookup - Letter Grade Creating...

there are 25 questions --- i feel totally lost please help1 1 Problem 10-14 Analyzing bond price changes [LO3] Katie Pairy Fruits Inc. has a $3,000, 22-year bond outstanding with a nominal yield of...

Here is a challenge question if anyone wants to help out. :) $10 tip if completed in 1 1/2 hour. Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $80,000....

1 B C D E F G H 2 HW Grade Due Date Completed Date Late/Early Late Points Early Points Adjusted HW Grade 3 5 6 901/29/19 801/28/19 1/21/19 601/27/19 1/30/19 501/23/19 1/20/19 481/25/19 1/27/19...

Assignment In the table below, there are exam scores from a class of students. The first exam was worth 150 points and the second exam was worth 180 points and the scores in the table are the points...

Please attached is the questions. Please let me know if you can get it done! Thanks Assignment Print View 1 of 21 1. http://ezto.mheducation.com/hm.tpx Award: 1.00 point Assume a corporation has...

Total Points Calculated Grade GPA Value 675 A+ (i.e., 675 points and above is an A+) 4.3 650 A (i.e., 650 to 674.99 points and above is an A) 4.0 630 A- (i.e., 630 to 649.99 points is an A-) 3.7 605...

Indeterminate Form 10: lim xx-2 2x-1

Referring to the previous problem, find the same probabilities through the counting argument explained in this section. Start with 100,000 athletes and divide them into the various categories. a....

1.40 Fur seals on Saint George Island. Every year hundreds of thousands of northern fur seals return to their haul-out territory in the Pribilof Islands in Alaska to breed, give birth, and teach...

1. Buying groceries at the supermarket. 2. Selling a house 3. Getting married out of community of property. 4. Starting a new cellphone contract. 5. Arranging monthly instalments to pay for the car...

Self-confidence

The number of people commenting on the statement

3. Choose a social incident in your local area. (a) List three points that you believe are the cause of the social incident and develop a model that shows a linear relationship. (b) What is the...