8 HOURS DELIVERY: PLAGIARISM FREE AND QUALITY WORK GUARANTEED.

Examine this week’s pcap files using Wireshark or any other tool from your foren

Examine this week’s pcap files using Wireshark or any other tool from your forensic workstation.
For pcaps 1-3:
1. Describe what types of activity are present in the capture. Be sure to assess the entire capture, not just a few packets! Hint: “Follow TCP Stream” can be very useful for some of these.
2. For each behavior you observe, report if you think the activity is normal, suspicious, or malicious.
3. Provide justification for your determinations, including annotated evidence and narrative analysis. Be sure to cite any references you use!
For pcap 7:
Obtain the username and password to understand why it is important to use encryption for sensitive traffic traversing the network. Explain how you (or the tool you used) did it (i.e. relying on Network Miner to show you the answer is not sufficient!). Hint: You may find this resource helpful: https://en.wikipedia.org/wiki/Basic_access_authentication

Project Scenario You have just been hired as an office manager for a local busin

Project
Scenario
You have just been hired as an office manager for a local business. You notice the company collects order information in Excel and you realize this information can be helpful in informing business decisions if it was sorted and had conditional formatting applied so valuable information stands out more easily.
Requirements
Orders Sheet
Create a column called “New City” and use a formula that references the data in the “City” column. Your formula should replace all instances of “Los Angeles” with the city where you currently reside as it is copied down (using the Auto Fill feature), leave all other cities as currently stated.
Replace the customer named “Brosina Hoffman” with your name.
Order Date – This column shows the date when the order was created. This column needs to number formatting to show up as a short date (e.g. M/D/YY).
Ship Date – This column shows the date when the order was created.
Ship Mode – This column shows how the order was shipped (FedEx, UPS, or USPS).
Customer Name – Use conditional formatting to highlight in gold the customers’ names (column D in the original worksheet) where their total sales rank in the top 20 (meaning the customer who spent the most is ranked number 1).
City, State, and Region – Sort the spreadsheet by region (ascending), then by state (ascending), and then by city (ascending).
Category – Use conditional formatting to highlight the entire row with a color of your choice if the category is “Technology”. Please be careful where the “$” goes in the conditional formatting custom formula.
Retail price per unit – This column needs to be formatted as currency.
Quantity sold – Add a green checkmark (conditional formatting icon set) for every customer that ordered five or more items.
Discount percent – This column needs to be formatted as a percentage. It is the percentage by which the retail price is discounted. For example, if the retail price is $10 and there is a 40% discount the customer would only pay $6.
Total Sales – Calculate the total sales for each order. Remember to factor in the quantity sold and discount percent in your formula. Use conditional formatting to highlight in gold the top 10% of cells in the total sales column.
Order Number – Create an additional column called “New Order Number” that uses a formula to add a region code at the front of each order number. The region codes for: East = 101.  South= 201. Central = 301.  West = 401. For example, the order number, “496-1850” from Central would look like “301-496-1850”. The region codes might change so set them up as input cells that can be altered in the future. Consider using named ranges.
Dashboard
Create a dashboard sheet that allows you to look up a customer name (on a drop down list) and see their order information (Output cells are: Order Date, Ship Date, Ship Mode, New City, State, Region, Category, Sales, Quantity, Discount, Total Sales, and New Order Number).
Protect the dashboard sheet so that the customer name is the only cell that users may select and edit. (Hint: Make sure to test that the protection prevents other edits and that a new name can be selected before turning it in.)
Insights Sheet
Create a new worksheet and label it “Insights.”
On the sheet, write down two insights that you can find in the data. You can ask yourself “What might be important for management to know?”. One example that you may not use would be: “The category that has the most sales dollars is _______”.
Follow the standards of professionalism Download standards of professionalism  to clean up the workbook and make it look sharp. On ALL sheets check that values are formatted correctly. Ensure all columns are wide enough to see their information clearly. 
Criteria Ratings Pts
This criterion is linked to a Learning Outcome Change some data – Create a column called “New City” and use a formula that references the data in the “City” column. All Los Angeles references are changed to city student is living in, Brosina Hoffman changed to the student’s name.
0.5 pts
Exemplary
Create a column called “New City” and use a formula that references the data in the “City” column. All Los Angeles references were changed to city the student is living in, Brosina Hoffman was changed to the student’s name.
0.37 pts
Proficient
Not all Los Angeles were changed to city the student is living in within the new column. Brosina Hoffman was changed to the student’s name.
0.25 pts
Developing
Either the Los Angeles references were not changed to city the student is living in within the new columnor Brosina Hoffman was not changed to the student’s name.
0.13 pts
Needs Improvement
Another city name was changed and another customer name was changed to the student’s name.
0 pts
No Marks
The city name was not changed and Brosina Hoffman was not changed to the student’s name.
0.5 pts
This criterion is linked to a Learning Outcome Total Sales – Ensure quantity and discount is used.
0.5 pts
Exemplary
Total sales have been calculated correctly, applying a discount. Cells have been referenced no typed in data. Formula example =(I2*J2)*(1-K2).
0.37 pts
Proficient
Total sales have been calculated using a different formula. Discount cell not referenced.
0.25 pts
Developing
Total sales calculation has the discount subtracted as a number, not as a percent.
0.13 pts
Needs Improvement
Total sales not calculated with a discount. Cells not all filled in.
0 pts
No Marks
0.5 pts
This criterion is linked to a Learning Outcome Sort – By Region (ascending), then by state (ascending) and then by city (ascending).
1 pts
Exemplary
On the orders sheet data has been sorted correctly in ascending order (by region, state then city).
0.75 pts
Proficient
Data has been sorted by region, state, and then by the city on the orders sheet. But was done in descending order.
0.5 pts
Developing
Data was not sorted in the right order or missing 1 or 2 areas was not sorted.
0.25 pts
Needs Improvement
Data on the orders sheet has been filtered not sorted.
0 pts
No Marks
1 pts
This criterion is linked to a Learning Outcome Conditional formatting – Highlight in gold the top 10% of total sales.
1 pts
Exemplary
Cells (Customer and Total Sales) with the top 10% of total sales, highlighted in gold.
0.75 pts
Proficient
Top 10% highlighted in the wrong color.
0.5 pts
Developing
Wrong conditions, other than the top 10% were highlighted.
0.25 pts
Needs Improvement
Cells highlighted – not with conditional formatting.
0 pts
No Marks
1 pts
This criterion is linked to a Learning Outcome Conditional formatting – For those that ordered 5 or more items include a green checkmark.
1 pts
Exemplary
Those with 5 or more ordered items have a green checkmark.
0.75 pts
Proficient
Those who ordered 5 or more items have a checkmark but the wrong color.
0.5 pts
Developing
Those who ordered less than 5 items have a checkmark.
0.25 pts
Needs Improvement
Wrong icons or just highlighted
0 pts
No Marks
1 pts
This criterion is linked to a Learning Outcome Conditional formatting – Highlight entire row if “Technology.”
0.5 pts
Exemplary
Each row of technology has been completely highlighted using conditional formatting.
0.37 pts
Proficient
Only partial rows or not complete rows of technology have been highlighted using conditional formatting.
0.25 pts
Developing
Only the word technology has been highlighted using conditional formatting.
0.13 pts
Needs Improvement
Only the word technology was highlighted, not using conditional formatting.
0 pts
No Marks
0.5 pts
This criterion is linked to a Learning Outcome Dashboard – Allows management to select customer name (Input Cell).
0.5 pts
Exemplary
The dashboard is interactive. The customer’s name put into the input cell with a drop-down list, duplicates removed.
0.37 pts
Proficient
The dashboard is interactive. The customer’s name put into the input cell with a drop-down list.
0.25 pts
Developing
The dashboard is interactive. The customer’s name put into the input cell with a drop-down list, duplicates are present.
0.13 pts
Needs Improvement
The customer cell is not put in as an input cell. Customers name is not a drop-down list, duplicates are present.
0 pts
No Marks
The dashboard does not list customers
0.5 pts
This criterion is linked to a Learning Outcome Dashboard -See order information (Output Cells)
2 pts
Exemplary
Output cells show order information (both shipping and order details) Lookup function used and references input cell. No errors.
1.5 pts
Proficient
Output cells doesn’t show all order information (both shipping and order details) Lookup function used and references input cell. There may be errors.
1 pts
Developing
Output cells are missing a few order or sales information. The lookup function does not reference the input cell and shows multiple errors.
0.5 pts
Needs Improvement
Output cells are missing more than half of the sales and order information. A cell may be blank or have typed in data. The dashboard is not interactive.
0 pts
No Marks
The dashboard does not list order and sales information.
2 pts
This criterion is linked to a Learning Outcome Protected Dashboard.
1 pts
Exemplary
Dashboard sheet has been protected, without a password. In the Protect Sheet option, only “Select unlocked cells” is checked.
0.75 pts
Proficient
Dashboard sheet has been protected, with a password OR in the Protect Sheet option, more than “Select unlocked cells” is checked.
0.5 pts
Developing
All the cells are protected and none are unlocked.
0.25 pts
Needs Improvement
The wrong sheet was protected
0 pts
No Marks
Dashboard has not been protected.
1 pts
This criterion is linked to a Learning Outcome Create a new worksheet and label it as “Insights.” Create two insights that would be important for management to know.
1 pts
Exemplary
Created a new worksheet and labeled it as “Insights.” Created two insights that would be important for management to know.
0.75 pts
Proficient
.
0.5 pts
Developing
Created one insight that would be important for management to know OR didn’t create a new worksheet and labeled it as “Insights.”
0.25 pts
Needs Improvement
0 pts
No Marks
No insights were created.
1 pts
This criterion is linked to a Learning Outcome Standards of professionalism- Removed the gridlines
0.34 pts
Exemplary
Gridlines were removed from the dashboard
0 pts
No Marks
The gridlines were not removed.
0.34 pts
This criterion is linked to a Learning Outcome Standards of professionalism- Clearly labeled Input and output cells (distinct and use color)
0.33 pts
Exemplary
Clearly labeled Input and output cells (distinct and use color)
0 pts
No Marks
Input and output cells were not distinct or no color used
0.33 pts
This criterion is linked to a Learning Outcome Standards of professionalism- Move the “Dashboard” to the first worksheet tab of the workbook
0.33 pts
Exemplary
Moved the “Dashboard” to the first worksheet tab of the workbook
0 pts
No Marks
The “Dashboard” was not moved to the first worksheet tab of the workbook
0.33 pts
Total Points: 10