Computer Applications – Mrs. Miñoso

Chapter 9 Lecture Notes

• Using Multiple Sheets
• Referring to Data in different Sheets
• Printing Sheets
• Charts
• Titles
• Legend
• Data Series
• Pie Charts
• Column Charts
• Line Charts

• Creating Charts
• Chart Wizard
• Moving, Sizing & Deleting Charts
• Printing Charts
• Adding Adjacent Series and Labels
• Adding Non Adjacent Series and Labels

Problem #1: Which type of Graph would we create in order to display the differences between 2001 – 2003 sales for this candy Store?

Candy Sales	2001	2002	2003
Gum	$ 32,576.54	$ 35,834.19	$ 44,792.74
Chocolate Bars	$ 56,435.40	$ 62,078.94	$ 77,598.68
Jelly Beans	$ 34,532.50	$ 37,985.75	$ 47,482.19
Jaw Breakers	$ 3,456.00	$ 3,801.60	$ 4,752.00
Malt Balls	$ 7,654.75	$ 8,420.23	$ 10,525.28
Chocolate Covered Raisins	$ 87,643.50	$ 96,407.85	$120,509.81
Almond Bars	$ 32,452.00	$ 35,697.20	$ 44,621.50
Sugar Sticks	$ 43,536.00	$ 47,889.60	$ 59,862.00
Saltwater Taffy	$ 2,345.34	$ 2,579.87	$ 3,224.84
Total Sales =	$ 300,632.03	$330,695.23	$413,369.04
Average Sales =	$ 33,403.56	$ 36,743.91	$ 45,929.89

Problem #2: Which type of graph would we create in order to display the plant growth over the five week period?

Plant Growth Experiment Result
Control Group	Week 1	Week 2	Week 3	Week 4	Week 5	Total Growth
A	2.00	2.50	2.75	2.50	2.50	12
B	1.50	2.00	1.50	2.00	2.00	9
C	2.00	2.00	2.50	2.00	2.75	11
D	1.75	1.75	2.00	2.00	1.50	9
E	1.00	1.00	0.50	0.75	1.00	4
F	2.50	2.00	2.50	1.00	1.75	10
G	1.75	1.50	1.75	1.75	2.00	9

Problem #3: Which type of graph would we create in order to display the costs associated with making a batch of cookies?

Cost of Production per Batch
	Current Costs
Sugar	$1.75
Dairy Products	$1.80
Spices and Flavorings	$0.40
Flour	$0.90
Packaging	$2.75
Labor	$12.00
Total Costs per Batch:	$19.60