Using the Grades feature of Folio as a guide (menu Grades > Grades), create a spreadsheet to calculate your current subtotal grade in the class. Then calculate your current percentage (subtotal/Total grades * 100%, such as 35.4%). This is your current final grade, which should be the same as what is calculated by Folio. You must use formulas to do the calculation and keep the formulas. Manual calculation or using a calculator will receive a zero.

My total grade is 82.33%

Part 1 subtotal: 97.5 % (Reading and syllabus quiz)

Part 2 subtotal: 81.93 % (Labs)

Part 3 subtotal: 55% (Practicals)

Part 4 subtotal: 90% (Exams)

Create an excel spreadsheet and calculate these percentages with the information at the top

1 answer

To create an Excel spreadsheet that calculates your current subtotal grade and percentage, you can follow these steps:

Step 1: Open Excel

  1. Open Microsoft Excel or any other spreadsheet software.

Step 2: Set Up Your Spreadsheet

  1. Create a new spreadsheet and label the columns as shown below:

| A | B | C | D | |--------------------|-----------------|---------------------|-------------------| | 1 | | Grade (%) | Weighted | | 2 Part 1 | Reading & Syllabus Quiz | 97.5 | | | 3 Part 2 | Labs | 81.93 | | | 4 Part 3 | Practicals | 55 | | | 5 Part 4 | Exams | 90 | | | 6 Subtotal | | | | | 7 Total grade | | 82.33 | | | 8 Current Percentage | | | |

Step 3: Input Formulas for Subtotals

  1. In cell C6, enter the following formula to calculate the subtotal grade:
=AVERAGE(C2:C5)

This formula calculates the average of the grades from Parts 1 to 4.

Step 4: Calculate Current Percentage

  1. In cell C8, use the formula below to calculate the current percentage:
=C6*C7/100

This formula calculates the current percentage based on your subtotal grade and the total grade of 82.33%.

Step 5: Format & Layout

  1. To enhance readability, you can format the cells:
    • Bold the headers.
    • Format the cells in column C to display percentages.
    • Adjust column widths as necessary.

Final Layout

The final layout of your spreadsheet will look similar to this:

| A | B | C | D | |--------------------|----------------------------------|------------------|----------------| | 1 | | Grade (%) | Weighted | | 2 Part 1 | Reading & Syllabus Quiz | 97.5 | | | 3 Part 2 | Labs | 81.93 | | | 4 Part 3 | Practicals | 55 | | | 5 Part 4 | Exams | 90 | | | 6 Subtotal | | =AVERAGE(C2:C5) | | | 7 Total grade | | 82.33 | | | 8 Current Percentage | | =C6*C7/100 | |

Notes:

  • Make sure to leave the formulas in place so they can calculate dynamically if any of the grades change.
  • The values you entered for the grades should match the grades you've mentioned in your original message.

This will allow you to see your current subtotal and percentage grade in the class, functioning similarly to the Grades feature in Folio.