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!

homework help For PROJECT – Implementing an Online Shopping System with Use of the Decorator, Strategy, and Command Patterns

/in , /by

homework help For PROJECT – Implementing an Online Shopping System with Use of the Decorator, Strategy, and Command Patterns

PROJECT – Implementing an Online Shopping System with Use of the Decorator, Strategy, and Command Patterns

(and more!)

 

PROBLEM

You are to design and implement an Amazon.com-like online shopping system. You may include actual features of Amazon (e.g., Prime customers), or you may include your own features. The capabilities of the system MUST INCLUDE the following:

 

· generation of a receipt of some kind for all of the orders placed, and the

inclusion of items on the receipt that are a result of the particular items

purchased (by use of the Decorator design pattern).

 

· the use of the Command design pattern for implementation of the

overall command-driven aspect of the system.

 

· the use of the Strategy design pattern for any part of the system the

demonstrates its appropriate use

In addition, utilize any other design patterns that can be appropriately applied. Be creative in the features supported by the inclusion of such design patterns. For example, the Decorator design pattern can be used for any situation in which there are various combinations of behavior that cannot be determined until runtime (not just the printing of a receipt). For example, the total amount of an order may utilimately be based on (a) the items ordered, (b) the shipping option selected, (c) whether a preferred (“prime”) customer or not, (d) whether you have any credit from previous purchases/returns, (e) whether you are purchasing items that are currently on sale, (f) whether the purchase of a given item gives you a free associated item, etc. The same is true of the Strategy pattern, it can be used in any situation in which a section of code (algorithm) can vary, and especially if it can be judged that it may vary in the future.

 

 

DECORATOR AND COMMAND PATTERN MATERIALS

Materials are provided giving details on the design and example use of the Decorator pattern (from a previous Best Buy assignment(Decorator)) and the Command pattern (from a previous automated restaurant system assignment(Restaurant)). These should be used for studying the details of the GENERAL use of these patterns.

 

 

System Interface / User Interface

Your system must be designed with the use of a system interface class, as demonstrated in the automated restaurant system assignment. The methods of the system interface must only return values of type String for a separate user interface to call .The user interface may be text-based, or a GUI interface.

 

WHAT TO SUBMIT

Please submit one pdf document along with your code. (Export all class diagrams to pdf. Do not submit file formats of the particular UML drawing tool used.) and also Your code separately. Your submission should include,

· A use case diagram of your system. There is no set number of use cases to include – that will vary based on the particular system designing. Include an explanation of each use case. (Scenarios do not need to be provided.)

· The class diagram for your system. Make sure to include all of the classes and interfaces. The class diagram should include the relationships of association, composition, aggregation, generalization (inheritance), and dependency where they exist; notation of multiplicity, navigation, and role names where appropriate; and the inclusion of the methods within each class, including access modifiers (public, protected, private), parameters, and return type (instance variables do not need to be included).

· Discussion of the use of each design pattern within your design, including

· why you made the decision to incorporate the use of the pattern

· the benefits of the included pattern

· what specific aspects of the system can be easily modified as a

result of the use of design patterns in the design

· Program code, with sufficient in-code documentation

 

· List of commands the system provides, with a brief explanation of each

1

 
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

Warming Hut Management

This week it seems like everyone needs an answer to a question. The Accounting Manager for Operations has asked you to update some analysis prepared earlier in the year. In an attempt to predict year-end changes in net income, you have been asked to prepare some reports on changes in condominium rental fees, ski lift tickets, and X Game tickets and pricing.

The Sales Department for Luxury Condominiums wants to know how increasing their rental pricing by varying percentages will affect the existing pricing. The manager would like to know how that will increase the Summit Ridge Mountain Resort’s total revenue. A one-variable data table might be good to create these results.

The supervisor in charge of setting prices for lift tickets also needs some help. She wants to price the lift tickets so that they are affordable but yet offer the resort a chance to improve its net income at the end of the season. A one-variable data table might be able to answer this question.

Resort Management has a target income for the X Games. They need help determining the best combination of pricing and quantity of tickets to sell for the X Games to be a success. A two-variable data table might be best to display these results.

And there are more puzzling questions. Resort Management has reviewed variables such as lift ticket prices, restaurant revenues, retail revenues, maintenance costs, and payroll. They would like you to create a Scenario Summary to determine optimistic, mid-range, and pessimistic scenarios for the resort. The Operations Manager would like to know how these changes might affect revenue, expenses, and net income. A Scenario Summary would be a good choice for this analysis.

Last, all of the Warming Hut Management need a little help with some investigation on their data. They have quite a bit of data collected but need some assistance making sense of it. It may be time to polish your skills with Pivot Tables, because the management has many questions and concerns. Your boss is confident about your ability to be creative and customize some Pivot Tables that are unique to each Hut.

What-If questions need solid answers. It is time to provide a professional response.

Deliverables

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week6_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week6_Lab.xlsx.

LAB 6 – What-If-Analysis
Step Task Points Possible Points Received Comments
1 Complete Income Statement
1a – g Complete formulas & formatting 4
2 Build One-Variable Data Tables
2a One-Variable Data Table for condo rentals 3
2b One-Variable Data Table for ski lift tickets 3
2c Apply conditional formatting 2
2d Answer question in G17 5
3 Build Two-Variable Data Table
3a Enter Net Income and format 3
3b Apply conditional formatting 3
3c-d Answer question in G17 5
4 Scenarios and Summary
4a Name Cells for Scenario 2
4b Create three scenarios 4
4c Create Scenario Summary 2
4d Move sheet & apply formatting 2
5 Create Pivot Tables
5a, b Build Pivot Table 1 3
5c Build Pivot Table 2 3
5d Build Pivot Table 2 3
5e Create a chart for one pivot table 2
5f Apply professional formatting 2
6 Create Documentation Sheet
6a Create Documentation Sheet 2
6b Organize worksheet contents 1
6c, d Format Documentation Sheet 1
Comment: What you learned from completing this Lab 5
TOTAL POINTS 60 0

Week 6 Grading Rubric

Lab Resources

Microsoft Office: Excel 2016

Options for Accessing Microsoft Excel 2016

  1. Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources Page.
  2. If you are a MAC user, click to read the MAC User Information.
  3. If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.

Lab Steps

Preparation

You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab.

Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete.

Begin: Open and Save

Download the spreadsheet Week 6 Lab – Summit Ridge Mountain Resort Student.xslx. (Links to an external site.)Links to an external site. You will be prompted to save the file. Click yes.

Open the saved file from your Download folder on your computer.

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name,

  • open the workbook in Excel 2016; and
  • in Excel, click File and then Save As and rename it as lastname_first initial_Week6_Lab.xlsx (Jane Doe would save the file as Doe_J_Week6_Lab.xlsx).

Step 1: Complete Income Statement

It is time to build the formulas needed to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray.

  1. Enter the formula to calculate the Condo Rentals Revenue in C13 Multiple the Quantity of Condo Rental Days * the Price for Condo Rental.
  2. Enter the formula to calculate the Ski Lift Revenue in C14 Multiple the Quantity of Ski Lift Tickets * the Price for Ski Lift Tickets.
  3. Enter the formula to calculate the Winter X Games Revenue in C17 Multiple the Quantity of X Games Tickets * the Price for X Games Tickets.
  4. Enter the formula to calculate the Total Revenues in C20 and Total Expenses in C34.
  5. Make sure the cell references for Total Revenues and Total Expenses are placed in cells C37 and C38 respectively.
  6. Enter the formula to calculate the Net Income in cell C39.
  7. Apply professional formatting to all of this data using the image below as a guide.

Income Statement

Step 2: Build the One-Variable Data Tables

Now that the Income Statement is complete, begin to address the questions about the condo rentals and ski lift tickets.

  1. Build a one-variable data table based on condo rental days. The initial values for Revenue and Net Income for cells I6 and I7 should be cell references from the income statement.
  2. Build a one-variable data table based on the quantity of ski lift tickets. The initial values for Revenue and Net Income for cells I14 and I15 should be cell references from the income statement.
  3. Apply conditional formatting to highlight Net Income of at least $250,000 for each of the one-variable data tables.
  4. In cell G17, a question exists. “If management has a target net income of at least $250,000, which of the above SPECIFIC scenarios in the condo rentals or ski tickets one-variable data table would you recommend using? Explain your reasoning.” Make sure you place your answer in the text box beginning in cell G20.
  5. Apply professional formatting to all of this data using the image below as a guide.

One-Variable Data Tables 

Step 3: Build the Two-Variable Data Table

Once the one-variable data tables are complete, begin to address the questions about the X Games tickets sold.

  1. Build a two-variable data table based on the quantity and price of the X Games tickets sold.  Enter a reference to Net Income in cell I27 from the income statement.
  2. Apply conditional formatting to highlight Net Income of at least $250,000 for each of the two-variable data table.
  3. In cell G37, a question exists. “If management has a target net income of at least $250,000. Which of the above SPECIFIC combinations of price and quantity of X Games Tickets in the two-variable data table would you recommend using? Explain your reasoning.”
  4. Make sure you place your answer in the text box beginning in cell G40.
  5. Apply professional formatting to all of this data using the image below as a guide.
    Two-Variable Data Table

Step 4: Create the Scenario Summary

You addressed quite a few questions. Now it is time to create a Scenario Summary.

  1. Assign names to all of the income statement cell values in column C in the assumptions, revenues, expenses, and summary sections using the labels in column B. For example, select cells B5:C10, and then on the Formula tab in the Defined Names Group, select “Create from Selection” and use the left column as the name (repeat on lower sections).
  2. Build three scenarios by changing cells C8, C15, C16, C29, and C30 using the following data: Optimistic, Mid-range, and Pessimistic.
    Scenario Details
  3. Generate the Scenario Summary using C37:C39 as the result cells.
  4. Move the Scenario Summary sheet after the Income Statement and apply professional formatting to all of this data using the image below as a guide.

Completed Scenarios

Step 5: Create Pivot Tables From Warming Hut Data

Select the Warming Hut Sales Worksheet. You notice the data are not formatted or organized well.

  1. Use the Warming Hut Sales data to build Pivot Tables.
  2. Build the first Pivot Table to summarize total sales by category and by location. Name this sheet Pivot Table 1.
  3. Build the second Pivot Table to summarize total sales by category and by season for only the Summit View location. Name this sheet Pivot Table 2.
  4. Build the third Pivot Table to summarize total sales by month and by product for only the Mogul Hill location. Name this sheet Pivot Table 3.
  5. Choose one of the created Pivot Tables and add a professional chart to the same worksheet.
  6. Apply professional formatting to all of this data using the image below as a guide.
    Click Image to Expand

Step 6: Create a Documentation Sheet

Clean up the formatting of your Excel workbook, taking into account professional appearance.

 

The Minimum Requirement (per the Grading Rubric)

 

  1. Insert a new spreadsheet into the workbook. The documentation sheet should be the first sheet in the workbook.
  2. Make certain all contents of the workbook are properly noted on the documentation sheet.
  3. Make certain each tab has a descriptive name for each tab (sheet) in the workbook.
  4. Create the professional documentation worksheet. Be sure to include a description of each worksheet. An image is provided below.
    Click Image to Expand

     

 

 

Finish and Submit

Save your Excel file. Make sure you are aware as to where your files are physically saved. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain seven worksheets.

  • Documentation Page
  • Income Statement
  • Scenario Summary
  • WarmingHutSales
  • Pivot Table 1
  • Pivot Table 2
  • Pivot Table 3

Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week6_Lab.xlsx.

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