PCI

1.Navigate to https://www.pcisecuritystandards.org/ and read about the PCI Council.

The “About Us” and “Getting Started” portions of the website are very helpful for understanding why the PCI Council needed to be created.

2.Identify the types of data that the PCI Council seeks to protect. (Hint: if you have a credit card, what data is on it that would be attractive to data thieves?

3.Identify the consequences of cardholder data breaches that the PCI Council seeks to avoid.

4. Identify three to five PCI DSS requirements that Wyndham is alleged to have violated.

5. Identify three to five mitigations that Wyndham could have implemented to prevent the same losses from occurring again

6. Discuss whether the FTC would have pursued a case against Wyndham if it had been compliant with the PCI DSS regulations. Why or why not?

500 words.

oldm wk 5 dis

  1. Discuss and identify leader traits and attributes that are most beneficial in implementing the best decisions in an organization. 
  2. Explain the differences in charismatic and transformational leadership and how both leadership styles impact organizational effectiveness.  Please note how these leadership styles affect implementing new innovative technologies.
  3. Review table 8.1 in the reading this week, note the work characteristics and the traditional versus high-performance focus, note which focus is best for strategic decisions and which is best for operational decisions.  Please explain.

Please be sure to answer all the questions above in the  post.

Week 3 assignment

Assignment Instructions

Week 3 Assignment:

In order to complete assignment #3 you will need to answer the below questions. Please complete the

questions in a Word document and then upload the assignment for grading. When assigning a name to

your document please use the following format (last name_Assignment #3). Use examples from the

readings, lecture notes and outside research to support your answers. The assignment must be a

minimum of 1-full page in length with a minimum of 2 – outside sources. Please be sure to follow APA

guidelines for citing and referencing source. Assignments are due by 11:55 pm Eastern time on

Sunday.

Read this article: Importance of Understanding Logs from an Information Security Standpoint

https://www.sans.org/white-papers/200/

1) Discuss the purpose of logging, the importance of logging from an Information Security standpoint and how logging can help organizations perform audits their IT environment (think accountability).

Grading Criteria

1. Content 50%

2. Writing Conventions (Grammar and Mechanics)10%

3. Organization of Ideas/Format 300 Words 30%

4. Source (APA Format) 10%

Python programming

  1. This homework tests your knowledge of File Handling and use of Lists data type.
  2. Adhere to the naming conventions discussed in class for variable names, program name and function names
  3. Use meaningful names for variables, functions etc
  4. If there are two words in the variable use first word lowercase and first letter of second word upper case i.e., firstName or underscore between 2 words i.e first_name
  5. Include appropriate comments in the code
  6. Output should be displayed similar to as mentioned against each problem
  7. Indent the lines of code appropriately

1. Write and read file

a ) write_num.py (30 points)

Create a num_list file to write a range of numbers from 1 through 101.

Hints:

   Define main ():

   Open a file named as num_list in write mode.

   Use for loop to write a range of numbers from 1 through 101 into the file.

   Close file

b)read_num.py (40 points)

Use num_list file which got created in number 1.a. Write a program that will prompt the user to enter the name of the file (i.e. num_list.text), and display the first 10 lines of the file’s content. Use try/except construct to capture any file opening related errors such as invalid file name etc.

Hints:

                   Define main ():

                   Declare variables: line and counter, and initialize them

                   Prompt for file name: use input function

                   Open the file in read mode.

                   Read the lines in the file with readline function: ‘inline.readline()’ and initialize counter to 1

                   Use a while loop to read and display the first 10 lines

                                   Use rstrip method to remove n characters at the end of the line

                                   Print the line

                                   Update the counter when the line is read

                    Close file

Expected output:

Enter the name of the file: filename.txt

#

#

#

#

#

#

#

#

2. numanalysis.py (30 points)

Write a program that asks user to enter a series of 10 numbers. The program should store the numbers in a list then display the following data.

1. The list contents

2. The lowest number in the list

3.  The highest number in the list

4. The total of the number in the list

5. The average of the number in the list

Hints:

Define main ():

                       Declare variables and initialize them

                       Create an empty list 

                       Use the for loop with the range function to loop through 10 numbers. 

                       Prompt the User to enter the numbers from 1- 10. 

                           Ex: Enter number 1 of 10: 

                        Use append function to populate the  list

                        Use min, max, sum, functions to find the low , high and total number of the list.

                              Ex:  low = min(number_list)

                         Print the list contents

                        Print Low, high , total and average numbers of the list.

Expected output :

List: [#, #, #, #, #, #, #, #, #, #]

Low: #.##
High: #.##
Total: #.##
Average: #.##

Project: Conduct Quantitative Analysis ( Need Corrections)

  

For this project, I have already done the project in the attached file of (My Spread Sheet folder ). However, I ended up failing this project. For that reason, I would like you to make corrections to my given attached spreadsheet through the given attached folder of (professor feedback) and ( professor instruction folder) give it back to me. you might have to redo the several steps completely as well. Like answering questions and essay. 

The Quick Analysis button is near cell F17

Homework Assignmet

 

As a staff member at Blue Lake Sports Company, you are expected to prepare the monthly sales worksheet. You edit and format data, complete calculations, and prepare the workbook for distribution. You also copy the sheet for next month’s data.

[Student Learning Outcomes 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 1.8]

File Needed: BlueLakeSports-01.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-BlueLakeSports-01.xlsx

Skills Covered in This Project

  • Open and save a workbook.
  • Choose a workbook theme.
  • Edit and format data.
  • Center labels across a selection.
  • Use SUM and the Fill Handle.
  • Adjust column width and row height.
  • Insert a header and a footer.
  • Adjust page layout options.
  • Copy and rename a worksheet.
  1. Open the start file BlueLakeSports-01.xlsx workbook. The start file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor and save it.
  2. If the document opens in Protected View, click the Enable Editing button in the Message Bar at the top of the document so you can modify it.
  3. Apply the Slice theme to the worksheet.
  4. Edit worksheet data.
    1. Edit the title in cell A2 to display Monthly Sales by Department.
    2. Edit cell D6 to 1950.
  5. Select cells A1:F2 and click the Alignment launcher [Home tab]. Click the Horizontal arrow, choose Center Across Selection, and click OK.
  6. Select and delete row 8.
  7. Use the Fill Handle to complete a series.
    1. Select cell B3.
    2. Use the Fill Handle to complete the series to Week 4 in column E.
    3. AutoFit columns C:E to display the complete label.
  8. Use SUM and the Fill Handle to calculate totals.
    1. Use the AutoSum button to build a SUM function in cell F4.
    2. Use the Fill Handle to copy the formula in cell F4 to cells F5:F16.
    3. Delete the contents of cell F17 if you copied the formula to that cell.
    4. Select cells B17:F17 and click the AutoSum button. The SUM formula is inserted, and a Quick Analysis options button appears (Figure 1-98).The Quick Analysis button is near cell F17Figure 1-98 AutoSum complete with Quick Analysis button
    5. Press Esc to ignore the Quick Analysis options.
  9. Format labels and values.
    1. Select cells A1:A2 and increase the font size to 18.
    2. Increase the row height of rows 1:2 to 24 (32 pixels).
    3. Format cells A3:F3 as Bold and increase the row height to 18 (24 pixels).
    4. Center the data in cells B3:F3.
    5. Format cells B4:F16 with Comma Style and decrease the decimal two times.
    6. Select cells B17:F17 and apply the Accounting Number Format with no decimal places.
    7. Apply the All Borders format to cells A3:F17.
    8. AutoFit columns B:F.
  10. Finalize the worksheet.
    1. Click the Insert tab and click the Header & Footer button [Text group].
    2. In the right header section, insert the Sheet Name field.
    3. Go to the footer and click the right section.
    4. Type [your first and last name] (Figure 1-99).Your name is in the Right sectionFigure 1-99 Add a footer in Page Layout view
    5. Click a cell in the worksheet and then return to Normal view.
    6. Center the worksheet horizontally on the page.
  11. Copy and rename a worksheet.
    1. Right-click the January sheet tab and choose Move or Copy.
    2. Make a copy of the sheet at the end.
    3. Rename the copied sheet February.
    4. Format the February sheet tab color to Dark Blue, Accent 1 (fifth column).
    5. Delete the values in cells B4:E16 and press Ctrl+Home.
    6. Return to the January sheet and press Ctrl+Home.
  12. Preview the January sheet.
  13. Save and close the workbook (Figure 1-100).Excel 1-4 completedFigure 1-100 Excel 1-4 completed
  14. Upload and save your project file.
  15. Submit project for grading.

Exp19_Excel_Ch02_ML1_Metropolitan_Zoo_Gift_Shop_Weekly_Payroll

  

Exp19_Excel_Ch02_ML1_Metropolitan_Zoo_Gift_Shop_Weekly_Payroll

Excel Chapter 2 Mid-Level 1 – Metropolitan Zoo 

Exp19 Excel Ch02 ML1 Metropolitan Zoo Gift Shop Weekly Payroll

  

Project Description:

As manager of the gift shop at the Metropolitan Zoo, you are responsible for managing the weekly payroll. Your assistant developed a partial worksheet, but you need to enter the formulas to calculate the regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay. In addition, you want to include total pay columns and calculate some basic statistics. As you construct formulas, make sure you use absolute and relative cell references correctly in formulas 

     

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

 

Use IF functions to   calculate the regular pay and overtime pay based on a regular 40-hour   workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell   G5, calculate the gross pay based on the regular and overtime pay. Abram’s   regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

 

Create a formula in   cell H5 to calculate the taxable pay. Multiply the number of dependents   (column B) by the deduction per dependent (B24) and subtract that from the   gross pay. With two dependents, Abram’s taxable pay is $417.40.

 

Use a VLOOKUP   function in cell I5 to identify and calculate the federal withholding tax.   Use the tax rates from the range D21:E25. The VLOOKUP function returns the   applicable tax rate, which you must then multiply by the taxable pay.

 

Calculate FICA in   cell J5 based on gross pay and the FICA rate (cell B23), and calculate the   net pay in cell K5. Copy all formulas down their respective columns to row   16.

 

With the range E5:K16   selected, use Quick Analysis tools to calculate the total regular pay, overtime   pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row 17.
 

  Note, Mac users, with the range selected, on the Home tab, in the Editing   group, click AutoSum.

 

Apply Accounting Number   Format to the range C5:C16. Apply Accounting Number Format to the first row   of monetary data and to the total row. Apply the Comma style to the monetary   values for the other employees. Apply the Total cell styles format to the   range E17:K17.

 

Insert appropriate   functions to calculate the average, highest, and lowest values in the Summary   Statistics area (the range I21:K23) of the worksheet. Format the # of hours   calculations as Number format with one decimal and the remaining calculations   with Accounting number format.

 

Insert 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 of the worksheet.

 

Save and close the   workbook. Submit the file as directed. 

Peer-Reviewed Journal Analysis

  For this assignment you will read the Amron et al. peer-reviewed journal  article on cloud computing linked in Resources. As you read the  article, take notes about the theories, models, and/or frameworks the  authors used. Prepare to describe the main themes of the article’s  literature view and explain the research findings. State specifically  what business technical problem is answered by the research article. 

Instructions

Complete the following:

  • Describe the relevant theories, models, and/or frameworks the authors used to support their research.
  • Review at least one article cited by Amron et al. and explain how they used its findings, theory, or framework to support their research.       
    • Cite the article in current APA format.
  • Explain the findings from the Amron et al. research article.
  • State specifically what business technical problem is answered by this research article.
  • Communicate in a manner that is scholarly, professional, and  consistent with expectations for information technology professionals.

Submission Requirements

  • Written communication: Write in a professional manner using current APA style and formatting with correct grammar, usage, and mechanics.
  • APA formatting: Resources and citations are formatted according to current APA style and formatting.
  • Length: 3–6 typed, double-spaced pages.
  • Font and font size: Times New Roman, 12 point.

 

Resources