Posts: 2
Joined: Tue Dec 04, 2007 6:39 pm

nails and rst

Postby robertay » Wed Dec 05, 2007 6:46 pm

Hi I am doing a science project on nails and rust. I am already conducting my experiment but I do not know how to make a graph or chart with all of my data. Please can someone help me?! :mrgreen:

Former Expert
Posts: 1297
Joined: Mon Oct 16, 2006 11:47 am

Postby Craig_Bridge » Wed Dec 05, 2007 7:26 pm

What grade are you in and have you done any graphing in math? Knowing this will help us give grade appropriate help.

Do you have access to Microsoft Excel? If so, use the chart / graph wizard in it to help you get what you want. If you can't figure it out, please advise what version of Excel you are using as Microsoft tends to change things from version to version.

Posts: 2
Joined: Tue Dec 04, 2007 6:39 pm

nails and rust

Postby robertay » Thu Dec 06, 2007 7:48 pm

I am in grade 7 and in math we have not learned any graph. But in science we have learned types of graplhs like bar, line, and pie grapghs. Also a chart, but that is it. :D

Former Expert
Posts: 260
Joined: Thu Aug 25, 2005 7:44 am
Occupation: Software Engineer/QA Lead - Quality, Risk Assessment, Statistics, Problem Solving

Postby bradleyshanrock-solberg » Fri Dec 07, 2007 11:33 am

Do you have acess to a spreadsheet program (these days Microsoft Excel is by far the most common)?

If you do, all you need to make a variety of graphs is to enter your data into the cells and follow the graph-wizard instructions. The default toolbar has an icon that is the graph-wizard.

It'll do all kinds of graphs, labels, etc and these can be copy/pasted or saved into other formats for printing or sharing.

If you do not have a spreadsheet program, you can do what we used to do 25 years ago, which is to get some graph paper, draw an axis and plot data points. I can't remember when we first did this in school...I think it was 5th or 6th grade, but if iyou have not done anything like this before you may need some help from an instructor, your parents or an older friend/sibling to get the basic idea.

Generally you draw a line going up and a line going to the right, with them meeting on the left, lower side of the graph paper. You choose ranges based on your data...if you measured temperature over a period of time, you'd make one axis time and the other temperature, and use the graph divisions to match your data range. (if you went from freezing to boiling in 10 minutes, your temperature-in degrees C axis would have a range of 0 to 100, and your time axis would have minutes from 0 to 10)

Take your data and plot it on the graph...if it was 60 degrees 5 minutes in you'd go halfway down the time axis and 60% of the way up the temperature axis. When all the points are plotted, you just connect the dots (for a line graph).

Return to “Grades 6-8: Physical Science”