In this exercise we will calculate the concentrations of A and B as a function of time using the analytically integrated rate law. General directions for spreadsheet operations are given in the turtorial of Virtual Lab Simulator - Part 1.

For the first order reaction
The integrated rate law

Integral Method
1. Open a spreadsheet and enter the following into the designated cell:
A1 as "First Order Reaction A-> B Integral Method", A3 as "a=", B3 as "1000", A4 as "k=", B4 as "1", A6 as "t", B6 as "A", C6 as "B", D6 as "lnA".

2. Let A7 to be 0, A8 to be 0.1, A9 to be 0.2 and so on. Fill cells A10 to A107 so that A107 will contain 10.0.
Let B7 to be $B$3*EXP(-$ B$4*A7), C7 to be $B$3*(1- EXP( -$B$4*A7)) and D7 to be LN(B7). Fill down B7, C7, and D7 through B107, C107, and D107.


3. Plot A and B against t. Plot ln A against t.

4. Save the spreadsheet and close.