Full instructions attachedDirectionsWater Analysis ReportDownload and complete the Water Analysis Report. First, finish filling in the table that already contains the data from the DOWSE team in South America.Next, complete the Written Explanation section. In this section, address the following:Identify how the scientists in South America determined their hypothesis. Consider how the contaminated water impacted the surrounding environment and the people who live nearby.Describe the scientific testing performed and the results the team found. What were some of the testing procedures they used?Describe the different types of data collected, and include their units of measurement, where applicable. At what measurement is pH considered acceptable? What is the level of pH at the contaminated site?At what NTU level is water considered acceptable? How many NTUs are being measured at the contaminated site?What color is the water at the contaminated site?Determine whether the scientific data collected supports or refutes the hypothesis. Consider the following: How can low water pH cause problems for local people and wildlife?What do you think is the cause of the higher-than-normal turbidity?What does the color of the water tell you, and why is that important?Do you think DOWSE’s hypothesis is right? Why or why not?Identify a possible solution for the water problem in this location in South America, based on scientific methods and the provided data. Is there anything in the nearby area that could be degrading the water quality?Resources: https://www.usgs.gov/special-topic/water-science-school/science/water-color?qt-science_center_objects=0#qt-science_center_objectshttps://www.ted.com/talks/siddhartha_roy_science_in_service_to_the_public_goodhttps://www.nhm.ac.uk/content/dam/nhmwww/take-part/Citizenscience/citizen-science-guide.pdfhttps://youtu.be/5D1gV37bKXYhttps://youtu.be/0ZKtsUkrgFQ

Acinetobacter baumannii is a gram-negative bacterium commonly found in soil and water. This bacterium is also frequently associated with nosocomial infections, diseases patients acquire while they are in a hospital. A. baumannii tends to thrive in hospital settings because the bacterium is resistant to environmental influences and can survive for months on such objects as faucets, toilets, bedclothes, doorknobs, sinks, and medical equipment. The spread of this bacterium is a concern for all medical facilities, but especially military ones, which have seen increasing numbers of bloodstream infections caused by A. baumannii, probably because combat conditions make controlling and treating them more difficult.Additionally, A. baumannii infections have become problematic because increasing numbers of isolates show multiple drug resistance—that is, the bacteria are unfazed by the antibiotics commonly used to treat them. Many of the resistance genes found in A. baumannii are similar or identical to those seen in other genera of bacteria, such as Pseudomonas, Salmonella, and Escherichia, which also commonly occur in healthcare facilities. -    How might genes, such as those responsible for drug resistance, be transferred between bacterial species?-    Where could A. baumannii likely have acquired the genes for drug resistance?Ref.: Cowan, M. K. (2014) (4th Ed.). Microbiology: A Systems Approach, McGraw Hill

Both parts of this assignment must be done in the same Excel workbook or file with file name “Week 6 Excel Assignment” Worksheet 1: Part A -Using one named sheet or worksheet in this Microsoft Excel file, create a sample database table to handle student information system with at least 5 different columns and at least 5 rows of date. Name the columns, and list or number the rows. Hint: Your database needs a title, column titles and row numbers. Student information could be anything from program enrolled, grades, demographics, etc.) Worksheet 2: Part B – Using another worksheet in this same excel file in PART A, create a table of your last 6 months’ expenses (fictional) and create a cell that adds them all to show the sum. Hint: Your table must show 6 distinct months by name (January, February etc, at least 4 columns of expenses such as housing, gas, groceries, clothing, education cost, and the SUM function in your Total Column.