ITM301 Principles of Information Systems in Business COLLABORATION TECHNOLOGIES AND IT INFRASTRUCTURE In this assignment, you will apply Excel to produce visualization using data provided in the below
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. SLP 3, Lecture 1: Chart Basics: Module 3 Lecture: Excel Demo: Downtown Theatre: Excel Chart Basics https://www.youtube.com/watch?v=-btUxQi76qI 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.