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 assignment.
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.
- 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.
Please see attached files for assignment info.
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.