Ask a New Question
Menu

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.

Save the spreadsheet as an Excel file (.xlsx). Keep a copy for yourself on Google Drive and attach a copy to this drop box and submit. submit a screenshot or a pdf file along with the excel file.

1 answer

To create a spreadsheet for calculating your current subtotal grade in your class using Excel, follow these steps:

Step 1: Set Up Your Spreadsheet

  1. Open Excel: Start by launching Excel on your computer.

  2. Create Your Columns: In the first row, set up the following headers:

    • A1: Assignment Name
    • B1: Points Earned
    • C1: Total Points
    • D1: Subtotal

  3. Input Your Data: Below these headers, input your assignment names, points earned, and total points. For example:

| A | B | C | D | |-----------------|------------|-------------|--------| | Assignment 1 | 85 | 100 | =B2/C2 | | Assignment 2 | 90 | 100 | =B3/C3 | | Assignment 3 | 75 | 100 | =B4/C4 |

Step 2: Calculate Subtotal

  1. Calculate Subtotals: In column D, use the formula to calculate the subtotal percentage for each assignment. For example, in cell D2, enter the formula =B2/C2. Drag down the fill handle to apply this formula to the other cells in column D.

Step 3: Calculate Current Total Grade

  1. Total Points Earned and Total Points: Below your assignments, calculate the total points earned and total points possible:

    • In cell B6, use =SUM(B2:B4) to sum Points Earned.
    • In cell C6, use =SUM(C2:C4) to sum Total Points.

  2. Calculate the Overall Percentage: In cell D6, calculate the overall percentage using the formula:

    • =B6/C6*100
    • This cell will give you the final percentage as a result.

Step 4: Format Your Spreadsheet

  1. Format Cells: Make sure to format columns D and the final percentage cell in D6 to show percentage formats correctly.

Step 5: Save and Share

  1. Save Your Spreadsheet:

    • Save the file as YourName_CurrentGrade.xlsx.

  2. Upload to Google Drive:

    • Upload the Excel file to your Google Drive.

  3. Submit a Copy:

    • Use the submission link to attach your Excel file.

Step 6: Create a Screenshot or PDF

  1. Take a Screenshot:

    • Use the snipping tool or screenshot functionality on your computer to capture a visual of your spreadsheet, ensuring all data and calculations are visible.

  2. Convert to PDF (Optional):

    • You can also print the spreadsheet to a PDF using the "Print" option and then selecting "Save as PDF."

Step 7: Final Submission

  1. Attach the Screenshot/PDF:
    • Submit this screenshot or PDF along with the Excel file as required.

By following these steps, you'll have a fully functional spreadsheet that calculates your current final grade, replicating the functionality in Folio.