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
Dropped / Assignment / Points / Earned
□ □ / Excel 3 Listening Guide / 20
□ □ / Knowing your Charts / 10
□ □ / Chart Analysis Worksheet (5 pts each)
(Fill this out once you have finished activities 1-4) / 20
□ □ / Excel 3 In class Activity 1-Pie Chart / 10
□ □ / Excel 3 In class Activity 2-Bar Chart / 10
□ □ / Excel 3 In class Activity 3-Line Chart / 10
Total from Top Section / 80
See Excel 3 Instructions to complete the Activities
□ □ / 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-Plumbing Stacked Column Chart / 10
□ Print / File Management—Screenshot of the Contents of Excel 3 Folder / 10
Total from Bottom Section / 60


Listening Guide

1.  / A graphical representation of the data contained in a worksheet is called a
2.  / Name 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 object you want 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 ______tab or
on the object and choose the format options in the shortcut 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:

18. What is a Sparkline? ______

19. Sparkline’s allow you to ______and ______spot trends.

20. Write the path to insert a Sparkline ______

21. In order to change the look of your Sparkline, you must ______on the Sparkline cell.

22. List the steps to insert a Sparkline: ______

______

______

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?