All the details are bellow
January 13, 2021Individual: Microsoft Excel Troubleshooting Exercise
January 13, 2021Module 3 slp
Module 3 – SLP
COLLABORATION TECHNOLOGIES AND IT INFRASTRUCTURE
In this assignment, you will apply Excel to produce visualization using data provided in the below assignment. Here are some materials to help you with the assignment:
SLP 3, Lecture 1: Chart Basics:
SLP 3 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.
Module 3 Lecture: Excel Demo: Downtown Theatre:
SLP Assignment
Below is a table of jobs in the Information Technology field. IT jobs are in high demand are well paid. In the table you are provided the number of jobs in 2010 and the 2020 estimated number of jobs in that area. Also provided is the percentage growth and the median pay in 2010 for each type of job.
|
# of Jobs |
Job Growth |
Median Pay |
|||
|
Type of Job |
2010 |
2020 Est. |
# of New Jobs |
% Growth |
2010 |
|
Systems Analysts |
544,400 |
664,800 |
120,400 |
22% |
$ 77,740 |
|
Software App Developers |
520,800 |
664,500 |
143,700 |
28% |
$ 90,530 |
|
Programmers |
363,100 |
406,800 |
43,700 |
12% |
$ 71,380 |
|
Network/System Admins |
347,200 |
443,800 |
96,600 |
28% |
$ 69,160 |
|
CIS Managers |
307,900 |
363,700 |
55,800 |
18% |
$ 115,780 |
|
Info Security Analysts |
302,300 |
367,900 |
65,600 |
22% |
$ 75,660 |
|
Database Administrators |
110,800 |
144,800 |
34,000 |
31% |
$ 73,490 |
- Produce a bar chart of Number of Jobs by Type of Job
- Produce a pie chart of Number of Jobs by Type of Job
- Plot a line graph of the % of job growth over the bar chart of the job types.
SLP Assignment Expectations
Upload your work to the SLP 3 dropbox.