1.Go to Start, Programs, and Open Microsoft Excel

Do the Math

Review the table on the following link KEES Site 1that shows how much you can receive for each year that you earn a 2.5 GPA.

Create a spreadsheet and chart showing how much KEES money you would make, based on your current grades, if you were in high school.

1.Go to Start, Programs, and open Microsoft Excel.

2.Start in cellA3going to cell C3type the following headings: Year in School, GPA and Amount. Type one heading in each cell.Hint: if some of your text goes into the next cell, move your curser or mouse up to the line between the letters and double click to auto fit the cells to the text.

3.In cell A4 down column A, type your years in school: Freshman, Sophomore, Junior, Senior. Total

4.In column B starting with B4, under the GPA heading, type in your GPA's (as well as you remember them) from middle school, this doesn't have to be exact.6th Grade-Freshman 7th Grade-Sophomore 8th Grade Junior and Senior Year

5.To calculate your GPA.type =(first periodgrade + second period grade + third period grade + fourth period grade + fifth period grade + sixth period grade + seventh period grade)/7. You need to convert the grades into numbers as follows: A = 4; B = 3; C = 2; D = 1; F = 0

6.Use the table (How much can I receive for each year…) to determine how much money you would have earned for your grade point average if you were in high school. Record that amount in column three under the Amount heading. Click on the letter C at the top of the amount column and click on format, cells, number, and currency and change the decimal places to zero, this time. Make sure the $ symbol displays. Click OK.

7.Use a formula to total the scholarship you "earned" during your years in high school. Put your curser at the bottom of the Amount column and type an = sign, then click on the formulas tab and find sum and total the column.

8.If you made 1/2 grade point average higher, how much more money would you earn per year? Add another GPA column and Amount column; call it PredictedGPA and PredictedAmount. Increase your GPA and look up the correct $'s earned at the higher GPA.Hint: don't forget to format your columns for decimals and currency and use another formula to calculate the total.

9.How much more per year of college, could you make?

10.Create a column chart to show your information. Highlight Column A starting with Year in School down to Total, hold Ctrl highlight column C starting with Earned Amount, hold Ctrl highlight Column E. Click on the Insert tab. Select a column chart.

11.Change the chart layout to number 9. The chart should have a title, horizontal/vertical axis and a legend.

12.Give the chart a title“Earned and Predicted GPA Scholarship”. Label X axis as years in high school and the Y axis as Amount. Click Next.

13.Save as Do the Math

1