This assignment asks students to prepare a data base of weather statistics from the current year and compare the data over a period of several years. Source Barnes, Alan. The following activities can be used to apply simple concepts for designing and manipulating a data base, to prepare a variety of reports, and also to obtain new data.
Students work in pairs to collect and enter data and to produce reports of their findings.
Prepare a plan of the data structure including field names, type, width and order of field relevant to the source documents. Collect statistics for 1987 to present from newspaper articles and from the Ontario Climate Centre at Environment Canada, or from the daily newspapers. Prepare a data base recording the data for the current year. C. A 'wet day' has more than 1 mm of rain. Prepare a second database to record statistics for the years 1987-present and enter the current year's data into the file.