In this project

you will create a spreadsheet which keeps track of your grade in this Math 154 class. In addition

to simply recording all of your grades for the course, it will provide you with a "running tally" of how you are

doing in the course at any point in time du

ring the semester.

1. What does "running tally" mean? To help you understand this, compute the grade of a student with

an 82 MyMathLab Homework average, 84 Activities average

, a 92 on Project 1 and a 93 on Test 1

(label the cell sample s

tudent average). Use the syllabus to determine the appropriate weights for each

category and enter a formula in a spreadsheet to compute their grade. Re

-

compute their grade assuming

they get a 95 on Project 2. Insert a textbox into the spreadsheet and r

ecord both grades in the textbox.

Are you surprised by their grades? Explain what weights dominate at this point in the semester.

2. Create a new sheet (tab) in the spreadsheet from part 1 which will allow you to enter all of your

grades for this Math 1

54 course. Enter all your current grades for MyMathLab Homework, Activities

,

and Tests you already have. Enter a grade of 90% for Project 1. There should be nicely labeled spaces

for all of the following work:

Assume there will be 31 MyMathLab

Homework assignments.

Assume there will be 6 Activities.

There will be 2 Projects.

There will be 3 Tests.

3. Create cells which will compute the average MyMathLab Homework grade, average Activities grade

,

average Project grade, and average Test grade. Name these cells appropriately.

4. Create cells which will count the number of MyMathLab Homework grades entered so far

and

count

the number of Activities grades

. Name

these cells appropriately.

5. Create cells which will compute the max and min grades for each of the

4

categories: MyMathLab

Homework, Activities,

Project, and Test.

6. Create a Column Chart of your MyMathLab Homework grades

and

Activities grades

(put all on one

chart). The chart should update as you enter new scores.

7. Format all of this nicely with borders and shading.

8. Create a cell which computes your total grade using the ideas of weighted average. This formula

must

be linked to all of your input cells, so when you enter a grade it automatically updates. You may

use the average for the categories as counting for the full weight of that category.

9. Create a cell which computes the highest possible average you can ge

t in the class. Assume your

MyMathLab Homework

and

Activity

averages are fixed (use the averages on the sheet) but you should

assume that you get a 100 on all projects and remaining

tests

.

Reflection (place in a text box at the b

ottom of your Excel File):

Paragraph I

-

What did you learn from this process of creating a sheet to model something in your

world? Talk about successes and struggles while doing the project.

Paragraph II

-

Analyze your situation. What do your graph and computations tell you about your

grade? Where do you see the need for change? Where do you see the need to continue doing what

you have been?