Where does data analysis begin?

 The collection of data is not the onset of data analysis projects. A data analysis project begins with a purpose, problem, and research questions.

Find one scholarly research paper with an excellent example of:

  • Problem statement
  • Research questions

The example shall relate to a practical, real-world work environment in the information technology field. After finding the research, discuss the following:

  • What makes this example excellent in the topics that initiate a data analysis project?
  • What relates this example to a practical, real-world work environment in the information technology field?
  • Do the research questions meet the criteria defined in the lecture in week one?
  • What is the generalizability of this research?

Data Mining Project

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course 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. 

Represent Family using Graph data structure

 

Using the below image represent this family using a graph structure. The graph needs to be a weighted graph. The weights will constitute the types of relationships, I recommend using some kind mapping between numbers and strings to represent the relationships. When adding family members to the graph, this can be done programmatically for the provided family members within the description file.

Additionally,

  • I also want there to be an interface in which a user can create a new family member and add them to the tree.
  • This can be a simple CLI where the user provides a name, gender, and age to create a person.
  • Then another simple CLI where they select which member of the family, they want the original relationship to be with and what kind of relationship it should be.
  • Finally, they can edit the family member using another CLI and selecting the family member they wish to edit, the operation they wish to perform (edit name, edit age, edit relationship), and then add new relationship between family members which can call a function that you create in order to add the original relationship.

Finally, make data assertions within the FamilyTree class that enforce certain “rules” that exist in a typical human family. An example would be a person should not have any kind of relationship to itself (a person cannot marry themselves, a person cannot be their own brother, sister, father, mother, etc.). There should be at least 3 data assertions. These should exist as part of the family tree, not as part of the graph.

As a hint, for a successful design:

I would recommend using layers of abstraction. Your graph class is the backing structure to the family tree class. Your family tree should implement methods that interface with the graph class, i.e. add_family_member() should call the constructor to create a node and then call a function within the graph class to add a node to the graph. Then using the relationships function parameter, you can add edges to the graph between the new nodes and the existing nodes. The family tree should be what enforces what relationships can exist through the data assertions, the graph does not care about what relationships are made between family members. Your functions that the user would interface with would be greatly reduced compared to the total number of methods within the classes themselves. The user should be able to add, remove, and modify family members and that’s about it. Therefore, those should be your function calls.

Attachments area
 

TCP/IP protocol

 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. 

COMPUTER

 

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”)

Python Coding

 

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

FT:Paper-10

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.