First, decide on which numbers match which letters. After this, you will see a pie chart is formed in your worksheet. Before inserting make sure to select the data you want to analyze. You can also insert the pie chart directly from the insert option on top of the excel worksheet. Copy this cell down the column.Ĭonvert to a letter grade. From there select Charts and press on to Pie. This is the sum of all the weighted grades. Copy these cells down the columns for all your rows of data.Ĭompute the raw grade. Copy this to cells E2, G2, I2, K2, M2, O2 and Q2. So, in the example, in cell C2 enter "=B2_0.035". Each individual homework assignment would be 30/8 or 3.5 percent.Ĭompute the weighted grades in the blank columns next to each raw grade. Suppose you've decided that all the homework together will be 30 percent of the final grade, the midterm another 30 percent and the final exam 40 percent. In each cell that has a header, enter data. In the example, these would be cells V1 and W1.Įnter the data. Skip one more column and enter "Raw Grade" and "Letter Grade" in adjacent cells in row 1. Enter "Name" in cell A1, "HW1" in cell B1, "HW2" in cell D1, "HW3" in cell F1, "HW4" in cell H1, "HW5" in cell J1, "HW6" in cell L1, "HW7" in cell N1, "HW8" in cell P1, "Midterm" in cell R1 and "Final" in cell T1. We will click on the Pie Chart icon in the Charts section and select the type of Pie Chart we want. Leave a blank column to the right of each grade. We will click on anywhere within the Pivot Table. An example of this is: "Name," "HW" (with a number,)" Midterm" and "Final" in row 1. For example, you might want to combine eight homework assignments, one midterm exam and one final exam for a total of 10 grades.Įnter header that represent the following: the name of the student, the grade for each homework assignment, a header for the midterm and a header that represents the grade for the final. Decide on the number of grades you need to combine.