You will type a three to five page paper on the TCP/IP Protocol suite, its history and application. You may use the textbook in addition to researching  the internet for additional sources. Please submit your APA-formatted paper in a Word document. Your paper must be double spaced and include a cover page and a reference page for your cited sources. Please note that the reference page and cover page do not count towards your paper’s three to five pages in length. 

Complete the assignment below using Microsoft Excel.

You have been hired by an engineering firm needing a senior level data analyst. Upon accepting this position, your supervisor has a variety of data analysis task for you to complete using PMT and What-IF-Analysis functions. In this process, your supervisor wants you to complete all steps below:

1. Open a new Microsoft Excel workbook and rename any sheet tab of choice to “My Car” or “My Truck.”
2. Use the illustration and further steps below to set up and format your worksheet.

1. Merge and center cells A1 and I1 and then enter a title “My Car” or “My Truck.”
2. Using a color of choice, fill in cells C3 through I10 and in this colored region, include any picture of choice to represent a car or truck of choice. Nicely format and place this picture within this area.
3. Then from cell A4 through A10, enter the following labels:
   1. Purchase Price
   2. Down Payment
   3. Trade-in
   4. Amount Financed
   5. Term of loan (in years)
   6. Annual Interest Rate
   7. Monthly Payment
4. Then from cell B4 through B6, enter a purchase price, down payment, and trade-in value of choice. Then create a formula to calculate amount financed in cell B7. For example, a formula to use in this case would be “=B4-(B5+B6)”.
5. Then from cell B8 through B9, enter the term of loan in years and an interest rate of choice. Then use a PMT function to determine the monthly payment in cell B10. For example, a formula to use in this case for cell B10 would be “=-PMT(B9/12,B8*12,B7)”.
6. The illustration below will offer more support on input of all required formulas along with sample data input:

1. Once all data and calculations are working, do any other housekeeping to include professional format of choice to enhance presentation of data.
2. Repeat steps 4 through 12 creating another similar model for a house of choice and place this loan analysis model in the same workbook but in a new worksheet naming the worksheet “My Home.”
3. Once both PMT_Models are complete, go back to My Car or My Truck worksheet and use the illustration below and further enhance the loan analysis using What-IF-Analysis.

1. In cell A12, type the label Annual Interest Rate. Then merge and center cells B12 through I12 and enter the label Term of Loan (in years).
2. In cell A13, equal this to cell reference B10. Fill this cell with a color of choice and use the same color for the text color to hide this value.
3. Starting with cell A14 and ending with A35, enter some interest rates. Make sure data is centered and formatted as a percentage.
4. Starting with cell B13 through I13, enter some additional term of loan options in years and make sure data is centered.
5. Using your mouse, select all cells in the range from A13 through I35. Then select the data tab and then the What-If-Analysis tool. From the What-If-Analysis options select Data Table. At this point, a small dialog window will appear asking for Row and Column input cells. For the Row Input, select the value associated with years in the loan which would be an absolute reference as $B$8. For the Column Input, select the value associated with interest rate which would be an absolute reference as $B$9. 
6. To get a better understanding of the purpose and uses of the What-If-Analysis, be sure to explore www.youtube.com and the keywords “Microsoft Excel What-If-Analysis” to see additional demonstrations.
7. Once all data and calculations are working, do any other housekeeping to include professional format of choice to enhance presentation of data. Below is an illustration of what your My Car or My Truck worksheet will look similar too:

1. Repeat steps 11 through 18 creating another similar What-IF-Analysis model for the My House worksheet.
2. Save and be sure the name of the Microsoft Excel Workbook is “M7_YourLastName”.

Assignment Expectations

Structure and Format: Follow all 20 steps using ideally Microsoft Excel.

File name: Name your saved file according to your first initial, last name, and the assignment number (for example, “RHall Assignment 1.xlsx”)

Discussion Points:

Explore the “for loop” and the “while loop”. 
1. Explain when to use these different types of loops.
2. How do you include a ‘loop’ structure programming in Python?
3. How do you control a loop?

4. Provide sample code to demonstrate loops

please answer the following questions with a total of over 250 words

Considering the importance of data in organization, it is absolutely essential to secure the data present in the database. What are the strategic and technical security measures for good database security? Be sure to discuss at least one security model to properly develop databases for organizational security. Create a diagram of a security model for your research paper.

Your paper should meet the following requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.
• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook.

the requirements are in the attached document

Inspect 5 doors in your building with locks

Topic :Physical security

Gather all final project material:

 Topic: Access control planning & implementation in an enterprise environment
PAPER:
write an 8-page paper that must include all of the following: Discuss the strengths/weakness of the topic and possible improvements. Discuss what you have learned from this assignment and how you will apply it moving forward in your career. Use at least one NIST resource as a reference. Use a minimum of 10 peer-reviewed resources. APA format; Times New Roman 12-point font. The title page and reference page do not count towards your 8-page minimum.

PRESENTATION:
A minimum of 10 slides. The title slide and reference slide do not count towards your 10-slide minimum. Include speaker notes on each slide. 

create a presentation, covering the following objectives:

• Explain the  basic commands and functions of SQL
• How to use SQL for data administration (to create tables, indexes, and views)
• How to use SQL for data manipulation (to add, modify, delete, and retrieve data)
• How to use SQL to query a database to extract useful information

• Use PowerPoint. Prezi or a similar presentation tool.

Instructor”s question and case for class discussion:

“Why do we need to understand data visualisations? There is more and more data around us, and data are increasingly used in decision-making, journalism, and to make sense of the world. One of the main ways that people get access to data is through visualisations, but lots of people feel like they don’t have the skills and knowledge to make sense of visualisations. This can mean that some people feel left out of conversations about data.” – http://seeingdata.org/developing-visualisation-literacy/

Choose three of your favorite visualizations. Post a 3 – 5 sentence summary (for each) of why you chose the visualizations. What catches your attention? Are these visuals effective in presenting the provided data? If possible, explain what you would do to improve the visualization(s).

Also Reply to your classmates:

When replying to a classmate, offer your opinion on what he/she posted and the visualizations they chose. Using at least 3 – 5 sentences, explain if you agree or disagree with his/her evaluation of the visualizations.