Module 04 Content

1. Based on your work developing a Risk Mitigation Plan, you will be ready to draft a Risk Management Security Plan for management, proposing specific tools and policies for implementation. Your plan should include specific proposals for monitoring, control and reporting and six security policies that would safeguard your organization.

   Objectives

   • Develop a Risk Management Security Plan
   • Research industry policies as a basis for developing risk management policies
   • Requirements
     Your Risk Management Security Plan should include the following:

     1. Introduction (brief background and overview)

     2. Purpose of the Risk Management Security Plan (rationale for this document)

     3. Risk Monitoring, Controlling, and Reporting

   • Monitoring: What security tools do you need to implement to monitor your organization? Provide at least three examples and an explanation of why you chose them.
   • Controlling: What levels of password management, user access, and elevated privileges (i.e., domain) need to be implemented at XYZ Corporation. Provide details and explanations for your decisions?
   • Reporting: What reporting capacity do you have implemented based on adoption of your monitoring tools?
   • 4. Policies
     Research various ISO, SANS, COBIT or NIST policies and use these as a basis for drafting and customizing six
     policies that address the concerns of XYZ after the malware incident. Be sure to provide the details of each
     policy and to cite your research with links in APA format.

   • SANS Security Resources
   • ISO
   • NIST
   • COBIT

Project Summary: The Coffee Company Database Analysis Project comprises three main tables;
A Customer List (Company’s Table); An Orders List; Products List (Coffees). I’ve created the Relationships for all three tables. I’ve included a number of Quires in an Excel format. You will not be required to doing anything else to the Database other than analyze the data and complete the listed tasks below. This is a test of your abilities as an Analyst. Your Rep[ort will be presented to Senior management to help them make a business decision.

There are Excel Worksheets you can use to analyze the company’s business actions.

Project requirements:

1.  Analyze the results (findings) from the Excel Queries and tables. You will need to include the Excel Tables and Quires in your Report.

2.  You will need to make a number of business decisions based on your findings. Apply the appropriate PESTeL, Geographic Factors, SWOT factors if necessary that may affect your findings.

3.  Clearly identify and describe how you would address each point when you apply your analysis.

4.  The format of your report will be similar to the previous case studies: Cover page, Table of Contents, and ALL the requirements in your Final Report.

5.  Review How to Build a Case Study Format on eLearn, Your Personal Reflections, etc. Review the Files on eLearn.

6.  You are required to provide a Personal Reflection Report. (See the Reflection Report Guidelines).

7.  You must upload a softcopy of your analysis to eLearn.

8.  This is not a group project.

9.  I must remind you NOT to copy or provide a copy of your Report to another student.

 random numbers (or, at least, pseudorandom numbers) are essential in cryptography, but it is extremely difficult even for powerful hardware and software to generate them. Go online and conduct research on random number generators. What are the different uses of these tools besides cryptography? How do they work? Explain your answer using your own words in 2-3 paragraphs. 

Exp19_Excel_Ch02_HOEAssessment_Gateway_Vacations

Excel Chapter 2 Hands-On Exercise Assessment – Gateway Vacations 

Exp19 Excel Ch02 HOEAssessment Gateway Vacations

Project Description:

You have been hired as a loan officer for Gateway Vacation properties, a timeshare company in Southern Florida. As part of your responsibilities, you calculate loan information for customers who purchase timeshares. You will use Excel to calculate down payment, interest rate, and total payment information.

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

Click cell B2, click   the Formulas tab, click Date & Time in the Functions Library group.   Select NOW, and then click OK to enter today’s date in the   cell.

Click cell D9. On the   Formulas tab, click Logical in the Function Library group, and select IF.   Type C9<$B$6 in the Logical_test box, type B9*$B$4   in   the Value_if_true box, and type B9*$B$5 in the Value_if_false box.   Click OK, and use the fill handle to copy the contents of cell D9 down the   column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell E9, type =(B9-D9)/B9, and use the fill   handle to copy the contents of cell E9 down the column. Click Auto Fill   Options, and click Fill Without Formatting.

Click cell F9, type   =B9-D9,   and and press CTRL+ENTER. Use the fill handle to copy the contents of cell F9   down the column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell G9, click   Lookup & Reference in the Function Library group and select VLOOKUP. Type   C9   in the Lookup_value box, type $D$4:$E$6 in the Table_array box, and   type 2 in the Col_index_num box. Click OK.

With cell G9   selected, use the fill handle to copy the contents of cell G9 down the   column, stopping at row 28. Click Auto Fill Options, and click Fill Without   Formatting. With the range G9:G28 selected, on the Home tab, in the Number   group, click Increase Decimal twice.

Click cell H9, type   =G9/12,   and press CTRL+ENTER Use the fill handle to copy the contents of cell H9 down   the column, stopping at row 28. Click Auto Fill Options, and click Fill   Without Formatting. With the range H9:H28 selected, on the Home tab, in the   Number group, click Increase Decimal twice.

Click cell J9, type   =I9*12,   and press CTRL+ENTER. Use the fill handle to copy the contents of cell J9   down the column. Click Auto Fill Options, and click Fill Without Formatting.

Click cell K9. Click   the Formulas tab, click Financial, and then click PMT. Type H9 in the rate box, J9 in the NPER box, and   type -F9 in the Pv box. Click OK. 

Use the fill handle   to copy the contents of cell K9 down the column. Click Auto Fill Options, and   click Fill Without Formatting.

Click cell K29, press   ALT+=, and press ENTER.

Click cell B32, type  =COUNT(A9:A28), and press CTRL+ENTER to   calculate the total # of loans.

Click cell B33, type   =MIN(K9:K28), and press CTRL+ENTER to calculate the lowest monthly payment.

Click cell B34, type   =MAX(K9:K28), and press CTRL+ENTER to calculate the highest monthly payment.

Click cell B35, type =AVERAGE(K9:K28), and press   CTRL+ENTER to calculate the average monthly payment.

Click cell B36, type =MEDIAN(K9:K28), and press   CTRL+ENTER to calculate the median monthly payment.

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

Save and close Exp19_Excel_CH02_Assessment_Timeshare.xlsx.   Exit Excel and submit as directed.

Graphics are used in many different media: television, newspapers, and the internet. As web designers, you may need to select raster or vector graphics for the website you are creating. In this Assignment, you will compare and contrast these two types of graphics.

Create and submit the report in a 2- to 3-page paper (MS Word or PDF format file) that:

Compares and contrasts raster and vector graphics

Describes some of the benefits and drawbacks of raster and vector graphics

Explains when it is most appropriate to use each of the two graphic types

You want to install a biometric access control outside of a restricted room in your facility. You are considering a retina pattern system and a voice recognition system.

Answer the following question(s):

1. What are the top three factors that will influence your decision, and why?

Fully address the question; provide valid rationale for your choices, where applicable; in a one page review.

 1. Answer the following discussion question and use the grading rubric to see how you will be evaluated. Note that you must post your initial thread/post before you can view other students’ posts.

Compared with some of the other models you have read in the textbook, another increasingly common way to view IT-Business strategy and strategic use of information resources is through the lens of Digital Business Strategy and Digital Transformation. View the following video then answer the related questions – the presentation is titled Digital Disruption: Transforming Your Company for the Digital Economy with Jeanne Ross – [approximately 45-minute presentation] –

1. Other than a difference in terminology, how is a “Digital Strategy” as presented in the video different than an IT Strategy that you read about in Module 1?

2. What is SMACIT? How are the technologies included in SMACIT disrupting businesses? What operational or digital foundations must be in place in order for a business to successfully build an integrated digital strategy with SMACIT?

3. After reviewing the video, provide an example of a company you believe is successfully employing a digital business strategy and provide several examples as related to SMACIT and backbone? (Please choose a company other than one in the presentation. You may consider choosing a manufacturer. Avoid choosing a tech company such as Facebook or Amazon.)

Exp19_Excel_Ch07_CapAssessment_Shipping

Exp19_Excel_Ch07_CapAssessment_Shipping

Project Description:

You work for a company that sells cell phone accessories. The company  has distribution centers in three states. You want to analyze shipping  data for one week in April to determine if shipping times are too long.  You will perform other analysis and insert a map. Finally, you will  prepare a partial loan amortization table for a new delivery van.

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

The Week worksheet contains data   for the week of April 5.
 

  In cell D7, insert the appropriate date function to calculate the  number of   days between the Date Arrived and Date Ordered. Copy the  function to the   range D8:D35.

Next, you want to display the   city names that correspond with the city airport codes.
 

  In cell F7, insert the SWITCH function to evaluate the airport code  in cell   E7. Include mixed cell references to the city names in the  range F2:F4. Use   the airport codes as text for the Value arguments.  Copy the function to the   range F8:F35.

Now you want to display the   standard shipping costs by city.
 

  In cell H7, insert the IFS function to identify the shipping cost  based on   the airport code and the applicable shipping rates in the  range G2:G4. Use   relative and mixed references correctly. Copy the  function to the range   H8:H35.

Finally, you want to calculate a   partial shipping refund if two conditions are met.
 

  In cell I7, insert an IF function with a nested AND function to  determine   shipping refunds. The AND function should ensure both  conditions are met:   Total Days is grater than Total Days Delivery Goal  (cell C3) and Order Total   is equal to or greater than Order Total  Threshold (cell C2). If both   conditions are met, the refund is 50%  (cell C4) of the Shipping Cost.   Otherwise, the refund is $0. Use mixed  references as needed. Copy the   function to the range I8:I35.

The Stats worksheet contains   similar data. Now you want to enter summary statistics.
 

  In cell B2, insert the COUNTIF function to count the number of  shipments for   Austin (cell B1). Use appropriate mixed references to  the range argument to   keep the column letters the same. Copy the  function to the range C2:D2.

In cell B3, insert the SUMIF   function to calculate the total orders  for Austin (cell B1). Use appropriate   mixed references to the range  argument to keep the column letters the same.   Copy the function to the  range C3:D3.

In cell B4, insert the AVERAGEIF   function to calculate the average  number of days for shipments from Austin   (cell B1). Use appropriate  mixed references to the range argument to keep the   column letters the  same. Copy the function to the range C4:D4.

Now you want to focus on   shipments from Houston where the order was greater than $1,000.
 

  In cell C7, insert the COUNTIFS function to count the number of  orders where   the Airport Code is IAH (Cell D1) and the Order Total is  greater than $1,000.   

In cell C8, insert the SUMIFS   function to calculate the total  orders where the Airport Code is IAH (Cell   D1) and the Order Total is  greater than $1,000. 

In cell C9, insert the MAXIFS   function to return the highest order  total where the Airport Code is IAH   (Cell D1) and the Order Total is  greater than $1,000.

On the Map worksheet, insert a   map for the states and revenues. Cut and paste the map in cell C1.

Format the data series to show   only regions with data and show all map labels.

Change the map title to April 5-9   Gross Revenue.

Use the Loan worksheet to   complete the loan amortization table.
 

  In cell F2, insert the IPMT function to calculate the interest for  the first   payment. Copy the function to the range F3:F25. (The results  will update   after you complete the other functions and formulas.)

In cell G2, insert the PPMT   function to calculate the principal  paid for the first payment. Copy the   function to the range G3:G25.

In cell H2, insert a formula to   calculate the ending principal balance. Copy the formula to the range H3:H25.

Now you want to determine how   much interest was paid during the first two years.
 

  In cell B10, insert the CUMIPMT function to calculate the  cumulative interest   after the first two years. Make sure the result is  positive.

In cell B11, insert the CUMPRINC   function to calculate the  cumulative principal paid at the end of the first   two years. Make sure  the result is positive.

You want to perform a what-if   analysis to determine the rate if the monthly payment is $1,150 instead of   $1,207.87.
 

  In cell B15, insert the RATE function to calculate the necessary  monthly rate   given the NPER, proposed monthly payment, and loan. Make  sure the result is   positive.

Finally, you want to convert the   monthly rate to an APR.
 

  In cell B16, insert a formula to calculate the APR for the monthly rate in   cell B15.

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

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

Create a Tic-Tac-Toe game using FIFO (named) pipes as follows. Note: Two processes (p1 and p2) must communicate via FIFO (named) pipe.  

1. Create two programs that communicate via FIFO pipes.
   • p1 is for player 1 which plays with “O”.
   • p2 is for player 2 which plays with “X”.
   • You may assume p1 always plays first (for simplest’s sake in implementation).
2. p1 and p2 run at separate terminals on the same directory.
3. p1 and p2 are responsible for displaying the game board and interacting with each player
4. p1 and p2 are responsible for validating inputs from the player. Input validation includes:
   • selection of the location to play (0 ~ 8)
   • validation of input data: a digit and available locations (empty cells) only.
5. p1 and p2 communicate to find which move the other player has taken.
6. p1 and p2 are responsible for determining game progress statuses such as playing or game over with win, loss, or tie.
7. When the game is over, p1 and p2 show if it has won, lost, or tied at its own terminal.
8. Prompt user if they would like to play again,
9. If both p1 and p2 reply with Y (yes), the game starts over again instead of terminating the program.

At the initial screen: Instead of zero(0), a dot(.) is displayed to avoid confusion with O. However, the user enters 0 (zero) to select the location.

+-+-+-+
|.|1|2|
+-+-+-+
|3|4|5|
+-+-+-+
|6|7|8|
+-+-+-+

As O/X’s have been played in some locations, digits or . are replaced by O’s and X’s. The below board shows O has placed at cell locations 0, 1, and 8 while X has played at cell locations 4 and 6.

+-+-+-+
|O|O|2|
+-+-+-+
|3|X|5|
+-+-+-+
|X|7|O|
+-+-+-+

Research on the Internet to obtain the latest available information for the following:

• List of the 100 largest companies in US and in the World
• List of the top 10 largest Internet retailers in the World 

Make sure to obtain their sales and profits/losses in US Dollar