This project is on both sides of the paper you need to do both sides.

What Weekly Sales Report Look Like

The objective – is for you to make a line graph, A bar graph and five circle graphs with the included information

You are to answer the prior knowledge question sheet first.

You will make a line graph, bar graph and five circle graphs using the information provided for the week sales. You are to make a chart then graph the chart labeling all the parts of the graph properly.

Intended audience – Seventh grade students

Outcome – Students will be able to demonstrate the use of the Excel program and have a graph that shows the charted information.

Time schedule – 2 days

Logistic – Every student will do his/her own Excel chart and graph.

Resources –

Computer Excel Program information

Graded by - Assessment rubric


Data for Chart and Graph

Weekly sales for each sales representative;

Sam Smith Monday $123,456; Tuesday $234,567; Wednesday $ 167,956;

Thursday $ 186,652; Friday $ 199,342.

Michael Thompson Monday $183,556; Tuesday $164,567; Wednesday

$ 197,956; Thursday $ 187,452; Friday $ 179,342.

Sally Schaffer Monday $123,456; Tuesday $134,867; Wednesday $ 167,256; Thursday $ 146,452; Friday $ 129,542.

Round off each number to the nearest Thousand Dollars when you make your chart. Complete the chart then make your graphs.

Name______Date______Class______

Prior Knowledge

Must be answered in complete sentences

1. What is a cell?

2.  Where in Watkins can you see columns?

3.  Where in Watkins do you see rows?

4.  What is a chart?

5.  What is a line Graph?

6.  What is a Bar Graph?

7.  What is a Pie Graph?

8.  What is an equation?

9.  What is another name for an equation, when letters or symbols replace items in the equation?

10.  What does save mean to you?

11. What does print mean to you?


Name ______period ______

What I have learned?

What is the purpose of a chart?

What are the three main types of Graphs?

When would one type of graph be used instead of another?

1. Line-

2. Bar-

3. Circle-

Pertaining to the Excel program what is a cell?

Pertaining to the Excel program what is a column?

Pertaining to the Excel program what is a row?

Pertaining to the Excel program which comes first in listing a cell?

How could you use the excel program to make graphs?

How do you make sure that one graph will appear on one page?

How do you change the size of type on a graph once you have made the graph?

How do you write a formula in the Excel program?


Rubric Assessment

Topic

/

4 Points

/

3 Points

/

2 Points

/

1 Point

/

0 Points

Knowledge of step by step procedure to create a Chart / Demonstrates the complete use of all proper steps to develop and create the Chart / Demonstrates most of the proper steps to develop and create the chart / Demonstrates some of the proper steps to develop and create the chart. / Demonstrates little of the proper steps to develop and create the chart. / Unable to demonstrates the proper steps to develop and create the chart.
Knowledge of step by step procedure to create Bar graph. / Demonstrates the complete use of all proper steps to create and label the bar Graph. / Demonstrates most of the proper steps to create and label the bar Graph. / Demonstrates some of the proper steps to create and label the bar Graph. / Demonstrates some of the proper steps to create and label the bar Graph. / Unable to demonstrates the proper steps to create and label the bar Graph.
Knowledge of step by step procedure to create a line graph. / Demonstrates the complete use of all proper steps to create and label the line Graph. / Demonstrates most of the proper steps to create and label the line Graph. / Demonstrates some of the proper steps to create and label the line Graph. / Demonstrates little of the proper steps to create and label the line Graph. / Unable to demonstrates the proper steps to create and label the line Graph.
Knowledge of step by step procedure to create and label circle graphs. / Demonstrates the complete use of all proper steps and label create circle graphs. / Demonstrates most of the proper steps and label create circle graphs. / Demonstrates some of the proper steps and label create circle graphs. / Demonstrates little of the proper steps and label create circle graphs. / Unable to demonstrates the proper steps and label create circle graphs.
Knowledge of Saving the project. / Able to completely demonstrate how to save the project. / Able to demonstrate how to save most of the project. / Able to demonstrate how to save some of the project. / Able to demonstrate how to save a little of the project. / Unable to demonstrate how to save the document.
Knowledge of printing the project. / Able to completely demonstrate how to print the project. / Able to demonstrate how to print most of the project. / Able to demonstrate how to print some of the project. / Able to demonstrate how to print a little of the project. / Unable to demonstrate how to print the document.
Completing the prior knowledge sheet / Completes the prior knowledge sheet. / Completes most of the prior knowledge sheet / Completes some of the prior knowledge sheet / Completes little of the prior knowledge sheet / Does not complete the prior knowledge sheet.
Complete learned knowledge sheet / Completes the learned knowledge sheet. / Completes most of the learned knowledge sheet / Completes some of the learned knowledge sheet / Completes little of the learned knowledge sheet / Does not complete the learned knowledge sheet.
Completing the post reflection sheet / Completes the post-reflection sheet. / Completes most of the post-reflection sheet / Completes some of the post-reflection sheet / Completes little of the post-reflection sheet / Does not complete the post-reflection sheet.


Self- reflection and project reflection

Name ______period ______

Personal check list for grading the project

TOPIC

/ 4 Points / 3 points / 2 Points / 1 Point / 0 Points
Knowledge of step by step procedure to create a Chart
Knowledge of step by step procedure to create Bar graph.
Knowledge of step by step procedure to create a line graph.
Knowledge of step by step procedure to create and label circle graphs.
Knowledge of Saving the project.
Knowledge of printing the project.
Completing the prior knowledge sheet
Completing the learned knowledge sheet
Completing the post reflection sheet
Totals of each column
Grand Total of all columns
ALL ANSWERS ARE TO BE IN COMPLETE SENTENCES

What did you learn from this project?

Was the project challenging enough for you and why?

Where else could you use a graphing and charts?

What would you add to the project and why?

What would you omit from the project and why?

If you could do the project over, what would you do differently?

Name three areas that computer graphing would be helpful and why would it be helpful.

1.

2.

3.

1