data you can analyse
I find it educational to look at results collected by others. This is the page from which you can download the results of our experiments using sensors. They are real, often messy, results, and collected over the years but in many cases they offer good material for discussion. There are a few gems below.
How to use the following:
- You could show a graph image (eg in Powerpoint)
- You could import the file into your data logging program
- You could import the file into Excel as a comma separated file
Pick what you need or download everything, in one zip file here files.zip Usually your PC doesn’t know what to do with these files so you have to ‘import’ them using the menu. You can import SID or CSV files into Microsoft Excel or most data logging software.
- Many of the files come from experiments in the now free book ‘Data logging in Practice’ which I’ll link to SHORTLY. More graph screenshots in this Graph gallery.
Download file marked with this icon to use in Datalogging Insight software. These are “ISA” files that Insight recognises. Go to the program’s file menu to open or import them. Thank Laurence Rogers, author of Insight software. for these files.
Look for this icon below if you use other software. If you right click Photosynthesis: oxygen levels in an aquarium a menu will appear. Choose “Save target as” or “Save link as” and choose where to save it. Start Excel, open “files of type all files” and treat the file as comma separated data. Otherwise open your data logging program and look for the option to open or import ‘SID files’.
Bread roll in a freezer (Laurence Rogers)
Electricity – battery for the job (by Laurence Rogers)
Toy car rolling down a slope (by Martin King)
Temperatures in mown grass (by Laurence Rogers)
Reaction rates – sodium thiosulfate (Martin King)
Reaction rates and temperature (by Laurence Rogers)
Latent heat – cooling curve (by Martin King)
Heat – central heating house room temperature (by Roger Frost)
Heating ice and water (by Martin King)
Reactions – plaster of Paris (Laurence Rogers)
Pendulum swings (Martin King)
The coffee quandary (Roger Frost)
Heat – day and night in the house – graph story (Roger Frost)
Video recorder remote control pulses (Roger Frost)
Freezing water (Roger Frost)
Current & voltage in a resistor (Laurence Rogers)
Capacitor discharge across various resistors (100µF) (Laurence Rogers)
Pressure – temperature relationship (Laurence Rogers)
Duff thermostat / refrigerator – but which? (Roger Frost)
Teaching about acids – thermometric titration (Roger Frost)
Enzymes – lipase and fat: with & without emulsifier (Roger Frost)
Temperatures in mown grass over two weeks (Laurence Rogers)
Thanks to Data Harvest
Many thanks to Data Harvest (www.data-harvest.co.uk) for the following experiment files. They will load into Data Harvest’s EasySense software, though most other data logging software and Microsoft Excel will be able to use them. If you just click a file here this will produce a page of numbers. That’s no good to you, so instead right click the icons when the pointer turns into a hand, and a menu will appear. Choose “Save link as” or “Save target as”. Open your data logging program and use the File menu to open or import a ‘SID file’. A SID file is a CSV text file (data separated using commas). You can import SID files into most UK data logging software. Microsoft Excel can handle these files too.
A magnet dropped through a coil
Steve Allen’s party trick is to drop a magnet through a coil, then ask what happens if he turns the magnet round and drops it the other way round. You need really fast logging to get results like this.
Current surge as a bulb lights
Heat – using a heat loss sensor based on the worksheet produced by Roy Barton of University of East Anglia. Plot the difference between Temperature 1 and Temperature 2 against heat flow – it forms a straight line. Results by Sue Plant at Data Harvest.
A waveform from our new sound sensor recording at 28,000 readings per second. The file is middle C of a piano. Use an Interval tool to find the time period from peak to peak = 3.885ms. Dividing 1 second by .003885 gives the result of 259.7, rounded up to 260 which I believe is the frequency of middle ‘C’. Not bad for a bit of homework. The sound sensor normally gives a decibel reading, but when switched to mv can be used for really fast logging. Not as fast as an oscilloscope but it gets results.
and Two acid-base titration results files, the first is done by adding acid and using ‘snapshot’ to take a reading at each point. The file shows points as each 2 ml of alkali was added by pipette – we used 0.1M sodium hydroxide and 0.1M hydrochloric acid. This is from our new KS3 worksheets. The second file, titre.sid is the traditional alkali drained from a burette into acid.
Food as fuel
A file to show what happens in a collision between two hard surfaces measuring force. We repeated the collision with the same mass and at the same speed where one surface is ‘cushioned’. The area under the graph in each case is the same. We kept repeating the collision with the hard surface – the force sensor gives such consistent readings.
Thanks to Barbara Higginbotham of Data Harvest for sending these.