Assignment

 Select one network scanning software tool (there is a list in your required reading slides) and explain in detail how it works and how detects network vulnerabilities. Provide the site where you obtained your information and include that in your assignment write-up. 

IT470 week 7

Week 7 discussion topic

Share and explain what is the point of virtualization? Also feel free to explain to add what devices or areas in the computer that are virtualized or how it is virtualized?

Feel free to share diagrams, small videos, or links that can help understanding the topic. Ask questions if you need help understanding anything.

not more than 350 words. use diagrams, videos etc. to help explain.

Journal Article review- Week 6- Monitoring

Choose a journal article related to project status reporting, budgeting, or risk analysis (do not re-use a journal from a prior course).   Write a 2-3 page review of your chosen journal article.  Please choose a peer reviewed journal, and an article that has been published in the past five (5) years.

The review should contain the journal article title, author’s name and year of publication. 

Your paper should contain the following headings:

  •      Introduction
  •      Summary of the article
  •      Relevant points made by the author
  •      Critique of the article
  •      Application of the concepts in the article

You are going to review a single journal article, therefore your reference page should only contain the information from the article you reviewed.  There is no need to introduce other journals into this paper. 

Text-

A Guide to the Project Management Body of Knowledge (PMBOK® Guide) – Seventh Edition and The Standard for Project Management (RUSSIAN) 

ISBN: 9781628257007 

Authors: Project Management Institute Project Management Institute 

Publisher: Project Management Institute 

Publication Date: 2021-08-01

The formula is =(1+D$4)*Fleet!$H5

Homework Assignmet

 These instructions are compatible with both Microsoft Windows and Mac operating systems.

San Diego Sailing keeps data about its fleet of rental and charter boats. One of the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]

File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-SanDiegoSailing-02.xlsx

Skills Covered in This Project

  • Create and copy formulas.
  • Use formula auditing tools.
  • Set mathematical order of operations.
  • Use relative, mixed, and 3D cell references.
  • Use COUNTIF and SUMIF functions.
  • Build an IF formula.
  • Insert the TODAY function.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

  1. Open the SanDiegoSailing-02.xlsx workbook.
  2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
  3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  4. Review a formula.
    1. Click the New Prices sheet tab and review the Formula bar.
    2. Click cell D5. The formula begins with 1+D4.
  5. Edit and copy a formula with mixed references.
    1. Edit the formula in cell D5 to show D$4 instead of “D4.” The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105).The formula is =(1+D$4)*Fleet!$H5Figure 2-105 Mixed reference in the edited formula
    2. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.
    3. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19.
    4. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row.
  6. Build a formula with mixed references.
    1. Click cell F5 and type =(1+ to start the formula.
    2. Select cell F4 and make it an absolute reference to the row but not the column.
    3. Type )* for the closing parenthesis and multiplication.
    4. Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106).The formula is =(1+F$4)*Fleet!$I5Figure 2-106 Mixed references in the new formula
    5. Copy the formula down column F without formatting to preserve the border.
    6. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19.
  7. Build an IF function formula.
    1. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people.
    2. Create an IF function in which the logical_test argument determines if there are 8 or more seats.
    3. Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.)
    4. Copy the formula to cells G6:G19 without formatting and then center the data in column G.
  8. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).
  9. Create a division formula.
    1. Click the Bookings sheet tab and select cell F5. Calculate average revenue per passenger by dividing the fee by the number of passengers.
    2. Build the division formula.
    3. Copy the formula in cell F5 to cells F6:F19.
  10. Create and copy a COUNTIF function to count bookings by boat manufacturer.
    1. Select cell D27.
    2. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.
    3. Use cells $C$5:$C$19 as the Range argument.
    4. Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks.
    5. Copy the formula in cell D27 to cells D28:D30.
    6. Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make.
  11. Create and copy a SUMIF function to calculate total revenue by boat make.
    1. Select cell E27.
    2. Start the SUMIF function with cells $C$5:$C$19 as the Range.
    3. Set the Criteria argument to ben*.
    4. Set the Sum_range argument to cells $E$5:$E$19.
    5. Copy the formula in cell E27 to cells E28:E30.
    6. Edit the criteria in each copied formula in cells E28:E30 as needed.
  12. Complete formatting.
    1. Apply the Currency format to all values that represent money.
    2. Format the labels in cells A1:A2 as 18 point.
    3. Select cells A1:F2 and click the Alignment launcher [Home tab, Alignment group]. Center the labels across the selection.
    4. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points.
    5. Bold and center the labels in rows 4 and 26.
    6. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30.
    7. Center the page horizontally.
  13. Save and close the workbook (Figure 2-107).Excel 2-5 completedFigure 2-107 Excel 2-5 completed
  14. Upload and save your project file.
  15. Submit project for grading.

Write a complete C

  

Write a complete C program that finds and lists each 4-digit postive integer, X, that has the strange property that X to any positive power will end in those same 4 digits.

Exp19_Excel_Ch10_ML1_Dow_Jones

 

You are an intern for Hicks Financial, a small trading company  located in Toledo, Ohio. Your intern supervisor wants you to create a  report that details all trades made in February using current pricing  information from the Dow Jones Index. To complete the task, you will  import and shape data using Power Query. Then you will create data  connections and visualizations of the data.

Use   Get & Transform tools to import and transform Table 0 located in the file   e10m1Index.txt. Split the company column using space as the delimiter at the   left-most occurrence. Rename the respective columns Symbol and Company. Remove the columns Change, %Change, and   Volume. Name the table Dow and load it to the existing worksheet.
   Hint: Get Data is located on the Data tab in the Get & Transform Data   group.

Name the worksheet Current_Price.
   Hint: Double-click the worksheet tab to edit the sheet name.

Use Power Query to import trade   data located in the workbook Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv.    Before loading the data, if necessary use the Power Query Editor to  remove   the columns that contain NULL values. Split the company column  using the left   most space as the delimiter and rename the respective  columns Symbol and Company Name.
   Hint: Get Data is located on the Data tab in the Get & Transform  Data   group. Click Edit on the Import window to load the Power Query  Editor. 

Rename the worksheet Trades.
   Hint: Double click the worksheet tab to edit the sheet name.

Add the Dow table and the Exp19_Excel_Ch10_GRADER_ML1-TradeInfo   table to the Data Model.
   Hint: Manage Data Model is located on the Data tab in the Data Tools group.

Use Power Pivot to create the   following relationship:
 

  Table
Exp19_Excel_Ch10_GRADER_ML1-TradeInfo
 

  Field
Symbol
 

  Table
Dow
 

  Field
Symbol
 

  Hint: Relationships is located on the Data tab in the Data Tools group.

Use Power Pivot to create a   PivotTable with the  EXP19_Excel_Ch110_GRADER_ML1_TradeInfo Date field as a   Filter, Last  Price as a value, and the Dow table Company Name as Rows.
 

  Hint: Power Pivot is an Excel add-in that must be loaded. Power  Pivot can be   loaded by accessing COM add-ins in Excel options. Once  loaded, the Power   Pivot tab is located on the Office ribbon.

Create a Clustered Column   PivotChart based on the PivotTable that compares the trading price of Apple   and Coca-Cola stocks.
 

  Hint: PivotChart is located on the Analyze tab in the Tools group.

Add the chart title Trading   Comparison,   apply Accounting Number Format to cells C4:C5, and name the worksheet Price_Comparison.
   Hint: Chart elements can be added or edited on the Design tab in the Chart   Layouts group. 

Delete Sheet 1, if necessary.
 

  Hint: Delete is located on the Home tab in the Cells group.

Discussion Board 500 words

 Topic – Customer sentiment analysis using Artifical Intelligence

  • In the current literature, what counterarguments have you discovered about your topic?
  • In lieu of these counterarguments, justify why you chose the argument that is the foundation for your proposed study.

ITS-630: Organ Leader & Decision Making – Week 2 Research Paper

Reading Resources:

AKCIL, U., ALTINAY, Z., DAGLI, G., & ALTINAY, F. (2019). The Role of Technology Leadership: Innovation for School Leadership in Digital Age. ELearning & Software for Education, 2, 323. http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=edb&AN=135939718&site=eds-live&custid=s8501869&groupid=main&profile=eds_new

Research Paper:

This week’s journal article was focused on how information and communication innovation drives change in educational settings. The key focus of the article was how technology-based leadership has driven the digital age.  Also, that the role of technology leadership incorporates with the Technology Acceptance Model (TAM).In this paper, address the following key concepts:

  1. Define TAM and the components.
  2. Note how TAM is impacting educational settings.
  3. Give an overview of the case study presented and the findings.

Google Scholar is a great source for research.  Please be sure that journal articles are peer-reviewed and are published within the last five years.

The paper should meet the following requirements:

  • 3+ pages in length (not including title page or references)
  • APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
  • A minimum of five peer-reviewed journal articles.

The writing should be clear and concise.  Headings should be used to transition thoughts.  Don’t forget that the grade also includes the quality of writing.

Note: plagiarism check required, APA7 format, include References, within 8hrs