To create an Excel spreadsheet that calculates your current subtotal grade and percentage, you can follow these steps:
Step 1: Open Excel
- Open Microsoft Excel or any other spreadsheet software.
Step 2: Set Up Your Spreadsheet
- 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
- 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
- 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
- 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.