Graphing Periodic Trends in Excel

This video tutorial guides students on how to use Excel for graphing periodic trends such as ionization energy, electronegativity, and atomic radius against atomic numbers. It begins with an introduction to Excel as a graphing tool, followed by instructions on filling in element cards to identify missing elements. The tutorial then details the process of graphing these trends using Excel's scatter chart feature, including steps for data entry, chart creation, and labeling. Finally, students are instructed to compile their graphs into a Word document for class review.

What is the main purpose of using Excel in this video?

• To create a database

• To calculate chemical reactions

• To graph periodic trends

• To write a report

What should you do with the element cards?

• Color them

• Throw them away

• Use them as bookmarks

• Fill in missing elements

Which periodic trends are to be graphed against atomic number?

• Melting point, boiling point, density

• Color, texture, hardness

• Conductivity, malleability, ductility

• Ionization energy, electronegativity, atomic radius

What is the first step in creating a graph in Excel?

• Type ionization energy in the X column

• Type atomic number in the X column

• Type atomic number in the Y column

• Type electronegativity in the Y column

Which chart type should be selected for graphing the data?

• Scatter chart

• Line chart

• Pie chart

• Bar chart

What should be added to the chart for clarity?

• Axis titles

• Background music

• Animations

• 3D effects

Where should the atomic number be labeled on the chart?

• On the legend

• In the chart title

• On the Y-axis

• On the X-axis

What should be done with the completed graphs?

• Post them online

• Delete them

• Email them to the teacher

• Print and bring them to class

How should the graphs be organized in the document?

• One graph per page

• All graphs on one page

• Two graphs per page

• Randomly arranged

What is the final step after organizing the graphs?

• Delete the document

• Email the document

• Save the document

• Print the document