Ionization Energy And The First 20 Elements: Msexcel Activity printable pdf download

Ionization Energy And The First 20 Elements: Msexcel Activity

Ionization Energy and the first 20 elements: MSExcel activity

Your task: 1. To use Excel to calculate the ionization of the first 20 elements, and graph the results.

2. To use Excel to try and modify the formula that you used to get better, more accurate

results.

Data: Use the grid in the packet, pg 4, as a guide to help you build your data table. It is important that

Excel is used to calculate the values – don’t calculate them yourself and type then in!

The data table should include an “actual IE” column and a “percent error” column.

Using Excel:

There are 5 important things that you need to know how to do in Excel to be successful in this project.

Take notes in the space below if you don’t know how to do a task.

Performing formulas and calculations:

Sample Excel table

Referencing another cell in a calculation:

Copying the contents of a cell:

Copying the contents of a cell while keeping the reference cell consistent:

Making a graph or chart:

Ionization Energy And The First 20 Elements: Msexcel Activity