Radioactive decay simulation | Chemistry |

background [prelab assignment (25 points) due at the beginning of lab]

describe a method using graphical analysis (of a graph of # radioactive isotopes versus time) to determine the half-life of a radioactive isotope

describe a method using graphical analysis (of a graph of ln # radioactive isotopes versus time) to determine the decay constant of a radioactive isotope

describe the Excel command / syntax for __

- randbetween
- countif
- countifs

purpose

develop an Excel-based model to simulate radioactive isotope decay (start with 100 & end with < 15 simulated isotopes; read below content of your lab report for other aspects of the lab)

fulfill various aspects of the NGSS science & engineering standards

materials

Microsoft Excel

methods / data analysis

student design

Content of lab report [50 points]

data analysis- for 6- & 10- sided dice

describe / list two (ex1; ex2) NGSS science & engineering practices that correlates to an aspect of this laboratory activity;

- screenshoot of your Excel simulation, which includes the row / columm labels and use of the Excel commands in your simulation (show the syntax for each Excel command with respect to the row / column)
- 2 plots (of 6- & 10- side dice) on the same graph of # dice versus # dice roll (let time be simulated by # dice roll and # radioactive isotopes be simulated by # dice in the sample)
- determine the half-life for each type of dice using the preceding graph; include the basis of its value
- determine the decay constant for each type of dice using graphical analysis; include the basis of its value & the graph
- statistics; identify type of statistics test, raw data, & label data

- compare the half-life of the 6- versus 10- sided dice
- compare the decay constant of the 6- versus 10- sided dice
- describe / rationalize the relationship between the number of sides on the dice (i.e. 6- versus 10- sided) and the simulated half-life; refer to statistics to support your claim
provide an example in the lab or this lab report that meets these practices

**resource**s

lab activity source (examples): site 1 & site 2 [access 4 / 2009]

computational thinking [access 4 / 2017]

common core math standards: models & tools [access 4 / 2017]

Excel as a mobile apps: Android OS; iOS [access 4 / 2017]

Excel examples: *.xlsx (Excel); *.xlsm (Excel VBA); screenshots

mathematica: t-test