Exp22_PowerPoint_Ch03_CumulativeAssessment_IT_Careers

Step

Instructions

Points Possible

1

Start PowerPoint. Download and open the file named Exp22_PPT_Ch03_CumulativeAssessment_IT Careers.pptx. Grader has automatically added your last name to the beginning of the filename.

0

2

Insert a Title and Content layout slide after Slide 1. Type Jobs in IT in the Title Placeholder. Insert a Trapezoid List SmartArt graphic in the content placeholder. Type the following in the Text pane as first level bullet points. Remove any unneeded bullet points in the Text pane. Software applications developer Information security analyst Computer systems analyst Database administrator Computer network architect Management analyst

20

3

Apply the Moderate Effect SmartArt style. Change the color to Colorful – Accent Colors.

8

4

On Slide 4, insert a two column, seven row table in the content placeholder. Type the following information into the table: Row 1: Col 1: Profession; Col 2: Salary Per Year Row 2: Col 1 Software applications developer; Col 2: $103,560 Row 3: Col 1: Information security analyst; Col 2: $95,510 Row 4: Col 1: Computer systems analyst; Col 2: $88,270 Row 5: Col 1: Database administrator; Col 2: $87,020 Row 6: Col 1: Computer network architect; Col 2: $104,650 Row 7: Col 1: Management analyst; Col 2: $82,450

12

5

Apply the Light Style 2 – Accent 4 table style.

4

6

Add a new column to the left of column 1. Merge the cells in the new column. Set the cell width of the merged cell to 0.79". Type 2016 in the new column and rotate the text 270°. Center the text in the cell horizontally. Increase the font size of the text to 28 pt. Change the cell shading to White, Text 1.

14

7

Set the text in the table to Center Vertically. Set the table height to 4.2" and the width to 10.7".

11

8

Change the layout of Slide 3 to Title Only.

2

9

Start Excel. Download and open the file named ITData.xlsx and save it as ITData_LastFirst.xlsx. Copy the chart from the Job Growth Percentage worksheet and embed the chart using Paste Special on Slide 3. Paste as Microsoft Office Graphic Object. Note, Mac users: Paste as Microsoft Office Graphic Object.

8

10

Size the chart to a height of 4.5". Position the chart horizontally at 1" and vertically at 1.85".

6

11

On Slide 5, create a Clustered Column chart with the following data: In cell A1, type Profession and in cell B1 type # of Jobs.Then populate A2:B7 with the following values: Software applications developer 1,256,200 Information security analyst 100,000 Computer system analyst 600,500 Database administrator 119,500 Computer network architect 162,700 Management analyst 806,400 Change the source data to use the range A1:B7.

10

12

Make the following changes to the clustered column chart: • Apply Chart Style 9 • Apply the Layout 4 Quick Layout • Remove the legend and y-axis

5

13

Save and close Exp22_PPT_Ch03_CumulativeAssessment_ITCareers.pptx. Exit PowerPoint. Submit the file as directed.

0

Total Points

100