Exp19_PowerPoint_Ch03_CapAssessment_IT_Careers

  

Don't use plagiarized sources. Get Your Custom Essay on
Home>Homework Answsers>Computer Science homework helpExp19_PowerPoint_Ch03_CapAssessment_IT_Careers    Project Description: As the department chair of Information Technology at the college, you oft
Just from $10/Page
Order Essay

Project Description:

As the department chair of Information Technology at the college, you often give presentations on IT Careers to potential students. You have been asked to to update the presentation with recent data on the programs you offer at the college that will prepare students for a career in IT. 

     

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

 

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

 

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

 

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 

 

Apply the Light Style 2 – Accent   4 table style.

 

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 all text 270°. Center   the text in the cell. Increase the font size of the text to 28 pt. Change the cell shading to   White, Text 1.

 

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

 

Change the layout of Slide 3 to   Title Only.

 

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.

 

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

 

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.

 

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

  Note, Mac users apply Chart Style 9.

 

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

“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”

SUPPORT

support@classmatetutor.com

About us

Contact us

User reviews

Become a freelance writer

FAQ’s

OUR SERVICES

 

Persuasive essays

Expository essays

Compare and contrast Essays

Persuasive essays

Argumentative essays

Narrative essays

Definition essays

Informative essays

MAIN

Place order

Our Affiliate program

Privacy Policy

 

LEGAL

Our privacy policy

Terms and conditions

Our Cookie Policy

Confidentiality policy

 

 

Disclaimer: Writemasters is a professional essay writing service, providing custom assistance for research and reference purposes only. The use of our work must comply with all academic guidelines and integrity standards. Copyright © 2009 - 2024
7904 Dorothy St, Rosemead, CA 91770
Open chat
1
Need help? Chat Now
Scan the code
Hello, welcome to our instant WhatsApp chat. We are online and ready to assist.
How can we help you today?