Excel Chapter 3 Mid-Level 1 – Airports 

Exp19_Excel_Ch03_ML1_Airports

Exp19 Excel Ch03 ML1 Airports

Project Description:

As an analyst for the airline industry, you track the number of passengers at the top six major U.S. airports: Atlanta (ATL), Chicago (ORD), Los Angeles (LAX), Dallas/Fort Worth (DFW), Denver (DEN), and New York (JFK). You researched passenger data and created a worksheet that lists the number of total yearly passengers at the top six airports. To prepare for an upcoming meeting, you will create a clustered column chart to compare the number of passengers at each airport. Then, you will create a line chart that compares trends over time. Next, you will create a bar chart to compare the passenger count for the latest year of data available and then emphasize the airport with the largest number of passenger traffic. Finally, you want to insert sparklines to visually represent trends in passengers at each airport over the 10-year period.

Start Excel. Download and open the file named Exp19_Excel_Ch03_ML1_Airports.xlsx. Grader has automatically added   your last name to the beginning of the filename.

You want to create a   clustered column chart to depict the passenger counts at the six airports   over several years.
  Use Quick Analysis to create a clustered column chart for the range A4:L10.   Cut the chart and paste it in cell A15.

You want to customize   the column chart with a chart title, display the years as a data series,   enlarge the chart to be easier to read, and apply a chart style.
  •Type Passengers by Top U.S. Airports as the chart title.
  •Swap the data on the category axis and in the legend.
  •Set a 3.5″ height and 11.4″ width.
  •Apply the Style 7 chart style.

The value axis takes   up a lot of space for the numbers. You will adjust the value axis to simplify   it.
  •Change the display units to Millions for the value axis.
  •Edit the axis title to display Millions of Passengers.

You want to focus on   the 2016 data series by adding data labels.
  Display data labels above the columns for the 2016 data series only.

Applying a fill color   to the chart area will make the chart visually appealing.
  Apply the Light Gradient – Accent 2 preset gradient fill to the chart area.

A best practice is to   add Alt Text to a chart for accessibility compliance.
  Add Alt Text: The chart displays the number of passengers in millions   for the top six airports from 2006 to 2016. (including the period).

When you change the   workbook theme, Excel applies that theme to the chart styles.
  Change the workbook theme to Slice.

You want to create a   bar chart to display passenger counts for only one year.
  Create a recommended clustered bar chart for the range A5:A10 and L5:L10 and move   the chart to a chart sheet named Bar Chart.

You want to customize   the bar chart.
  •Change the chart color to Colorful Palette 3.
  •Enter Passengers at Top 6 U.S. Airports in 2016 as the chart title.
  •Apply the Style 5 chart style.
  •Add Alt Text: The bar chart shows passengers at Top 6 U.S.   Airports in 2016. Atlanta had the most passengers. (including the   period).

Modifying the axes   will improve readability of the bar chart.
  •Change the font size to 10 for the category axis and value axis.
  •Change the value axis Maximum Bound to 1.1E8.

You will format a   data point so that it stands out and then add gridlines to enhance   readability in the bar chart.
  •Format the Atlanta data point with Dark Blue, Text 2 fill color.
  •Add Primary Minor Vertical gridlines.

A line chart   effectively shows trends over time for the passenger counts at the different   airports.
  Create a line chart using the range A4:L10 in the Passenger worksheet and   move the chart to a chart sheet named Line Chart. Add a chart title   Passengers at U.S. Airports 2006-2016 and bold the title.

You want to customize   the line chart.
  •Set the Minimum Bound at 4.0E7 for the value axis. The Maximum   Bound should change to 1.1E8 automatically.
  •Set the Vertical (Value) Axis Display units to Millions. Delete the Vertical   (Value) Axis Display Units Label from the upper-left corner of the chart. Add   a value axis title In Millions.
  •Change the font size to 10 for the value axis and category axis.
  •Move the legend to the top.
  •Filter the chart by deselecting the odd-numbered years.
  •Add Alt Text: The line chart displays trends for top six   U.S. airports from 2006 to 2016 at two-year intervals. (including the   period).

Sparklines provide a   simple visualization to represent data in a worksheet.
  Display the Passenger worksheet and insert Line sparklines in the range   M5:M10 to illustrate the data in the range B5:L10.

You want to customize   the sparklines to point out high and low points.
  •Show the high and low points in each sparkline.
  •Apply Black, Text 1 color to the high point marker in each sparkline
 

On the Questions   worksheet, type the answer to the first question in cell A2. Enter only the   airport code.
  Answer the other questions by typing in the answers in cells A3, A4, A5, and   A6.

Group the Bar Chart   and Line Chart sheets and insert a footer with Exploring Series on the left side, the   sheet name code in the center, and the file name code on the right on all   worksheets. Group the Passenger and Questions sheets and insert a footer with   the same data. Change to Normal view.

Set page formats for   the Passenger worksheet.
  Select Legal paper size, select Landscape orientation, set 0.3″ left and right   margins, and scale to fit 1 page.

Save and close Exp19_Excel_Ch03_ML1_Airports.xlsx.   Exit Excel. Submit the file as directed.

For Courses: InfoTech in a Global Economy and Information Governance, please give a brief explanation from your own perspective. 

Question 1 – Briefly explain any steps you are taking, or plan to take, to gain hands-on experience in your program of study. (50 – 100 words)

Question 2 – State two goals you hope to achieve through applying your coursework this term to your workplace experience. (50 – 100 words)

 2 full pages – 550 words

Your readings in Chapter 9 this week, as well as the handout discussing the risk companies face over unstructured data raises concerns that need to be addressed when a company uses social media. 

With your industry in mind, identify and discuss these concerns and address how this can be effectively handled. Support with references and do your usual critical review of at least 2 other students’ posts.

Reading Assignments

Reading AssignmentsTextbook:  

Chapter 13 – Information Governance for Social Media

Ahmed, J., Yildirim, S., Nowostaki, M., Ramachandra, R., Elezaj, O., & Abomohara, M. (2020). GDPR Compliant Consent Driven Data Protection in Online Social Networks: A Blockchain-Based Approach. 2020 3rd International Conference on Information and Computer Technologies (ICICT), Information and Computer Technologies (ICICT), 2020 3rd International Conference on, ICICT, 307–312. https://doi.org/10.1109/ICICT50521.2020.00054

Elsayed, M., Abdelwahab, A., & Ahdelkader, H. (2019). A Proposed Framework for Improving Analysis of Big Unstructured Data in Social Media. 2019 14th International Conference on Computer Engineering and Systems (ICCES), Computer Engineering and Systems (ICCES), 2019 14th International Conference On, 61–65. https://doi.org/10.1109/ICCES48960.2019.9068154

Jackson, O. (2018). GDPR: companies at risk over unstructured data. International Financial Law Review, N.PAG. 

1.Write at least 500 words discussing how Cambridge Analytica used text mining to analyze to affect the 2016 US presidential election.  Use APA format and Include at least 3 quotes from your sources enclosed in quotation marks.

2.Write at least 500 words discussing what you have learned from analyzing the twitter feeds of Donald Trump and Joe Biden.  Use APA format and Include at least 3 quotes from your sources enclosed in quotation marks.

• What is What is Web Design and Development? (5 points)
• Which aspect(s) of Web design and development is new to you? (15 points)
• Were you aware of any Web Design and development -related job opportunities before taking this course?  (5 points)
• Does this course change your overview of the future job opportunities? and How? (15 points)
• What type of jobs do you plan to pursue after graduation? Is it going to be in web design or development related? (10 points)

Please make your analytic points specific as this is your self-reflection. Reference anything that are not your own using APA style.

The formatting of the paper should be of at least two pages long (references do not count), single line spacing, use a font size of minimum 10 points but no larger than 12 point. Set margins to 1 inch on all sides.

Describe how catching exceptions can help with file errors. Write three Python examples that actually generate file errors on your computer and catch the errors with try: except: blocks. Include the code and output for each example in your post. 

Describe how you might deal with each error if you were writing a large production program. These descriptions should be general ideas in English, not actual Python code. 

Theoretical framework discussion post

WD1 – Exercise # 2

Create the Flyer Lab 2: Creating a Flyer with Multiple Pictures that is on the page WD 54 to WD 56 or (Page 432 to 434).

Follow the steps in your book. All necessary pictures and documents can be found in the Course Documents section, under Data Files. You can find pictures related to the topic on the internet.

Add your name and current Date as a footer of the flyer. 

My Name: Nayancy Rodriguez.

Date: current date

Save as 2-WD1-B-YourName

Add your name in the footer section

Submit these file when done

Be sure to save your assignment in a .docx format, especially if you are using an Apple or MAC computer.

Note: You need to submit the File:

• Lab 2: Creating a Flyer with Multiple Pictures as 2-WD1-EX2-YourName

IMPORTANT!

Remember that all the Word documents that you create should be in a file with the Creation Date of this week, or after if you submit late, but not a previous date. Files Assignments with the previous date will not be accepted.

Developing an Incident Communications Plan*

You are the CSIRT leader for a major eCommerce website, and you are currently responding to a security incident where you believe attackers used a SQL injection attack to steal transaction records from your backend database. Currently, only the core CSIRT members are responding. Develop a communication plan that describes the nature, timing, and audiences for communications to the internal and external stakeholders that you believe need to be notified. 

*Activity 11.3: Chapple, Mike; Seidl, David. CompTIA CySA+ Study Guide Exam CS0-002 (p. 400). Wiley. Kindle Edition. 

Please follow up file 1,2,3  those are homework instruction and the other file is coding file you must do in vscode