• 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. Marked by a teacher

    Geography Coursework

    3 star(s)

    erode, whereas the less resistant ones will, as they are softer and are not as hard and strong enough like the others.

  2. Debden Brook Rivers Coursework Data Collection Table

    people with ranging rods exactly at either end so that they were five meters away from one another. Ranging rods are long sticks which have been painted red and white along precise points of the stick to indicate a height (Pic 3).

  1. GCSE Geography Coursework: Strand 4 - Interpertation of Data

    river bed and moves them creating a greater load; and attrition which slowly wears away the rocks' material by making them collide against each other. (7) Bed-load roundness: Bed-load roundness Site 1 Site 2 Site 3 Site 4 Site 5 % rounded 2 6 19 51 77 % sub-angular 43

  2. rivers coursework

    Epping receives little rainfall every year. Cold, dry winters decrease the water volume of streams, further declining erosion rates. Epping Forest stretches over 12 miles (19km) and covers 2,400 hectares (6,000 acres); from Wanstead (East London) to North Epping (Essex).

  1. Lulworth Cove Coursework

    of the Car Park Figures 9 - 18 are all of my results of my Bi-Polar's I have taken from around the Lulworth area. Each one of the Bi-Polar's are similar in the fact that they all have high ratings, meaning that in each section (Litter, Dirtiness, Naturalness, Facilities and Noisiness)

  2. Morpeth Coursework

    Noise pollution Environmental noise of sufficient loudness to be annoying, distracting or physically harmful Air pollution Environmental air which is cause by vehicle exhausts and fumes from factories. Burgess Model A model of an urban structure Urban land use The use of land in towns and cities.

  1. Geography Coursework - Data Interpretation

    Annotated Photos: As well as making a spider graph about what each area contained, I also took a photo of each area and annotated it. The first photo, which is of P.M, shows that there is a large amount of litter on the floor.

  2. Earthquakes and volcanoes research

    Sometimes a layer of ash and dust settle on the land, choking plants and animals nearby, ruining home and blocking roads. Although volcanic eruptions may be loud and violent, the actual eruption doesn?t kill many people at all. The reason being is that not many people live on top of

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