Lab work due in 5-6 hours

HintsForXtra1PJT.docx

Home >Computer Science homework help >Lab work due in 5-6 hours

Hints/Steps for working with this project:

To get started with this project, here is what you need:

1. Open the file 4LTR_Excel_Xtra1PJT_ FirstLastName_1.xlsx and save the file as 4LTR_Excel_Xtra1PJT_ FirstLastName_2.xlsx before you move to the next step (Note: you will substitute FirstLastName with your first and last names – ex. Jane Doughy will be 4LTR_Excel_Xtra1PJT_Jane Doughy_2.xlsx .)

This document contains 2 worksheets – Documentation and Final Grades. In cell B4 of the Documentation sheet replace the FirstName LastName with your first and last names (say Jane Doughy).

Answer: open and save this file as indicated above.

2. 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

Answer: In cell F16, enter the following formula: =B16*$B$6+C16*$B$7+D16*$B$8+E16*$B$9

Now copy this formula to F17 through F45 using the Auto Fill or use copy and paste.

3. In cell F12, use the COUNT function to calculate the total number of final grades in the range F16:F45.

Answer: =COUNT(F16:F45)

4. In cell C6, use the MEDIAN function to calculate the median grade for the first marking period. Answer: =MEDIAN(B16:B45)

5. In cell D6, use the MAX function to calculate the maximum grade for the first marking period. Answer: =MAX(B16:B45)

6. In cell E6, use the MIN function to calculate the minimum grade for the first marking period. Answer: =MIN(B16:B45)

7. 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. Answer: =D6-E6

8. 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.)

Answer: repeat (4), (5), (6) above but this time you will use MP2, MP3, Final Exam and Final Grades columns. You have done this for MP1 column, which is B16:B45. do it for the others.

(*********************************************************************************)