Having sorted out creating climate graphs in Excel, drawing flood hydrographs seemed the logical next step. The theory's the same: two data sets on two axes on the same graph so this wasn't a long job.
The bigger problem seems to be finding data to draw a reasonably accurate and reliable hydrograph from. If anyone can help out with better data please let me know.
Hydrographs in Excel 2007/2010/2011
The instructions will talk you through producing a hydrograph in Excel 2007 - with some pointers for Excel 2011 for Macs (and probably for 2010 for Windows). Use the spreadsheet provided as a starter so that you know how to do it!
Hydrograph Drawing Instructions
Boscastle data sheet
The datasheet is one that seems to have been passed around a number of places. I can't work out where the original data came from - my gut feeling is that it's been simplified a touch. If it's your work please get in touch and I'll add whatever credits you want.As usual feedback is useful.
If you have problems downloading the spreadsheet please let me know. There have been difficulties experienced downloading similar sheets from this site and I'm keen to try and find a solution.
Here's an example of the sort of thing you can produce.
More on Boscastle
The 2004 Boscastle flash flood event is a pretty reasonable GCSE or A Level flash flood case study. There are loads of places on the web where information can be found, from the obvious Wikipedia article (rather in need of references) to contemporary BBC news articles.
The Met Office Case Study page is well worth a look, especially for a GCSE case study.
· In 2005, a new £800,000 flood defence scheme opened in Boscastle which includes a new, larger culvert on the river Jordan which will be able to carry double the amount of floodwater.
· In August 2006, construction started on the river Valency flood defence scheme, see Figure 9. In order to increase its capacity the river has been widened and deepened and the lower bridge replaced. A new car park has been built which is raised and set back from the river and a new tree management scheme has been introduced to reduce the chances of tree blockage. Two new sewing pumps and stations and a new sewer pipe to assist with flood flows have also been introduced.
·Flood defence works together with the regeneration scheme cost £10 million and were officially opened in October 2008.
(Environment Agency, 2012).
BBC, 2004a. In Pictures: Dramatic Floods in Boscastle [image online] Available at: <http://news.bbc.co.uk/cbbcnews/hi/newsid_3570000/newsid_3572400/3572488.stm> [Accessed 31 January 2012].
BBC, 2004b. The Boscastle Floods 2004 [image online] Available at: <http://www.bbc.co.uk/cornwall/content/image_galleries/boscastlefloods2004_gallery.shtml?26> [Accessed 27 January 2012].
BBC, 2004c. In pictures: Flooding in Cornwall [images online] Available at: <http://news.bbc.co.uk/1/shared/spl/hi/picture_gallery/04/in_pictures_flooding_in_cornwall/html/3.stm [Accessed 14 March 2012].
BBC, 2005a. In pictures: Boscastle then and now [image online] Available at: <http://news.bbc.co.uk/1/shared/spl/hi/pop_ups/05/uk_boscastle_then_and_now/html/1.stm> [Accessed 27 January 2012].
Burt, S., 2005. Cloudburst upon Hendraburnick Down: The Boscastle storm of 16 August 2004. Weather, 60(8), pp.219-227.
Bull, J., 2007. The Boscastle Flood 2004.Staffordshire Learning Net. [Online] Available at: <http://www.sln.org.uk/geography/schools/blythebridge/Boscastle%20Assignment.pdf> [Accessed 27 January 2012].
Cherrington, J., 2006. Boscastle Flood- The Silver Linings, Ranger, 76, [Online]. Available at: <http://www.countrysidemanagement.org.uk/publns/ranger/76/Boscastle.pdf> [Accessed 27 January 2012].
Environment Agency, 2012. Boscastle to benefit for years to come from new flood defence scheme and regeneration projects [Online] Available at:< http://www.environment-agency.gov.uk/news/94818.aspx?page=3&month=10&year=2008> [Accessed 27 January 2012].
Golding, B., Clark, P. and May, B., 2005. The Boscastle flood: Meterorological analysis of the conditions leading to flooding on 16 August 2004. Weather, 60(8), pp.230-235.
Met Office, n.d. Floods devastate village [image online] Available at: <http://www.metoffice.gov.uk/education/teens/case-studies/boscastle> [Accessed 27 January 2012].
MightyQuinn57, 2007. Boscastle, Flash Flood. [video online] Available at: <http://www.youtube.com/watch?v=SxweiRNlHbo> [Accessed 27 January 2012].
Nicholas Pearson Associates, 2012. Boscastle Flood Alleviation Scheme [image online] Available at: <http://www.npaconsult.co.uk/projects.asp?gid=99&pid=16&pkeyword=&prelated=&pproject=> [Accessed 31 January 2012].
North Cornwall District Council, 2004. Boscastle The Flood. [Online]. Available at: < http://www.hotelriverside.co.uk/BoscastleFlood.pdf> [Accessed 27 January 2012].
Roseveare, N. and Trapmore, G., 2008. The sustainable regeneration of Boscastle. BHS 10th National Hydrology Symposium, Exeter, 2008.