COMPUTER TECHNOLOGY

EXCEL 3—Charts and Analysis

Grading Sheet & Assignments

Signing your name below means the work you are turning is your own work and you haven’t given your work to anyone else.

Name / Period
Teacher
Completed
Uploaded to
Edu20.org / Assignment / Points / Earned
□ □ / Excel 3 Study Guide / 10
□ □ / Knowing your Charts / 10
□ □ / Inclass Activity 1-Pie Chart / 10
□ □ / Inclass Activity 2-Bar Chart / 10
□ □ / Inclass Activity 3-Line Chart / 10
□ □ / Chart Analysis Worksheet (5 pts each)
(Fill this out once you have finished activities 1-4) / 20
See Excel Book to complete the Activities / 0
□ □ / Excel 3 Activity 1-Vital Stats Column Chart / 10
□ □ / Excel 3 Activity 2-Weekly Sales Pie Chart / 10
□ □ / Excel 3 Activity 3-Weekly Sales Line Chart / 10
□ □ / Excel 3 Activity 4-Wage Comparison Bar Chart / 10
□ □ / Excel 3 Activity 5 (Extra credit) / 10
□ Print / File Management—Screenshot of the Contents of Excel 3 Folder / 10
TOTAL / 120


Study Guide

1.  / A graphical representation of the data contained in a worksheet is called a
2.  / Names the four common types of charts and tell what each is best used for?
a.
b.
c.
d.
3.  / Charts can be displayed in two ways. Name each and describe it.
a.
b.
4.  / List the steps to create a chart
a.
b.
c.
5.  / Explain how to rename a sheet.
6.  / To change anything on the chart / on the part of the chart to change
7.  / How do you resize the chart?
8.  / How do you move the chart?
9.  / How do you copy the chart?
10.  / To change the appearance of any object you can simply click and use the ______tabs or
on the object and choose the format options in the menu
11.  / What are non-adjacent cells?
12.  / What are the steps in selecting non-adjacent data ranges?
a.
b.
13.  / How many ranges can you show using a pie chart?
13. / Title:
14. / Sub-Title:
15. / Axes:
16. / Gridlines:
17. / Legend:


Knowing your Charts

  1. Draw a simple column chart and tell what column charts are used for.
  1. Draw a simple line chart and tell what line charts are used for.
  1. Draw a simple pie chart and tell what pie charts are used for.
  1. Draw a simple bar chart and tell what bar charts are used for.


Chart Analysis Worksheet

1.  Using the chart from activity 1 determine what the leading cause of death was in:

1910______

2003______

2.  Using the information from activity 2 analyze the chart and identify:

Which two areas had the exact same percent?______

Which area had the highest sales?______

What percent of sales did Home Décor have? ______

3.  Analyze the chart in Activity 3 and explain the trend in cell phone sales from week 1 through week 4.

4.  Glancing at the chart from Activity 4, which two employees make the most money at this store?