Excel Spread Sheet and Charts Project

Excel Spread She= et and Charts Project

Making Graphs...Circle- Bar- Line

= ;

Purpose:&n= bsp; To create a spread sheet from data and change the data into charts t= o

&= nbsp; &nbs= p; analyze motion graphs (distance, speed, and time) for constant speed,

&= nbsp; &nbs= p; positive acceleration, negative acceleration, and stopped. Graphs aide

&= nbsp; &nbs= p; the understanding of relationships of displacement, time and velocity.

&nb= sp;

MA Standards:&nb= sp; Technology Standard 1 Performance Indicators: 1.24

&= nbsp; &nbs= p; &= nbsp; Physical Sciences Standards: 11.0 and = 12.0

&nb= sp;

Materials:&n= bsp; 1. D= ata tables provided with the lesson

&= nbsp; &nbs= p; 2. Computer with Word and Excel softw= are and internet access

&= nbsp; &nbs= p; 3. Science class website files and li= nks

&nb= sp;

Procedure: &n= bsp; Practice using the Excel Graphs file for the following data table.=

&nb= sp;

Gase= s in the Atmosphere

Gases	Percent by Volume
Nitrogen	78%
Oxygen	21%
Other gases	1%

&= nbsp; 1. Enter this information into an Exc= el spread sheet putting the x axis information

&= nbsp; &nbs= p; first.

&= nbsp; 2. Create a pie graph for the data.

&= nbsp; 3. Create a bar graph for the data

&= nbsp; 4. Create a line graph for the data a= nd remember to use XY (scatter).

&= nbsp; 5. Each graph must be seen and checke= d by the instructor of the class.

&= nbsp; 6. Now that everything is fine, you a= re ready to go on in the procedure.

&nb= sp;

&= nbsp; Making Motion Graphs from data tables using Excel

&= nbsp;

&= nbsp; 1. Use the data tables provided to en= ter the information on an Excel spread

&= nbsp; &nbs= p; sheet.

&= nbsp; 2. Create line graphs for the data and remember to use XY (scatter).

&= nbsp; 3. Each graph must be seen and checke= d by the instructor of the class.

&= nbsp; 4. Save you spread sheet and graphs as Motion Graphs in My Documents.

&nb= sp;

Data:&n= bsp; 1.Use the data tables to create spread sheets and motion graphs in Excel.

&= nbsp; 2. Using a calculator complete the da= ta table speed columns in m/min.

&nb= sp;

Speed D= ata Table 1

Ti= me (m= in)	Di= stance (m= )	Sp= eed (m= /min)
0<= o:p>	0<= o:p>
1<= o:p>	6<= o:p>
2<= o:p>	12=
3<= o:p>	18=
4<= o:p>	24=

= =

Speed =3D Distance /= Time

&nb= sp;

Speed D= ata Table 2

Ti= me (m= in)	Di= stance (m= )	Sp= eed (m= /min)
0<= o:p>	0<= o:p>
1<= o:p>	1<= o:p>
2<= o:p>	4<= o:p>
3<= o:p>	9<= o:p>
4<= o:p>	16=

&nb= sp;

Speed = =3D Distance / Time

&nb= sp;

Speed D= ata Table 3

Ti= me (m= in)	Di= stance (m= )	Sp= eed (m= /min)
0<= o:p>	0<= o:p>
1<= o:p>	6<= o:p>
2<= o:p>	6<= o:p>
3<= o:p>	12=
4<= o:p>	18=

&nb= sp;

Speed = =3D Distance / Time

&nb= sp;

Speed D= ata Table 4

Ti= me (m= in)	Di= stance (m= )	Sp= eed (m= /min)
0<= o:p>	0<= o:p>
1	6<= o:p>
2<= o:p>	10=
3<= o:p>	13=
4<= o:p>	15=

&nb= sp;

Speed = =3D Distance / Time

&nb= sp;

Analysis/Conclusion: = Motion Graph Analysis Questions

Ø Which graph shows constant speed? Explain= using math and the shape of the

line to indicate the type of motion.

Ø Which graph shows a stop in motion? Expla= in using math and the shape of the

line to indicate the type of motion.

Ø Which graph shows acceleration? Explain u= sing math and the shape of the

line to indicate the type of motion.

Ø Which graph shows negative acceleration (slowing down)? Explain using math

and the shape of the line to indicate the type of motion.

Error Analysis:

1. Explain the problems using Excel to create line graphs. Use compl= ete

&= nbsp; sentences and paragraph style writing.

= 2. Explain = the problems encountered when answering the Motion Graph

&= nbsp; Analysis Questions. Use complete sente= nces and paragraph style

&= nbsp; writing.