Description
More ChartingAssignment 10OverviewLearn how to use a charting with Excel using the charting tools and spark lines. Student Start FileAssignment 10 Original File.xlsxInstructions for Origins WorksheetCreate a chart that looks like figure 1 in a worksheet called Origins Chart.Instructions for Class Size WorksheetAdd Data Bars to the Class Size spreadsheet in Column B. Instructions for Population Worksheet1. Add column spark lines for each row, to show the trend in population for each county and state in Column G.2. Freeze the row and column headers.
2012 – 2013 SVSU Student Origins
Origin Location
2012
Saginaw County
2.506
Bay County
1.179
Midland County
565
Tuscola County
434
Genesee County
683
Huron County
219
Macomb County
694
Oakland County
619
Wayne County
675
Other Michigan Counties
2.297
Other U.S.
58
International/Canadian
623
Source: SVSU OIR
2013
2.412
1.181
549
447
669
211
644
580
662
2.176
82
632
SVSU 2013 Undergraduate Class Size
Class Size
2-9
10-19
20-29
30-39
40-49
50-99
100+
Source: SVSU OIR
Count
112
355
470
359
56
44
1
Michigan Population by County 2008 – 2012
2008
2009
2010
2011
Michigan
Alcona
Alger
Allegan
Alpena
Antrim
Arenac
Baraga
Barry
Bay
Benzie
Berrien
Branch
Calhoun
Cass
Charlevoix
Cheboygan
Chippewa
Clare
Clinton
Crawford
Delta
Dickinson
Eaton
Emmet
Genesee
Gladwin
Gogebic
Grand
Traverse
Gratiot
Hillsdale
Houghton
Huron
Ingham
Ionia
Iosco
Iron
Isabella
Jackson
Kalamazoo
Kalkaska
Kent
Keweenaw
Lake
Lapeer
2012
9.946.889 9.901.591 9.877.670 9.876.801 9.883.360
11.286
11.106
10.899
10.787
10.635
9.647
9.334
9.554
9.580
9.541
111.589
111.252
111.472
111.591
112.039
30.119
29.755
29.551
29.352
29.234
24.047
23.796
23.511
23.408
23.406
16.547
16.243
15.873
15.622
15.477
8.822
8.874
8.838
8.821
8.683
59.788
59.469
59.062
58.936
58.990
108.320
107.913
107.723
107.273
106.935
17.733
17.564
17.517
17.489
17.465
157.380
157.059
156.799
156.489
156.067
46.305
45.378
45.147
43.902
43.868
137.313
136.301
136.075
135.529
135.099
52.684
52.362
52.197
52.574
52.242
26.280
26.068
25.909
26.003
26.023
26.738
26.330
26.096
25.974
25.835
39.247
39.174
38.482
38.776
38.917
31.064
30.856
30.993
30.955
30.753
74.302
74.828
75.400
75.838
76.001
14.379
14.157
14.040
14.012
14.009
37.409
37.059
37.068
36.955
36.884
26.622
26.357
26.137
26.094
26.220
108.021
107.430
107.878
107.970
108.008
32.852
32.765
32.663
32.800
32.915
433.082
427.989
425.152
422.053
418.408
25.956
25.738
25.702
25.800
25.484
16.499
16.390
16.386
16.127
16.084
86.209
86.767
87.034
88.294
89.112
42.774
42.285
42.439
42.139
42.063
46.951
46.735
46.603
46.565
46.229
36.292
36.378
36.694
36.712
36.520
33.504
33.269
33.063
32.704
32.463
281.315
280.889
280.882
281.806
281.723
65.167
63.858
63.883
63.898
63.941
26.542
26.174
25.806
25.523
25.357
12.081
11.959
11.799
11.761
11.587
69.328
70.026
70.321
70.636
70.617
160.825
160.114
160.226
159.810
160.309
246.862
249.023
250.729
252.328
254.580
17.546
17.223
17.133
17.156
17.099
599.234
601.437
602.982
608.106
614.462
2.119
2.131
2.142
2.231
2.215
11.629
11.593
11.510
11.484
11.498
89.914
88.774
88.187
88.081
88.173
Leelanau
Lenawee
Livingston
Luce
Mackinac
Macomb
Manistee
Marquette
Mason
Mecosta
Menominee
Midland
Missaukee
Monroe
Montcalm
Montmorency
Muskegon
Newaygo
Oakland
Oceana
Ogemaw
Ontonagon
Osceola
Oscoda
Otsego
Ottawa
Presque Isle
Roscommon
Saginaw
St. Clair
St. Joseph
Sanilac
Schoolcraft
Shiawassee
Tuscola
Van Buren
Washtenaw
Wayne
Wexford
Source:
Michigan
Department of
Community
Health
21.731
21.724
21.677
21.646
21.607
101.169
100.250
99.646
99.340
98.987
181.171
181.082
180.999
182.299
182.838
6.680
6.614
6.598
6.534
6.522
11.248
11.159
11.091
11.083
11.137
837.857
839.435
841.291
842.881
847.383
24.960
24.818
24.566
24.747
24.672
66.539
66.765
67.116
67.563
67.906
28.668
28.656
28.715
28.642
28.680
42.683
42.621
42.815
43.296
43.318
24.317
24.118
23.984
23.970
23.815
83.605
83.639
83.637
84.015
83.822
15.028
14.898
14.822
14.947
15.031
152.806
152.296
151.960
151.609
151.048
63.635
63.496
63.320
63.236
63.097
9.922
9.794
9.765
9.590
9.476
173.846
172.755
171.969
170.021
170.182
49.153
48.649
48.394
48.432
47.959
1.199.545 1.200.890 1.203.036 1.211.357 1.220.657
27.120
26.779
26.527
26.442
26.310
21.885
21.856
21.647
21.547
21.437
6.922
6.828
6.746
6.608
6.413
23.662
23.522
23.515
23.455
23.276
8.963
8.717
8.614
8.659
8.592
24.378
24.190
24.161
24.127
24.020
261.906
262.879
264.117
266.176
269.099
13.701
13.505
13.307
13.198
13.129
24.856
24.499
24.463
24.310
24.106
201.966
200.835
199.940
198.990
198.353
165.959
164.011
162.717
161.559
160.644
62.083
61.417
61.259
61.016
60.796
44.177
43.319
43.044
42.671
42.268
8.471
8.487
8.484
8.489
8.343
71.523
70.710
70.610
69.934
69.232
56.512
55.901
55.665
55.342
54.662
76.501
76.581
76.182
76.025
75.454
341.595
343.520
345.350
348.637
350.946
1.865.058 1.837.536 1.815.598 1.801.789 1.792.365
32.765
32.658
32.766
32.675
32.608
CS 150: Excel – More Charting
Assignment 10
Overview
Learn how to use a charting with Excel using the charting tools and spark lines.
Student Start File
Assignment 10 Original File.xlsx
Instructions for Origins Worksheet
Create a chart that looks like figure 1 in a worksheet called Origins Chart.
Instructions for Class Size Worksheet
Add Data Bars to the Class Size spreadsheet in Column B.
Instructions for Population Worksheet
1. Add column spark lines for each row, to show the trend in population for each county and state in
Column G.
2. Freeze the row and column headers.
CS 150
Excel
1
1. Origins Chart
CS 150
Excel
2
Purchase answer to see full
attachment