Monthly Archives: June 2023

 1. What are the common mistakes to avoid in your program when using loops?  Use examples to explain. 

Technical Report on the title named Nanotechnology in Communication.

Note:-

Must be in APA format; please do the in-text citations.

The draft is already done. Now, please do the final report where you should be adding 5 more pages supporting and favoring the current paper attached to this question. 

It should be 10 pages long excluding the outline and reference pages.

Assignment Content

1. For this assignment, your team will add to last week’s assignment and outline application security policies for the health insurance company. Your organization’s chief information security officer (CISO) wants to improve the application security controls throughout the company since it must protect confidential and personally identifiable information of its customers.

   Outline a 2- to-3-page security policy in which your team:

   • Defines application security policies
   • Defines user login and password policies
   • Defines secure coding policies and tests for internally created software
   • Includes 2 other standards or guidelines of your team’s choice
   • Cite any references to support your assignment.

     Format your assignment according to APA guidelines.

Exercise 1:  If an organization has three information assets to evaluate for risk management purposes, as shown in the list below, which vulnerability should be evaluated for additional controls first? Which vulnerability should be evaluated last?

• A CRM-Server that is connected to the Internet. It has two vulnerabilities:
  • susceptibility to hardware failure, with a likelihood of 8, and
  • susceptibility to ransomware attack with a likelihood of 4.

The CRM-Server has been assigned an impact value of 10.  Assume that there are no current controls in place to protect it, and there is a 75 percent certainty of the assumptions and data.

• An E-commerce server hosts the company Web site and supports customer transactions. It runs a server software that is vulnerable to a buffer overflow attack, with the likelihood of such an attack estimated at 6. The server has been assigned an impact value of 8. Assume that there are no current controls in place to protect the server, and there is a 70 percent certainty of the assumptions and data.
• A Control-Console to monitor operations in the server room. It has no passwords and is susceptible to unlogged misuse by the operators. Estimates show that the likelihood of misuse is 2. There are no controls in place on this asset, which has an impact value of 5. There is a 90 percent certainty of the assumptions and data.

Exercise 2:  Using the list of threats to InfoSec presented in Chapter 6 identify and describe three instances of each that were not mentioned in the chapter.

Refer to the attached requirements and guidelines in the uploads.

  2 pages —————-

Chapter Eight (8): Information Governance and Legal Functions: According to the authors, Smallwood, Kahn, and Murphy, IG is perhaps one of the functional areas that impact legal functions most. Failure to meet them could be literally put an organization out of business or land executives in prison.   Privacy, security, records management, information technology (IT), and business management functions are very important.  However, the most significant aspect of all of these functions relates to legality and regulatory compliance from a critical perspective. 

For this discussion, identify the industry you will be writing about in your final paper (https://www.homeworkmarket.com/questions/ig-wk3)  and discuss the regulatory compliance requirements that the company has to meet and the corresponding security, privacy, and records management functions that would need to be enabled for that organization. Remember to cite your sources and critically respond to two other learners.

Assignment B: SQL Statements Instructions

In this assignment, you will construct SQL Statements based on a sample data provided in the Excel document located in the assignment submission folder located after this page. Here are the steps to follow to complete this short assignment:

1. Download the SQL Queries Excel document (Located in the assignment submission folder that follows this page).
2. Review the data.
3. After reviewing the examples in our textbook, construct three SQL documents in a Word document to satisfy the following conditions:
4. Write a query in SQL to display the first and last name and salary for those employees who earn below 6000.
5. Write a query in SQL to display the first and last name and salary for all employees who do not earn any commission.
6. Write a query in SQL to display the last name and phone number of employees who were hired before January 1, 2007.
7. Save your work and submit the document to assignment submission folder in this module.

 Exp19_Excel_Ch11_Cap_Donors

Project Description:

You are a development officer for a state university. As an officer, you manage a portfolio of important donors who contribute financially to different areas within the university. You categorize the donors based on the college or school for which they want their donations associated. You recently downloaded the portfolio to an Excel workbook. Based on the way the data downloads from the main database, you want to format the text for readability and to make it easier for you to analyze. In addition, you will create an advanced filter to review a list of donors for a particular college or school. Finally, you want to create a look up area to look up data for a specific donor and create a summary section.

1

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

2

The first column displays the   name of the college or school (such as ART   or BUSINESS) associated with each.   You want to assign a three-character code for each college and use that code   to attach to existing donor IDs to create a unique field.
 

  In cell B8, insert the LEFT function to extract the first three characters   from the college name in cell A8. Copy the function to the range B9:B35.

3

You now want to combine the   college ID and donor ID.
 

  In cell D8, insert the CONCAT function to combine the college ID in cell B8   with the donor ID in cell C8 with a hyphen between the two text strings. Copy   the function to the range D9:D35.

4

In cell J8, insert a text   function that displays the college name from cell A8 with just the first   letter capitalized, such as Engineering.   Copy the function to the range J9:J35.

5

The Full Name column displays   last and first names of the donors. You want to display last names only in a   separate column.
 

  In cell F8, type Schneider and use Flash Fill to fill in the last names for   the donors in the range F9:F35.

6

The Address column contains   street addresses, city names, and state abbreviations. To manage the address   list better, you will separate the data into three columns.
 

  Select the addresses in the range G8:G35 and convert the text to columns,   separating the data at commas .

7

The top-left section of the   spreadsheet is designed to be able to enter a donor’s ID, such as ENG-15, and   look up that person’s position in the list, display the donor’s full name, and   display the amount donated this year. The first step is to identify the   position number of the donor ID.
 

  In cell B3, insert the MATCH function to look up the donor ID in cell B2,   compare it to the list in the range D8:D35, and then return the donor’s position   within the list.

8

Now you are ready to use the   position number as an argument within the INDEX function.
 

  In cell B4, insert an INDEX function that uses the range D8:K35, looks up the   row position number from the MATCH function result, and then uses the column   position number for Full Name.

9

In cell B5, insert an INDEX   function that uses the range D8:K35, looks up the row position number
  from the MATCH function result, and then uses the column position number for   Donation.

10

You want to format the results   of the INDEX function.
 

  Format the value in cell B5 as Accounting Number Format with zero decimal   places.

11

To analyze the donor records,   you are ready to create criteria and output ranges. You will enter conditions   to find records for donors to the College of Business who donated $1,000 or   more.
 

  Copy the range A7:K7 to cell A38 to create the column labels for the criteria   range. Type Business in cell J39 and >=1000 in cell K39.

12

You are ready to create the   output area and perform the advanced filter.
 

  Copy the column labels to cell A42. Perform the advanced filter by copying   the records to
  the output area.

13

Now that you created a copy of   the records meeting the conditions, you are ready to enter database functions   in the Summary area.
 

  In cell K2, insert the database function to total the value of the donations   for the records that meet the conditions in the criteria range.

14

In cell K3, insert the database   function to calculate the average donation for the records that meet the   conditions in the criteria range.

15

In cell K4, insert the database   function to count the number of records that meet the conditions in the   criteria range.

16

Format the range K2:K3 with   Accounting Number Format with zero decimal places. Format cell K4 with Comma   Style with zero decimal places.

17

You want to use the FORMULATEXT   function to display the functions.
 

  In cell G2, insert the FORMULATEXT function to display the formula stored in   cell B3.
  In cell G3, insert the FORMULATEXT function to display the formula stored in   cell B4.
  In cell G4, insert the FORMULATEXT function to display the formula stored in   cell D8.
  In cell G5, insert the FORMULATEXT function to display the formula stored in   cell K2.

18

Create 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.

Read the attached case study  on STARBUCKS and answer the case study questions.

Writing Requirements

• 2 -3 pages in length  (excluding the cover page, abstract, and reference list)

• Lab THREE – 01Problem Statement:
  • 4.3.1.6 LAB: A leap year: writing your own functions
  • ================================================================================================Submit your Python solution through Blackboard (as explained below).
    Your lab will be graded on whether it’s been set up as a complete and workable solution.

    For your solution to be complete, your program must be able to

  • Set up code to do the following:
    • prompt the user for the input data asked for (as explained above within the Input Data section)
    • Set up the processing section, using a loop
    • Display output
  • compile (ie, no syntax error(s))
  • run (ie, no run-time error(s))
  • For your solution to be workable,
  • Your solution should be free of any type of errors (syntax, run-time, logic)
  • you may want to develop an algorithm first, using pseudocode
  • you do NOT need to turn in any algorithm
  • ==========================================================================================================================Grading rubric:
    • You’ll receive full credit, if 
      • your program
        • compiles and runs with no problems 
        • produces the expected output
    • You’ll receive partial credit, if 
      • your program
        • compiles and runs with no problems 
        • produces partial output (that is, incomplete output)
  • You’ll receive 25% of the points, if your program will not compile
  • You’ll receive 30% of the points, if your program compiles but has a run-time problem
  • You’ll receive 40% of the points, if your program produces logic error(s) 2021.==========================================================================================================================What to submit:
    • Your Python solution as a text file
    • A screenshot of a run of your program, showing the output
  • How to submit:
  1. Save your Python program (Lab THREE – 01) as a text file to your computer
  2. Save a screenshot of a run of your program, showing the output
  3. Click on the above link: Lab THREE – 01
  4. Locate your Python program (Lab THREE – 01 file) on your computer
  5. Locate your screenshot of the run of your program
  6. upload (that is, attach) BOTH files, under #4 and #5, to Blackboard
  7. Click on SUBMIT
  8. NOTE: You can make your submission just ONCE.  So, before making your submission, ensure that it does not need any additional editing/revisions.=====================================================================================================
• Lab THREE – 02Problem Statement:
  • 4.3.1.7 LAB: How many days: writing and using your own functions
  • ================================================================================================Submit your Python solution through Blackboard (as explained below).
    Your lab will be graded on whether it’s been set up as a complete and workable solution.

    For your solution to be complete, your program must be able to

  • Set up code to do the following:
    • prompt the user for the input data asked for (as explained above within the Input Data section)
    • Set up the processing section, using a loop
    • Display output
  • compile (ie, no syntax error(s))
  • run (ie, no run-time error(s))
  • For your solution to be workable,
  • Your solution should be free of any type of errors (syntax, run-time, logic)
  • you may want to develop an algorithm first, using pseudocode
  • you do NOT need to turn in any algorithm
  • ==========================================================================================================================Grading rubric:
    • You’ll receive full credit, if 
      • your program
        • compiles and runs with no problems 
        • produces the expected output
    • You’ll receive partial credit, if 
      • your program
        • compiles and runs with no problems 
        • produces partial output (that is, incomplete output)
  • You’ll receive 25% of the points, if your program will not compile
  • You’ll receive 30% of the points, if your program compiles but has a run-time problem
  • You’ll receive 40% of the points, if your program produces logic error(s)
  • 2021.==========================================================================================================================What to submit:
    • Your Python solution as a text file
    • A screenshot of a run of your program, showing the output
  • How to submit:
  1. Save your Python program (Lab THREE – 02) as a text file to your computer
  2. Save a screenshot of a run of your program, showing the output
  3. Click on the above link: Lab THREE – 02
  4. Locate your Python program (Lab THREE – 02 file) on your computer
  5. Locate your screenshot of the run of your program
  6. upload (that is, attach) BOTH files, under #4 and #5, to Blackboard
  7. Click on SUBMIT
  8. NOTE: You can make your submission just ONCE.  So, before making your submission, ensure that it does not need any additional editing/revisions.=====================================================================================================
• Lab THREE – 03Problem Statement:
  • 4.3.1.8 LAB: Day of the year: writing and using your own functions
  • ================================================================================================Submit your Python solution through Blackboard (as explained below).
    Your lab will be graded on whether it’s been set up as a complete and workable solution.

    For your solution to be complete, your program must be able to

  • Set up code to do the following:
    • prompt the user for the input data asked for (as explained above within the Input Data section)
    • Set up the processing section, using a loop
    • Display output
  • compile (ie, no syntax error(s))
  • run (ie, no run-time error(s))
  • For your solution to be workable,
  • Your solution should be free of any type of errors (syntax, run-time, logic)
  • you may want to develop an algorithm first, using pseudocode
  • you do NOT need to turn in any algorithm
  • ==========================================================================================================================Grading rubric:
    • You’ll receive full credit, if 
      • your program
        • compiles and runs with no problems 
        • produces the expected output
    • You’ll receive partial credit, if 
      • your program
        • compiles and runs with no problems 
        • produces partial output (that is, incomplete output)
  • You’ll receive 25% of the points, if your program will not compile
  • You’ll receive 30% of the points, if your program compiles but has a run-time problem
  • You’ll receive 40% of the points, if your program produces logic error(s)2021.==========================================================================================================================What to submit:
    • Your Python solution as a text file
    • A screenshot of a run of your program, showing the output
  • How to submit:
  1. Save your Python program (Lab THREE – 03) as a text file to your computer
  2. Save a screenshot of a run of your program, showing the output
  3. Click on the above link: Lab THREE – 03
  4. Locate your Python program (Lab THREE – 03 file) on your computer
  5. Locate your screenshot of the run of your program
  6. upload (that is, attach) BOTH files, under #4 and #5, to Blackboard