Peters Company Assignment help

/in , /by

Peters Company Assignment Help

The case study below offers an excellent perspective on how projects are often initiated under less than ideal circumstances—which often lays the ground work for project failure.

Companies that provide a service for another company usually respond to a bid document from a company that needs help.  This case study is a good example of this situation.  The bid document can be as simple as an email from the buyer to the seller or as complicated as a request for proposal (RFP) outlining the objectives of the project and asking a seller to develop a proposal that provides a solution.

Each company (seller and buyer) will have a business case for doing the project. The Peter’s Company is outsourcing for a reason.  The Corwin Corporation is taking on the project for a different set of reasons.  One of the reasons the Corwin Corporation is taking on the work is the looming, potentially very lucrative production contract if they are successful.  There are no guarantees in research and development project that there will be success.

Part 1 (20 points)–Prepare a requirements management plan (RMP) that addresses the five components described in Section 5.1.3.2, PMBOK 6e.  The plan should be at least 3 but not exceed 4 pages and does not need to conform to APA guidelines (except for citing and referencing sources).

Some things to think about – how is the role of the in-house rep dealt with in the RMP as it relates to activities for planning, tracking and reporting requirements?   Configuration management is not just about software and versioning.  What processes will be used for configuration management activities as they relate to changes in the product requirements?  How and who will authorize/approve changes?   The traceability structure should be tailored to the type of project and should ensure that each requirement adds business value.

Part 5 (15 points)– Create Scope Validation Process.  Using the cast of characters from the case study (and any additional people needed), prepare a process for validating the work packages and higher-level components of the WBS.   For each part of the process flow diagram, explain in a separate page who from the case study is involved and what is to be done.

 

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Executive Program Practical Connection Assignment

/in , /by

Executive Program Practical Connection Assignment

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course(please refer attached document for Course content) have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.

Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

Share a personal connection that identifies specific knowledge and theories from this course.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.

You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Python Challenge 1 homework help

/in , /by

Python Challenge 1 homework help

In this challenge, you are tasked with creating a Python script for analyzing the financial records of your company. You will give a set of financial data called budget_data.csv. The dataset is composed of two columns: Date and Profit/Losses. (Thankfully, your company has rather lax standards for accounting so the records are simple.)
Your task is to create a Python script that analyzes the records to calculate each of the following:
The total number of months included in the dataset
The net total amount of “Profit/Losses” over the entire period
The average of the changes in “Profit/Losses” over the entire period
The greatest increase in profits (date and amount) over the entire period
The greatest decrease in losses (date and amount) over the entire period
As an example, your analysis should look similar to the one below:
Financial Analysis
—————————-
Total Months: 86
Total: $38382578
Average Change: $-2315.12
Greatest Increase in Profits: Feb-2012 ($1926159)
Greatest Decrease in Profits: Sep-2013 ($-2196167)

In addition, your final script should both print the analysis to the terminal and export a text file with the results.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Solved Word_Intro_Cap1_National_Sales_Meeting Assignment Help

/in , /by

Solved Word_Intro_Cap1_National_Sales_Meeting Assignment Help

Solved Word_Intro_Cap1_National_Sales_Meeting

Project Description:

In this project, you will apply skills you practiced from the Objectives in Word Chapters 1-3. You will assist Irene Shviktar, the Vice President of Marketing, to edit and create documents for a National Sales Meeting that will precede a Winter Sports Expo sponsored by Front Range Action Sports. The documents include a cover letter from the vice president to the company president. The letter will accompany a packet of materials for the meeting and the expo, which includes a brief resume for the guest speaker, a flyer that will announce the expo, a newsletter for employees, and a research paper on the history and development of skis.

1

Open the Word document Student_Word_Cap1_National_Sales_Meeting.docx downloaded with this Project. Be sure that the rulers and formatting marks display.

2

On the letter on Page 1, select the first paragraph—Front Range Action Sports—and increase the Font Size to 28 pt. Change the Font Size of the next four paragraphs—the address lines and website—to 12 pt.

3

Select the first five paragraph lines that you just formatted, change the Font to Arial, and then with the text selected, display the Borders and Shading dialog box. Create a 6 pt, Automatic-colored border on the left side of the selected text.

In the paragraph that begins If you have any, select the second sentence and move it to the beginning of the paragraph. Adjust spacing as necessary so that there are no extra blank spaces at the end of the paragraph.

4

On Page 2, in the newsletter, select the second paragraph of text, which begins with Employee Newsletter. Display the Borders and Shading dialog box, and then add an Automatic-colored, 3 pt line below the paragraph.

5

Starting with the paragraph that begins National Sales Meeting, select all of the text from that point to the end of the page, including the paragraph mark after the word event. Do not select the Page Break. Change the Spacing After to 6 pt, format the text in two columns, and apply the Justify alignment.

6

At the top of the first column, select the paragraph National Sales Meeting. From the Font dialog box, change the Font Size to 20, apply Bold, and add the Small caps effect. Then Center the paragraph. Apply the same formatting to the paragraph Winter Sports Expo.

7

On the same page, in the blank line above the last paragraph of the newsletter, insert the picture from your downloaded files wCap1_Powder_Skiing.jpg. If necessary, set the Width of the picture to 3″ and apply a 10 pt Soft Edges effect.

8

In the blank paragraph at the top of Page 3, insert a 2×3 table. In the first cell of the table, type the following four lines, pressing ENTER after each line:

Robert Lewis
1227 Aspen Lake Trail
Vail, CO 81657
www.boblewisskis.com

9

In the second row of the table, in the first cell, type CAREER HIGHLIGHTS and then press TAB. In the second cell of the second row, insert the text from the downloaded file wCap1_Career_Text.docx and then press BACKSPACE to remove the blank line at the bottom of the inserted text.

10

In the third row of the table, in the first cell, type EDUCATION and then in the cell to the right, type Mr. Lewis’ educational information as follows, pressing ENTER after each line:
University of Colorado
Ph.D. in Psychology
University of Colorado
M.S. in Psychology
University of Minnesota
B.S. in Psychology

11

Insert a new row at the bottom of the table. In the first cell of the new row, type CONSULTANT and then in the cell to the right, type the following, pressing ENTER after each line:
U.S. Junior Ski Team
U.S. National Ski Team
Special Olympics

12

Apply Bold to the headings CAREER HIGHLIGHTS, EDUCATION, and CONSULTANT. Drag the vertical border between the two columns to the 1.5-inch mark on the horizontal ruler.

13

In the first row, merge the two cells, and then Center the text. Select Robert Lewis, increase the Font Size to 24 pt, apply Bold, and then add 24 pt space Before the text. Select the web address and add 18 pt space after the text.

14

Create a bulleted list, using solid round black bullets, for the items below SKIING and below COACHING. Apply Bold to the name of each university, and then apply 12 pt spacing after to the name of each college degree.

15

Select the table, and then remove all borders. From the Borders and Shading dialog box, add a 3 pt solid border to the top of the table.

16

Near the top of Page 4, in the paragraph that begins The use of skis, in the third line, position the insertion point to the right of the period following wood, and then insert the following footnote: The oldest known ski and pole is more than 4,000 years old.

17

Modify the footnote style by changing the Font Size to 11 pt, add a First Line Indent of 0.5″, and set Line spacing to 2.0 (double).

18

In the paragraph that begins The use of skis, position the insertion point to the left of the period at the end of the paragraph. Using the MLA format, add the following Book citation:
Author: Huntford, Roland
Title: Two Planks and a Passion: The Dramatic History of Skiing
Year: 2008
City: New York
Publisher: Continuum Press

In the text, select the Huntford citation and add the page numbers 4-6

19

On Page 6, in the blank line below the Works Cited title, insert the built-in Bibliography. Select the two references, change the line spacing to 2.0 and change the Spacing After to 0 pt. Center the Bibliography title. After the bibliography is entered and formatted, delete the Works Cited paragraph.

20

On Page 7, select the two paragraphs below the title that begin Friday and Saturday, and then change the Spacing After to 0.

21

Select the three paragraphs below the title—the dates—and then from the Borders and Shading dialog box, apply a Box border using theme color Blue, Accent 1 (fifth column, first color) and a 3 pt border. Click the Shading tab, and add Shading using theme color Blue, Accent 1, Lighter 80% (fifth column, second color).

22

Click after the colon at the end of the line that precedes the bulleted list. Insert the downloaded picture wCap1_Downhill_Skiing.jpg. Change the Height of the picture to 3.5″, and then set the wrapping to Square.

23

Position the picture so that the Horizontal Alignment is set to Right relative to Column and the Vertical Alignment is set to Top relative to Line. Apply a Picture Style using the Soft Edge Rectangle.

24

At the bottom of the flyer, click in the second blank paragraph below the last paragraph of text. Insert a Basic Process SmartArt (first style under Process). Click the outer rectangle surrounding the SmartArt to select it, and if necessary, change the wrapping style to In Line with Text. On the Format tab, set the Height of the SmartArt graphic to 1″ and the Width to 6.5″. Add the following text, in order, to the three shapes:
Exhibits
Speakers
Workshops

To the SmartArt graphic, apply the 3-D Polished style.

25

Save and close the file, and then submit for grading.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Exp22_Excel_Ch02_HOE – Townsend Mortgage Company homework help

/in , /by

Exp22_Excel_Ch02_HOE – Townsend Mortgage Company homework help

Excel Chapter 2 Hands-On Exercise – Townsend Mortgage Company

Exp22_Excel_Ch02_HOE – Townsend Mortgage Company
Exp22 Excel Ch02 HOE – Townsend Mortgage Company

 

 

Project Description:
You are an assistant to Yui Matheson, a mortgage broker at the Townsend Mortgage Company. Yui spends days reviewing mortgage rates and trends, meeting with clients, and preparing paperwork. Yui relies on your expertise in using Excel to help analyze mortgage data. Today, Yui provided you with sample mortgage data: loan number, house cost, down payment, mortgage rate, and the length of the loan in years. She asked you to perform some basic calculations so that the output provided by her system can be checked to verify that it is calculating results correctly. You have also been tasked with calculating the amount financed, the periodic interest rate, the total number of payment periods, the percentage of the house cost financed, and the payoff year for each loan. In addition, you will calculate totals, averages, and other basic statistics. Furthermore, Yui asked you to complete another worksheet that uses functions to look up interest rates from a separate table, calculate the monthly payments, and determine how much (if any) the borrower will have to pay for private mortgage insurance (PMI).

 

 

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

 

You would like to create a formula to calculate the amount financed for each loan.

Enter a formula in cell D8 to calculate the amount financed for the first mortgage. Once completed, copy the formula down completing column D.

 

 

You would like to create a formula to calculate the monthly interest rate per period for each loan.

Enter in formula in cell F8 to calculate the monthly interest rate for the first loan. Add the appropriate absolute cell reference for cell B5 and then use the fill handle to copy the formula down completing column F.

 

You would like to calculate the total number of payment periods for each loan. To complete the task, you will use a mixed cell reference as an alternative to an absolute cell reference.

Enter a formula in cell H8 to calculate the total number of payment periods per loan. Use an appropriate mixed cell reference for cell B5 and then use the fill handle to copy the formula down completing column H.

 

You would like to calculate the total value of the homes being financed.

Use AutoSum in cell B16 to calculate the total value of all homes sold.

 

You would like to calculate the average value of all homes being purchased.

Use AutoSum in cell B17 to calculate the average value of all homes being purchased.

 

You would like to calculate the median value of all homes being purchased.

Enter a function in cell B18 to calculate the median value of all homes being financed.

 

You would like to display the cost of the least expensive home.

Enter a function in cell B19 to display the value of the least expensive home financed.

 

You would like to display the value of the most expensive home financed.

Enter a function in cell B20 to display the most expensive home financed.

 

You would like to determine the total number of homes financed.

Enter a function in cell B21 to count the total number of homes being financed based on the values column B.

 

To complete your calculations you will use the fill handle to copy the previously created functions.

Use the fill handle to copy the functions in the range B16:B21 through the range C16:D21.

 

You would like to test the functions you created by editing one of the values in the worksheet.

Edit the value in cell B9 to 425000. Note the results of the formulas are now updated.

 

It is a good practice to insert the date in a worksheet containing financial information. You will use the TODAY function to insert the current date in cell B4.

Use the TODAY function to insert the current date in cell B4.

 

You would like to use a lookup function on the Payment Info worksheet to determine the annual percentage rate (APR) of homes financed based on the lookup table in the range D4:E6.

Use the XLOOKUP function in cell G9 to determine the APR based on the years financed in cell F9, lookup array in the range D4:D6, and return array in the range E4:E6. Be sure to use the appropriate absolute cell referencing. Then use the fill handle to copy the function down completing column G.

 

Next you will calculate the total payment for each mortgage financed.

Use the PMT function in cell H9 to calculate the monthly payment based on the APR in cell G9, years financed in cell F9, and amount financed in cell D9. Ensure the final value is positive. Use the appropriate absolute cell references and then copy the function down completing the column.

 

For your last step you will determine the monthly personal mortgage insurance (PMI) if applicable. Since not all mortgages require PMI, you will use the IF function.

Enter an IF function in cell I9 to determine the monthly PMI if applicable. The mortgage requires PMI if the percent of down payment is less than 20% (cell B7). If the mortgage requires PMI it is .38% of the amount financed. Be sure to use the appropriate absolute cell references for the input values and then use the fill handle to copy the function down completing the column.

 

Save and close Exp22_Excel_Ch02_HOE_Loans.xlsx. Exit Excel. Submit the file as directed.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

/in , /by

Computer Science homework help

2

 

The Tip Left column in the Friday worksheet contains a fill color and number formatting. You want to fill these formats to the other daily worksheets.

Group the Friday through Monday worksheets, staring with the Friday worksheet. Fill the format only for the range E5:E24.

 

8

 

3

 

Now you want to insert column totals for the five worksheets simultaneously.

With the worksheets still grouped, insert SUM functions in the range B25:E25 and apply the Totals cell style. Ungroup the worksheets.

 

5

 

4

 

The Week worksheet is designed to be a summary sheet. You want to insert a hyperlink to the Total heading in the Monday worksheet.

On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to ensure it works correctly.

 

2

 

5

 

In cell A6 on the Week worksheet, insert a hyperlink to cell A25 in the Tuesday worksheet with the ScreenTip text Tuesday’s Totals. Test the hyperlink to ensure it works correctly.

 

2

 

6

 

In cell A7, insert a hyperlink to cell A25 in the Wednesday worksheet with the ScreenTip text Wednesday’s Totals. Test the hyperlink to ensure it works correctly.

 

2

 

7

 

In cell A8, insert a hyperlink to cell A25 in the Thursday worksheet with the ScreenTip text Thursday’s Totals. Test the hyperlink to ensure it works correctly.

 

2

 

8

 

In cell A9, insert a hyperlink to cell A25 in the Friday worksheet with the ScreenTip text Friday’s Totals. Test the hyperlink to ensure it works correctly.

 

2

 

9

 

Now, you are ready to insert references to cells in the individual worksheets. First, you will insert a reference to Monday’s Food Total.

In cell B5 on the Week worksheet, insert a formula with a 3-D reference to cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

 

2

 

10

 

The next formula will display the totals for Tuesday.

In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday worksheet. Copy the formula to the range C6:E6.

 

2

 

11

 

In cell B7, insert a formula with a 3-D reference to cell B25 in the Wednesday worksheet. Copy the formula to the range C7:E7.

 

2

 

12

 

In cell B8, insert a formula with a 3-D reference to cell B25 in the Thursday worksheet. Copy the formula to the range C8:E8.

 

2

 

13

 

In cell B9, insert a formula with a 3-D reference to cell B25 in the Friday worksheet. Copy the formula to the range C9:E9.

 

2

 

14

 

Now you want to use a function with a 3-D reference to calculate the totals.

In cell B10 on the Week worksheet, insert the SUM function with a 3-D reference to calculate the total Food purchases (cell B25) for the five days. Copy the function to the range C10:E10.

 

5

 

15

 

The servers are required to share a portion of their tips with the Beverage Worker and Assistants. The rates are stored in another file.

Open the Exp_Excel_Ch09_Cap_Assessment_Rates.xlsx workbook. Go back to the Exp_Excel_Ch09_Cap_Assessment_Tips.xlsx workbook. In cell F5 of the Week worksheet, insert a link to the Beverage Worker Tip Rate (cell C4 in the Rates workbook) and multiply the rate by the Monday Drinks (cell C5). Copy the formula to the range F6:F9.

 

5

 

16

 

Next, you will calculate the tips for the assistant.

In cell G5 in the Tips workbook, insert a link to the Assistant Tip Rate (cell C5 in the Rates workbook) and multiply the rate by the Monday Subtotal (cell D5). Copy the formula to the range G6:G9. Close the Rates workbook.

Note: The tip is a monetary value in the Week worksheet. It should be formatted for Accounting Number Format.

 

5

 

17

 

You noticed a circular error when you first opened the Tips workbook. Now you will find and correct it.

On the Week worksheet, check for errors and correct the formula with the circular reference.

 

5

 

18

 

You want to create a validation rule to prevent the user from accidentally entering a negative value. For now, you will create a validation in the Friday worksheet.

Select the range E5:E24 in the Friday worksheet, create a validation rule to allow a decimal value greater than or equal to zero. Enter the input message title Tip and the input message Enter the amount of tip. (including the period). Use the Stop alert with the error alert title Invalid Number and the error alert message The tip must be zero or more. (including the period). Test the data validation by attempting to enter -20 in cell E5 and then cancel the change.

 

10

 

19

 

Now you will copy the validation settings to the other daily worksheets.

Copy the range E5:E24 in the Friday worksheet. Group the Monday through Thursday worksheets, select the range E5:E24, and use Paste Special Validation to copy the validation settings.

 

10

 

20

 

You want to unlock data-entry cells so that the user can change the tips in the daily worksheets.

Group the Monday through Friday worksheets. Select the ranges E5:E24 and unlock these cells.

 

10

 

21

 

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

 

5

 

22

 

Now that you unlocked data-entry cells, you are ready to protect the worksheets to prevent users from changing data in other cells. Individually, protect each sheet using the default allowances without a password.

 

12

 

23

 

Mark the workbook as final.

Note: Mark as Final is not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab.

 

0

 

24

 

Save and close Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx. Exit Excel. Submit the file as directed.

 

0

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Wireshark Lab: IP V6.0

/in , /by

Wireshark Lab: IP V6.0

Wireshark Lab: IP v6.0

Supplement to Computer Networking: A Top-Down Approach, 6th ed., J.F. Kurose and K.W. Ross

“Tell me and I forget. Show me and I remember. Involve me and I understand.” Chinese proverb

© 2005-21012, J.F Kurose and K.W. Ross, All Rights Reserved

image1.jpg

In this lab, we’ll investigate the IP protocol, focusing on the IP datagram. We’ll do so by analyzing a trace of IP datagrams sent and received by an execution of the traceroute program (the traceroute program itself is explored in more detail in the Wireshark ICMP lab). We’ll investigate the various fields in the IP datagram, and study IP fragmentation in detail.

Before beginning this lab, you’ll probably want to review sections 1.4.3 in the text and section 3.4 of RFC 2151 [ ftp://ftp.rfc-editor.org/in-notes/rfc2151.txt ] to update yourself on the operation of the traceroute program. You’ll also want to read Section 4.4 in the text, and probably also have RFC 791 [ ftp://ftp.rfc-editor.org/in-notes/rfc791.txt ] on hand as well, for a discussion of the IP protocol.

1. Capturing packets from an execution of traceroute

In order to generate a trace of IP datagrams for this lab, we’ll use the traceroute program to send datagrams of different sizes towards some destination, X. Recall that traceroute operates by first sending one or more datagrams with the time-to-live (TTL) field in the IP header set to 1; it then sends a series of one or more datagrams towards the same destination with a TTL value of 2; it then sends a series of datagrams towards the same destination with a TTL value of 3; and so on. Recall that a router must decrement the TTL in each received datagram by 1 (actually, RFC 791 says that the router must decrement the TTL by at least one). If the TTL reaches 0, the router returns an ICMP message (type 11 – TTL-exceeded) to the sending host. As a result of this behavior, a datagram with a TTL of 1 (sent by the host executing traceroute) will cause the router one hop away from the sender to send an ICMP TTL-exceeded message back to the sender; the datagram sent with a TTL of 2 will cause the router two hops away to send an ICMP message back to the sender; the datagram sent with a TTL of 3 will cause the router three hops away to send an ICMP message back to the sender; and so on. In this manner, the host executing traceroute can learn the identities of the routers between itself and destination X by looking at the source IP addresses in the datagrams containing the ICMP TTL-exceeded messages.

We’ll want to run traceroute and have it send datagrams of various lengths.

· Windows. The tracert program (used for our ICMP Wireshark lab) provided with Windows does not allow one to change the size of the ICMP echo request (ping) message sent by the tracert program. A nicer Windows traceroute program is pingplotter, available both in free version and shareware versions at http://www.pingplotter.com . Download and install pingplotter, and test it out by performing a few traceroutes to your favorite sites. The size of the ICMP echo request message can be explicitly set in pingplotter by selecting the menu item Edit-> Options->Packet Options and then filling in the Packet Size field. The default packet size is 56 bytes. Once pingplotter has sent a series of packets with the increasing TTL values, it restarts the sending process again with a TTL of 1, after waiting Trace Interval amount of time. The value of Trace Interval and the number of intervals can be explicitly set in pingplotter.

· Linux/Unix/MacOS. With the Unix/MacOS traceroute command, the size of the UDP datagram sent towards the destination can be explicitly set by indicating the number of bytes in the datagram; this value is entered in the traceroute command line immediately after the name or address of the destination. For example, to send traceroute datagrams of 2000 bytes towards gaia.cs.umass.edu, the command would be:

%traceroute gaia.cs.umass.edu 2000

Do the following:

· Start up Wireshark and begin packet capture (Capture->Start) and then press OK on the Wireshark Packet Capture Options screen (we’ll not need to select any options here).

· If you are using a Windows platform, start up pingplotter and enter the name of a target destination in the “Address to Trace Window.” Enter 3 in the “# of times to Trace” field, so you don’t gather too much data. Select the menu item Edit->Advanced Options->Packet Options and enter a value of 56 in the Packet Size field and then press OK. Then press the Trace button. You should see a pingplotter window that looks something like this:

image2.png

Next, send a set of datagrams with a longer length, by selecting Edit->Advanced Options->Packet Options and enter a value of 2000 in the Packet Size field and then press OK. Then press the Resume button.

Finally, send a set of datagrams with a longer length, by selecting Edit->Advanced Options->Packet Options and enter a value of 3500 in the Packet Size field and then press OK. Then press the Resume button.

Stop Wireshark tracing.

· If you are using a Unix or Mac platform, enter three traceroute commands, one with a length of 56 bytes, one with a length of 2000 bytes, and one with a length of 3500 bytes.

Stop Wireshark tracing.

If you are unable to run Wireshark on a live network connection, you can download a packet trace file that was captured while following the steps above on one of the author’s Windows computers . You may well find it valuable to download this trace even if you’ve captured your own trace and use it, as well as your own trace, when you explore the questions below.

2. A look at the captured trace

In your trace, you should be able to see the series of ICMP Echo Request (in the case of Windows machine) or the UDP segment (in the case of Unix) sent by your computer and the ICMP TTL-exceeded messages returned to your computer by the intermediate routers. In the questions below, we’ll assume you are using a Windows machine; the corresponding questions for the case of a Unix machine should be clear. Whenever possible, when answering a question below you should hand in a printout of the packet(s) within the trace that you used to answer the question asked. When you hand in your assignment, annotate the output so that it’s clear where in the output you’re getting the information for your answer (e.g., for our classes, we ask that students markup paper copies with a pen, or annotate electronic copies with text in a colored font).To print a packet, use File->Print, choose Selected packet only, choose Packet summary line, and select the minimum amount of packet detail that you need to answer the question.

1. Select the first ICMP Echo Request message sent by your computer, and expand the Internet Protocol part of the packet in the packet details window.

image3.png

What is the IP address of your computer?

2. Within the IP packet header, what is the value in the upper layer protocol field?

3. How many bytes are in the IP header? How many bytes are in the payload of the IP datagram? Explain how you determined the number of payload bytes.

4. Has this IP datagram been fragmented? Explain how you determined whether or not the datagram has been fragmented.

Next, sort the traced packets according to IP source address by clicking on the Source column header; a small downward pointing arrow should appear next to the word Source. If the arrow points up, click on the Source column header again. Select the first ICMP Echo Request message sent by your computer, and expand the Internet Protocol portion in the “details of selected packet header” window. In the “listing of captured packets” window, you should see all of the subsequent ICMP messages (perhaps with additional interspersed packets sent by other protocols running on your computer) below this first ICMP. Use the down arrow to move through the ICMP messages sent by your computer.

5. Which fields in the IP datagram always change from one datagram to the next within this series of ICMP messages sent by your computer?

6. Which fields stay constant? Which of the fields must stay constant? Which fields must change? Why?

7. Describe the pattern you see in the values in the Identification field of the IP datagram

Next (with the packets still sorted by source address) find the series of ICMP TTL-exceeded replies sent to your computer by the nearest (first hop) router.

8. What is the value in the Identification field and the TTL field?

9. Do these values remain unchanged for all of the ICMP TTL-exceeded replies sent to your computer by the nearest (first hop) router? Why?

Fragmentation

Sort the packet listing according to time again by clicking on the Time column.

10. Find the first ICMP Echo Request message that was sent by your computer after you changed the Packet Size in pingplotter to be 2000. Has that message been fragmented across more than one IP datagram? [Note: if you find your packet has not been fragmented, you should download the zip file http://gaia.cs.umass.edu/wireshark-labs/wireshark-traces.zip and extract the ip-ethereal-trace-1packet trace. If your computer has an Ethernet interface, a packet size of 2000 should cause fragmentation. ]

11. Print out the first fragment of the fragmented IP datagram. What information in the IP header indicates that the datagram been fragmented? What information in the IP header indicates whether this is the first fragment versus a latter fragment? How long is this IP datagram?

12. Print out the second fragment of the fragmented IP datagram. What information in the IP header indicates that this is not the first datagram fragment? Are the more fragments? How can you tell?

13. What fields change in the IP header between the first and second fragment?

Now find the first ICMP Echo Request message that was sent by your computer after you changed the Packet Size in pingplotter to be 3500.

14. How many fragments were created from the original datagram?

15. What fields change in the IP header among the fragments?

� References to figures and sections are for the 6th edition of our text, Computer Networks, A Top-down Approach, 6th ed., J.F. Kurose and K.W. Ross, Addison-Wesley/Pearson, 2012.

� Download the zip file � HYPERLINK “http://gaia.cs.umass.edu/ethereal-labs/ethereal-traces.zip” ��http://gaia.cs.umass.edu/wireshark-labs/wireshark-traces.zip� and extract the file ip-ethereal-trace-1. The traces in this zip file were collected by Wireshark running on one of the author’s computers, while performing the steps indicated in the Wireshark lab. Once you have downloaded the trace, you can load it into Wireshark and view the trace using the File pull down menu, choosing Open, and then selecting the ip-ethereal-trace-1 trace file.

� The packets in the ip-ethereal-trace-1 trace file in � HYPERLINK “http://gaia.cs.umass.edu/ethereal-labs/ethereal-traces.zip” ��http://gaia.cs.umass.edu/wireshark-labs/wireshark-traces.zip� are all less that 1500 bytes. This is because the computer on which the trace was gathered has an Ethernet card that limits the length of the maximum IP packet to 1500 bytes (40 bytes of TCP/IP header data and 1460 bytes of upper-layer protocol payload). This 1500 byte value is the standard maximum length allowed by Ethernet. If your trace indicates a datagram longer 1500 bytes, and your computer is using an Ethernet connection, then Wireshark is reporting the wrong IP datagram length; it will likely also show only one large IP datagram rather than multiple smaller datagrams.. This inconsistency in reported lengths is due to the interaction between the Ethernet driver and the Wireshark software. We recommend that if you have this inconsistency, that you perform this lab using the ip-ethereal-trace-1 trace file.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

PC Build And Manual Part homework help

/in , /by

PC Build And Manual Part homework help

You will provide a comprehensive and detailed manual documenting the step-by-step process for building a computer using the components provided in LabSim 13.1: “Build a Computer from Scratch.” The manual will be used by entry-level technicians, so it should be clear, concise, and formatted using the IEEE citation style, with screenshots of each step from LabSim 13.1. Your manual should be similar to step-by-step instructions on How to Change the Oil in Your Car. Note carefully how in this example, not only is each step described individually, and in detail, but also there is a visual representation of each step. You should model your submission along the same lines. Keep in mind that your manual will be used as a guide for new technicians.

The manual should not document how to complete a LabSim section; rather, it should provide detailed instructions on how to build an actual computer for a potential customer:

“Drag the motherboard from the shelf to the motherboard plate in the system case.”

“After properly grounding yourself, pick up the motherboard and place it inside the area where the motherboard will sit in the case. Align the screw holes on the motherboard with the screw holes on the case. Use appropriate screws to mount the motherboard inside the case, making sure not to scratch the surface of the motherboard.”

To learn about the required parts which must be present in your submissions, and to learn how you will be assessed on this assignment, please take a moment to review the  rubrics.

The manual will be submitted in three separate parts, at three suggested milestone times. Part 1 addresses Sections 1-5 of the overall manual, Part 2 addresses Sections 6-10, and Part 3 addresses Sections 11-12.

PC Build & Manual Part 1:

1. Workspace Preparation (LabSim 2.0)
2. Installing Motherboard (LabSim 3.3)
3. Installing Power Supply (LabSim 3.2)
4. Installing CPU (LabSim 3.5)
5. Installing RAM (LabSim 3.7/3.8)

PC Build & Manual Part 2:

6. Installing Hard Drive (LabSim 5.2)
7. Installing Optical Drive (LabSim 5.3)
8. Installing Video Card (LabSim 3.12)
9. Connecting Monitors, Keyboard, and Mouse (LabSim 4.0)
10. BIOS Configuration (LabSim 3.10)

PC Build & Manual Part 3:

11. Installing Windows 7 (LabSim 10.3)
12. Configuring Critical Windows Features (LabSim 9.0 and 10.0)

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

/in , /by

Computer Science homework help

  1. sDownload the attached template called “INFO620-Assignment1_LastNameFirst.doc”.
  2. Change the file name applying your Last Name and First Name in place of the LastNameFirst.
  3. Then open the newly saved file and enter your name and the date due on the top of the document.
  4. Then enter each problem’s solution within this same file in their proper locations WITHOUT changing or erasing the questions.
  5. Support your responses and answers by references from the text.
  6. Review and complete all questions.
  7. Then upload to Assignment #1 area of the Assignments.
  8. Your grade may be reduced if these instructions are NOT followed closely.

Week 1 Assignment Grading Rubric: 

#1.9 0.2 points #3.13 0.3 points #4.12a 0.2 points
#1.10 0.2 points #3.16 0.3 points #4.12b 0.2 points
#1.12 0.2 points #3.19a 0.2 points #4.12c 0.2 points
#1.13 0.2 points #3.19b 0.2 points #4.12d 0.2 points
#1.14a 0.2 points #3.19c 0.2 points #4.12e 0.2 points
#1.14b 0.2 points #3.19d 0.2 points #4.12f 0.2 points
#2.14 0.3 points #3.20 0.3 points #4.15a 0.2 points
#2.15 0.3 points     #4.14b 0.1 points

Here are the contents of Assignment #1 (however – please use the template attached  – don’t copy and paste from here):

CH1: DATABASES AND DATABASE USERS
#1.9 – What is the difference between controlled and uncontrolled redundancy?
#1.10 – Specify all the relationships among the records of the database shown in Figure 1.2.
#1.12 – Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2.
#1.13 – Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
#1.14 – Consider Figure 1.2.
a.        If the name of the ‘CS’ (Computer Science) Department changes to ‘CSSE’ (Computer Science and Software Engineering) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated.
b.       Can you restructure the columns in COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be updated?
CH 2: DATABASE SYSTEM CONCEPTS AND ARCHITECTURE
#2.14 – if you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5? Why? Why would the other architectures not be a good choice?
#2.15 – Consider Figure 2.1. In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a column or a combination of columns within a table. One such constraint forces that a column or a group of columns must be unique across all rows in the table. For example, in the STUDENT table, the StudentNumber column must be unique (to prevent two different students from having the same StudentNumber). Identify the column or the group of columns in the other tables that must be unique across all rows in the table?
CH 3: THE RELATIONAL DATA MODEL AND RELATIONAL DATABASE CONSTRAINTS
#3.13 – Consider the relation CLASS(Course#, Univ_Section#, InstructorName, Semester, BuildingCode, Room#, TimePeriod, Weekdays, CreditHours). This represents classes taught in a university with unique Univ_Section#. Give what you think should be various candidate keys and
#3.16 – Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:
STUDENT (SSN, Name, Major, Bdate)
COURSE (Course#, Quarter, Grade)
ENROLL (SSN, Course#, Quarter, Grade)
BOOK_ADOPTION (Course#, Quarter, Book_ISBN)
TEXT (Book_ISBN, Book_Title, Publisher, Author)
Specify the foreign keys for this schema, stating any assumptions you make.
#3.19 – Consider a STUDENT relation in a UNIVERSITY database with the following attributes (Name, SSN, Local_phone, Address, Cell_phone, Age, GPA). Note that the cell phone may be from a different city and state (or province) from the local phone. A possible tuple of the relation is shown below:
Name
SSN
LocalPhone
Address
CellPhone
Age
GPA
George Shaw William Edwards
123-45-6789
555-1234
123 Main St., Anytown, CA 94539
555-4321
19
3.75
a.        Identify the critical missing information from the LocalPhone and CellPhone attributes as shown in the example above. (Hint: How do call someone who lives in a different state or province?)
b.       Would you store this additional information in the LocalPhone and CellPhone attributes or add new attributes to the schema for STUDENT?
c.        Consider the Name attribute. What are the advantages and disadvantages of splitting this field from one attribute into three attributes (first name, middle name, and last name)?
d.       What general guideline would you recommend for deciding when to store information in a single attribute and when to split the information.
#3.20 – Recent changes in privacy laws have disallowed organizations from using SSN to identify individuals unless certain restrictions are satisfied. As a result, most US universities cannot use SSNs as primary keys (except for financial data). In practice, StudentID, a unique ID, a unique identifier, assigned to every student, is likely to be used as the primary key rather than SSN since StudentID is usable across all aspects of the system. Reference the entire problem in the text
CH 4: Basic SQL
#4.12 – Specify the following queries in SQL on the database schema of Figure 1.2.
a)       Retrieve the names of all senior students majoring in ‘COSC’ (computer science).
b)       Retrieve the names of all courses taught by professor King in 85 and 86.
c)       For each section taught by professor King, retrieve the course number, semester, year, and number of students who took the section.
d)       Retrieve the name and transcript of each senior student (Class=5) majoring in COSC. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.
e)       Retrieve the names and major departments of all straight A students (students who have a grade of A in all their courses).
f)        Retrieve the names and major departments of all students who do not have any grade of A in any of their courses.
#4.15 – Consider the EMPLOYEE table’s constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows:
CONSTRAINT EMPSUPERFK
 FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN)
        ON DELETE CASCADE ON UPDATE CASCADE,
Answer the following questions:
a.        What happens when the following command is run on the database state shown in Figure 5.6?
                DELETE EMPLOYEE WHERE LNAME = ‘Borg’
b.       Is it better to CASCADE or SET NULL in case of EMPSUPERFK constraint ON DELETE?
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

/in , /by

Computer Science homework help

Exp19_Excel_Ch10_ML1_Dow_Jones_Instructions.docx

Grader – Instructions Excel 2019 Project

Exp19_Excel_Ch10_ML1_Dow_Jones

 

Project Description:

You are an intern for Hicks Financial, a small trading company located in Toledo, Ohio. Your intern supervisor wants you to create a report that details all trades made in February using current pricing information from the Dow Jones Index. To complete the task, you will import and shape data using Power Query. Then you will create data connections and visualizations of the data.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch10_GRADER_ML1_Dow.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 Use Get & Transform Data tools (Power Query) to import the Dow Index information located in Table 2 from the URL https://finance.yahoo.com/quote/%5EDJI/components?p=%5EDJI. Before loading the data, use the Power Query Editor to remove the Change, % Change, and Volume columns. Format the Last Price column as Currency, name the query Dow and load the data into the existing worksheet. 15
3 Name the worksheet Current_Price. 5
4 Use Power Query to import trade data located in the workbook Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv. Before loading the data, if necessary use the Power Query Editor to remove the NULL value columns and use the First Row As Headers. Split the company column using the left most space as the delimiter and rename the respective columns Symbol and Company Name. 15
5 Rename the worksheet Trades. 5
6 Add the Dow table and the Exp19_Excel_Ch10_GRADER_ML1-TradeInfo table to the Data Model. 0
7 Use Power Pivot to create the following relationship: Table Exp19_Excel_Ch10_GRADER_ML1-TradeInfo Field Symbol Table Dow Field Symbol 15
8 Use Power Pivot to create a PivotTable with the EXP19_Excel_Ch110_GRADER_ML1_TradeInfo Date field as a Filter, Last Price as a value, and the Dow table Company Name as Rows. 20
9 Create a Clustered Column PivotChart based on the PivotTable that compares the trading price of Apple and Coca-Cola stocks. 15
10 Add the chart title Trading Comparison, apply Accounting Number Format to cells C4:C5, and name the worksheet Price_Comparison. 5
11 Delete Sheet 1, if necessary. 5
12 Edit the connection properties to Refresh data when opening the file. 0
13 Save and close Exp19_Excel_Ch10_GRADER_ML1_Dow.xlsx and Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv. Exit Excel. Submit the file as directed. 0
Total Points 100

 

Created On: 10/05/2020 1 Exp19_Excel_Ch10_ML1 – Dow Jones 1.3

Amy_Exp19_Excel_Ch10_GRADER_ML1-Dow.xlsx

Sheet1

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Exp19_Excel_CH10_GRADER_ML1_Dow Jones_Final.jpg

Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv

Date,Trade_#,Company,,,,, 2/27/2021,8280,CAT Caterpillar,,,,, 2/25/2021,3564,CVX Chevron,,,,, 2/25/2021,7709,BA Boeing,,,,, 2/11/2021,5494,BA Boeing,,,,, 2/7/2021,6555,HD Home Depot,,,,, 2/13/2021,8821,CSCO Cisco,,,,, 2/14/2021,4771,DIS Disney,,,,, 2/17/2021,9021,HD Home Depot,,,,, 2/28/2021,1342,BA Boeing,,,,, 2/6/2021,5092,AAPL Apple,,,,, 2/20/2021,9602,AAPL Apple,,,,, 2/16/2021,3952,GS Goldman Sachs,,,,, 2/20/2021,3432,MMM 3M,,,,, 2/10/2021,2953,KO Coca-Cola,,,,, 2/27/2021,9270,AXP American Express,,,,,

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!