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

    In actual fact Old Harry is a smaller rock further to the south of the large rocks near the Pinical. Old Harry has been around for well over 200 years where as the larger rock only broke away from the cliff more recently.

  2. rivers coursework

    Epping Forest The largest public open space in London and Essex, Epping Forest is owned by the Corporation of London, and used primarily for recreational and conservational purposes. Being a Site of Specific Scientific Interest (SSSI), research is undertaken here.

  1. Geography Coursework - Data Interpretation

    The other results on the bar graph also support this theory. There was only 3 pieces of litter in R.H.G but there were 30 pieces in P.M. There were also 57 cars parked in sight of where we were in P.M, compared to the 0 in R.H.G.

  2. Hunstanton coursework

    2. Where do you live? Day tripper.............. Longer stay............... This question is important because it helps me find out about from which place people are coming to visit Hunstanton and this enables me to find out where most people are coming from. I could use this information to see weather people are coming from all around England to Hunstanton.

  1. Swanage Geography Coursework

    Another way my plan is good is because I added a large supermarket for residents to use. Residents would find this very useful as they mentioned this in questionnaire. Most of the facilities did not take much thought it was mostly commence sense and guidance from the tourist and residential questionnaire.

  2. Lulworth Cove Coursework

    High Street Figure 16 - Graph of the Bi-Polar of the High Street Bi-Polar of the Car Park Litter 4 Noisy 3 No Facilities 5 Un Natural 4 Dirty 4 Figure 17 - Table of results of the Bi-Polar of the Car Park Figure 18 - Graph of the Bi-Polar

  1. Morpeth Coursework

    I have mentioned a lot of key words in the introduction. To show my understanding of these key words here is a table (fig1.4) of the main key words and there definition. Key words Definition Environment Something that surrounds or a surrounding.

  2. Debden Brook Rivers Coursework Data Collection Table

    The meter stick was held in exactly the same way along the surface of the water at each site so that it would be a fair test. Just to make sure we made no errors and had reliable results, we repeated this exact same procedure 3 times to make sure

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