Freshwater Pollution Coursework- Data Presentation

Authors Avatar

Caroline Stretton

Geography GCSE Coursework

Freshwater Pollution

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. I used Microsoft Excel to create this graph.

Figure 2

The graph shows the total abundance at each location.

Oxygen Saturation

I decided to display the oxygen concentration as a line graph so I could compare the results of each site and identify any patterns. A line graph shows the results as continuous data, whereas a bar chart would not have done so.

Figure 3

The chart shows the oxygen concentration at each location.

pH

I decided to display the pH of each site as a bar chart, as this data is categoric not continuous and is therefore unsuitable for a line graph. I used Microsoft Excel to create this chart.

Figure 4

The chart shows the pH of the water at each location.

Oxygen Saturation and Total Abundance

I decided to present the oxygen saturation and the total number of invertebrates (total abundance) at each site as a histogram so I could easily compare the two factors to identify any patterns which may be relevant to my hypothesis. This histogram is included on the following page.

Temperature and Oxygen Concentration

I decided to present the oxygen concentration and temperature as a histogram so I could easily compare the two factors to identify any patterns which may be relevant to my hypothesis. This histogram is included on the page after next.

Nitrates

Finally, I decided to present the concentration of nitrates in the water at each site as a pie chart to establish what percentage of nitrates each site had. This information may be relevant to my hypothesis. I used Microsoft Excel to create this chart.

Join now!

Analysis and Conclusion

Analysis of Data

Oxygen Levels

The oxygen concentration and saturation are both at their highest at the first site, before the sewage outfall.  At site two, after the sewage outfall, the oxygen concentration falls from 10.8 mg/l to 8.17 mg/l. Similarly, the oxygen saturation falls from 96.2% at site one to 80.7% at site two. This reduction in dissolved oxygen can be attributed to the process of eutrophication, as stated in my hypothesis.

In my hypothesis, I predicted ...

This is a preview of the whole essay