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 __

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; provide an example in the lab or this lab report that meets these practices

resources

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