Question

Please answer below questions(plagiarism applies)

  1. Discuss each of the following terms:
    1. data
    2. field
    3. record
    4. file
  2. What is data redundancy?
  3. Discuss the disadvantages of file-based systems.
  4. Explain the difference between data and information.
  5. Use Figure 1.2 (below attachment) to answer the following questions.
    1. In the table, how many records does the file contain?
    2. How many fields are there per record?
    3. What problem would you encounter if you wanted to produce a listing by city?
    4. How would you solve this problem by altering the file structure?

Excel_1E_Gym_Sales

Excel_1E_Gym_Sales

  

Project Description:

In the following project, you will create a worksheet comparing the sales of different types of home gym equipment sold in the second quarter.

     

Open the file Student_Excel_1E_Gym_Sales.xlsx   downloaded with this project.

 

Change the workbook theme to   Wisp. If the Wisp theme is not available on your computer, in the Themes   gallery, click Browse for Themes, and then select the theme from your   downloaded student data files.

 

In cell B3, use the fill handle   to fill the months May and June in the range C3:D3.

 

Merge & Center the title   across the range A1:F1, and then apply the Title cell style. Merge &   Center the subtitle across the range A2:F2, and then apply the Heading 1 cell   style. Center the column titles in the range B3:F3.

 

Widen column A to 180 pixels,   and then widen columns B:F to 115 pixels. In the range B7:D7, enter the   monthly sales figures for the Elite Home Gym for April, May, and June as   follows:
 

137727.85 for April and 121691.64 for May and 128964.64 for June.
 

  Mac users: Widen column A to 21.83 (136 pixels) and columns B:F to 13.83 (88   pixels).
 

  Note: If any columns are too narrow to display all the data, apply AutoFit to   the column.

 

In cell B8, on the Home tab, use   the AutoSum button to sum the April sales. Copy the resulting formula across   to cells C8:D8 to sum the May monthly sales and the June monthly sales. In   cell E4, use the AutoSum button to sum the Basic Home Gym sales. Copy the   formula down to cells E5:E8.

 

Apply the Heading 4 cell style   to the row titles and column titles. Apply the Total cell style to the totals   in the range B8:E8. 

 

Apply the Accounting Number   Format to the first row of sales figures and to the total row. Apply the   Comma Style to the remaining sales figures.

 

To compare the monthly sales of   each product visually, select the range that represents the sales figures for   the three months, including the month names and the product names—do not   include any totals in the range. With this data selected, use the Recommended   Charts command to insert a Clustered Column chart with the month names   displayed on the category axis and the product names displayed in the legend.

 

Move the chart so that its upper   left corner is positioned in the center of cell A10. Then drag the center   right sizing handle to the right until the right edge of the chart aligns   with the right edge of column E; this will display the legend on one row and,   after you add the sparklines, center the chart below the data.

 

Apply Chart Style 6 and change   the colors by applying the second row of colors under Colorful. Change the   Chart Title to Second Quarter Home Gym Sales

 

In the range F4:F7, insert Line   sparklines that compare the monthly data. Do not include the totals. Show the   sparkline Markers. Display the sparkline Style gallery, and then in the first   row, apply the second style.

 

Center the worksheet   Horizontally on the page, and then insert a Footer with the File Name in the   left section.

 

Change the Orientation to Landscape. Display the document properties,   and then as the Tags, type home gym, sales
 

  As the Subject, type your course name and section number. Be sure your name   displays as the Author. Check your worksheet by previewing it in Print   Preview and then make any necessary corrections.

 

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

h10

Weekly Learning and Reflection 

In two to three paragraphs (i.e., sentences, not bullet lists) using APA style citations if needed, summarize, and interact with the content covered in this lab. Summarize what you did as an attacker, what kind of vulnerabilities did you exploit, what might have prevented these attacks. Mention the attackers and all of the targets in your summary. You can provide topologies, sketches, graphics if you want. In particular, highlight what surprised, enlightened, or otherwise engaged you. You should think and write critically, not just about what was presented but also what you have learned through the session. You can ask questions for the things you’re confused about. Questions asked here will be summarized and answered anonymously in the next class.

Network Infrastructure Design Diagram

Background: Kamehameha Institute is an organization that provides educational offerings to non-traditional students via the institute’s website in a three-tier web, application, and database configuration. The State of Hawai’i regulates the educational sector, driving the need to ensure Kamehameha follows the State’s strict security and regulatory requirements. Kamehameha’s leadership is also very concerned with the threat posed by the online theft of their unique intellectual property. Additionally, the number of Hawai’ian entities breached by threat actors is on the rise. Thus, security, privacy, and compliance are all important considerations for the Kamehameha network architecture.

Your boss, the Kamehameha Institute’s Chief Operating Officer (COO) has tasked you to design a network infrastructure for three facilities located in the Hawaiian Islands of Honolulu, Hilo, and Lihue. The COO stipulated that you must provide for strengthened defenses to protect Kamehameha’s cultural heritage. After meeting with the COO, the two of you drafted the following set of requirements for your network design:

  • Each of the facilities has three floors:
    • The first and second floor of each building requires 150 network connections each for machines connected to the management network used by administrators to manage the network devices
    • The third floor of each building requires 75 network connections for the servers
    • All sites require redundant connectivity to the other sites (e.g., Internet redundancy between the sites can be accomplished through a single Internet connection and a point-to-point link between the sites or two Internet connections provided by separate vendors along with point-to-point VPN connections between the sites)
  • Each datacenter is a redundant failover environment to the other datacenters (Hilo, Honolulu, Lihue)
  • A constant connection between the three locations, carrying at least 75 Mbps of data
  • All servers at all locations must have redundancy
  • Protection from intrusions is required and should be documented
  • A plan to verify security and failover measures is required

Submission: Using a network diagramming tool such as Microsoft Visio, or free tools such as LibreOffice Draw or Draw.io available at https://draw.io (no sign-in or registration required), create a network diagram (drawing) specific to the organization that encompasses the three facilities and also depicts any necessary interconnections. Figure 1 shows the draw.io ‘new network diagram’ dialog window:

Figure 1. Draw.io New File Dialog Showing the Network Diagramming Templates

Your diagram should include enough detail to show the topology interconnections. The viewer should be able to understand the Kamehameha Institute’s network environment and be able to implement the architecture you develop. Ensure that you properly cite any external sources.

One of the keys to producing a viable network diagram is labeling the objects consistently and descriptively. Think about what you would want to know about a network device if you logged into it with little prior information. Consider location, floor number, or other pertinent information. At a minimum, include the following elements:

  • IMPORTANT: Your network diagram must include an identifying label (e.g., callout box) that includes your class and section, assignment title, your name, and the date. Edit the items in italics. Your assignment will not be accepted if this element is missing:

Example Network Diagram Callout Box.

CMIT 350 6980
Project #1 Network Diagram
Student Name: Name
Date: 6/22/2010

  • Any necessary hardware
  • Site-to-Site (WAN) connections (e.g., leased line connectivity, satellite, etc.)
  • Annotate the following values for each of the Sites:
    • Network ID
    • Useable Range
    • Subnet Mask
    • CIDR Value
    • Broadcast Address
  • All devices require hostnames complying with the following naming conventions:
    • Routing Devices: Rx; where x is the site number incremented by a value of 1 for each routing device
    • Switching Devices: Sx; where x is the site number incremented by a value of 1 for each switching device
    • Servers: SRVx where x is the server number incremented by a value of 1 for each server
  • For each site routing device, implement a private ip addressing scheme using a range suitable for corporate infrastructure and include the following:
    • management vlan
    • production vlan
  • High availability

When finished, export the diagram as a PDF document (Note: You will need to use this diagram again in Project 3, so ensure you save the xml source file!) and submit it to the Assignment folder. Figure 2 demonstrates how to export your draw.io diagram as a PDF document:

BI

 

BI-16

1.  Some say that analytics in general dehumanize manage-rial activities, and others say they do not. Discuss arguments for both points of view.

2.  Diagnosing infections and prescribing pharmaceuticals are the weak points of many practicing physicians. It seems, therefore, that society would be better served if analytics-based diagnostic systems were used by more physicians. Answer the following questions:

a. Why do you think such systems are used minimally by physicians?

b. Assume that you are a hospital administrator whose physicians are salaried and report to you. What would you do to persuade them to use an intelligent system?

c. If the potential benefits to society are so great, can society do something that will increase doctors’ use of such intelligent systems?

3.  What are some of the major privacy concerns in employing intelligent systems on mobile data?

4.  Identify some cases of violations of user privacy from current literature and their impact on data science as a profession.

5.  Search the Internet to find examples of how intelligent systems can facilitate activities such as empowerment, mass customization, and teamwork.

Leadership and Conflict Management Presentation

6 SLIDE

you proposed how you would build your own team. Now, your newly formed team is starting to work on its first real project that needs to have strong collaboration and a quick turnaround. However, your team has encountered the following challenges:

  • One team member does not agree with the goal and keeps questioning the processes.
  • Two team members are having a personal conflict, and this is preventing them from collaborating on the project.
  • One team member is not engaged.

Answer the following questions in your presentation:

  • What were your choices for managing conflict on your team?
  • What conflict resolution strategies did you employ to encourage collaboration and build consensus within a team? 
  • Are these strategies something you typically employ when confronted with a conflict? Why or why not?
  • How can you keep all employees on your team engaged? Provide examples.

ppt

Write a 2-3 page paper (deliverable length does not include the title and reference pages)

1.Describe the steps for securing software

2.Explain how to create data backups

Chapter Summary

 

Need to write about 350 words of summary of EACH CHAPTER, so that it contains:

(part 1) important concepts of the chapter

(part 2) experience/application/opinions of the chapter.  

Total 6 chapters, 350 word for each