All posts by : chebby

Research and identify a major event in IT project management that has occurred over the past three (3) years. Describe the event, list the challenges encountered and show how the company dealt with it. 

With Summary at the end of the paper.

 Provide an overview of natural hazards and technological (man-made) hazards, and include examples of each and their distinctive differences. Then, select a hazard that would pose a significant threat to life and property, and as you being the emergency manager, what steps would you plan for, and prepare a community for such a hazard, or to effectively plan and prepare for a disaster.

Forensic Tool Selection

Overview

Your supervisor has asked you to research current forensic acquisition tools and to compile a list of recommended tools for the new forensics lab.

Instructions

1. Research current forensic acquisition tools listed in Chapter 3, using the Strayer University Library and/or the Internet.
2. Populate the Forensic Acquisition Tool Template [XLSX] with information about the forensic acquisition tools you researched. 
   • Be sure to populate all columns in the template.
3. In a separate two-page written report, recommend two tools for use in a forensics lab. 
   • Be sure to justify your recommendations.
4. Integrate into the assignment at least three quality professional and/or academic resources, written within the past five years. 
   • Note: Wikipedia and similar websites do not qualify as quality resources.

Note: Be sure to submit the Forensic Acquisition Tool Template and your written report.

Formatting

This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. Note the following:

• The preferred method is for your written report to be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
• Include a cover page containing the assignment title, your name, your professor’s name, the course title, and the date. The cover page is not included in the required page length.
• Include a source list page. Citations and references must follow SWS format. The source list page is not included in the required page length.

Learning Outcomes

The specific course learning outcome associated with this assignment is:

• Recommend acquisition tools for a forensics lab.

Classic Gardens and Landscapes counts responses to specialty promotions to determine effectiveness. You use SUMIFS and an IFS formula to complete the summary. You also calculate insurance statistics and display full names in one cell.

[Student Learning Outcomes 6.1, 6.2, 6.3, 6.6, 6.7]

File Needed: ClassicGardens-06.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-ClassicGardens-06.xlsx

Skills Covered in This Project

• Nest MATCH and INDEX functions.
• Create DSUM formulas.
• Build an IFS function.
• Build SUMIFS formulas.
• Use TEXTJOIN to join labels.

1. Open the ClassicGardens-06 start file. 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.
2. Create a nested INDEX and MATCH function to display the number of responses from a city.
   1. Click the Mailings sheet tab and select and name cells A3:D28 as Responses.
   2. Click the Mailing Stats sheet tab.
   3. Click cell B21 and type Carthage.
   4. Click cell C21, start an INDEX function, and select the first argument list option.
   5. Choose or type the Responses range name for the Array argument.
   6. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box and type 0.
   7. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
   8. Click the Match_type box and type 0 (Figure 6-106) and click OK. The result displays as 343.00.Figure 6-106 Nested MATCH and INDEX functions
   9. Format the results to show zero decimal places.
   10. Type Smyrna in cell B21.
3. Use DSUM to summarize mailing data.
   1. Select the Mailings sheet and note that number mailed is located in the third column and response data is in the fourth column.
   2. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design department.
   3. Type law* in cell B5 for the Lawn & Maintenance department.
   4. Type pat* in cell B8 for the Patio & Furniture department.
   5. Click the Mailing Stats sheet tab and select cell B7.
   6. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument (# Mailed column), and enter an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument.
   7. Copy the formula to cell C7 and edit the Field argument to use the fourth column (# Responses).
   8. Use DSUM in cells B8:C9 to calculate results for the two remaining departments.
4. Use SUM in cells B10:C10.
5. Format all values as Comma Style with no decimal places.
6. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(C7/B7>=20%,$C$15,IF(C7/B7>=15%,$C$16,IF(C7/B7>=11%,$C$17,$C$18))) to display the rating.
   1. Click cell D7. The response rate and ratings are shown in rows 14:18.
   2. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test.
   3. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107).Figure 6-107 First Logical_test and Value_if_true arguments
   4. Click the Logical_test2 box, select C7, type /, select cell B7, and type >=15%.
   5. Click the Value_if_true2 box, click cell C16, and press F4 (FN+F4).
   6. Complete the third and fourth logical tests and Value_if_true arguments (Figure 6-108).Figure 6-108 Completed IFS function arguments
   7. Copy the formula in cell D7 to cells D8:D10.
7. Use SUMIFS to total insurance claims and dependents by city and department.
   1. Click the Employee Insurance sheet tab and select cell E25.
   2. Use SUMIFS with an absolute reference to cells F4:F23 as the Sum_range argument.
   3. The Criteria_range1 argument is an absolute reference to cells E4:E23. The Criteria1 argument is bre* to select the city of Brentwood.
   4. The Criteria_range2 argument is an absolute reference to cells D4:D23, the department column, with criteria of lan* to select the Landscape Design department.
   5. Click OK. The result for cell E25 is 10.
   6. Build SUMIFS formulas for cells E26:E28 based on the criteria displayed in cells C26:C28.
   7. Format borders to remove inconsistencies, if any, and adjust column widths to display data.
8. Use TEXTJOIN to display names. Note: If your version of Excel does not include the TEXTJOIN function, use CONCAT or CONCATENATE to build the function.
   1. Click the Full Names sheet tab and select cell E4.
   2. Start a TEXTJOIN function and press Spacebar for the Delimiter argument.
   3. Click the Text1 box and select cell C4.
   4. Complete the Text2 and Text3 arguments to show middle and last names and click OK (Figure 6-109).Figure 6-109 Delimiter is a space
   5. Copy the formula to display full names in column E.
9. Save and close the ClassicGardens-06 Excel workbook (Figure 6-110).

 As we deep dive into TCP/IP and OSI protocols, looking at each one’s  architecture.  TCP/IP consists of four to five layers application,  transport, network, data link, and physical. OSI (International  Organization for Standardization) consists of seven layers application,  presentation, session, transport, network, data link, and physical.   

     Both Protocols use application for their first layers.  The  application layer supports applications and sometimes support services  such as encryption and compression.  Which user applications like  browser and word processing applications are not found within this layer  they use protocols that function within the application layer.   Application Protocols used for TCP/IP and OSI include HTTP (Hypertext  Transfer Protocol) which allows browsers and servers to send and receive  web pages.  SMTP (Simple Mail Transfer Protocol) enables users to send  and receive emails.  FTP (File Transfer Protocol) moves files from one  computer to another.  SSH (Secure Shell) allows remote computers to  securely log in to other computer systems.  SNMP (simple Network  Management Protocol) manages the numerous elements in a computer network  to be managed at a single point. 

     Looking at the second layer of TCP/IP and OSI which they differ.    TCP/IP second layer is the Transport Layer.  Which uses TCP  (Transmission Control Protocol) this allows for an error free end to end  connection.  TCP protocol is not the only protocol found in the  Transport Layer.  You can also find UDP (User Datagram Protocol) this is  not commonly found within this layer and usually used when steaming  data like music or videos.  OSI uses the presentation layer for its  second layer.  We do not find this layer within TCP/IP.  Which it  performs functions for presenting data properly to the sender or  receiver.

     The Third layer of TCP/IP and OSI differ also.  TCP/IP has the  Network layer thirdly.  The Network layer also known as Internet layer  or IP layer is used to transfer data within, and between networks.  IP  (Internet Protocol) software which prepares packets of data for  transmission between the networks. OSI third layer consists of the  session layer and is not found within the layering of TCP/IP protocol.   The session layer consists of transferring large amounts back and forth  between two systems.  It uses a point after each small section of  transmission to ensure proper data transmission.

     Now we are at the fourth layer of TCP/IP and OSI protocols.   TCP/IP uses Data Link at this layer.  Data Link layer which gets data  from user’s workstations and passes it to the router connected to the  Internet.  Commonly the LAN gets the data from workstation to Internet.   The Data Link Layer prepares data for transmission to a router sitting  between the LAN and internet.  OSI’s fourth layer is the second layer of  TCP/IP, Transport Layer.  Which verifies the data that arrived at the  destination is the same sent from the original station.

     Diving into the fifth layer of TCP/IP and OSI we see they also  differ.  With TCP/IP we find the Physical Layer which is the final layer  of its architecture.  This is where the data transmission occurs.  This  can be through physical wiring, or radio signal.  OSI uses the same  layer TCP/IP uses at its third layer.  Network layer also known as  Internet layer or IP layer is used to transfer data within, and between  networks.  IP (Internet Protocol) software which prepares packets of  data for transmission between the networks.

     OSI architecture only contains two more layers which are  included in the architecture of TCP/IP.  The sixth layer of OSI is the  Data Link layer it prepares data for transmission to a router sitting  between the LAN and internet.  OSI’s fourth layer is the second layer of  TCP/IP, Transport Layer.  Which verifies the data that arrived at the  destination is the same sent from the original station.  The seventh  layer is the Physical layer which is the final layer of OSI  architecture.  The physical layer where the data transmission occurs.   This can be through physical wiring, or radio signal.  

     After deep diving into both TCP/IP and OSI protocols we can see  that OSI architecture is bigger and more in depth then TCP/IP.   Understanding their architecture really brings why and what purpose  would you want to use ether.  My opinion is that you would use OSI in a  more secured networked area and TCP/IP within a expansion and smaller  less secure networked area.

References

West, J. (2022). Data Communication and Computer Networks (9th ed.).  Cengage Learning US. https://ecpi.vitalsource.com/books/9780357504413

Lab #5 Week 5 WiFi capture using Tshark

Using Google find information on using Tshark to capture a wifi communication, then using the environment execute some of the Tshark commands. This is an exploratory lab so the goal is to find as much information on the use of Tshark as a wireless capture tool as you can find and report on it in your lab books.

Writing Requirements

• Use the APA template located in the Student Resource Center to complete the assignment.

#Exp22 Excel Ch07 HOE Salaries

#Exp22 Excel Ch07 HOE Salaries

#Excel Chapter 7 Hands-On Exercise – Home Protection, Inc. 

Project Description:

You are an assistant accountant in the Human Resources (HR) Department for Home Protection, Inc., a company that sells smart home security systems to residential customers. Home Protection, Inc., with locations in Atlanta, Boston, Chicago, and Cleveland, has a manager at each location who oversees several account representatives. You have an Excel workbook that contains names, locations, titles, hire dates, and salaries for the 16 account representatives and 4 managers. To prepare for your upcoming salary analyses, you downloaded salary data from the corporate database into the workbook. The HR director wants you to perform several tasks based on locations and job titles. You will use date functions to identify the year each employee was hired and how many years they have worked for the company. In addition, you will use logical functions to calculate annual bonus amounts. Next, you will insert math and statistical functions and a map to help analyze the data. Finally, you will review the financial aspects of automobiles purchased for each manager.

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

Your first task is to extract   the year hired from the hire date for each employee.
 

  In cell F7 of the 1-Date Logic worksheet, insert the YEAR function to   identify the year from the date stored in cell E7. Use the fill handle to   copy the function from cell F7 to the range F8:23 using the Fill Without   Formatting option. 

Your next task is to calculate   how long each manager and representative has worked for the company.
 

  In cell G7, insert the YEARFRAC function using the Hire Date and Last Day of   the Year. Use relative and mixed references correctly. Use the fill handle to   copy the function in cell G7 to the range G8:G23 using the Fill Without   Formatting option. 

You want to identify which day   of the week each employee was hired. To do this, you will insert a WEEKDAY   function to return an integer representing the weekday.
 

  In cell H7, insert the WEEKDAY function using the Hire Date. Copy the   function from cell H7 and paste to the range H8:H23 using the No Borders   paste option.  

You will use a custom number   format to display the result as a weekday instead of an integer.
 

  Select the range H7:H23, apply the custom number format dddd, and apply left horizontal alignment.

Column B contains the city   location for each account rep and manager. However, you also want to display   the regions. Atlanta is in the South, Boston is in the Northeast, and Chicago   and Cleveland are both in the Midwest. You will use the SWITCH function to   identify which region each city is in.
 

  In cell C7, insert the SWITCH function to identify the city in cell B7.   Switch Atlanta   for South (cell   C2), switch Boston for Northeast (cell C4), switch Chicago for Midwest (cell C3), switch   for Midwest (cell C3). Insert city names as text   strings, and use mixed references to the cells containing the regions. Copy   the function from cell C7 and paste to the range C8:C23 using the paste   Formulas option. 

Your next task is to calculate   the annual bonus amount for each employee. The company uses a tiered bonus   system that awards a specific percentage of salary based on hire date.
 

  In cell J7, insert the IFS function to test if the Hire Date is before   1/1/2013. If so, the bonus is 8% of the salary. If the Hire Date is before   1/1/2018, the bonus is 4% of the salary. If the Hire Date is before 1/1/2023,   the bonus is 2% of the salary. If none of the conditions are met, the bonus   is 0. Use mixed references to the   dates in the range J2:J4 and bonus percentages in the range K2:K4. Copy the   function from cell J7 and paste it in the range J8:J23 using the paste   Formulas option.  

The HR director recommends that   the company pay managers at least $80,000.
 

  In cell K7, insert an AND function that evaluates if the the Title is Manager and if the Salary is less than   $98,000. Insert the title as a text string and use a mixed reference to the   $98,000 in cell G3. Nest the AND function as the logical test within an IF   function. If the results of the AND function are true, display the text Due for a   raise. If the   results are false, display the text N/A. Use the fill handle to copy the function to the   range K8:K23 using the Fill Without Formatting option. 

You want to calculate the number   of employees in each state. You set up a worksheet with a summary section to   calculate statistics by states, indicated by the state abbreviations.
 

  Display the 2-Stats Map worksheet. In cell J3, insert the COUNTIF function to   count the number of state abbreviations in the State column that match the   state abbreviation in cell I3. Use mixed references to the range and relative   reference to the criteria state abbreviation. Copy the function from cell J3   to the range J4:J6. 

Next, you want to calculate the   total payroll by summing employee salaries in each state.
 

  In cell K3, insert the SUMIF function to total the Salary column if the State   column meets the state abbreviation criteria in cell I3. Use mixed and   relative references correctly. Copy the function from cell K3 to the range   K4:K6.  

You now want to focus on average   salaries by job title. You will calculate the average account rep salary and   the average manager salary.
 

  In cell J9, insert the AVERAGEIF function to calculate the average salary if   the Title column meets the title criteria in cell H9. Use mixed and relative   references correctly. Copy the function from cell J9 to cell J10. 

Now you want to focus on the   summarizing data for Account Reps hired before 1/1/2018. Specifically, you   want to calculate the total number of Account Reps.
 

  In cell J13, insert the COUNTIFS function to calculate the number of Account   Reps (cell H9) in the Title column where the date in the Hire Date column was   before 1/1/2018. Use relative references for   the two criteria range arguments and the title criteria argument in cell H9.   Type the date comparison for the second criteria argument.

The next step is to calculate   the total salary for Account Reps hired before 1/1/2018. You will use mixed   references so that you can later copy the function and change the function   name for other calculations.
 

  In cell J14, insert the SUMIFS function to calculate the total amount in the   Salary column where the Title contains the job title criteria Account Rep   (cell H9) and where the date in the Hire Date column was before 1/1/2018. Use relative references for   the sum_range argument, the two criteria range arguments, and the title   criteria in cell H9. Type the date comparison for the second criteria   argument.

Copy the function from cell J14   to cell J15. In cell J15, change the function name to AVERAGEIFS. If the original function was   created correctly with mixed and relative cell references, the modified   function should calculate the average salary for Account Reps hired before   1/1/2018.

Copy the function from cell J15   to cell J16. In cell J16, change the function name to MAXIFS. If the original function was   created correctly with mixed and relative cell references, the modified function   should calculate the highest salary for Account Reps hired before 1/1/2018.

Copy the function from cell J16   to cell J17. In cell J17, change the function name to MINIFS. If the original function was   created correctly with mixed and relative cell references, the modified   function should calculate the lowest salary for Account Reps hired before   1/1/2018.

You want to insert a map to   indicate the total payroll by state.
 

  Select the ranges I2:I6 and K2:K6 and insert a filled map. Cut the map and   paste it in cell M1.

Change the map title to Payroll by   State.

You want to customize the map.
 

  Display the Format Data Series task pane and display map labels in the Best   fit only position. Apply the Diverging (3-color) series color. Change the   minimum lowest value fill color to Orange. Change the maximum highest value   fill color to Dark Red. Close the task pane.

The location managers want new   company cars. The chief financial officer has determined that the company can   afford $600 monthly payments based on a 5.25% APR for three-year loans. Your   first step is to calculate the loan.
 

  Display the 3-Finance worksheet. In cell E2, insert the PV function using the   periodic rate, the number of payment periods, and a negative value for the   monthly payment.

Next, you want to enter formulas   that will calculate the beginning balance.
 

  In cell B8, enter a reference to cell E2. In cell B9, enter a reference to   cell F8. Copy the formula from cell B9 to the range B10:B43. (The results   will be correct after all other formulas and columns are completed.)

In cell C8, enter a mixed   reference to B2. Copy the formula to the range C9:C43. The results should be   600 for all formula results.

The next column is designed to   calculate the interest amount per payment.
 

  In cell D8, insert the IPMT function using the periodic rate, the current   payment number in the first column, the number of payments, and loan. Use   relative and mixed references correctly. Make sure the result is a positive   value. Copy the function to the range D9:D43.

Column E is to display the   portion of the payment that goes toward paying down the principal.
 

  In cell E8, insert the PPMT function using the same arguments that you used   for the IMPT function. Copy the function to the range E9:E43.

You are now ready to calculate   the ending balance after each payment. After you complete this step, the   amortization table should display complete results.
 

  In cell F8, enter a formula that subtracts the principal payment from the   beginning balance. Copy the formula to the range F9:F43.

You are ready to format the   amortization table.
 

  Format the range B8:F8 with Accounting Number Format. Format the range B9:F43   with Comma Style.

Format the range C44:E44 with   the Total cell style.

You decide to include a column   to show the cumulative interest after each payment.
 

  In cell H8, insert the CUMIPMT function using the periodic rate, number of payments, loan, first payment   number as start period, first payment number as end period, and 0 as the Type   argument. Use mixed references for all cell references except the end_period   argument, which should be a relative reference. Edit the function to display   a positive result. Copy the function to the range H9:H43.

Finally, you want to calculate   cumulative principal after each payment.
 

  In cell I8, insert the CUMPRINC function using the same arguments that you   used for the CUMIPMT function. Copy the function to the range I9:I43.

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

 –    Read Leaked Movie Trailer and a Confidentiality Agreement and complete the questions at the end of the case study.     ( https://www.scu.edu/ethics/focus-areas/business-ethics/resources/leaked-movie-trailer//)

– The answers should be a minimum of two pages with two references attached for each. There should be no plagiarism- attach a plagiarism report with 0% similarity index

Title: Chapter-05 Video Case-3 Netflix

SEE LINKS: 

Watch 2 videos and Answer the following questions:

1. What event convinced Netfix to switch to a cloud-based service? 
2. What is Chaos Monkey and why is it importance for Netfix and its use of AWS? 
3. Why is it important for Netfix that AWS has multiple availability regions?

4. Do you watch TV or movies on Netfix? Have you encountered varying quality of service 
at different times of day?

———————————

Title: Chapter-06 Video Case-1 BrooksBrothers

SEE LINKS BELOW:

https://youtu.be/Pdil74-KoAU

Watch Video and Answer the following questions: 

1. What were some of the information system problems Brooks Brothers needed to resolve?
2. What critical aspect of Brooks Brothers service did the company hope to preserve with its
SAP implementations?
3. Why did Brooks Brothers select the SAP HANA database management system?
4. How will Brooks Brothers use its new database?
5. Do you think systems like SAP CRM and SAP HANA are necessary for all businesses with a
global presence? Why or why not?

———————–

Save both in separate Microsoft Word Files. 

Assigned Readings:

Chapter. 9 Reducing Project Duration

Chapter. 10 Being an Effective Project Manager

Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.

Also, provide a graduate-level response to each of the following questions:

1. Which of the eight traits/skills associated with being an effective project manager is the most important? The least important? Why?
2. It is possible to shorten the critical path and save money. Explain how.

Text

Title: Project Management: The Managerial Process 

ISBN: 9781260238860 

Authors: Clifford F. Gray, Erik W. Larson 

Publisher: McGraw-Hill Education 

Publication Date: 2020-01-09