Question

Explain how you setup your excel worksheet. Make sure to address any formula used by showing an example but avoid using cell references (B5, A3, G12, etc.) What final course percentage (to 1 decimal) did you calculate? What letter grade in the course did this student earn?

Answer 1

Answer:

Step-by-step explanation:

to set a spreadsheet on excel, you start with the category labels on the top row, then you go down in columns. Then you enter the scores that you want for each category . after you are done with entering the scores, you found the average percent of each category by dividing the total amount of scores by the number of score in one cell . For Example, the total score was 1530 and there was 20 , you got 76.5%. you continue this for each category. Then multiplied it by the category weights. Finishing it off, I added each categories’ answers up and got my final grade of 76.5%. The letter grade this student got was a C.(google spread sheet)