• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Freshwater Pollution Coursework- Data Presentation

Extracts from this document...


Data Presentation Once I had entered the results of my investigation into a Microsoft Excel spreadsheet, I decided to present the data in a variety of ways to aid its evaluation within Microsoft Excel. I used this software to create graphs and calculate totals. I also used Microsoft Paint to create a map of the area. (Figure 1). Map Annotation: Biotic Summary I decided to annotate a map, which shows the locations of each site in relation to each other, with a biotic summary of each location. I decided to display the biotic summary in this way, so I can compare both the geographical importance of the results and the results themselves. This will, therefore, help me to analyse the data by showing me how the distance between each sites affects the biotic factors. I created the map using Microsoft Paint. The map shows a summary of the biotic results at each site. There is also a graph detailing biotic results on the following page. Total Abundance I decided to compare the total abundance (total number of invertebrates) at each site, in order to view the effects of the outfall of effluent. This will help me to prove or disprove my hypothesis by giving a summary of the biotic results. ...read more.


The turbidity fell, however, between the penultimate and the fourth site to 6 mg/l. These results are another indication of the ecosystem's recovery, a considerable distance from the outfall. The conductivity results also indicate the same conclusion. The conductivity was at its lowest at the first site (467 ?S) before rising at the second site (1302 ?S). However, once again, the highest result was recorded at the third site (1355 ?S) before the conductivity fell at the fourth site to 1042 ?S. This follows the same pattern of all the results so far, with the first result representing the lowest level of pollution and the second result representing a huge increase in the level of pollution with the third results having the greatest amount of pollution. The fourth result continues to represent the ecosystem's recovery. The concentration of nitrates at each site is another important indication of the level of pollution at that site. In my hypothesis, I predicted that nitrogen levels would increase after the sewage outfall, due to nitrification. My results prove this prediction. The first site had the lowest concentration of nitrates (48 mg/l) and the results at the second site showed a huge increase from this amount to 107 mg/l. ...read more.


Additionally, my research into public attitudes towards freshwater pollution indicates that 'water pollution continues to be a public concern'. This research has lead me to the conclusion, therefore, that the local residents in Pocklington would be concerned about the level of pollution in Pocklington Beck. My research indicated that freshwater pollution often is an important concern for farmers, who may need to monitor their use of pesticides. Possible Improvements of the Study I could have improved my study by taking more measurements and repeating my readings. This would have made the final results more reliable. Investigating more sites at Pocklington Beck would also have achieved this aim. However, it may have been difficult to do this as it may have disrupted local residents or agricultural activities. I could also have investigated more freshwater ecosystems around the country to confirm the pattern I established during this investigation. This would have made any conclusions more reliable and added credibility to my research. It may also have made my results more accurate. However, I did not have enough time to carry out these improvements. Due to these time restraints, my explanation and conclusions may be incomplete as I have only investigated one freshwater ecosystem and this may not be a large enough sample size. ?? ?? ?? ?? Caroline Stretton Geography GCSE Coursework Freshwater Pollution ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Physical Geography section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Physical Geography essays

  1. rivers coursework

    Epping Forest Field Centre offers throughout the year many educational and recreational events for all. Epping Forest lies mainly on a ridge of high land, with much ancient woodland, and home to many environments - including river, grassland and woodland habitats.

  2. Hunstanton coursework

    Have you visited Hunstanton before? Yes............................. No..................... By asking this question I am trying to find out weather there are more people coming to Hunstanton for the first time or weather people who have been in Hunstanton before are coming to Hunstanton more.

  1. Geography Coursework - Data Interpretation

    Also, in R.H.G, there, seems to be patches of exposed topsoil whereas I the picture of P.M, there doesn't seem to be any. This is strange because it would be expected that there is more exposed topsoil in P.M because of the higher expected amount of tourism.

  2. Swanage Geography Coursework

    On the next page of this coursework I will justify my coursework giving reason as to why it is effective and fits the needs of residents and if it will benefit them or not. JUSTIFICATION OF PLAN On this page I will evaluate my plan giving reason for why it

  1. Debden Brook Rivers Coursework Data Collection Table

    - Method very simple making it hard to go wrong. - The tape measure had a piece of string replacing the end which had come off. We were told it was the right measurement but human error may have occurred whilst measuring and attaching it.

  2. Morpeth Coursework

    For a noise pollution test, to be more precise, I will use my phone and mesure the distance until you can no longer hear the noise. The theory is; the longer the distance the quieter the area. I will need to keep the same person for walking the distance to make my test as accurate as possible.

  1. Lulworth Cove Coursework

    me in the future what sort of changes Lulworth may have made. I could also be able to monitor things like litter bins, cafes, pubs, etc. Data Presentation and Data Analysis/Interpretation Visitors to Heritage Centre 1st minute 2nd minute 3rd Minute 4th Minute 5thminute MAN 2 2 1 3 1

  2. Investigationg Eco-systems At Sand Dunes

    has the more acidic soil. The younger dune is more alkaline due to the western rains in this area that dissolves shells from the shingle beach into the soils of the younger dune. This is known as leaching, shown by the diagram to the left.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work