Central Sierra Insurance (CSI) sets bonus percentages based on commissions earned by each agent and calculates totals by branch office. This workbook also tracks fundraising efforts of employees for a community event.

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

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

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

Skills Covered in This Project

• Create, copy, and edit formulas.
• Name cell ranges.
• Set mathematical order of operations.
• Set cell references to be absolute.
• Use the NOW function.
• Use HLOOKUP and VLOOKUP
• Use the SUMIF function.
• Build an IF function.

1. Open the start file CentralSierra-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. 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. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group].
3. Select cells B1:F2 and click the Name box. Name the selection H_Rates. Note that the first row is arranged in ascending order.
4. Create an HLOOKUP function to display the bonus rate.
   1. Click the Commissions sheet tab and select cell F5.
   2. Start the HLOOKUP function and use cell E5 as the lookup_value.
   3. For the table_array argument, use the H_Rates range.
   4. Use the second row for the row_index_num argument (Figure 2-100).Figure 2-100 HLOOKUP function to display bonus
5. Format the results as Percent Style with two decimal places.
6. Copy the formula in cell F5 to cells F6:F14.
7. Set order of operations to calculate total earnings.
   1. Select cell G5.
   2. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5).
   3. Copy the formula in cell G5 to cells G6:G14.
8. Create and copy a SUMIF function to calculate total earnings by branch office.
   1. Select cell E18.
   2. Start the SUMIF function with cells $D$5:$D$14 as the Range argument.
   3. Set the Criteria argument as a relative reference to cell C18.
   4. Select cells G5:G14 for the Sum_range argument and make the references absolute.
   5. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders.
   6. Format cells E18:E21 as Currency.
9. Total the earnings in cell E21.
10. Create and format the current date.
    1. Select cell G23 and insert the NOW function.
    2. Select cell G23 and click the Number group launcher [Home tab]. On the Number tab, select the Date category.
    3. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).Figure 2-101 Date format selected
    4. Click OK. Press Ctrl+Home.
11. Create and copy a VLOOKUP function to display goals for each funding source.
    1. Click the Family Day sheet tab and select cell F6.
    2. Start the VLOOKUP function and use cell E6 as the lookup_value.
    3. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.
    4. Use the second column as the col_index_num The range_lookup argument is empty.
    5. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.
    6. Format cells F6:F20 as Currency with no decimal places.
12. Create and copy an IF function.
    1. Select cell H6 and start an IF
    2. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.
    3. Type Yes as the Value_if_true argument and No as the Value_if_false argument.
    4. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.
    5. Center align cells H6:H20.
    6. Press Ctrl+Home.
13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.
14. Save and close the workbook (Figure 2-102).

Problem: Transportation system in London has an issue of getting overloaded during some soccer games. Since this data was not available consistently due to soccer games not having a set pattern every season, the city of London needed to put together a data analysis strategy in order to predict the transportation usage during these games and administer transportation systems accordingly.  

Definition: Overloading of high volume stations with travelers on Weekend evenings which was design as a low load period. 

Scope: Data  governance strategy for acquiring data, specifying principles, quality, metadata, access and lifecycle 

 Provide >=3 examples of security exploits that have taken place in the last 3 years.  In each example, provide the type of attack, technical detail on how the attack worked, what was known about the attacker, the impact of the attack (on both the victim/organization and on technology in general).
 

1200 Words – Exclude references!! 

***no Plagiarism, APA format***

!!!! No money Negotiations after accepting the Bid !!!!!!!

Answer the following questions with reference to the textbook.

Textbook: Introduction to Data Mining by Pang-Ning Tan.

1. How does data and classifying data impact data mining?

2. What is association in data mining?

3. Select a specific association rule (from the text) and thoroughly explain the key concepts.

4. Discuss cluster analysis concepts.

5. Explain what an anomaly is and how to avoid it.

6. Discuss methods to avoid false discoveries.

This assignment should consider all the course concepts in the textbook and follow APA 7 Guidelines.  Be very thorough in your responses.  There should be headings to each question above and an introduction and conclusion. The paper should be 3-4 pages long and contain at least two-peer reviewed sources.

Jan and Kim Levering have decided to expand their IT consulting business. They have leased space in a nearby building. The following are the details: They will have an entire floor that has the following: a receptionist area 2 offices (one for Jan and one for Kim) a conference room an office that will accommodate 15 cubes for their consultants a computer room to house their server(s) They currently have 8 Windows XP systems set up in a workgroup They would like you to develop a 2-phased plan. The first phase involves moving from the current office to the new office. In a 3–4-page report, you need to do the following: Diagram the network and identify the topology and components: Their existing equipment is as follows: 8 XP systems 1 each in Jan and Kim’s offices 6 systems cubes (1 per cube) 1 Windows Server 2008 (standard edition) system in the computer room 1 printer in the computer room Include the following: IP addressing scheme (use static addressing) subnetting/supernetting subnet mask for phase 1 Provide an installation guide on how to set up the Windows Server 2008 system and the network, including the following: illustrations of the server installation process a minimum of 8 Windows Server 2008 screenshots, with detailed explanations descriptions of the settings for the following: server roles naming conventions disk format (NTFS or FAT) joining security centralized versus decentralized administration a discussion of TCP/IP configuration a comparison of settings between workgroup and domain an explanation of typical installation problems/difficulties related to the following: hardware software the network The second phase, to be completed later, will be to expand their network to accommodate additional equipment. The answer should be in a 3-4 page Words Document.

What is Medicare? Explain the components and financing of each part. What are the problems for Medicare? What are your solutions? 
The  paper should be 3 pages and include the following and must be free of plagiarism 
• Introduce and define the topic (your study group knows nothing about it). 
• Discuss the details of the topic. 
• What are the pros and cons (or support vs opposition)? 
• What is your personal stand on the issue? 
• After reading the briefing paper, a member of your support group should have a general understanding of the issue. 

Point-of-Sale (POS) Attacks

Overview

Suppose you are an information security officer for a consulting firm that implements, secures, investigates, and supports POS for small and medium retail businesses.Read the article If You Shopped at These 16 Stores in the Last Year, Your Data Might Have Been Stolen. Choose two stores from the list and use the Strayer University Library to research the specific attack or breach.

Instructions

Write a 3–5 page paper in which you:

1. Summarize the selected attacks, providing details on the breaches’ effects.
2. Identify the common purpose of attacks on POS systems.
3. Assess how and why these POS systems have become a prime target for hacking groups.
4. Examine the forensics challenges that exist for investigations on POS systems.
5. 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.
   • One of your resources may be the provided article.

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 paper 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:

• Assess the forensics challenges that exist for investigations.

Create the logic for a program that continuously prompts the user for a number of dollars until the user enters 0. Pass each entered amount to a conversion method that displays a breakdown of the passed amount into the fewest bills; in other words, the method calculates the number of 20s, 10s, 5s, and 1s needed.
 

Explain how information technology affects the strategies of the organization in a nursing home.

What other external factors could affect the use of new technologies? 

Explain how technology can impact an organization’s external environment. 

Please use examples to highlight your points.

Please see below the discussion in response to the original question asked and respond as a peer using 150 or more words.

Original Question:  Please conduct your own research on Instruction Set Architecture (ISAs). Look over how they process address memory. Compare the similarities and differences of format, instructions, type of instructions, and addressing modes. 

Peer Response:  

Good day, all!

Instruction Set Architecture (ISA) can be described as the interface between a computer’s hardware and software. ISA dictates what a particular computer will support in terms of the computer’s features such as various hardware, I/O devices, registers, processors, etc. For instance, both Intel and AMD can build a processor using the x86 instruction set, but the physical formation of components within the two processors may be completely different. The instruction set simply serves as the basic outline for the computer, but leaves the actual implementation up to the builder. There are several types of ISAs including Reduced Instruction Set Computer (RISC), Complex Instruction Set Computer (CISC), and Minimal Instruction Set Computer (MISC). Each of these architectures consist of different strategies for storing and processing data.

Microprocessors Without Interlocked Pipelined Stages (MIPS) is an architecture which uses the RISC instruction set. It consists of thirty-two 32-bit registers and defines instructions such as Load and Store (for moving data between registers and memory), arithmetic instructions (add, multiply, etc.) and instructions for jumping to control the flow of data. Each instruction in this architecture holds 32 bits, and comes in one of three formats: R-type, I-type, and J-type. Each one begins with a 6 bit operation code which defines what operation is to be performed. R-type instructions also consist of 5 bits for the indices of two source registers, 5 bits for a destination register, 5 bits to define the shift amount, and 6 bits for the function to be performed. I-type instructions are used for immediate values, and J-type is used for jumping operations.

As mentioned above, the x86 instruction set holds some differences compared to the MIPS architecture. It consists of six general purpose registers and two special purpose registers (the stack pointer and base pointer). All registers are 32 bits long. Four of the six general purpose registers hold the ability to divide the register into one unique 16-bit subsection and two unique 8-bit subsections. x86 utilizes data movement instructions (such as mov, push, and pop), arithmetic instructions (such as logical operations, add, subtract, etc.) and control flow instructions (such as jump and compare). x86 allows for memory regions to be declared using labels, which the assembler replaces with 32-bit quantities that specify addresses in memory.

Thanks all and have a great day!