Software development Cycle

Please read file and you have 2 days

My question is about tourist in deferent country specially Philipines .

Week 6 Quiz

Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.1. what do each of these terms refer to: copyright, patent, trademark, trade secret?2. Why is intellectual property entitled to legal protection? 3. Why did copyright laws become stricter and more punishing in the late 20th century?4. What is the Fair Use doctrine?5. Make an argument for legalizing the copying of music or software. 6. Do I or don’t I own the books on my Kindle? If I own them, why can’t I transfer them? If I don’t own them, what is my legal right to them?7. What was the 1984 Sony Supreme Court case about?8. Was Napster responsible for the actions of its users?9. Why did the court find in favor of Diamond in the Rio case? 10. What is Digital Rights Management?
 

Exp19_Excel_Ch01_ML2_Sales

Exp19 Excel Ch01 ML2 Sales

Excel Chapter 1 Mid-Level 2 – Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price 

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

The owners of the   house on 386 East Elm Street took their house off the market. You want to delete   that row since it did not sell.
 

  Delete row 8, which has incomplete sales data.

You want to assign a   property ID to each listing. The code will have the year 2021 with a   sequential number.
 

  Type 2021-001 in cell A5 and use Auto Fill to complete the   series to assign a property ID to each property in the range A6:A12.

Real estate agents   study the number of days houses are on the market. In some cases, the longer   a house is on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C12.

Monetary values look   better when they are formatted to display the dollar signs. Because all   monetary values are whole numbers, you will decrease the decimal points to   avoid columns where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G12 with Accounting   Number Format with zero decimal places.

To analyze the real   estate market, it is helpful to calculate the selling prices as a percentage   of the list price. For example, the second house was listed for $500,250, but   it sold for only $400,125. Therefore, the sale percentage of the list price   is .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H12.

The calculated   percentages need to be formatted with the percent symbol rather than   displaying the values as raw numbers.
 

  Format the values in the range H5:H12 with Percent Style with two decimal   places.

Currently, the labels   on row 4 are hard to read. You will wrap the headings within each cell to   improve readability.
 

  Wrap the headings in the range A4:H4.

For better sequencing   of columns, you want to display the Days on Market column after the two   columns containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

You notice the list   contains a wrong date and wrong list price that need to be corrected.
 

  Edit the list date of the 41 Chestnut   Circle house to be 4/22/2021. Edit the list price of the   house on Amsterdam Drive to be $355,000.

Increasing the height   of the rows of data and centering the data vertically between the top and   bottom cell margins will make it easier for the other agents to review the   data.
 

  Select the property rows (rows 5:12), set a 25 row height, and apply   Middle Align.

Displaying borders   helps separate the property listings.
 

  Apply the All Borders border style to the range A4:H12.

You want to improve   the alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market   formula results in the range E5:E12.

The widths of the   columns containing the Days on Market, List Price, and Sold Price data need   to be adjusted for better appearance.
 

  Set the Days on Market column width to 9. Set the List Price and Sold   Price column widths to 11.86.

The property listings   dataset is small. To improve readability on the printed copy for the other   real estate agents, you will increase the scaling.
 

  Apply 120% scaling.

You don’t need the   data on the Properties sheet but you do want to insert another sheet for   formulas.
 

  Delete the Properties sheet and insert a new sheet named Formulas.

You want to copy the   original data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the Houses Sold worksheet   and copy it to the Formulas worksheet.

You do not want to   display the columns containing dates on the new worksheet.
 

  Hide the Date Listed and Date Sold columns in the Formulas worksheet.

You want to review   the formulas within the worksheet and prepare the Formulas sheet to be   printed.
 

  Display cell formulas. Set options to print row and column headings. Set 6.86   column width for column E and 6 for column H.

You want to apply   page setup options to both sheets, so you need to group the sheets first.
 

  Group the two worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets   still grouped, insert a footer with the text Exploring Series on the left side,   the sheet name code in the center, and the file name code on the right side.

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

This project must be completed and submitted to the FOL submission folder by the due date and time specified on the submission folder.
Late submissions will not be accepted.
This assignment is worth 30% of your final grade.
Objectives:
1) Demonstrate your understanding of the calculations needed to determine the power required for a piece of equipment
2) Demonstrate your understanding of the calculations needed to determine the power required for a rack of equipment
3) Demonstrate your understanding of how to connect equipment to the PDUs in a rack.
4) Demonstrate your understanding of how to cable equipment to rack network equipment.
5) Demonstrate your understanding of the calculations needed to determine the cooling required for a piece of equipment
6) Demonstrate your understanding of the calculations needed to determine the cooling required for a rack of equipment
7) Demonstrate your understanding of how to install equipment in racks. 8) Demonstrate your understanding of server cabling requirements
Submission requirements:
a) You are to submit a single Microsoft Word document containing your answer to this assignment as well as your Microsoft Excel Rack Template.
b) Your word document should be a professional document that is intended for both management and technical deployment teams to use as a reference. The racking template will be used by the rack and stack install team to properly rack and cable your equipment.
c) The name of the submitted files is to be in the form ‘Project_your_FOL_login_Summary’ for the summary solution and ‘Project_your_FOL_login_Rack Template’ for your rack layout. NOTE: You should use Microsoft Word to prepare your submission and save as a pdf for uploading. For the Rack Template, upload the MS Excel file.
Grading:
Item Marks
Available
Calculation of the power available per rack as provided by the data center operator 10
Calculation of the power and cable requirements for each piece of equipment. 10
Determination of the number of racks that will be required to house the equipment and the power required for each rack. 20
Determination of the overall total power requirement for all racks. 5
Determination of which PDU(s) to plug each piece of equipment into (on a per rack basis) 10
Rack diagrams showing the position of each piece of equipment in the rack 15
Calculation of the cooling required by each piece of equipment 10
Calculation of the cooling required per rack and the total cooling required. 10
Document formatting, spelling and grammar 5
Following submission instructions 5
Total marks available 100
Background information
Your organization has decided to move all of the equipment it currently has in several small data centers location at various organization offices around the country to a colocation data center near the offices where the IT department is location. This new data center has an Uptime Institute Tier 4 certification.
There are a number of reasons for making this move:
a) Most of the organization’s offices need additional space for staff.
b) The small data centers are running out of capacity for new equipment (physical space, cooling and/or power).
c) Reduce travel costs as all of the IT staff are based in one location.
d) Achieve economies of scale to reduce IT operating and capital costs (in the future).
Senior management have decided that they do not want to incur the cost of buying any new IT equipment that is not essential to the move. This means that the only new equipment will be 2 network core switches to be used to connect the server distribution layer switches to redundant WAN networks in the data center. Senior management have agreed, in writing, that downtime is acceptable as each office’s equipment is moved to accommodate this restriction on new equipment purchases.
The 2 new core network switches each have dual power supplies with a current of 2.0A at 240V. Each switch requires 2U of space in a rack. The Colocation will also allow you to rack your core switches in the sites core network racks if you wish, otherwise they need to be accounted for in your rack template. Identify these switches are Core-switch-1 and Core-switch-2
A consolidated list of the equipment that is to be moved into the colocation data center is:
a) One hundred 1U servers with redundant power supplies requiring 2A each at 240V. Identify these servers as Server-1 through Server-100. Each server required 2 cat5 for production, 1 cat5 for management, 1 cat5 for backup, 2 fiber for storage.
b) Twenty 1U network switches with redundant power supplies requiring 1.5A each at 240V. All switches have 48 network ports. Identify these switches as Switch-1 through Switch-20
c) Twenty 2U servers with redundant power supplies requiring 3A each at 240V. Identify these servers as Server-101 through Server-120. Each server required 2 cat5 for production, 1 cat5 for management, 1 cat5 for backup.
d) Six 10U blade server chassis units with 6 power supplies (3 redundant pairs). Each power supply requires 12A at 240V. Each chassis has 33 network ports Identify these units as Chassis-1 through Chassis-6. Of the 33 network ports 1 cat5 is for management and 2 are for backup. (30 for production 15×15)
e) Eight 6U storage arrays each with 4 power supplies (2 redundant pairs) each power supply requires 8A at 240V. Each storage array has 4 network ports. 2 for production, 1 for backup and 1 for management. In addition, each SAN requires 8 fiber connections. Identify these units as Storage-1 through Storage-8.
The data center is providing all of the racks already provisioned with PDUs as follows:
a) Each rack is a standard 19 inch 4-post closed rack, 42U high and includes
a. a full set of blank panels
b. Internal vertical cable management on both sides at the rear of the rack.
b) Each rack receives its power from the data center’s 2 redundant power sources provided by a bus bar.
c) Cooling is provided from the outside aisle through perforated raised floor tiles.
d) Each rack should have horizontal cable management were appropriate.
e) Each rack will have a 2u 48 port patch panel.
a. backup and server management network (iDRAC) switches are already provisioned at the site
b. the backup network is terminated using purple RJ45 keystone jacks
c. the management network is terminated using red RJ45 keystone jacks
f) Each rack has a Dell 2161 KVM (16 port) switch installed at position 21u. g) All power is 240V AC.
h) In a rack each power source has the following 1u horizontal mount PDUs:
a. One 50A PDU with 4 receptacles
b. Two 20A PDUs with 8 receptacles each
This gives a total of 6 PDUs per rack (3 on each power source).
What you are to do:
IMPORTANT: The power cables for a piece of equipment must be plugged into PDUs in the same rack as the piece of equipment is installed.
1) Determine and report the total power available on each of the redundant power sources per rack. Since all of the racks have the same power supplied to them, you only have to calculate and report this information once. (5 marks)
Item AMPS Input Watts
PDU 50A
PDU 20A
PDU 20A
Total
2) Determine and report the power required by each piece of equipment your organization will be installing in the data center. Since there are multiple pieces of equipment with the same power requirement, you only need to calculate and report this value once for each type of equipment. (5 marks)
Item AMPS Input PSU Watts
Fanshawe 48p Switch

http://assignmenthelp4u.com/
Fanshawe Core 48p Core Switch
Fanshawe Servers Model X
Fanshawe Servers Model Y
Fanshawe Blade Chassis
Fanshawe SAN
Total
3) Determine and report the total power required by all of your equipment. (5 marks)
Item Qty Watts Total Watts
Fanshawe 48p Switch 20
Fanshawe Core 48p Core Switch 2
Fanshawe Servers Model X 100
Fanshawe Servers Model Y 20
Fanshawe Blade Chassis 6
Fanshawe SAN 8
Total
4) Determine and report the number of racks that will be required to install all of the equipment and the total power required per rack. (8 marks) (per rack total power can be derived from the summary row in the assignment rack template)
In order to do this, you will need to:
a. assign individual pieces of equipment to racks. Implement racking rules where required.
(10 marks)
b. keep a running total of the power used per PDU or remaining PDU power. (7 marks)
c. keep track of which piece of equipment is plugged into which PDU. (5 marks)
d. keep a running total of the number of receptacles used in each PDU. (5 marks)
e. Remember that each rack is 42U high and that you need 6U for the PDUs and that you should have a cable management unit above or below each switch at minimum. (5 marks)
f. Keep a per rack port density count per switch. (5 marks)
g. Keep a per rack port density count per patch panel (5 marks)
HINT: Remember each PDU can only deliver a limited amount of power and that each PDU has a specific number of receptacles available.
5) Create rack diagrams for each rack that you populate with equipment. These diagrams need to include the equipment, PDUs, cable management units and blank panels. All equipment must be labeled with its name (as given in the Background Information section above). Do not attempt to show any cable routing or connections within each rack, this will make the diagrams to complicated. (15 marks)
There are a number of tools available to create rack diagrams suitable for this project. They include Microsoft Excel, Microsoft Visio. For consistency you will be provided with an Excel Racking Template that must be used and submitted as part of your overall solution.
HINT: This template, if used properly, provides many of the calculations needed for your summary document submission.
6) Determine and document the cooling requirements for each piece of equipment your organization is installing in the data center. Since there are multiple pieces of equipment with the same cooling requirement, you only need to calculate and report this value once for each type of equipment. (5 marks)
Item BTU/h
Fanshawe 48p Switch
Fanshawe Core 48p Core Switch
Fanshawe Servers Model X
Fanshawe Servers Model Y
Fanshawe Blade Chassis
Fanshawe SAN
Total
7) Determine and report the per rack cooling requirement for your racks and the total cooling requirement for your organization’s equipment. (per rack cooling can be derived from the summary row in the assignment rack template) (5 marks)
Item Qty BTU/h Total BTU/h
Fanshawe 48p Switch 20
Fanshawe Core 48p Core Switch 2
Fanshawe Servers Model X 100
Fanshawe Servers Model Y 20
Fanshawe Blade Chassis 6
Fanshawe SAN 8
Total

Respond to the following required content in a minimum of 175 words:

1. Another important property of a binary search tree is being able to easily find the maximum and minimum key in the tree. Thoroughly discuss the simple rule to identifying these keys.
2. Define the three tree traversal processes (i.e., pre-order, in-order, and post order).
3. Provide an example of one tree traversal process, ideally utilizing a visual image along with an explanation.

For this assignment we will build Neural Network to predict house prices with Keras package.

Use the link below from “FreeCodeCamp” website, download the dataset and implement the model step by step using Jupyter Notebook. The tutorial is well-structured and easy to follow.

Link: https://www.freecodecamp.org/news/how-to-build-your-first-neural-network-to-predict-house-prices-with-keras-f8db83049159/

Deliverable:

· Your report including the screenshots of your implementation.

· Your code (.ipynb) file.

Need to follow instruction as mentioned in document and write discussions 

Complete the three questions according to the requirements in the picture