Final Report

I have already prepared the document all you have do is contents and check whether it is in IEEE format (one column) or not 

paraphrase 240 words

  

In the Unit 2 Lab assignment, we continued to learn how to analyze wireless traffic using Wireshark and also began learning how to analyze wireless traffic using the NetWitness Investigator Tool. I began with practicing loading a file of traffic that Wireshark had previously captured. We reviewed previously captured ones so that all students were were following the same instructions. There is so much information to look at it can be a bit overwhelming. I am still finding that I have trouble using the Wireshark application, even after thoroughly following instructions. The introduction to the NetWitness Investigator Tool seemed a bit easier to follow. I was capturing the same packet information that I viewed in the first step when using WireShark. There was obviously a little trial and error involved, but I feel a little better about using this tool than WireShark. It appears to be a little more user friendly, but that could be because it isn’t all information overload on the menu. It appears to be displayed a littler easier to read. I still feel a little lost when it comes to most of the information that I am trying to find. This information is important to the cybersecurity field because it can provide important information to where a criminal hacker may be located or what it is exactly they are trying to achieve. It more or less shines a little light into the dark spaces of the internet.

Exp19_Access_Ch03_ML1 – Small Business Loans 1.0

 

Exp19_Access_Ch03_ML1 – Small Business Loans 1.0

 

Exp19_Access_Ch03_ML1 – Small Business Loans 1.0

You are the manager of a regional  business loan department for the U.S. Small Business Administration  office. You have decided to evaluate whether Access could be used in  place of the Excel worksheet you are currently using. You will create a  table, add some sample customers, and import some recent data from an  Excel spreadsheet. You will calculate the payments for the loans that  are currently on the books by creating a query using the Pmt function.  You will also summarize each loan by the type of loan (M=Mortgage,  C=Car, and O=Other).

In   Design view, create a new table. Add the first field named CustomerID with   AutoNumber Data Type. Add Company as the second field name, and FirstName as   the third field name. Accept the default data types.
 

  Save the Table with name as Customers. Click Yes, when prompted for defining Primary   Key.

Add the following fields to the   Customers table (in this order), accepting the default data type of Short   Text:
 

LastName
   City
   State
   Zip
 

  Verify that CustomerID is the primary field.

Save the table and switch to   Datasheet view. Add the following records to the table:
 

Company FirstName LastName City State Zip
Jones   and Co Robert Paterson Greensboro NC 27401
   Elements, Inc. Merve Kana Paterson NJ 07505
   Godshall Meats, LLC Francisco De La Cruz Beverly Hills CA 90210

Import the spreadsheet using the   downloaded Excel file a03_h2_Loans.xlsx   into a new table. Choose LoanID as the primary key and accept all other   defaults in the Import Wizard.

Open the Loans table in Design   view. Change the InterestRate field format to
   Percent. Change the field size for the CustomerID field to Long  Integer. Save   and close the table. Click Yes when prompted that some  data may be lost. 

Create a relationship between   the CustomerID fields in the  Customers and Loans tables. Enforce referential   integrity. Save and  close the Relationships window.

Create a query using the two   tables that will calculate the payment  amount for each loan. Add the   following fields: Company, LoanID,  Amount, InterestRate, Term, and LoanClass,   in that order. Sort the  query by LoanID in ascending order. Save the query as   Loan   Payments.

Use the Expression Builder to   add a calculated field named Payment  in the first blank column to   calculate the loan payment for each loan  using the Pmt function. Insert the   appropriate field names in place  of the placeholder arguments. Assume the   loans have monthly payments  (12 payments per year). Ensure the payment   displays as a positive  number. Run the query.

Switch to Design view and change   the format for the Payment  calculated field to Currency. Run the query again   to verify your  change.

In Datasheet view, add a Totals   row. Use it to calculate the sum of  the Amount column, the average   InterestRate, and the average Term.  Save and close the query.

Create a copy of Loan Payments.   Save the new query as Loan Payments Summary. Open the Loan Payments Summary   query in Design view and rearrange the columns as follows:
   LoanClass, LoanID, Amount, and InterestRate. Delete columns Company, Term,   and Payment.

Group the Loan Payments Summary   query by the LoanClass field.  Display the number of loans in the LoanID   column, the sum in the  Amount column, and the average in the InterestRate   column. Run the  query.

Switch to Design view and   display the Property Sheet. For the LoanID field, change the caption to Loans. For the Amount field, change   the caption to Total Amount and change the format to   Currency. For the InterestRate field, change the caption to Avg Interest   Rate and change the format to Percent. Run the query.   Save and close the query.

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

Research Paper

Find a peer-reviewed scholarly journal article discussing blockchain technology. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing. You should use the UC library (https://www.ucumberlands.edu/library) and/or Google Scholar to find these types of articles (https://scholar.google.com/ )Once you find the article, you will read it and write a review of it.  This is considered a research article review.Your paper should meet these requirements: 

  • Be approximately three to four pages in length, not including the required cover page and reference page.
  • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Lab 11

  

Weekly Learning and Reflection 

In two to three paragraphs (i.e., sentences, not bullet lists) using APA style citations if needed, summarize, and interact with the content covered in this lab. Summarize what you did as an attacker, what kind of vulnerabilities did you exploit, what might have prevented these attacks. Mention the attackers and all of the targets in your summary. You can provide topologies, sketches, graphics if you want. In particular, highlight what surprised, enlightened, or otherwise engaged you. You should think and write critically, not just about what was presented but also what you have learned through the session. You can ask questions for the things you’re confused about. Questions asked here will be summarized and answered anonymously in the next class.

Module 05 Content

 

  1. You now have the appropriate elements needed for the development of a rough draft for the executive leadership of MedicalWise. Please refer back to the course project introduction and other research performed to complete this assignment. This week you will submit your final submission so in addition to the new elements this week, you will also include all previous course project work including any recommended changes by your instructor.

    For this assignment, you will add to your project the inclusion of a certificate-based authentication for returning customers to MedicalWise. Indicate what type of certification will be used and which CA provider you have chosen. Explain why you chose a specific CA provider.

    The second element to add to this assignment is an assessment of the appropriate KPIs (Key Performance Indicators) that would provide the customer with peace of mind that the security and traffic analysis tools the company uses are maintaining the level of security.

    Assignment Details
    Your submission should include the following elements:

    • A background of the organization.
    • A discussion on how the incentive program is predicted to increase sales and marketing.
    • Include Module 02 – Module 04 course project, including any recommended changes by your instructor.
    • A description of how CloudPath works including at least one hacking method this prevents.
    • Recommended KPIs to ensure that the security and traffic analysis tools the company uses are maintaining the level of security.
    • Include at least three cited sources
    • Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.

      Save your assignment as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Cyber Security

6-8 page PPT on Cybersecurity in Networking (must include Introduction, Importance, Cybersecurity objectives, conclusion, and reference section)

Include at least one figure or one table in the presentation and format in APA style, Highlight your knowledge of technology by including some transition and some animation

Follow the 7×7 rule:  No more than 7 bullets per slide, and no more than 7 words per bullet. (Any further explanation needs to be put in the Notes Pane)

4 Scholarly References 

Exp19_Access_Ch08_Cap – Performance 1.0

Exp19_Access_Ch08_Cap – Performance 1.0

Exp19_Access_Ch08_Cap – Performance 1.0

Access Chapter 8 Capstone – Performance 

EX19_AC_CH08_GRADER_CAP_AS

  

Project Description:

You have been asked to modify an Employees database that tracks employee data, company locations, and performance and bonus information.You will import a spreadsheet from Excel and a text file into the database.You will add a Hyperlink field that will store a URL for each city where the company has a location.You will also add an Attachment field that will store employee photos.You will then use imported data to enhance a query in the database, create a report, and then export it to a PDF document.

     

Start   Access. Open the downloaded Access file named Exp19_Access_Ch8_Cap_Performance.accdb. Grader has automatically   added your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

 

Create   a new table in the database by importing the downloaded workbook named a08c2Location.xlsx. Use the first row   of the worksheet as column headings, set LocationID as the primary key, and   import the table as Location.   Accept all other default options. Do not save the import steps.

 

Create   a table in the database by importing the downloaded text file named a08c2Titles.txt. Use the first row of   the file as field names, TitleID as the primary key, and name the table Titles. Accept all other default options. Do   not save the import steps.

 

In   the Employees table, add an Attachment field named Photo as the last field. Save the table.

 

Add   the downloaded image file KFleming.jpg   for EmployeeID 3 to the Employees table.

 

Add   the downloaded image file PBrumbaugh.jpg   for EmployeeID 17 to the table. Close the table.

 

In   the Location table, add a Hyperlink field named CityInfo   as the last field. Save the table.

 

Add   the URL http://en.wikipedia.org/wiki/Atlanta   as the CityInfo value for Atlanta in the Location table.

 

Add   the URL http://en.wikipedia.org/wiki/Pittsburgh as   the CityInfo value for Pittsburgh. Close the table.

 

Add   the Location and Titles tables to the Relationships window. Join Location and   Employees by their common field, enforcing referential integrity. Join Titles   and Employees by their common field, enforcing referential integrity.

 

Open   the Performance query in Design view (right-click the query in the Navigation   Pane, and select Design View). Add the newly imported Titles table to the   query window. Drag and drop the Title field from the Titles table over the   Performance field in the query design grid so that it is placed to the left   of the Performance field. The query calculates raises for the employees based   on data in the Titles table.

 

Add   the Photo field from the Employees table to the last position in the query.   Run the query.

 

Set   the criteria in the query so that only employees on probation will display   and then run the query. Note that these employees will receive no bonus.   Modify the criteria to display employees who are not on probation. Employees   whose performance is good or excellent will receive a bonus. Run, save, and   then close the query.

 

Create   a simple report based on the Performance query. In Layout view, delete the   Probation and PercentIncrease fields. Adjust the column widths so that they   all fit within the page, but the data is still visible.

 

In   Design view, move the page numbering control to the left so that its right   edge is just inside the 7.5-inch mark on the horizontal ruler. Drag the right   edge of the report to the left so that it is just inside the 8-inch mark on   the ruler. View the report in Print Preview; the report should consist of two   pages.

 

Modify   the report title as Performance Reviews   and delete the logo to the left of the title.

 

Save   the report as Employees in Good   Standing   and close the report. Export the report as a PDF document using the same name   and publish the report. Open the report in your reader program and close the   report. Do not save the export steps.

 

Open   the Performance query in Design view. Add the newly imported Location table   to the query window. Drag and drop the Location field from the Location table   over the LastName field in the query design grid so that it is in the first   field position. Sort the records by Location in ascending order. Run, save,   and then close the query.

 

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.