Researching current articles (published in the past twelve months), identify at least two emerging products, two security practices, and one emerging trend in the cybersecurity field. Look specifically for issues with implementation and compliance.

Evaluate – To judge or calculate the quality, importance, amount, or value of something.

Write a 2–3-page paper. Your purpose is to fully evaluate each of the items identified in your research. Contrast the items with others of like type in order to assess their relative importance and impact to the practice and application of cybersecurity efforts overall.

Write a main function that asks the user for four floats and then outputs the minimum, maximum, their sum and mean value.
use the functions from (a) – (d) to implement this.
(a) Take two floats as argument and returns the minimum of those.
(b) Take four floats as argument and returns the minimum. Make use of the function defined in a)
(c) Are the same as in a) and b), but returns the maximum.
(d) Take four floats as argument and returns their sum and mean.
The output has to be as follows:
Give four floats: 10.0 -2.3 13.2 20.4
Min: -2.300000
Max: 20.400000
Sum: 41.299999
Mean: 10.325000

Exp19_Excel_Ch11_ML1_Internships

Exp19 Excel Ch11 ML1 Internships

 Excel Chapter 11 Mid-Level 1 – Internships 

Project Description:

As the Internship Director for a regional university, you created a list of students who are currently in this semester’s internship program. You have some final touches to complete the worksheet, particularly in formatting text. In addition, you want to create an advanced filter to copy a list of senior accounting students. Finally, you want to insert summary statistics and create an input area to look up a student by ID to display his or her name and major.

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

You want to extract   the last four digits of the student’s ID.
 

  In cell B2 on the Students sheet, extract the last four digits of the first   student’s ID using the RIGHT function. Copy the function from cell B2 to the   range B3:B42.

After extracting the   last four digits of the ID, you want to align the data.
 

  Apply center horizontal alignment to the range B2:B42.

The first and last   names are combined in column C. You want to separate the names into two   columns.
 

  Convert the text in the range C2:C42 into two columns using a space as the   delimiter.

You want to convert   the text in column F to upper and lowercase letters.
 

  Use a text function in cell G2 to convert the text in cell F2 into upper and   lowercase letters. Copy the function to the range G3:G42.

Now that you have   converted text from uppercase to upper and lowercase, you will hide the   column containing the majors in all capital letters.
 

  Hide column F.

You want to create a   criteria range for the dataset.
 

  Create a criteria range by copying the range A1:I1 and pasting it in cell   A44. Create conditions
  for Senior Accounting majors on row 45 and an OR   condition for Junior Accounting majors in the respective cells   on row 46

You are ready to   perform the advanced filter.
 

  Create an output range by copying the range A44:I44 to cell A48. Perform the   advanced filter by copying data to the output range. Use the appropriate   ranges for list range, criteria range, and output range

On the Info   worksheet, you want to insert a database function based on conditions.
 

  Display the Info worksheet and insert the DSUM function in cell B2 to   calculate the total tuition for junior and senior accounting students. Use   the range A1:I42 for the database, Tuition for the field, and   the criteria range.

You want to insert   database functions to perform calculations.
 

  In cell B3, insert the DAVERAGE function to calculate the average GPA for junior and   senior accounting students on the Students worksheet. Use mixed references in   the ranges.

You want to identify   the highest GPAs for junior and senior accounting majors.
 

  In cell B4, insert the DMAX function to identify the highest GPA for junior and   senior accounting students on the Students worksheet. Use mixed references in   the ranges.

In cell B5, insert   the DMIN function to identify the lowest GPA for junior and   senior accounting students on the Students worksheet. Use mixed references in   the ranges.

In cell B6, insert   the DCOUNT function to count the number of junior and senior accounting
  students on the Students worksheet. Use mixed references in the ranges.

In cell B9, insert   the DGET function to retrieve the last name of the student who has the ID   listed in cell A9. Use the column number representing the Last Name column   for the field argument and use the criteria range A8:A9. Edit the function to   make the column letters absolute. Copy the DGET function from cell B9 to cell   C9. Edit the field number to represent the GPA column.

You want to format   the results of the database functions.
 

  Format the range B3:B6 with Comma Style. Decrease the number of decimal   places to zero
  for cell B6.

You want to identify   the location of a particular ID.
 

  Insert the MATCH function in cell B13 to identify the position of the ID   stored in cell B12. Use
  the range A2:A42 in the Students worksheet as the lookup_array argument and   look for exact
  matches only.

Insert the INDEX   function in cell B14 with Students!A$2:I$42 as the array, B$13 that contains
  the MATCH function as the row number, and 4 as the column number. Copy the   function from cell B14 to cell B15. Edit the function to change the column   number to 7.

Change the ID in cell   B12 to 11282378. The results of the MATCH and INDEX functions
  should change.

You want to insert a   function to display other functions as text.
 

  Insert the FORMULATEXT function in cell D2 to display the formula that is   stored in cell B2.
  Copy the function to the range D3:D6 and to the range D13:D15. In cell D8,   insert the
  FORMULATEXT function to display the function that is stored in cell B9, and   in cell D9, insert
  the FORMULATEXT function to display the function that is stored in cell C9.

Increase the width of   column D to 50.

Create a footer with   your name on the left side, the sheet name code in the center, and the file   name code on the right side on all sheets.

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

please see assignment 

In this assignment, you will perform an exploratory analysis that will allow you to get a feel for the data and start exploring potential relationships. This may include:

• Descriptive statistics
• Histograms
• Bar charts
• Heat maps
• Line graphs
• Box plots
• Frequency tables

Once your analysis is complete, you will need to provide a Word document showing and describing the results of your exploratory analysis.

2nd part

you will perform a model development on your dataset, following these step:

1. Using your chosen dataset, reevaluate the heat map from the last module.
2. Consider ways to perform a visual check to see if there is a relationship between fields.
3. With this insight, develop a model using either linear regression or multiple linear regression.
4. Report the intercepts, slope, model accuracy, output to predicted comparison, and a scatterplot with line portraying the model.

Once you complete these steps, you will need to provide a Word document showing and explaining the results of your model development. 

 Discussing 3 ways that analytics can be used to improve life on this planet. 

need 750 words in 1 hr.

 You will use Microsoft Project to create a Gantt chart for your e-commerce company project. Use Microsoft Project to create a Gantt chart identifying the major and minor tasks, illustrating dependency relationships between activities.  Create an initial information systems project plan for a new startup company.

Our readings this week focused on databases and SQL. We learned about several types of databases and how to interface with them. Use the Internet to find some examples of database technology that you might encounter in your chosen career field. Share an example with the class. As a business professional, why do you think it is important to understand databases and SQL language?

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.