Today you will be familiarising yourself with the Excel Spreadsheet environment.
You will be using the computers to put together graphs based on the data on this page.
Exercise 1
Convert the following information into a table in Excel and then plot a bar graph of the data.
Atomic weight and elements :
EXTENSION
Use the internet to find a periodic table and find out these elements’ atomic number. Use this in Excel to plot a line graph of atomic number vs atomic weight.
~~~
Exercise 2
A student recorded the length of a candle over time as it burned
Download the following table and use the data to make a line graph of the results.
~~~
Exercise 3
A student investigated how changing the concentration of hydrochloric acid effects the time taked to dissolve a strip of magnesium ribbon. Use the data in the following table to plot a graph of the results.
~~~
Exercise 4
The following table lists the melting point of various chemicals. Use Excel to create a suitable graph to illustrate the differences in melting point.
~~~