Your total grade is made up of four parts - homework, classwork, POWs and assessments. The pie chart shows the percentage of the total that each part represents.

A spreadsheet template has been made for you to calculate your grade. Listen to the verbal directions for getting and saving this template into your folder as a WP document.

The formulas that calculate the percentages earned in each category have been written in cells B11, B20, B25 and B31. The totaling formula has already been written in cell B33. You simply add all the % earned from each of the four categories to get the total.

Now, enter the grades you have received in each category. Your total grade is shown at the bottom.

So, what do you have?

1. First, move to page two.

2. Now, insert a spreadsheet onto your page that is 5 rows x 3 columns.
In the first column, enter the four categories of grades in the class. In the second column, enter the percentage breakdowns for each category. In the third column, enter YOUR percentages earned in each category. Those percentages earned are found on your grading spreadsheet in B11, B20, B25 and B31. The numbers shown below in column C are only an example! Your percentages will probably not be the exact same as my example!

3. Next, you highlight all the cells on the spreadsheet. Remember, you cannot work on the sheet unless you are in spreadsheet mode on the tool panel. With all the cells highlighted, you then go up to your options pulldown menu and select MAKE CHART. The gallery will pop up in a dialogue box, allowing you to pick from a bunch of kinds of graphs. Choose bar graph and click on OK. You will see the following graph. Move it below your spreadsheet.

4. Now, you need to add a few things. You need to label you axes. Click onto your graph in either spreadsheet or arrow mode, then go up to the OPTIONS pulldown and select MODIFY CHART. Choose AXES. Label your X axis "Grading Categories" and your Y axis "Percentage". Now, modify again and choose SERIES. Choose to label the bars with their values. Lastly, choose LABELS and add a title called "My Grade". Your graph should look like this, except with your personal scores in the second category, not my example scores.

5. Now, discuss what this graph shows. How does this graph relate to the pie graph at the start of this lesson? Put your discussion paragraph below the graph.

6. Are you happy with your current grade? What can you do to improve your grade if you are not satisfied? Respond to this in one more paragraph below the graph.